- Why Send WPForms Entries to Google Sheets Automatically?
- How Does the Automatic Sync Work?
- What You Need Before You Start
- Free vs PRO: Automatic WPForms to Google Sheets
- How to Automatically Send WPForms Entries to Google Sheets (Step by Step)
- PRO Automation Options
- Send Old or Missed Entries with Data Sync (PRO)
- Optional: Keep a Copy in the WPForms Database Tab
- Practical Examples
- Troubleshooting: WPForms Entries Not Sending Automatically
- Best Practices
- Conclusion
- FAQs
How to Automatically Send WPForms Entries to Google Sheets
You can automatically send WPForms entries to Google Sheets with GSheetConnector for WPForms. Connect your Google account once, switch on Google Sheets in your form’s settings and save. From then on, every new submission is added to your spreadsheet as a row at the moment it is sent.
This guide is based on the real free and PRO plugins. It shows how the automatic sync works, the exact steps to set it up, what PRO adds and how to fix problems. It is part of our WPForms Google Sheets guide. If you want the no-Zapier angle, read WPForms to Google Sheets without Zapier.
Quick answer: Install GSheetConnector for WPForms and click Sign in with Google under WPForms → Google Sheet → Integration. Edit your form, open Settings → Google Sheets, enter the Spreadsheet Name, Spreadsheet ID, Tab Name and Tab ID, and save. Each new entry is then sent to your sheet automatically when the form is submitted.

Why Send WPForms Entries to Google Sheets Automatically?
WPForms keeps your entries inside WordPress. That is fine until your team needs them in a sheet to sort, share, filter or build reports. Copying entries by hand is slow and easy to forget. Automatic sending fixes this.
- Instant data: the row is added when the form is submitted, so your sheet is always current.
- No manual exports: no downloading or pasting entries.
- Team access: sales, support or hiring teams work in Google Sheets without a WordPress login.
- Easy reports: use filters, formulas and charts on live data.
For more ways to connect WordPress to Sheets, see our Google Sheets integration overview.
How Does the Automatic Sync Work?
The plugin hooks into WPForms. When a visitor submits a form, WPForms processes the entry and the plugin then sends it to Google Sheets using your saved connection. There is no timer and no schedule, so you will not wait for a cron job.
The free and PRO plugins use the same idea with different extras:
| Part | Free plugin | PRO plugin |
|---|---|---|
| When it runs | On form submission | On form submission |
| Which sheet | The Spreadsheet Name, ID, Tab Name and Tab ID you enter for the form | Dropdown selection, a new spreadsheet, or manual details |
| What is sent | Date, time and every field, matched by the header text in row 1 | The fields you enable, with your column names and order |
| Duplicate protection | Each entry is marked as sent | An Entry ID column matches rows to entries |
| Sheet writing | Adds a row | Adds a row, can freeze and style the header |
Both plugins work with WPForms Lite and WPForms Pro.
What You Need Before You Start
| Item | Why you need it |
|---|---|
| WordPress with WPForms (Lite or Pro) | The form that creates the entries. |
| GSheetConnector for WPForms (free or PRO) | The connector. Its settings appear under WPForms. |
| A Google account and a Google Sheet | The account must have edit access to the sheet. |
| A saved form | Your field labels become the column names. |
Free vs PRO: Automatic WPForms to Google Sheets
| Feature | Free | PRO |
|---|---|---|
| Send new entries automatically on submission | Yes | Yes |
| Works with WPForms Lite and Pro | Yes | Yes |
| Sign in with Google (Auto Setup) and Service Account | Yes | Yes |
| Manual Client/Secret Key | No | Yes |
| Enter Spreadsheet Name, ID, Tab Name and Tab ID | Yes | Yes |
| Pick the spreadsheet and tab from dropdowns, or create a new spreadsheet | No | Yes |
| Select fields, rename columns, Smart Tags, column order | No | Yes |
| Entry ID column to match rows | No | Yes |
| Conditional Logic | No | Yes |
| Header settings (freeze, fonts, colors) | No | Yes |
| Data Sync for old or missed entries | No | Yes |
| Multiple feeds per form | No | Yes |
| WPForms Database tab | Yes | Yes |
How to Automatically Send WPForms Entries to Google Sheets (Step by Step)
Step 1: Install and Activate the Plugin
Install and activate WPForms, then install GSheetConnector for WPForms from Plugins → Add New. For PRO, upload the PRO plugin and activate your license. A Google Sheet item appears under the WPForms menu. See the plugin documentation for install help.
Step 2: Connect Your Google Account
Go to WPForms → Google Sheet → Integration. Keep Existing Client / Secret Key (Auto Setup) selected and:
- Click Sign in with Google.
- Choose the account that owns your sheets.
- Allow access to Google Drive and Google Sheets.
- Click Allow and save the code if you are asked.

