This guide makes it easy to Configuration of WooCommerce and the WooCommerce Google Sheet Connector Plugin.
Integration of Divi Forms with Google Sheet:
- Ensure that you have successfully integrated (Automatic Integration or Manual Integration) Divi with Google Sheet Connector.
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.”
Name The Feed:
- Provide a name for the feed.
- Select the page.
- Click “Submit.”
Edit the Feed:
- Once the feed is successfully added, edit the feed.
Fetch Fields & Save Form Fields:
- Click on “Fetch Fields” to retrieve form fields.
- Save the form fields.
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.
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.
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.
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.
How to Enable Cron Sync
Follow the steps below to turn on automatic sync:
- Go to your WordPress Dashboard and open the GSheetConnector settings for your form plugin.
- Scroll down to the Cron Settings section.
- Turn on the Enable Cron Sync toggle. This turns on automatic scheduling.
- The schedule options will appear below the toggle.
- Choose your schedule (explained in the next section).
- Click on the Save button to apply your settings.
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.
- Turn on Enable Cron Sync.
- Click on Set Schedule.
- Select Repeat Weekly as the schedule type.
- In the How Often dropdown, select Every Ten Minutes.
- 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.
- Turn on Enable Cron Sync.
- Click on Set Schedule.
- Select Run Once as the schedule type.
- 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.
- Click on No Schedule, or turn off the Enable Cron Sync toggle.
- Click Save.
Result: The automatic sync stops. Your existing Google Sheet data stays as it is.
- 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
- Save your Cron Settings with a short interval, for example Every Ten Minutes.
- Submit a test entry on your form.
- Wait for the selected interval to pass.
- Open your connected Google Sheet.
Submit Data for Save:
- Save the configuration.
Sync to Google Sheet :
Click on Sync button to sync entries.








