This guide simplifies configuring Feed Settings for the Formidable Forms Google Sheet Connector Plugin Pro.
Add Form Feed
Choose this option if you want to connect to multiple Google Sheets. You can add as many feeds as needed to meet your requirements.
In Multi Sheet Connection, you just have to select the form, name the feed, and submit.
Follow these steps:
- Go to Wp-admin > Formidable Forms > Google Sheet Connector.
- Click on Form Feed Tab and Add Feeds
- Enter the Feed Name, select the form from the dropdown menu, and submit.
Here you will see that a new feed has appeared . You can edit the feed using the Edit button and delete the feed using the Delete button.
Edit Form Feed Section
1 ) Google Sheet Settings – (Manual Settings | Auto Settings)
2 ) Field List | Special Mail Tags
Enable Fields that you want in Google Sheet as header
3 ) Header Management Settings
a) Freeze Header Row – For Sticky Header In Google Sheet
-
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.
b) Header – Font Settings – Sheet Header Font Settings – font size, font style, font color
c) Sheet Background Color – Sheet Header & Row color options
d) Row – Font Settings – Sheet Row font style, font size & color options
Save & Submit Data.
Manually adding Sheet Name & Tab Name
In Manual Method You have to Manually Add Google Sheet Name , Google Sheet Id , Google Sheet Tab Name & Google Sheet Tab Id.
Save & Submit Data.
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.
Sync Settings
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.
To fetch past and real-time form entries, simply click “Sync Entries With Connected Sheet.”
Note: Before syncing, ensure that the header names are already available in the sheet.





