⌘K
  1. Home
  2. Docs
  3. Ninja Forms GSheetConnect...
  4. Plugin Feed Settings – PRO Version

This guide makes it easy to install Ninja Form and the Ninja Forms Google Sheet Connector Plugin.

Integration of Ninja Form with Google Sheet :

Edit Contact Form :

Go to the Ninja Form Dashboard :

  • Log in to your WordPress admin dashboard.
  • Navigate to the Ninja Form dashboard.

Edit the Form:

  • Locate and edit the specific form that you want to integrate with Google Sheets.

Ninja Forms Google Sheet Connector Pro integration steps

Edit Form – Emails & Actions – Google Sheet :

  • In the form editor, go to the “Emails & Actions” tab.
  • Click on “Add New Section” and add “Google Sheet Connector Pro.”

Ninja Forms Google Sheet Connector Pro integration steps

Enable Feed and Integration Mode :

  • Enable the feed by turning on the switch for “On.”
  • Set the Integration Mode to “Automatic.”

Ninja Forms Google Sheet Connector Pro integration steps

Click on Fetch Spreadsheet :

  • Click on “Fetch Spreadsheet.”
  • Select the Google Sheet Name.
  • Choose the specific Tab Name.

Ninja Forms Google Sheet Connector Pro integration steps

Add Feeds :

  • Add feeds based on your requirements. There are different options for adding feeds:
    • Add Feed from Fields.
    • Add Feed from WordPress.
    • Add Feed from Form Default Fields.
    • Add Feed from Other Fields.

Ninja Forms Google Sheet Connector Pro integration steps

  • Add Feed from Fields.

 .Ninja Forms Google Sheet Connector Pro integration steps

  • Add Feed from WordPress.

Ninja Forms Google Sheet Connector Pro integration steps

  • Add Feed from Form Default Fields.

Ninja Forms Google Sheet Connector Pro integration steps

  • Add Feed from Other Fields.

Ninja Forms Google Sheet Connector Pro integration steps

Freeze Header :

Header Settings for Google Sheet header and row styling
Style your header row and alternating row colors, and freeze the header or first column if needed.
  • Header Behavior:

    • Turn on Freeze Header to keep the header row visible while scrolling down.

    • Turn on Freeze Column to keep the first column fixed while scrolling to the right. This is helpful when your sheet has many columns and you want to keep key details (like name or entry ID) always visible.

    Ninja Forms Google Sheet Connector Pro integration steps

    Header/Odd/Even Color :

    • Customize the appearance by setting the Header Color, Odd Color, and Even Color.

    Ninja Forms Google Sheet Connector Pro integration steps

    Cron Settings

    The Cron Settings option allows you to sync your form entries with Google Sheets automatically, on a schedule that you choose. Once it is set up, you do not need to click any sync button manually. The plugin runs the sync by itself at the time you have selected.

    In this guide, you will learn how to enable Cron Sync and how to set a schedule using the Repeat Weekly or Run Once option.

    When Should You Use Cron Settings?

    • You want your Google Sheet to stay updated automatically, without syncing manually every time.
    • You want the sync to run at regular intervals, for example every ten minutes.
    • You want to run a one-time sync at a specific time, such as after a campaign ends or at the end of the day.
    • You want full control over when the sync runs, or you want to stop automatic sync completely.
    Note : Before using Cron Settings, make sure your Google account is connected and your Google Sheet is selected in the plugin settings.

    How to Enable Cron Sync

    Follow the steps below to turn on automatic sync:

    1. Go to your WordPress Dashboard and open the GSheetConnector settings for your form plugin.
    2. Scroll down to the Cron Settings section.
    3. Turn on the Enable Cron Sync toggle. This turns on automatic scheduling.
    4. The schedule options will appear below the toggle.
    5. Choose your schedule (explained in the next section).
    6. Click on the Save button to apply your settings.
    Cron Settings in GSheetConnector Pro
    Enable Cron Sync and choose a schedule: Repeat Weekly or Run Once.
    Note : If the Enable Cron Sync toggle is turned off, no automatic sync will run.

    Understanding the Schedule Options

    1. Set Schedule / No Schedule

    After enabling Cron Sync, you first decide whether you want a schedule or not.

    • Set Schedule: Choose this option if you want the sync to run automatically at the time you define.
    • No Schedule: Choose this option if you do not want any automatic schedule to run.

    2. Choose Schedule Type

    When Set Schedule is selected, you can choose how the schedule should run:

    • Repeat Weekly: The sync runs again and again on a regular basis. Use this when you want your Google Sheet to be updated continuously without any manual work.
    • Run Once: The sync runs only one time. Use this when you need a single sync at a particular time and do not want it to repeat.

    3. How Often

    The How Often dropdown decides how frequently the sync should run. Click on the dropdown and select the interval you prefer, for example Every Ten Minutes.

    • Choose a shorter interval if you want your sheet to update quickly after every new form submission.
    • Choose a longer interval if you do not need instant updates and want to reduce the load on your website.

    Step-by-Step Examples

    Example 1: Keep Your Sheet Updated Regularly

    Suppose you want your Google Sheet to be updated automatically all the time.

    1. Turn on Enable Cron Sync.
    2. Click on Set Schedule.
    3. Select Repeat Weekly as the schedule type.
    4. In the How Often dropdown, select Every Ten Minutes.
    5. Click Save.

    Result: The plugin syncs your form entries to Google Sheets automatically at the interval you selected. You do not need to sync manually.

    Example 2: Run a One-Time Sync

    Suppose you want to run the sync only one time and do not want it to repeat.

    1. Turn on Enable Cron Sync.
    2. Click on Set Schedule.
    3. Select Run Once as the schedule type.
    4. Click Save.

    Result: The sync runs one time only. It will not repeat after that.

    Example 3: Stop Automatic Sync

    Suppose you no longer want the sync to run automatically.

    1. Click on No Schedule, or turn off the Enable Cron Sync toggle.
    2. Click Save.

    Result: The automatic sync stops. Your existing Google Sheet data stays as it is.

    Note :

    • You must click Save after changing any Cron Setting, otherwise your schedule will not be applied.
    • Cron Sync works through the WordPress cron system, which runs when someone visits your website. On a website with very low traffic, the sync may run slightly later than the selected time.
    • Choose a sensible interval. Very short intervals on a website that receives a large number of form entries can increase the load on your website.

    Verify That Cron Sync Is Working

    1. Save your Cron Settings with a short interval, for example Every Ten Minutes.
    2. Submit a test entry on your form.
    3. Wait for the selected interval to pass.
    4. Open your connected Google Sheet.
    If Cron Sync is working correctly, the new form entry will appear in your Google Sheet automatically, without any manual sync.

    Synchronous :

    Note: If you have a large volume of data exceeding 1,000 rows, you must manually add more rows to the sheet, as shown in the image.

    • Click on “Sync” button to synchronized data.

    Ninja Forms Google Sheet Connector Pro integration steps

    Publish :

    • Click on “Publish” to save and update the form details.

    Now, in the connected sheet, all the headers used in the form will be automatically created.

    Whenever the form is filled, an entry will be saved in the connected Google Sheet.

Still not using GSheetConnector?
Quick and easy setup ⚙️ seamlessly import your settings from any other Google Sheets plugin!
👉 Learn more about the Pro Version | Download the Free Version