Connect Google Sheets Integration Easily to Your WordPress Site

Prema Anjum . April 12, 2021 . 5 minutes
Google sheets integration

We often need to gather and analyze information from different sources to identify the big picture of research. For online businesses, you might have to collect your clients’ data for various purposes. But manually copying and pasting data from one place to another consumes a lot of time. Even sometimes, there is a chance of wrong data input. Well, there’s a better solution; Google Sheets integration. 

There are multiple ways to connect Google Sheets with your WordPress website. But, we’ll discuss only how to make a bridge between Sheets and a form plugin. To do that, we chose Fluent Forms, and the reason is obvious. It is the e most profitable plugin to build WordPress forms.

Today, we’re going over the process of combining Fluent Forms with Google sheets integration – starting with the features of Google Sheets. Let’s jump right in. 

What makes Google Sheets rich?

The features that made Google Sheets successful are accessible through the Sheets API. You can update the spreadsheets with the API easily. More so, you can:

  • Import, export, and format data from Sheets
  • Set up data validation
  • Design and edit charts from embedded sheets
  • Control conditional formatted data
  • Build and update ranges
  • Create and adjust filtered views
  • Make and manage pivot tables

Fluent Forms

Fluent Forms is a robust form builder that will let you design unique contact forms that collect leads automatically to your database. The WordPress tool is equipped with drag and drop, 65+ pre-built templates, conditional logic, anti-spam functions like Honeypot, reCAPTCHA,hCaptcha etc. 

But that’s not the end of the features the form builder provides. You can also schedule and restrict your contact forms and place partial form entries to collect data if users do not hold the submit button. More so, there are tons of third-party integrations available in WP Fluent Forms. Google Sheets integration is one of the items. So, let’s see how you can unite these two platforms together. 

How to integrate Google Sheets to WordPress with Fluent Forms

Send the user submissions data to your Google Spreadsheet without any hassle with WP Fluent Forms. Here are the steps of integrating Google Sheets with the form builder:

  1. Turn on the Google Sheets module
  2. Get the access code from Google Sheets
  3. Copy and paste the code in Google Sheets settings
  4. Configure the integration feed & connect Spreadsheet ID
  5. Give a name to the Worksheet
  6. Map the spreadsheet fields

Let’s proceed with the steps.

Step 1: Turn on the Google Sheets module

Hover over to the Fluent Forms pro on your WordPress dashboard from the admin panel sidebar. Click on Integrations Modules, and activate the Google Sheets module just like the given screenshot.

Google sheets, Google sheets API, Google forms

Step 2: Get the access code from Google Sheets

Now, go to the Global Settings section from the left sidebar. Choose the Google Sheets option from the sidebar of the new page. Here, you will be asked for a Google Sheets’ Access Code. To get the code, click on the Get Google Sheet Access Code just below the Access Code bar.

Google sheets integration

Step 3: Copy and paste the code in Google Sheets settings

After clicking on the link, a new window will open, and you have to select the email connected with your spreadsheet account. Once you give your email, you will get a link. Then you have to copy and paste it on your application. For better understanding, see the screenshot below.

WordPress, contact forms

After that, click on the Verify Code button from the respective page. 

WP Fluent Forms, Google sheets integration

Voila! Your Google Sheet integration is now up and running.

Google forms, Google sheets API

Step 4: Configure the integration feed & connect Spreadsheet ID

Go to the All Forms from WP Fluent Forms and select any form you want to connect with Google Spreadsheet. Get into the settings option from the respective form.

web forms, WordPress

Now you need to go to the Marketing & CRM integrations in the Settings & Integrations section. Here, hover on the Add New Integration button and select the Google Sheet option for your desired action.

Google sheets integration

Step 5: Give a name to Spreadsheet

Configure the settings according to your requirements. Give a name to the feed first, then paste the Spreadsheet ID. To get the ID, open a Google sheet from your drive where you want to paste your data. You will get the ID here. Follow the given screenshot.

google sheets templates, WP Fluent Forms

The red underlined line is your ID. Copy and paste it to the settings page. Now give a name to your Worksheet. One Worksheet can maintain multiple sheets like Sheet1, Sheet2, Sheet3, or any defined name.

Google Forms, WP Fluent Forms

Step 6: Map the Spreadsheet fields

Name the fields as you want to map them with your form fields. For example, we are settling name, email, and message fields only. If you want, you can add more. Finally, click on the Create Google Sheets Feed button when your feed is complete.

Google sheets

Congratulations! You have successfully connected your Google Sheets integration feed with your form.

To conclude

Google Sheets is a powerful, cloud-based application that helps you make sophisticated spreadsheets. Besides, Fluent Forms is a hefty tool that works as a complete solution for your website. If you can connect these two, you will get the best result for your data management and business output. 
So, apply the Google Sheets integration with the lightweight WordPress form builder, Fluent Forms, for a better marketing experience. And while you are on this, you can also take a look at the best market research tools of the era.

Prema Anjum
Prema Anjum

Hello, This is Prema. I work as a digital marketer for Fluent Forms at WPManageNinja. When I am not playing with words, I go to explore nature.

8 responses to “Connect Google Sheets Integration Easily to Your WordPress Site”

  1. Danny Avatar

    I get error when I try do delete fields. I had to delete some form fields and column in spreadsheet receiving data. When I delete also from the mapping fields I get error when saving it.

    1. Prema Anjum Avatar
      Prema Anjum

      Please open a support ticket here. We need to look into the problem and find a solution based on this. https://wpmanageninja.com/support-tickets/#/

  2. Shahrzaad Parekh Avatar

    Is the Google Sheets integration available for free users or is it a PRO feature ?

    1. Inqiat Reza Avatar
      Inqiat Reza

      Hi Shahrzaad,
      Google Sheets is a pro-integration. And if you’re wondering about free vs. pro features & integrations of Fluent Forms, please check out this page – https://fluentforms.com/free-vs-pro/
      Thank you

  3. Syarif Avatar

    i tried this instruction and worked,
    Then i tried to delete some data on fluentform “all entries” page but data in google sheet didn’t delete.
    can I delete data or update data in google sheet from fluent ?

    thank you

    1. Prema Anjum Avatar
      Prema Anjum

      Any deleted data from Fluent Forms won’t be updated on Google Sheets. Only new entries on Fluent Forms will be added on Google Sheets automatically.

  4. Copperwoman Avatar

    I get an error after setting up 21 fields.
    Can I add more than this?

    1. Prema Anjum Avatar
      Prema Anjum

      Hello Copperwoman,
      Thanks for your question. Your issue is not clear to us. Could you please open a support ticket here: https://wpmanageninja.com/support-tickets/#/

Leave a Reply

Your email address will not be published. Required fields are marked *

Search Post

Subscribe for weekly email
fluentform Newsletter Inline
We won’t send you spam. Unsubscribe at any time.