The list also offers Service Account (Recommended). The plugin recommends it because Auto Setup can be affected by Google API quotas, so a few entries may not sync. Paste or upload your JSON credentials and share your sheet with the service account email. PRO adds the Manual Client/Secret Key option. For a full comparison, read WordPress to Google Sheets authentication methods, and see how the setup works without your own API key.

Step 3: Prepare Your Google Sheet
Create or open a Google Sheet and note:
- Spreadsheet Name: the file name at the top.
- Spreadsheet ID: the code in the URL between
/d/and/edit. - Tab Name: the tab at the bottom, such as Sheet1.
- Tab ID: the number after
gid=in the URL.
Free plugin: type your headers in row 1, for example Name, Email and Comment or Message. They must match your form field labels. You can also add date and time columns, which the free plugin fills from your WordPress date and time settings. PRO: the plugin manages the columns for you.

Step 4: Open the Google Sheets Settings in Your Form
The automatic sync is set per form. Go to WPForms → All Forms, edit your form, click Settings and then Google Sheets.

Step 5: Enter Your Spreadsheet Details
A box shows your connection status and connected account. Under Integration Mode choose Manual Google Sheets Configuration and fill in the Spreadsheet Name, Spreadsheet ID, Tab Name and Tab ID. Use View SpreadSheets to check the link. In PRO you can switch to Automatic Google Sheets Configuration, pick the spreadsheet and tab from dropdowns, or create a new spreadsheet by name.
Step 6: Save the Form and Test
Click Save in the builder, submit a test entry on your live form and open the sheet. The new row appears with no further action.

PRO Automation Options
GSheetConnector for WPForms PRO adds more control over the automatic sync.

Select Fields and Set Column Names
In Select Fields to Sync enable the fields you need, set the Column Name and use Smart Tags for dynamic values. Columns Manager lets you drag and drop the column order. The Entry ID column matches sheet rows to entries. It is the first column on a new sheet and is added after the last column on a sheet that already has data.
Send Only Some Entries with Conditional Logic
Turn on Conditional Logic and set rules from your form values. If an entry does not match, the plugin stops and does not send it. The same rules apply when you use Data Sync or Send To Spreadsheet.
Style the Header
Header Settings lets you freeze the header and set the header font style, size, and the header, odd and even row colors.
Use Several Feeds
PRO supports more than one feed per form, so one form can send to more than one sheet or tab.
Send Old or Missed Entries with Data Sync (PRO)
Automatic sending covers new submissions. For entries made before you connected, or entries that did not reach the sheet, use Google Sheets Data Sync in the form builder.

- Open the form, go to Settings → Google Sheets and scroll to Google Sheets Data Sync.
- Pick a From Date and To Date, or tick Sync All Entries with this feed.
- Check the Entries available to sync count.
- Choose Add missing entries only, or Clear this sheet tab and sync all again, which keeps the header row.
- Click Click Here next to Sync to Google Sheet and read the summary.
Rows are matched by Entry ID, so entries already in the sheet are not added again. If the sheet has no Entry ID column, the plugin tells you and does not write, to avoid duplicates. You can also use Send To Spreadsheet for one or many entries in the WPForms Database tab.
Optional: Keep a Copy in the WPForms Database Tab
Under WPForms → Google Sheet → WPForms Database, turn on Enable Database Storage and click Save Settings. It is off until you enable it. You can then view, search, mark read or unread and delete entries. In the free plugin, Export CSV and Send To SpreadSheet show an upgrade message. In PRO both work.

