# How to Connect Fluent Forms with GSheetConnector: Step-by-Step Guide

Source: https://www.gsheetconnector.com/how-to-connect-fluent-forms-with-gsheetconnector-step-by-step-guide

Managing form submissions often feels like juggling too many balls at the same time. You get an email notification or manually check in your wordpress database, then [manually copy paste everything into a spreadsheet](https://www.gsheetconnector.com/manual-data-entry-costs) for your team to access that lead.

Isn’t it time consuming. Yes it is, and with that it is repetitive too. And honestly there is a better way to do this which can save your time, energy and money.

At GSheetConnector, we have built a simple solution that automatically sends every [Fluent Forms](https://wordpress.org/plugins/fluentform/) submission directly to Google Sheets. No manual work needed. No copy-pasting needed. Just automatic data sync that happens in real-time.

In this guide, we will see through exactly How To Connect Fluent Forms with GSheetConnector and automate one of your manual tasks, step-by-step.

Whether you are a complete beginner or someone who just wants a straightforward setup process, this guide has got you covered.

## What is Fluent Forms GSheetConnector?

Before we start with the setup, let us understand what the [GSheetConnector](https://www.gsheetconnector.com/) plugin actually does.

Fluent Forms GSheetConnector is an addon plugin, which means that it works alongside another plugin that creates a direct connection between your WordPress Fluent Forms and Google Sheets.

You can think of this plugin as a bridge. So when someone fills out a form on your website that information will not just sit in your WordPress dashboard anymore. Instead it will travel across the bridge and land directly in your google sheet, in organized manner.

### Why Use Google Sheets for Form Data?

Now you might be wondering, “Why send form data to Google Sheets when WordPress is already storing it?”

So here is why many businesses out there prefer this method:

**Easy Sharing:** Sharing with your entire team is easy. You can share it with your sales team, customer support team, marketing team, and managers.

Everyone sees the updated information. Plus you don’t have to share your WordPress access with everyone.

**Always accessible:** Google Sheets works on any device. You or your team can easily check form submission from your phone, tablet, or computer easily.

Now whether you are out due to some work or on vacation, you can easily see your leads without opening the WordPress dashboard every time.

**Real-time updates:** The second when someone submits a form on your website, data will appear in your sheets. No delays, no manual updates.

**Better organization:** You can easily sort, filter, color-code and analyze your leads data using [Google Sheets powerful features](https://www.gsheetconnector.com/google-sheets-features-for-beginners).

**Automatic backup:** Your data lives safely in Google’s cloud storage and not just on your website’s database.

Now that you know about the benefits, let's start with the actual setup.

## Requirements checklist Before you start

Before installing anything, do make sure that your website meets these basic requirements. Do not worry if you are not much technical, because most modern websites already have everything needed.

### Your website needs:

**PHP Version 7.4 or higher:** This is the programming language on which WordPress runs. Most hosting providers like Hostinger, GoDaddy and others already use [PHP version 7.4 or higher](https://www.gsheetconnector.com/how-to-change-php-version). The current PHP version is 8.3. If you are not sure about this, then you can check on your hosting dashboard or contact your hosting support team. They can always update it to the latest for you.

**WordPress 6.3.1 or higher:** Check your WordPress version by going to your WordPress dashboard and looking at the bottom right corner. The current WordPress version is 6.9.1. If you see an older version, then simply navigate to updates in your dashboard menu and update your WordPress.

You can also see a small banner at the top right corner when a new version of WordPress is available saying “WordPress 6.9.1 is available! Please update now”

**Fluent Forms 5.0 or higher:** You need the Fluent forms plugin installed on your website first. If you have not installed it, then no worries we will show you the exact way how to install this in the next section.

**HTTPS enabled:** Your site should have an SSL certificate installed, because it keeps data secure. To confirm you can see your website URL. If it starts with “https://” then congratulations, the SSL certificate is already installed.

If your website URL opens with “http://” then your SSL certificate is not installed. Though domain and hosting providers already install this on your website.

**cURL enabled:** This is a technical feature that lets WordPress communicate with other services like Google. Nearly all hosting providers have this enabled by default.

If any of the technical requirements like PHP version, HTTPS or cURL is not enabled then instantly contact your web hosting provider. They can update these settings in just a few minutes.

## Step 1: Install Fluent Forms

If you have already installed the Fluent Forms plugin on your WordPress website, then you can skip to Step 2. And if you have not downloaded, here is how to install it.

First, Log in to your WordPress dashboard. Use this link to login to your WP (WordPress) dashboard using this type of URL: yourwebsitename.com/wp-admin. Users can change this due to security reasons

Now that you have successfully logged in to your WP dashboard.

Go to the plugins section: On the left sidebar of your dashboard, navigate to “Plugins”, here you will see three options: “Installed Plugins”, “Add New”, “Editor”.

Click on “Add New”. Now a new page will be open. On top you will see a heading and a button “upload plugin”. There are different use cases of this which we will see in some other blog.

Below this you will see some filters on the left side and a search bar on the right. And some related and best plugin options.

Click on the search bar and search for “Fluent Forms”. Usually it will be the first one. Click on “Install Now”, after installation, the button will be changed to “Activate”.

Click on “Activate”. Congratulations, Fluent Forms are activated on your website and ready to create forms.

## Step 2: Install Fluent Forms Google Sheet Connector

Now that you have successfully installed Fluent Forms, let’s install the GSheetConnector plugin that will connect your Fluent Forms to Google Sheets.

Now after activating Fluent Forms, you will be automatically redirected to “installed plugins” in Plugins. Again click on “Add New”.

Search for “[Fluent Forms GSheetConnector](https://www.gsheetconnector.com/fluent-forms-google-sheet-connector-pro)” OR “Fluent Forms Google Sheet Connector”. You will see our Fluent Form Google Sheet Connector plugin.

Click on Install Now, and then click on Activate.

You now have both plugins installed. The next step is connecting them to your Google account.

## Step 3: Connect Your Google Account

Now, we are the step where the magic will happen. Because we are going to link your WordPress site to your account so the data can flow automatically to your [Google Sheets](http://sheets.google.com/).

First, Go to your WordPress Dashboard and find Fluent Forms in the left menu. Hover over it and click “Google Sheet”. Now you will see a few tabs at the top click on the “Integration” tab if you are not by default in that tab.

Scroll down, you will see a blue button saying “sign in with google”. Click it. A new window will open showing your google accounts, select the account where you want to store the form data.

Now connect your google sheets account. Follow the simple steps. Grant all the permission. Basically they will for two important permission:

- Access to Google Sheets (so it can send data to your spreadsheets)

- Access to Google Drive (so it can find and manage your sheets)

Important: You must check both permission boxes. Without these permissions, the plugin can't send data to your sheets.

Do not worry about any data privacy, We at GSheetConnector do not store any data from your Google account on external servers. Every data stays between your WP site and your google account.

Automatic authentication: You'll be redirected back to your WordPress dashboard. The authentication code will automatically fill in. Click “Save & Authenticate”.

Success! You'll now see your Google account email address displayed. This confirms the connection worked.

## Step 4: Prepare Your Google Sheet

Before connecting your form, you need to create and prepare your Google Sheet properly to receive the data in the proper manner.

Now create a new google sheet, For that go to google sheets and create a new blank spreadsheet or you can also type sheets.new in the new tab which will create a new google sheet directly.

Now give your google sheet a meaningful name like “Website Contact Forms” or “Website Lead Submissions”

Now in the first row of your sheet, add column headers that match your form fields. For example, if your form collects:

- 

Name

- Email

- Phone

- Message

Then your first row should have these exact labels: Name, Email, Phone, Message.

Optional – you can also add a date column, if you want to automatically record when each form was submitted.

Now get you Sheet ID and Tab ID. These two are the unique identifiers that tell the plugin exactly where to send data. Here is how you can find them:

Look at your Google Sheet's web address. It looks something like this:

https://docs.google.com/spreadsheets/d/1ABC123xyz789/edit#gid=0

In this long code after “/d/” and before “/edit” is your Sheet ID (in the above example: 1ABC123xyz789)

And the number after “gid=” is your Tab ID (in this example: 0).

Copy both of these. You'll need them in the next step.

## Step 5: Connect a Fluent Form to Your Google Sheet

Now we will link a specific form on your website to the Google Sheet which you just prepared.

What you have to do is, go to your fluent forms, click “all forms”. Click on the form which data you want to send to Google Sheets. You can click on edit, to edit that form.

Once you have edited the form, save it, and click on “settings & integrations” button. (usually on the top of the editor. Second option.)

Now you will see various integration options. Click on “Google Sheets”.

You need to enter your google sheets information here:

- Google Sheet Name: The name you gave your spreadsheet (like “Website Contact Forms”)

- Google Sheet ID: Paste the Sheet ID you copied in Step 4

- Google Sheet Tab Name: Usually this is “Sheet1” unless you renamed it

- Google Sheet Tab ID: Usually this is “0” for the first tab

The plugin will automatically match your form fields with the column header in your google sheet. Make sure that the field labels in your form and in google sheet exactly match.

**For example:**

- Form field “Name” → Sheet column “Name”

- Form field “Email Address” → Sheet column “Email Address”

- Save your settings: Click the Save button.

- That's it! Your form is now connected to Google Sheets.

## Step 6: Test Your Connection

Now the setup is completed, but we have to make sure that everything is working properly or not.

For that, open your website page where the form appears. Then fill out that form and submit it.
Now open the google sheet which you have used. Refresh it. You should see a new row with the test data which you just submitted.

If you see your test data in the sheet, congratulations! Your connection is working perfectly. If you don't see the data, double-check that:

- Your Sheet ID and Tab ID are correct

- The column headers in your sheet match your form field labels exactly

- You granted both permissions during the Google authentication process

## What Happens Next?

From now on, whenever someone will be submitting this form on your website, the data will automatically appear in your Google Sheet within seconds.

You do not need to do anything else. This connection will run automatically in the background.

What you can do:

Share this sheet with your team: You can assign edit or view access to your team who needs to see form submissions like sales team, managers, support team.

Analyze your data: Use google sheets in-built sorting, filtering, and chart features to understand your form data like a pro and make better decisions.

Set up notifications: Use Google Sheets' notification features to get alerts when new rows are added.

Export data: Download your data as Excel, CSV, or PDF anytime you need it.

Connect multiple forms: Repeat Step 5 for any other forms on your website. Each form can send data to a different Google Sheet, or you can send multiple forms to different tabs in the same spreadsheet.

### FAQs

**Q. Can I connect the same form to multiple Google Sheets?**

Ans. The free version connects only one form to one Google Sheet. If you need advanced features like sending data to multiple sheets at the same time, then consider [upgrading to the PRO version](https://www.gsheetconnector.com/fluent-forms-google-sheet-connector-pro).

**Q. What if I change my form fields later?**

Ans. If you change your form fields like add or remove or change name, then simply update the column headers in your Google Sheet to match that. After that the plugin will automatically adjust it.

**Q. Is my data secure?**

Ans. Yes, your data is 100% secured as the connection uses Google’s official API, that means all the data transferred between your website and google sheets are encrypted and secure. Your data flow directly from your WordPress website to your Google account without stopping anywhere else.

**Q. Do I need to keep WordPress open for this to work?**

Ans. No. Once you have completed the set up. It will work automatically. You don't need to keep your WordPress dashboard open, form submission will still reach your google sheet without any problem.

**Q. What happens if my internet connection drops during a submission?**

Ans. The plugin is designed to handle connection issues. If a submission fails to send immediately, it will retry automatically.

## Take the Next Step

Now that you know how to connect Fluent Forms with GSheetConnector. This simple setup eliminates your hours of manual data entry work and gives your entire team and instant access to your form submissions.

Are you ready to get started? So [install Fluent Forms Google Sheet Connector](https://wordpress.org/plugins/gsheetconnector-for-fluentform/) from the WordPress plugin directory today. It is free and takes less than 10 minutes to set up and start using.

If you manage multiple websites or need any advanced features like conditional data sending, automatic data updates, or role based access controls, then you can also [explore our PRO version](https://www.gsheetconnector.com/pricing) for more powerful automation options.

Have any questions about the setup? Our support team is always here to help you. [Visit our documentation](https://www.gsheetconnector.com/docs/fluent-forms-gsheetconnector) or [contact us directly](https://www.gsheetconnector.com/support).

Start automating your form data today. Your future self (and your team) will thank you