Plugin Settings – Connect Your Forminator Form with Google Sheets
After you have connected your Google account and activated your license, the next step is to connect a Forminator form with a Google Sheet. This is done by creating a feed. A feed links one Forminator form to one Google Sheet tab and holds all the settings for that connection: which sheet to use, which fields to send, how the headers look, and when a submission should be sent.
In this guide, you’ll learn how to:
- Create a Forminator form and add a new feed for it
- Select your Google Sheet and tab automatically, or add the details manually
- Choose the fields to sync, rename them, and change their order
- Use Conditional Logic to control which submissions are sent
- Style the header and rows of your sheet, and enable sorting
- Sync your previous form submissions to the sheet
- Test your form and check the entries in Google Sheets
Step 1: Create Your Forminator Form
If you already have a published Forminator form, you can skip to Step 2. Otherwise, create one first:
- In your WordPress dashboard, go to Forminator → Forms.
- Click the Add New button to create a new form.
In the Form Editor, open the Form Fields section and click Insert Form Fields to add the fields you need, such as First Name, Email Address, Phone Number, and Message. You can customize each field according to your requirements. When you’re done, click Publish Changes to make the form live.
Step 2: Open the Form Feeds Tab
In your WordPress dashboard, go to Forminator → Google Sheet. This opens the GSheetConnector for Forminator Forms settings page, which has the following tabs:
- Dashboard: Quick access to plugin information.
- License: Activate and manage your PRO license.
- Integration: Connect your Google account. The badge next to the name shows the method you are using, for example Existing.
- Form Feeds: Create and manage the feeds for your forms.
- Settings: General plugin settings.
- System Status: System information and the error log.
- Extensions: More add-ons from GSheetConnector.
Click the Form Feeds tab. This page is called Sheet Sync Feeds, and it is where you create, connect, manage, and monitor how your form submissions are synced to Google Sheets in real time.
Step 3: Add a Form Feed
On the Sheet Sync Feeds page, click the green + Add Form Feed button.
Step 4: Create the Feed
The Create Sheet Sync Feeds panel opens. Fill in the following:
- Feed Name: Enter a clear name for the feed, for example Contact Feed.
- Select Form: Choose your Forminator form from the dropdown menu.
- Click the Submit button.
If you want to close this panel without creating a feed, click – Close Form Feed.
Step 5: Review Your Feed List
After you submit, your new feed appears in the Sheet Sync Feeds list. The list shows these details for every feed:
- Form ID and Form Name: The Forminator form linked to the feed.
- Feed Name: The name you gave the feed.
- Timestamp: The date and time the feed was created.
- Actions: Three icons to manage the feed (see below).
- Spreadsheet Connected: The Google Sheet and tab connected to the feed.
- Status: A toggle to enable or disable the feed.
The three icons under Actions work like this:
- Eye icon: View the Forminator form selected for the feed.
- Edit icon: Open the feed settings.
- Delete icon: Delete the feed.
Turn the Status toggle on to let the feed send data to Google Sheets.
To configure the feed, click the Edit icon.
Step 6: Open the Feed Settings
The feed settings page has several sections, from top to bottom:
- Back to Feeds List: Takes you back to the list of feeds.
- Google Account Connection: Shows the integration method you are using, the connected Google account email, and a Connected status.
- Feed Details: Shows the Form ID, Feed Name, Form Name, and Timestamp of the feed, for your reference.
- Enable Manual Google Sheets Configuration: A toggle for adding your sheet details manually (see Step 8).
- Automatic Google Sheets Configuration: The dropdowns for choosing your sheet and tab (see Step 7).
- Select Fields To Sync, Conditional Logic, Header Settings, and Google Sheets Data Sync: The remaining settings, covered in the next steps.
- Save Settings: The button at the bottom that saves everything.
Step 7: Select Your Google Sheet and Tab (Automatic)
By default, the feed uses the Automatic Google Sheets Configuration. This is the easiest way, because you pick your sheet from a dropdown and don’t have to copy any IDs.
- Open the Sheet Name dropdown and select your Google Sheet.
- Open the Sheet Tab Name dropdown and select the tab where you want the data to be saved.
Next to the tab dropdown, you will see two icons:
- Eye icon: Opens the connected Google Spreadsheet, so you can view it.
- Download icon: Downloads the connected Google Spreadsheet.
Fetch Sheets
If your Google Sheet is not visible in the dropdown, use the Fetch Sheets box below it. Click the Click here link to retrieve all accessible Google Sheets from your connected Google account and update the dropdowns. The box also shows the date and time of the last fetch.
Step 8: Add the Sheet Details Manually (Optional)
If you prefer to use your existing Google Sheet details instead of the dropdowns, you can add them manually.
- Turn on the Enable Manual Google Sheets Configuration toggle.
- Enter the following details:
- Sheet Name: The name of your Google Spreadsheet.
- Sheet ID: The ID of your Google Spreadsheet.
- Sheet Tab Name: The name of the tab where the data should be saved.
- Tab ID: The ID of that tab.
- Use the eye icon (View Spreadsheet) to open your Google Sheet, or the download icon to download it.
- Click Save Settings at the bottom of the page.
Where to Find the Sheet ID, Tab ID, and Names
Open your Google Sheet in the browser and look at the page, as shown below:
- Sheet Name: Shown at the top left, next to the Google Sheets icon.
- Sheet ID: The long text in the URL between
/d/and/edit. - Tab ID: The number after
gid=in the URL when that tab is open. - Tab Name: The name of the tab shown at the bottom of the sheet, for example Sheet1.
gid= value in the URL of the exact tab you want to use.Step 9: Select the Fields to Sync
In the Select Fields To Sync section, you choose which fields are sent to Google Sheets and how their columns are named. This section has two tabs:
- Field List: The fields of your Forminator form.
- Submission Info: Default submission details such as Submission ID, Entry Date, Date & Time, Post ID, Post Title, Post URL, Source URL, User ID, User Agent, and IP Address.
Enable or Disable Fields
- Turn on the toggle of every field you want to see in your Google Sheet.
- Turn on Select All Fields to enable all the fields at once.
- Fields that are turned off are marked as Hidden and will not be sent to the sheet.
Rename a Field
Click the Edit (pencil) icon on a field to rename it. The new name is also used as the column header in your Google Sheet.
Change the Order of Columns
Each field shows the column of the spreadsheet it will use, such as Column A, Column B, and Column C. Drag and drop the fields to arrange them in the order you want the columns to appear in your Google Sheet. The column letters update as you move the fields.
Step 10: Set Up Conditional Logic (Optional)
Conditional Logic lets you decide when a form submission should be sent to Google Sheets, based on the values entered in the form. This way, only the submissions that match your rules are added to the sheet.
- Turn on the Conditional Logic toggle.
- In the Process this feed if line, choose how the rules should match (for example, All).
- Select a field from the first dropdown.
- Select the condition from the second dropdown, for example Is.
- Enter the value in the last box.
- Click the + button if you want to add more rules.
Step 11: Customize the Header and Rows
The Header Settings section lets you customize how the header and rows of your Google Sheet look and behave, to make the data easier to read and organize.
Header Behavior
- Freeze Header: Turn this on to keep the header row fixed at the top while you scroll through the sheet.
- Sheet Sorting: Turn this on to sort your sheet data. Then choose the Sort Column to sort by, and the Sort Order, either Ascending or Descending.
Header Style
Turn on Header Appearance to style your header row:
- Font Style: Normal, Italic, or Bold.
- Font Size: Choose the size of the header text.
- Font Color: Choose the color of the header text.
Row Style
Turn on Color Appearance to set the background colors:
- Header Background: The background color of the header row.
- Odd Row Color: The background color of the odd rows.
- Even Row Color: The background color of the even rows.
Turn on Row Appearance to style the text of your data rows:
- Font Style: Normal, Italic, or Bold.
- Font Size: Choose the size of the row text.
- Font Color: Choose the color of the row text.
Step 12: Sync Previous Submissions (Optional)
If your form already has submissions from before you created the feed, you can send them to your Google Sheet with Google Sheets Data Sync. This keeps your spreadsheet complete and up to date.
- Turn on the Google Sheets Data Sync toggle.
- Choose one of the options:
- Sync All Submissions: Sends all the previous submissions of the form.
- Sync by Date Range: Sends only the submissions between two dates. Select the From Date and To Date (in dd-mm-yyyy format).
- Click the Sync Entries button.
Step 13: Save Your Settings
When you have finished configuring the feed, click the Save Settings button at the bottom of the page. Your settings are applied to the feed right away.
Step 14: Check the Headers in Your Google Sheet
Open your Google Sheet. The fields you selected appear as column headers in row 1, in the order you set. If you turned on Freeze Header, the header row stays fixed at the top.
Step 15: Test Your Form
Now check that everything works:
- Open your Forminator form on the front end of your website.
- Fill out the form and click Submit.
- Open your Google Sheet and check that a new row has been added with the submitted data.
Manage Your Feeds
You can manage your feeds at any time from Forminator → Google Sheet → Form Feeds:
- Use the Status toggle to enable or disable a feed. A feed only sends data to Google Sheets while it is enabled.
- Click the Edit icon to change the feed settings.
- Click the Eye icon to view the form selected for the feed.
- Click the Delete icon to remove a feed you no longer need.
- Click + Add Form Feed to connect another form, or the same form with another sheet.
Troubleshooting
If your data does not appear in the sheet, check the following:
- The Google Account Connection section shows your account as Connected.
- The feed Status toggle is turned on.
- The correct Sheet and Tab are selected. If you don’t see your sheet in the dropdown, use Fetch Sheets.
- If you use manual configuration, the Sheet ID and Tab ID are correct.
- The fields you want are turned on in Select Fields To Sync.
- If Conditional Logic is on, your submission matches the rule.
- You clicked Save Settings after making changes.
- Check the System Status tab for errors and system details.
What’s Next?
You can create more feeds for your other forms at any time. Each feed can have its own sheet, fields, header style, and conditional logic, so you can organize your form data exactly the way you need it.
Frequently Asked Questions
What is a feed in GSheetConnector for Forminator Forms?
A feed is the connection between one Forminator form and one Google Sheet tab. It stores the sheet details, the fields to send, the header and row styles, and the other settings for that connection. You can create as many feeds as you need.
Can I connect one form with more than one Google Sheet?
Yes. Create a separate feed for each Google Sheet you want to connect. Each feed can have its own settings.
My Google Sheets are not showing in the dropdown. What should I do?
Click the Click here link in the Fetch Sheets box. It retrieves all the accessible sheets from your connected Google account and updates the dropdowns. Use it after you create a new sheet or rename a spreadsheet or tab. If the sheets still don’t appear, check that your Google account is connected in the Integration tab.
Can I add the sheet details manually?
Yes. Turn on Enable Manual Google Sheets Configuration and enter the Sheet Name, Sheet ID, Sheet Tab Name, and Tab ID. The Sheet ID is in the sheet’s URL between /d/ and /edit, and the Tab ID is the number after gid=.
Can I choose which fields are saved in the Google Sheet?
Yes. In Select Fields To Sync, turn on only the fields you want, or use Select All Fields to enable every field. Fields that are turned off are marked as Hidden and are not sent to the sheet.
Can I rename the column headers?
Yes. Click the pencil icon on a field and enter a new name. The new name is used as the column header in your Google Sheet.
Can I change the order of the columns?
Yes. Drag and drop the fields in the Select Fields To Sync section. The column letters shown above each field (Column A, Column B, and so on) show the position of each field in your sheet.
What is the Submission Info tab?
The Submission Info tab contains the default details of each submission, such as the Submission ID, Entry Date, Date & Time, Post ID, Post Title, Post URL, Source URL, User ID, User Agent, and IP Address. Turn on the ones you want to see in your Google Sheet.
What does Conditional Logic do?
Conditional Logic lets you set rules so that only the submissions that match specific field values are sent to Google Sheets. Submissions that don’t match the rules are not added to the sheet.
Can I send my old form submissions to Google Sheets?
Yes. Use Google Sheets Data Sync in the feed settings. Choose Sync All Submissions or Sync by Date Range, and then click Sync Entries.
What do Freeze Header, Header Background, Odd Row Color, and Even Row Color do?
Freeze Header keeps the header row fixed at the top while you scroll. Header Background sets the color of the header row, and Odd Row Color and Even Row Color set the background colors of the odd and even rows.
Can I sort the data in my sheet?
Yes. Turn on Sheet Sorting in the Header Settings, choose the Sort Column, and select Ascending or Descending as the Sort Order.
Can I change the font style, size, and color of my sheet?
Yes. Use Header Appearance to style the header text, and Row Appearance to style the text of your data rows. You can choose Normal, Italic, or Bold, along with the font size and font color.
How do I stop a feed from sending data?
Turn off the Status toggle of the feed in the Form Feeds list. The feed will stop sending data to Google Sheets until you turn it on again.
Do I need to click Save Settings after making changes?
Yes. Click Save Settings at the bottom of the feed settings page, so your changes are applied to the feed.