Practical Examples
Example 1: Lead Alerts for Sales
Send a contact form to a Leads tab. Your team sees each new lead in the sheet right after submission and can add a status column next to it.
Example 2: Quote Requests and Contact Forms in Different Sheets
Each form has its own Google Sheets settings. Point each one to its own spreadsheet or tab.
Example 3: Qualified Leads Only with PRO
Use Conditional Logic to send only entries where a field matches your rule, such as a budget choice. Your sheet stays clean.
Troubleshooting: WPForms Entries Not Sending Automatically
| What you see | What to check |
|---|---|
| Nothing is added | Check the Integration tab. If it shows Auth Required, sign in with Google again. |
| Only some forms send | Open each form, go to Settings, Google Sheets and confirm it is enabled and saved. |
| Values are in the wrong columns (free) | Check that the row 1 headers match your field labels. |
| Sheet not found | Check the Spreadsheet Name, ID, Tab Name and Tab ID, and that the account can edit the sheet. |
| Some entries are missing | Use a Service Account. In PRO, run Data Sync with Add missing entries only. |
| Entries blocked in PRO | Check Conditional Logic. An entry that does not match is not sent. |
| You need the reason | Open the Error Log on the Integration tab. |
Still stuck? Contact GSheetConnector support.
Best Practices
- Test every form after you save its settings.
- Use a Service Account for the most reliable connection.
- Keep headers stable and match them to field labels in the free plugin.
- Do not delete the Entry ID column in PRO sheets.
- Share the sheet carefully with only the people who need it.
Conclusion
To automatically send WPForms entries to Google Sheets, connect Google, open your form’s Google Sheets settings, enter your sheet details and save. Every new entry is then added as a row when it is submitted. PRO adds dropdown setup, field control, conditional logic, header styling and Data Sync for missed entries.
Ready to automate your forms? Get GSheetConnector for WPForms free or explore the PRO version. Read more in our WPForms Google Sheets guide.
FAQs
1. How do I automatically send WPForms entries to Google Sheets?
Install GSheetConnector for WPForms, sign in with Google at WPForms → Google Sheet → Integration, then open your form in the WPForms builder. Go to Settings → Google Sheets, enter your spreadsheet details and save. After that, every new submission is added to your sheet as a row on its own.
2. Is the sync real-time?
Yes. The plugin runs when the form is submitted, so the row is added to Google Sheets as part of the submission. You do not need to click anything or run an export.
3. Does the plugin sync on a schedule?
No. There is no timed or scheduled sync. Entries are sent when they are submitted. With PRO you can use Data Sync to send older or missed entries when you need to.
4. Can WPForms send entries to Google Sheets without a plugin?
WPForms has no built-in Google Sheets feature. You need a connector plugin or an outside automation service. GSheetConnector keeps the connection inside WordPress.
5. Do I need WPForms Pro?
No. Both GSheetConnector for WPForms plugins work with WPForms Lite and WPForms Pro.
6. Will the same entry be added twice?
The free plugin marks each entry as sent, so a submission is added once. PRO adds an Entry ID column and matches rows by Entry ID, which also prevents duplicates when you use Data Sync.
7. What is sent to Google Sheets?
In the free plugin, the submission date and time plus every form field, placed under the column whose header matches the field label. In PRO you choose the fields, rename the columns, use Smart Tags and set the column order.
8. Can I send only some entries to Google Sheets?
Yes, with PRO. Turn on Conditional Logic in the form’s Google Sheets settings. When an entry does not match your rules, the plugin stops and does not send it.
9. How do I send old WPForms entries to Google Sheets?
With PRO, use Google Sheets Data Sync in the form builder. Pick a date range or tick Sync All Entries with this feed, then choose Add missing entries only or Clear this sheet tab and sync all again. Data Sync works with entries saved by WPForms or stored by the plugin’s WPForms Database.
10. Can I send one form to several sheets?
Yes, with PRO. You can add more than one feed to the same form. Each form also has its own Google Sheets settings, so different forms can use different sheets.
11. Why are my WPForms entries not reaching Google Sheets?
Check that your Google account is connected on the Integration tab, that the form’s Google Sheets setting is saved, and that the Spreadsheet Name, Spreadsheet ID, Tab Name and Tab ID are right. Then open the Error Log on the Integration tab. Switching to a Service Account also helps if some entries are missed.