Customer enquiries arrive in your email inbox at odd hours. Some get marked as read by mistake, some land in your spam folder, and others sit unanswered because two people on your team thought the other person was handling them. Copying those names, email addresses, and phone numbers by hand into a spreadsheet takes time and leads to typing mistakes.
You can solve this by sending your form entries straight to a spreadsheet. When someone fills out a contact or lead form on your website, a new row appears in your sheet right away. In this guide, I will show you how to set up a working wordpress form to google sheets workflow using Diviniket WP Forms, our form plugin for WordPress.
Why Send Form Data to Sheets?
WordPress stores your form submissions inside your website database, and you can always view them by heading to Divine Forms > All Entries in your dashboard. That built-in database storage is helpful because your data remains safe on your own server even if an email fails to deliver.
Working directly inside the WordPress admin area is not always practical for your whole team. You might not want to give every team member an administrator account just to review customer messages. A spreadsheet gives your team a shared space where they can sort rows, add notes, and check off completed enquiries. Setting up a direct google sheets integration means you do not need to copy and paste form submissions manually or pay for separate automation services.
When you send form data to sheets, your sales or support team can work with incoming leads without touching your WordPress dashboard. It also helps you build clean records for customer service logs or project requests.
What to Know Before You Begin
The connection relies on a Google service account. A service account is a special type of Google account meant for applications rather than individual people. It allows your WordPress site to communicate with Google Sheets using an authorized API token.
Before you start, here are a few practical facts about how this feature works:
- The sync is one-way. Submissions travel from your WordPress form to your spreadsheet. Editing a cell in Google Sheets will not change the entry stored inside your WordPress database.
- Data is sent when a visitor submits the form and synchronization is enabled for that specific form. It does not run retroactive syncs for entries submitted before the connection was activated.
- You need access to the Google Cloud console to generate service account credentials. That part takes a few minutes of setup on Google, but you only have to do it once.
- If you use file upload fields on your form, the plugin records references to those uploaded files so you can track attachments alongside your spreadsheet row data.
The plugin does not offer offline retry queues or complex multi-sheet branching logic. It simply sends the submitted field values directly to the sheet you configure.
Step 1: Create Your Form
Before connecting a spreadsheet, you need an active form to collect the information. You can build your layout quickly using the visual form builder included in the plugin.
Go to the Divine Forms section in your WordPress dashboard and select the option to add a new form. From there, you can add the fields your business requires:
- Name field: Collects your visitor's name. The plugin prioritizes this dedicated field when listing names in your entry logs.
- Email field: Collects the user's email address for notifications and follow-up emails.
- International phone input: Adds a phone field with a country flag selector and automatic country code prefixing, which keeps phone numbers organized when you serve international clients.
- File upload: Allows visitors to attach documents or images to their enquiries.
You can adjust basic styling options like form width, alignment, text color, and placeholder colors in the form settings. Once your fields are ready, save the form. The plugin will generate a shortcode that looks like this:
[divismfo_form id="123"]Keep in mind that 123 is only an example ID. Your form will have its own unique number. You can paste this shortcode into any standard WordPress block, widget, or page builder area when you are ready to publish it.
Step 2: Set Up Anti-Spam Protection
If you connect a form directly to a spreadsheet without any spam filtering, automated bots will fill your spreadsheet with junk rows. You will spend unnecessary time cleaning up fake entries.
The plugin includes built-in honeypot protection. A honeypot adds hidden checks designed to catch automated bots without showing confusing puzzles to human visitors. It works out of the box and requires no external API keys.
If you need stronger verification, you can configure external spam services under the plugin's global settings and switch them on per form. The plugin supports Google reCAPTCHA v2, Cloudflare Turnstile, and hCaptcha. When active, these services verify tokens with the respective provider during submission. To see how these options work together, review our guide on spam protection before launching your form.
Step 3: Connect Google Sheets to Diviniket WP Forms
Once your form fields are saved and your spam settings are in place, you can configure the spreadsheet connection. Here is the step-by-step walkthrough:
- Set up a Google service account: In the Google Cloud console, create a service account and generate a JSON credentials key file. Share your target Google Sheet with the email address of that service account, giving it editor permissions so it can write new rows.
- Enter credentials in the plugin settings: Open your WordPress dashboard, navigate to the plugin settings, and add your Google service account credentials. This allows the plugin to request an OAuth access token directly from Google.
- Configure the spreadsheet details: Enter your spreadsheet ID and the specific sheet name where you want form entries to appear. The spreadsheet ID is the long string of letters and numbers found in your sheet's browser URL.
- Validate the connection and headers: Use the validation options in the settings to confirm that the plugin can communicate with your spreadsheet. The plugin can request spreadsheet metadata, check sheet names, and read your existing header columns.
- Enable synchronization for the form: Open your specific form settings, make sure the Google Sheets synchronization option is turned on, and verify that your form fields match the columns you want to fill in the spreadsheet.
- Save your settings: Save your changes in the form builder and ensure your form shortcode is placed on the desired page or post.
Step 4: Send a Test Submission
Never assume an integration works without testing it yourself. Visit the front end of your website where your form shortcode is published and fill out the fields just like a regular customer would.
Because the plugin uses AJAX form submission, your page will submit the data without doing a full browser reload. After you see the success message, open your spreadsheet. A new row should appear containing the exact information you typed into the form, including links to any uploaded files you attached.
Next, log in to your WordPress dashboard and check Divine Forms > All Entries. Verify that the entry was recorded in your database as well. If the entry shows up in your WordPress admin but does not appear in your Google Sheet, open the form settings and re-check your spreadsheet ID, sheet name, and service account sharing permissions. You can also turn on the debug logging feature in the plugin settings to help identify where the connection encountered an issue.
Limitations to Keep in Mind
Every integration has boundaries, and knowing them upfront prevents frustration down the line:
- No two-way synchronization: The plugin pushes data outward to Google. It does not import rows from your spreadsheet back into WordPress.
- Requires individual form activation: Adding your credentials in global settings does not automatically send every form on your site to a sheet. You must turn on synchronization on each form where you want it active.
- Service account dependencies: If you change the permissions on your Google Drive folder or delete the service account key inside Google Cloud, new submissions will stop syncing until you update your credentials in WordPress.
- Standard server connectivity: If your web hosting server blocks outbound connections to Google APIs, the OAuth request cannot complete. This is a general WordPress hosting issue rather than a plugin bug.
FAQ
Can I send entries from multiple forms to different spreadsheets?
Yes. You can manage your spreadsheet settings and sheet names per form so that separate forms direct their entries to distinct sheets. Just ensure your service account has editor access to every spreadsheet you want to use.
What happens to submissions if Google Sheets is temporarily down?
Your data is not lost because Diviniket WP Forms saves every valid submission into your WordPress database first. You can always view or export those submissions from the Divine Forms entries list in your dashboard.
Do visitors need a Google account to fill out the form?
No, visitors do not need any Google account. The connection runs behind the scenes between your WordPress web server and Google Sheets using the service account credentials you entered.
Can I still receive email notifications when the sheet sync is turned on?
Yes. The Google Sheets integration operates alongside the built-in email notification settings. You can still send an alert email to the administrator and a confirmation email to the person who submitted the form.
Setting up your integration takes only a few minutes once your service account credentials are ready. For step-by-step video walkthroughs showing how to configure form fields and third-party tools, check out our YouTube tutorial channel. If you have questions about the plugin or want to connect with me directly, you can reach me through my LinkedIn developer profile.