⌘K
  1. Home
  2. Docs
  3. Elementor Forms GSheetCon...
  4. Inside Elementor Form Widget Feed Settings – PRO Version

Single Google Sheet Configuration for Elementor Forms Google Sheet Connector Pro

This guide will help you connect your Elementor Pro form with Google Sheets using Elementor Forms Google Sheet Connector Pro. By following the steps below, you can automatically store Elementor form submissions directly into your Google Sheet.

GSheetConnector for Elementor Pro supports multiple Google authentication methods, including Existing Authentication, Manual Authentication, and Service Account Authentication. Once connected, you can either create a new Google Sheet or connect an existing sheet and start syncing your form entries automatically.

Note :

  • Before configuring Google Sheets, make sure Elementor Pro and Elementor Forms Google Sheet Connector Pro are installed and activated.
  • Your Elementor form must be configured properly before enabling Google Sheets integration.
  • Google authentication must be completed before connecting any sheet.
  • Service Account authentication is the recommended method for better security and easier management.
  • If you are using the Service Account method, make sure the target Google Sheet is shared with the Service Account email address.
  • Form Feed Settings is the recommended approach for new users because it provides better flexibility and easier management of multiple forms and sheets.

Step 1: Create a New Page

Create a new page in WordPress where you want to display your Elementor form.

Step 2: Add a Form Widget

Edit the page using Elementor.

Add a new row or section to the page and search for the Form widget in Elementor.

Drag and drop the Form widget onto the page and configure all required form fields.

Find and add the Form widget to your page
Search for the Form widget and add it to your page.

Step 3: Enable GSheetConnector Action

Navigate to the Actions After Submit section inside the Form settings.

Add GSheetConnector to the list of actions.

After adding the action, scroll down and open the GSheetConnector Pro settings panel.

Find and add the Form widget to your page
Search for the Form widget and add it to your page.

Step 4: Configure Google Authentication

If you have not connected Google Sheets yet, navigate to:
GSheetConnector → Settings → Integration

You will find the following authentication methods:

You may choose any authentication method based on your requirements.

Using MetForm instead of the Elementor Form widget? See our MetForm Setup Guide – Pro Version.

Recommended : Service Account Authentication.

Complete the authentication process and save your settings.

Step 5: Open GSheetConnector Pro Settings

Return to your Elementor form page and open the GSheetConnector Pro settings section.

The authentication method you selected in the Integration settings will be displayed here automatically.

Step 6: Manual Google Sheet Configuration

You will see the Enable Manual Google Sheet Configuration option.

This option allows you to manually enter and configure your Google Sheet details.

Use this option if you want to manually connect a specific spreadsheet and worksheet.

Step 7: Automatic Google Sheets Configuration

The Automatic Google Sheets Configuration section allows you to:

  • Create a new Google Sheet directly from Elementor.
  • Connect an existing Google Sheet.
  • Select an existing worksheet from your connected Google account.

Under the Sheet Name dropdown, select the Google Sheet you want to connect.

If your sheet is not displayed in the dropdown list, click the Fetch Sheets option.

Then click the Click Here link to reload and fetch all available Google Sheets from your connected Google account.

Step 8: Configure Form Feed Settings (Recommended)

You will also see the following link:

Click here to Setup Form Feed Settings to easily configure multiple feeds simultaneously

Using Form Feed Settings, you can:

  • Create multiple feeds.
  • Connect multiple Google Sheets.
  • Configure different sheets for different forms.
  • Manage integrations more efficiently.
Note : This configuration method was available in older plugin versions and has been retained for existing users. For new users, we strongly recommend using the Form Feed feature available under Plugin Settings → Form Feed. It provides a more flexible, organized, and user-friendly experience.
Elementor Form GSheetConnector Inner Settings
Access the GSheetConnector settings from the Elementor Form widget's Inner Settings panel.

Step 9: Select Fields to Sync

The Select Fields to Sync option allows you to control which form fields are sent to Google Sheets.

You can:

  • Use Check All to enable all fields at once.
  • Use Uncheck All to disable all fields.
  • Manually enable or disable individual fields as needed.

Enable only the fields that you want to appear in your Google Sheet.

Step 10: Header Settings

The Header Settings section allows you to customize the appearance of your Google Sheet.

Available options include:

  • Freeze Header & Column :
    • 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 Background Color
  • Odd Row Color
  • Even Row Color

