⌘K
  1. Home
  2. Docs
  3. WPForms GSheetConnector
  4. Plugin Feed Settings – FREE Version
Free Version Guide

How to Connect WPForms with Google Sheets (Free Version)

This guide shows you how to connect an individual WPForms Contact Form with Google Sheets using the free WPForms Google Sheet Connector plugin, so every new entry is saved automatically in your sheet. If you haven’t installed the plugin yet, start with the Installation Process – FREE Version guide.

In the free version, you connect your sheet using the Manual Google Sheets Configuration method. You enter the Spreadsheet Name, Spreadsheet ID, Tab Name and Tab ID, and the plugin sends each submission to that tab.

Step 1: Confirm the Google Integration Is Complete

Before editing any form, make sure you have already connected WPForms Google Sheet Connector with your Google account, using either method:

Without this step, the plugin cannot send data to any Google Sheet, so double-check it before moving on.

Step 2: Open the Contact Form You Want to Connect

  1. In your WordPress dashboard, go to WPForms → All Forms.
  2. Find the Contact Form you want to connect with Google Sheets and click Edit.
Open a WPForms Contact Form in the editor to connect it with Google Sheets
Open your Contact Form in the WPForms editor to begin the Google Sheets configuration.

Step 3: Open the GSheetConnector Settings

  1. In the form builder, click Settings in the left sidebar.
  2. Select GSheetConnector (Existing) from the settings menu.
  3. Check the Google Account Connection box at the top. It should show your Google email and a green Connected badge. In the screenshot, the connection method shown is Authenticated Using Existing Method.
  4. Make sure Integration Mode is set to Manual Google Sheets Configuration.

WPForms Google Sheet Connector free version feed settings with manual Google Sheets configuration
The free feed settings screen: Google account connection, Manual Google Sheets Configuration and the sheet detail fields.

Note: If your form shows an Enable Settings dropdown, set it to On. If it is Off, new submissions will not be sent to Google Sheets.

Step 4: Find Your Google Sheet Details

Open the Google Sheet where you want to save the entries. You need four details, and all of them are easy to find:

  • Spreadsheet Name – the file name at the top-left of Google Sheets (for example, WPForms GSC).
  • Spreadsheet ID – the long code in the browser URL, between /d/ and /edit.
  • Tab Name – the name of the tab at the bottom of the sheet (for example, Sheet1).
  • Tab ID – the number after gid= in the URL. The first tab is usually 0.
Where to find Google Sheet Name, Sheet ID, Tab Name and Tab ID in a Google Sheet
Copy the Sheet Name, Sheet ID, Tab Name and Tab ID from your Google Sheet and its URL.

Step 5: Add the Sheet Details in the Plugin

Go back to the form’s GSheetConnector settings and paste the details into the matching fields:

  1. Spreadsheet Name – enter the name of your Google Sheet file.
  2. Spreadsheet ID – paste the ID copied from the URL.
  3. Tab Name – enter the tab name exactly as it appears (for example, Sheet1).
  4. Tab ID – enter the gid number (for example, 0).

Then click the orange Save button at the top of the WPForms builder.

Tip: Always copy and paste the Spreadsheet ID and Tab ID from the URL instead of typing them. A single wrong character will stop the data from reaching your sheet.

Step 6: Copy the Field Label Names from Your Form

In the free version, the plugin matches your form data to Google Sheet columns using the Label Name of each field. So you need to copy these labels first.

  1. Go back to your Contact Form editor and open the Fields tab.
Fields tab inside the WPForms Contact Form editor
Open the Fields tab in your Contact Form editor to view each field's label name.
  1. Note down the Label Name of each field you want to send to Google Sheets (for example, Name, Email, Comment or Message).
Copying field label names from a WPForms Contact Form
Copy the exact Label Name for every field you want to send to Google Sheets.

Step 7: Paste the Label Names into Your Google Sheet

  1. Open the Google Sheet linked to this Contact Form.
  2. In the first row (header row), paste each Label Name into its own column, one by one.
Pasting WPForms field labels as column headers in Google Sheets
Paste the form's field labels as column headers so each answer lands in the right column.

Make sure the spelling and spacing of each header matches the form’s Label Name exactly. Even a small mismatch can cause that field to be skipped.

Optional: Track the Submission Date

If you also want to see when each entry was submitted, add one more column in your Google Sheet named “date”. The submission date will then be filled in automatically for every new entry, with no extra setup.

Step 8: Submit a Test Entry and Check Your Google Sheet

Now let’s confirm everything works. In the free version, entries are sent to Google Sheets automatically at the moment a form is submitted, so you do not need to click any sync button.

  1. Open your form on the front end of your website and submit a test entry.
  2. Open your Google Sheet and go to the tab you connected.
  3. Check the first empty row under your headers. Your new entry should appear there, with each answer placed in the column that matches its field label.
