Introduction

GSheetConnector for Elementor Pro allows you to automatically send your Elementor Form submissions directly to Google Sheets. By creating a Feed, you can connect your Elementor Form with a specific Google Sheet and configure which form fields should be synced.

The Feed Setting helps you manage the connection between your Elementor Form and Google Sheet. Once the Feed is configured correctly, every new form submission will be automatically added as a new row in your connected Google Sheet.

Before creating a Feed, you need to create an Elementor Form and configure the required fields. Follow the below steps to create an Elementor Form and start the Feed setup process.

Create Elementor Form

First, go to your WordPress Dashboard and create a new page.

1. Navigate to Pages → Add New.
2. Enter your page title.
3. Click on Edit With Elementor.
4. Search for the Form Widget and add it to your page.
5. Configure your form fields according to your requirements.
6. Save or update the page.

After creating the Elementor Form, you can proceed with creating a Feed in GSheetConnector.

Important Things to Keep in Mind

• Make sure the Elementor Form is published and working correctly before creating the Feed.
• Ensure that the GSheetConnector plugin is installed and activated on your WordPress website.
• Your Google Sheet connection should be completed before syncing form submissions.
• Use unique and clear field names in your form to make field mapping easier.
• After creating and saving the Feed Settings, test your form submission to confirm that data is successfully added to your Google Sheet.

Create New Feed

After creating the Elementor Form, you need to create a Feed in GSheetConnector to connect your form with Google Sheets.

Follow the below steps to create a new Feed:

1. Go to WordPress Dashboard → GSheetConnector → Form Feed.
2. Click on the Add Form Feed button.
3. The Create Feed section will open.
4. Enter your required Feed Name.
5. Select the Elementor Form that you created from the dropdown menu.
6. Click on the Submit button.

Your newly created Feed will be displayed in the Feed Table.

Feed Table Overview

In the Feed Table, you can view all your created Feeds with the following details:

• Feed Name: Displays the name of your created Feed.
• Page Name: Shows the page where your Elementor Form is added.
• Time: Displays the Feed creation date and time.
• Feed Status: Shows whether the Feed is enabled or disabled.

Feed Actions

The Feed Table provides different action options:

View Icon (Eye Icon) –  Click on the Eye Icon to view the connected form details of your Feed.

Edit Icon –  Click on the Edit Icon to open and configure Feed Settings.

Delete Icon – Click on the Delete Icon to remove the Feed.

Feed Status

The Feed Status option controls whether your Feed Settings will work or not.

• If the Feed Status is Enabled, your Feed configuration will work and form submissions will sync with Google Sheets.
• If the Feed Status is Disabled, your Feed Settings will not work even if the configuration is completed.

Feed Detail Settings

When you open Feed Settings, you will see different configuration options.

Feed Information

At the beginning of the Feed Detail page, you will see basic Feed Information, including the connected form details.

Manual Google Sheets Configuration

The Enable Manual Google Sheets Configuration option allows you to manually enter your Google Sheet details.

Enable this option to display the required settings:

• Sheet Name
• Sheet ID
• Tab Name
• Tab ID

To get this information:

1. Open your Google Sheet.
2. Copy the required details.
3. Enter the information in the respective fields as shown in the screenshot.

Service Account Permission

If you are using the Service Account Method, your Google Sheet must be shared with the Service Account email address.

• If the Google Sheet is not shared with the Service Account email, the Service Account email will appear in red color.
• If the Google Sheet is shared with the Service Account email and Editor access is provided, the Service Account email will appear in green color.

You can verify the Service Account connection status using the email color indicator.

Automatic Google Sheet Configuration

The Automatic Google Sheet Configuration option allows you to select your Google Sheet without manually entering Sheet ID and Tab ID.

Follow these steps:

1. Select your Sheet Name.
2. Select your required Tab Name.

Select Field To Sync

The Select Field To Sync option allows you to choose which Elementor Form fields should be sent to Google Sheets.

Select All Fields

• Enable the Select All option to select all form fields automatically.

Select Individual Fields

• You can enable or disable individual fields using the toggle option available next to each field.

Change Field Order

• You can drag and drop fields to change their position.
• The field order will decide the column order in your Google Sheet.

Field Column Preview

• The selected field position will display the corresponding Google Sheet column where the data will be stored.

Edit Field Name

• Each field has an Edit Icon.
• Click on the Edit Icon to change the field name before syncing it with Google Sheets.

Header Setting

The Header Setting option allows you to customize the appearance of your Google Sheet.

You can customize:

Freeze Header

• Enable the Freeze Header option to keep the header row fixed while scrolling.

Header Style

Customize the header appearance:

• Font Size
• Font Color
• Font Style

Row Style

Customize the Google Sheet row appearance:

• Font Style
• Font Size
• Font Color
• Odd Row Color
• Even Row Color

After completing all settings, click on the Save Settings button to save your Feed configuration.

Google Sheet Data Sync

The Google Sheet Data Sync option allows you to sync existing form submission data with Google Sheets.

You can use this option when:

• You want to import old form entries.
• You need to perform data-wise synchronization.
• You want to sync previously submitted form data after creating a Feed.

Using this option, you can transfer existing form data to your connected Google Sheet.

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.

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.

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.