These settings help improve the readability and organization of your spreadsheet.

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.

Step 11: Sync Existing Entries

At the bottom of the settings section, you will find the following option:

Click here to Sync with your Selected Google Sheet

Use this option to send previously submitted form entries to your connected Google Sheet.

This feature is useful when you want to export older form data that was collected before the Google Sheet connection was configured.

Save Feed Settings and Test Form Submission

After completing all Feed Settings, click on the Save Settings button.

Once the Feed Settings are saved successfully, the plugin will automatically create the header row in your connected Google Sheet using your Elementor Form field labels.

All selected form fields will be displayed as column headers in the connected sheet.

Save feed settings to display form fields in Google Sheet
Save the feed settings to display your form field labels as headers in the connected Google Sheet.

Test Form Submission

After saving the Feed Settings, it is recommended to test the integration.

  1. Open the page where your Elementor Form is published.
  2. Fill out the form with sample information.
  3. Click on the Submit button.
After the form is submitted successfully, open your connected Google Sheet. Google account connected successfully.

You will see the submitted form data automatically added as a new row in the sheet under the corresponding column headers.

This confirms that your Elementor Form and Google Sheet integration is working correctly.

Submit form to add data to connected Google Sheet
Submit the form to add the filled information as a new entry in the connected Google Sheet.

Frequently Asked Questions

Which Google authentication method should I use?

GSheetConnector for Elementor Pro supports Existing Authentication, Manual Authentication, and Service Account Authentication. We recommend Service Account Authentication because it is more secure, reliable, and does not require re-authentication when a Google account password changes.

Can I create a new Google Sheet directly from Elementor?

Yes. The Automatic Google Sheets Configuration section allows you to create a new Google Sheet directly from the Elementor Form settings and connect it immediately without leaving your website dashboard.

Can I connect an existing Google Sheet?

Yes. You can select an existing Google Sheet from the Sheet Name dropdown and connect it with your Elementor Form. Once selected, form submissions will automatically be stored in the selected sheet.

Why am I unable to find my newly created Google Sheet in the Sheet Name dropdown?

If your newly created sheet does not appear in the dropdown list, click the Click Here link below the Sheet Name field. This will refresh and fetch the latest sheets available in your connected Google account.

Can I use multiple Google Sheets for different Elementor Forms?

Yes. You can use the Form Feed Settings feature to create separate feeds for different Elementor Forms and connect each form to a different Google Sheet.

Should I use the Form Feed feature or the Elementor Form Inner Settings?

For new users, we recommend using the Form Feed feature available in the plugin settings. It provides better feed management, supports multiple sheets, and makes configuration easier. The Elementor Form Inner Settings option is retained mainly for compatibility with older setups.

What happens if I add new fields to my Elementor Form after completing the setup?

If you add new form fields after the initial setup, open the GSheetConnector settings again, review the field mapping, save the settings, and update the Google Sheet headers if necessary.

Can I customize the column headers in Google Sheets?

Yes. The plugin allows you to edit field labels before syncing them. The edited labels will be used as column headers in the connected Google Sheet.

Will existing data in my Google Sheet be deleted when I connect the form?

No. Connecting your Elementor Form to Google Sheets will not delete existing spreadsheet data. New form submissions will be added as new rows in the connected worksheet.

Can I sync previous form submissions after connecting Google Sheets?

Yes. Use the Click here to Sync with your Selected Google Sheet option to send previously submitted form entries to your connected Google Sheet.

Do I need to save the settings after selecting fields and configuring the sheet?

Yes. After completing the configuration, you must click the Save Settings button. The plugin will then create the column headers and prepare the sheet for future form submissions.

How can I verify that the integration is working correctly?

After saving the settings, submit a test entry through your Elementor Form. Open the connected Google Sheet and verify that a new row has been added with the submitted information.

Why are the Google Sheet column headers not created automatically?

Column headers are generated when the Feed Settings are saved successfully. If the headers are not created, verify that the sheet is connected correctly, required permissions are granted, and the settings have been saved without errors.

Can I disable specific fields from being sent to Google Sheets?

Yes. The Select Fields to Sync section allows you to choose exactly which form fields should be synced. Disabled fields will not be sent to Google Sheets.

Can I change the Google Sheet later without recreating the form?

Yes. You can edit the GSheetConnector settings at any time and select a different Google Sheet or worksheet without recreating the Elementor Form.

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