Introduction

JetFormBuilder Google Sheet Connector PRO allows you to automatically send your JetFormBuilder form submissions directly to Google Sheets. By creating a Feed, you can connect your JetFormBuilder form with a specific Google Sheet and choose which form fields should be synced.

The Feed Setting manages the connection between your JetFormBuilder form and your Google Sheet. Once a Feed is configured correctly, every new form submission is automatically added as a new row in the connected Google Sheet.

Before creating a Feed, make sure your Google account is connected successfully. If you haven’t completed the authentication yet, follow the Existing Google Authentication Guide, the Manual Google Authentication Guide, or the Service Account Setup Guide. Once connected, build your JetFormBuilder form and continue with the Feed setup process.

Create a JetFormBuilder Form

First, go to your WordPress Dashboard to build your form.

1. Navigate to JetFormBuilder, then Add New Form.
2. Enter a title for your form.
3. Use the form builder to add the fields you need.
4. Configure each field according to your requirements.
5. Save or publish the form, then place it on your page.

After your JetFormBuilder form is ready, you can move on to creating a Feed in the Google Sheet Connector PRO settings.

Important Things to Keep in Mind

• • Make sure the JetFormBuilder form is published and working correctly before creating the Feed.
  • Ensure the JetFormBuilder Google Sheet Connector PRO plugin is installed and activated on your WordPress website.
  • Your Google Sheet connection should be completed before syncing form submissions. If you haven’t connected your Google account yet, follow one of our authentication guides for the Existing OAuth, Manual OAuth, or Service Account method.

• Use unique and clear field names in your form to make field mapping easier.
• After saving the Feed Settings, test a form submission to confirm the data is added to your Google Sheet successfully.

Create a New Feed

After creating your JetFormBuilder form, you need to create a Feed in Google Sheet Connector PRO to link the form with Google Sheets.

Follow the steps below to create a new Feed.

1. Go to WordPress Dashboard, then Google Sheet Connector, then Form Feed.
2. Click the Add Form Feed button.
3. The Create Feed section opens.
4. Enter a Feed Name of your choice.
5. Select the JetFormBuilder form you created from the dropdown menu.
6. Click the Submit button.

Your newly created Feed will now appear in the Feed Table.

Feed Table Overview

The Feed Table shows all your created Feeds along with the following details.

• Feed Name, which shows the name you gave the Feed.
• Page Name, which shows the page where your JetFormBuilder form is placed.
• Time, which shows when the Feed was created.
• Feed Status, which shows whether the Feed is enabled or disabled.

Feed Actions

The Feed Table offers a few action options.

The Edit icon opens the Feed Settings so you can configure it further.

The Delete icon removes the Feed.

Feed Status

Feed Status controls whether your Feed actually runs.

• When Feed Status is Enabled, your configuration is active and form submissions sync with Google Sheets.
• When Feed Status is Disabled, the Feed will not run, even if the rest of the configuration is complete.

Feed Detail Settings

Opening a Feed shows you several configuration sections.

Feed Information

At the top of the Feed Detail page, you will see basic Feed information along with the connected form details.

Manual Google Sheets Configuration

The Enable Manual Google Sheets Configuration option lets you enter your Google Sheet details by hand.

Turning this on reveals the following fields.

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

To find this information:

1. Open your Google Sheet.
2. Copy the required details.
3. Enter each value in its matching field, 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, that email will appear in red color.
• If the Google Sheet is shared with the Service Account email and Editor access has been granted, that email will appear in green color.

You can check your Service Account connection status just by looking at this color indicator.

If you haven’t configured a Service Account yet, follow the Service Account Setup Guide to generate your JSON key and connect Google Sheets.

Automatic Google Sheet Configuration

The Automatic Google Sheet Configuration option lets you pick your Google Sheet without manually entering a Sheet ID or Tab ID.

Follow these steps:

1. Select your Sheet Name.
2. Select the Tab Name you need.

If your Google account is not connected yet, complete the Existing Google Authentication or Manual Google Authentication setup before using Automatic Google Sheet Configuration.

Select Field to Sync

The Select Field to Sync option lets you choose which JetFormBuilder fields get sent to Google Sheets.

Select All Fields

• Turn on Select All to select every form field automatically.

Select Individual Fields

• Enable or disable individual fields using the toggle next to each one.

Change Field Order

• Drag and drop fields to reorder them.
• The order you set decides the column order in your Google Sheet.

Field Column Preview

• Each selected field shows a preview of the Google Sheet column it will be stored in.

Edit Field Name

• Every field has an Edit icon.
• Click it to change the field name before it syncs to Google Sheets.

Header Setting

The Header Setting option lets you customize how your Google Sheet looks.

You can customize:

Freeze Header

• Turn on Freeze Header to keep the header row fixed while scrolling.

Header Style

Customize the header appearance, including:

• Font Size
• Font Color
• Font Style

Row Style

Customize the row appearance, including:

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

Once you are done, click the Save Settings button to store your Feed configuration.

Google Sheet Data Sync

The Google Sheet Data Sync option lets you sync existing form submissions into Google Sheets.

This is useful when:

• You want to import older form entries.
• You need a one-time, data-wise synchronization.
• You want to sync submissions that came in before the Feed was created.

This option transfers your existing form data into the connected Google Sheet.

Save Feed Settings and Test a Form Submission

Once every Feed Setting is configured, click the Save Settings button.

After saving, the plugin automatically creates the header row in your connected Google Sheet using your JetFormBuilder field labels.

All the fields you selected will appear as column headers in the connected sheet.

Test Your Form Submission

After saving the Feed Settings, it is worth testing the integration.

1. Open the page where your JetFormBuilder form is published.
2. Fill out the form with sample information.
3. Click the Submit button.

You will see the submitted data added automatically as a new row, under the matching column headers.

This confirms your JetFormBuilder form and Google Sheet integration is working correctly.

If you need to import entries that were submitted before creating this Feed, use the Google Sheet Data Sync feature available in the PRO version.