WPForms form entries added to Google Sheets after form submission
Every new form submission is added as a new row in your Google Sheet, with answers placed under the matching column headers.

Each new submission is added as a new row, so your sheet keeps growing as visitors fill in your form. If you added the optional “date” column, the submission date is filled in for every entry too.

Note: A new Google Sheet starts with about 1,000 rows. If your data grows beyond that, add more rows manually in Google Sheets so new entries can continue to sync.

If the entry does not appear, check that the Spreadsheet ID, Tab Name and Tab ID are correct, that you clicked Save in the form builder, and that the column headers match your field labels exactly.

Good to know: In the free version, the Google Sheets Data Sync option (to send past entries by date range) is locked as a PRO feature. This does not affect new submissions. Every entry submitted after your setup is complete will still reach your Google Sheet automatically. Only entries that were submitted before the connection was set up are not sent.

Step 9: Free vs PRO Feed Settings

The free version gives you a simple, reliable way to send form entries to Google Sheets. The advanced feed options are locked and marked with a PRO badge in the plugin until you upgrade. The screenshot below shows the free feed settings screen.

WPForms Google Sheet Connector free feed settings with locked PRO features
In the free version, advanced feed options are locked with a PRO badge. Upgrade to unlock them.

With the PRO version, you unlock:

  • Automatic Google Sheets Configuration – auto fetch your Google Sheets list, auto detect tabs, one-click configuration and real-time entry sync.
  • Select Fields to Sync – choose specific fields, rename column headers and reorder fields with drag and drop.
  • Smart Tags – add dynamic values, such as the submission date with a custom format, as extra columns.
  • Header Settings – freeze the header row, set alternate row colors, and customize font size, style and color for headers and rows.
  • Sheet Sorting – sort your sheet by any column in ascending or descending order.
  • Conditional Logic – send entries only when they match your rules, and filter out unwanted or incomplete entries.
  • Google Sheets Data Sync – send past form entries (submitted before the connection was set up) to your sheet by date range, or sync all entries with one click. New submissions are sent automatically in both the free and PRO versions.

You can learn how to set up each option in our Plugin Feed Settings – PRO Version guide.

That’s it. Every new submission from your Contact Form will now be sent straight to your connected Google Sheet. If you would rather use a Service Account instead of your personal Google login, see the Service Account Setting guide. If a submission does not appear in your sheet as expected, check the System Status page to confirm your server meets all requirements.

Frequently Asked Questions

Why is my Contact Form not sending data to Google Sheets?

This is usually caused by one of these things: the Google integration is not completed, GSheetConnector is not enabled for that form, the Spreadsheet ID or Tab ID was entered incorrectly, or the column headers in your Google Sheet do not exactly match the field label names. Check each of these in order to find the issue.

Where do I find my Google Sheet ID and Tab ID?

Open your Google Sheet and look at the browser’s address bar. The Sheet ID is the long code between “/d/” and “/edit” in the URL. The Tab ID is the number after “gid=” once you click on the tab you want to use.

Do the Google Sheet column headers need to match the form's field labels exactly?

Yes. In the free version, the plugin matches your form data to the correct column using the exact Label Name from the form, so the header row in your Google Sheet must be spelled and spaced identically.

Is adding a date column required?

No, it is optional. Add a column named “date” only if you want the submission date recorded automatically with each entry.

What is the difference between Automatic and Manual Integration?

Automatic Integration connects your Google account with a simple one-click login, while Manual Integration uses a Client ID and Client Secret you create yourself in Google Cloud Console. Both connect your Google account. Choose whichever fits your setup.

Can I choose my Google Sheet from a dropdown in the free version?

No. The free version uses Manual Google Sheets Configuration, where you enter the Spreadsheet Name, Spreadsheet ID, Tab Name and Tab ID yourself. Automatic sheet and tab selection is available in the PRO version.

Will new form entries still reach Google Sheets if Data Sync is locked in the free version?

Yes. Google Sheets Data Sync is only used to send older entries by date range, and it is a PRO feature. In the free version, every new form submission is still sent to your Google Sheet automatically as soon as the form is submitted.

Can I send old WPForms entries to Google Sheets in the free version?

No. Past entries (submitted before the connection was set up) can be sent using the Google Sheets Data Sync option in the PRO version. In the free version, only new submissions are sent automatically.

Which features are only available in the PRO version?

Automatic Google Sheets configuration, field selection with drag and drop, Smart Tags, header and row styling, freeze header, sheet sorting, Conditional Logic and Google Sheets Data Sync are PRO features. The free version supports the basic manual connection.

Does the free version support Smart Tags?

No. Smart Tags are available in the PRO version, giving you more control over what data is sent to each Google Sheet column.

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