Configure Gravity Forms Google Sheet Connector PRO Feed Settings

Introduction

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

The Feed Setting helps you manage the connection between your Gravity 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 a Gravity Form and configure the required fields. Follow the below steps to create a Gravity Form and start the Feed setup process.

Create Gravity Form

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

1. Navigate to Forms → New Form.
2. Enter your form title and description.
3. Add the required fields from the field panel on the right.
4. Configure your form fields according to your requirements.
5. Click Save Form.
6. Publish the form on a page using the Gravity Forms block or shortcode.

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

Important Things to Keep in Mind

• Make sure the Gravity Form is published and working correctly before creating the Feed.
• Ensure that the Gravity Forms 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 labels 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 Gravity 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 Forms → Edit your form → Settings → Emails & Actions.
2. Click on Add New Section and select Google Sheet Connector Pro.
3. Click on the Add New button to create a Feed.
4. Enter your required Feed Name.
5. Click on the Save button.

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

Feed List Overview

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

• Feed Name: Displays the name of your created Feed.
• Form Name: Shows the Gravity Form the Feed is attached to.
• Active: Shows whether the Feed is enabled or disabled.

Feed Actions

The Feed List provides different action options:

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

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

Feed Status

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

• If the Feed Status is Active, your Feed configuration will work and form submissions will sync with Google Sheets.
• If the Feed Status is Inactive, 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.

Integration Mode

Set the Integration Mode to Automatic to connect your Google Sheet quickly, or use Manual if you prefer to enter the Sheet details yourself.

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. Click on Fetch Spreadsheet.
2. Select your Sheet Name.
3. Select your required Tab Name.
4. Or click Create New Google Sheet to generate a new sheet automatically.

Manual Google Sheets Configuration

The Manual Integration Mode allows you to manually enter your Google Sheet details.

Enter the following details:

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

To get this information:

1. Open your Google Sheet.
2. Copy the required details from the Sheet URL and tab.
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.

Select Field To Sync (Field List)

The Field List option allows you to choose which Gravity Form fields should be sent to Google Sheets.

Add Fields

• Add the fields you want to sync from your Gravity Form based on your requirement.

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.

Edit Field Name

• You can edit a field’s label before syncing it, so the column header in Google Sheets shows the name you prefer.

Merge Tags

Using Merge Tags, you can add extra data columns to your Google Sheet, such as:

• Entry ID
• Entry Date
• Form URL

Header Setting

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

You can customize:

Header Sorting

• You can sort headers according to your preference.

Freeze Header

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

Colors

Customize the appearance of your Google Sheet:

• Header background color
• Odd row background color
• Even row background color

Sheet Sorting

• Choose between Ascending or Descending order for how new entries are sorted in the sheet.

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

Google Sheet Data Sync

This section allows you to sync existing form entries 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 entries after creating a Feed.

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

Save Feed Settings and Test Form Submission

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

Once the Feed Settings are saved successfully, the plugin will automatically create the header row in your connected Google Sheet using your selected Gravity 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 Gravity 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 Gravity Form and Google Sheet integration is working correctly.