⌘K
  1. Home
  2. Docs
  3. Divi Forms Google Sheet C...
  4. Plugin Feed Settings

This guide makes it easy to Configuration of WooCommerce and the WooCommerce Google Sheet Connector Plugin.

Integration of Divi Forms with Google Sheet:

Divi Forms Feeds Setting :

In Google Sheet – Feeds Setting :-

In WordPress Dashboard :

  • Navigate to Divi > Google Sheet > Feeds Setting.

Fetch Sheets :

  • If you haven’t fetched sheets from the integration tab, click on “Fetch sheets.”

Add Feed :

  • In the Google Sheet – Feeds tab, click on “Add Feed.”

WooCommerce Google Sheet Connector Plugin Settings

Name The Feed:

  • Provide a name for the feed.
  • Select the page.
  • Click “Submit.”

WooCommerce Google Sheet Connector Plugin Settings

Edit the Feed:

  • Once the feed is successfully added, edit the feed.

WooCommerce Google Sheet Connector Plugin Settings

Fetch Fields & Save Form Fields:

  • Click on “Fetch Fields” to retrieve form fields.

WooCommerce Google Sheet Connector Plugin Settings

  • Save the form fields.

WooCommerce Google Sheet Connector Plugin Settings

Google Sheet Setting:

Integration:

  • Ensure the integration is complete as per the instructions.

Fetch Sheets:

  • Click on “Click here” to fetch sheets.

Select Google Spreadsheet:

  • Choose the existing Google Spreadsheet or create a new sheet.

Save or Submit Data:

  • Select Google Sheet and Tab Name.
  • Save or submit data.

Enable Manually Adding of Sheet Name and Tab Name:

  • Optionally enable this checkbox to manually add the sheet name and tab name.

WooCommerce Google Sheet Connector Plugin Settings

Manually Adding Sheet Name & Tab Name: #

  • Manual Method:

    • Manually add Google Sheet Name, Google Sheet ID, Google Sheet Tab Name, and Google Sheet Tab ID.
    • Save and submit data.

WooCommerce Google Sheet Connector Plugin Settings

Field List Setting:

Fetch Fields:

  • Click on “Fetch Fields.”

Enable Fields:

  • Enable the fields you wish to view in your Google Sheet.

Sort Fields & Rename:

  • Optionally, sort and rename fields.

WooCommerce Google Sheet Connector Plugin Settings

Header Management:

  • Freeze Header: Enable to stick the header to the top.
    • 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.

  • Header Color: Set the background color for the header.
  • Odd Color: Set the background color for odd rows.
  • Even Color: Set the background color for even rows.

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.

Submit Data for Save:

  • Save the configuration.

WooCommerce Google Sheet Connector Plugin Settings

Sync to Google Sheet :

Click on Sync button to sync entries.

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