Google Sheets Integration

Integrate your Google Sheets easily with WP Fluent Forms and send user submissions to your Google Spreadsheet with no hassle. Here is how you can integrate Google Sheets with WP Fluent Forms.

  • At first, hover over Fluent Form Pro on your WordPress admin panel sidebar, click on Modules and turn on Google Sheets module as shown in the screenshot below.
  • Again hover over Fluent Forms Pro and go to Settings and select Google Sheets as shown on the screenshot below. You will be asked for a Google Sheets Access Code here.
Google Sheet Access Code WP Fluent Forms
  • Now click on the “Get Google Sheet Access Code“. A new window will open and you might need to select the email associated with your spreadsheet account. Note that as this integration is new, It’s not yet verified by Google. Hence, you might see a warning “This app hasn’t been verified by Google yet. Only proceed if you know and trust the developer.” Ignore the message until WP Fluent Forms Google Sheets integration is verified by Google. Click on Advanced located in the bottom left corner and you will see “Go to Fluent Forms Google Sheet Integration (unsafe)“, Go ahead and click on it.
Google Sheet Access Code Warning WP Fluent Forms
  • Now another popup window will appear asking for permission. Click allow to give WP Fluent Forms the permission to create and update the spreadsheet. Again you will be asked to confirm your choice. Go ahead and confirm it.
  • As soon as you confirm your choice, you will be given the Access Code. Copy it and go back to WP Fluent Forms Settings and paste the code.
How to Connect WordPress to Google Sheets - Fluent Forms
  • Now click on the “Verify Code” and if you did everything right previously you will see the success message “Your google sheet API key is verified and successfully set.
  • Now go to the All Forms of WP Fluent Forms and select the particular form the entries of which you want to send to Google Spreadsheet.
Google Sheet Integration with Fluent Forms WordPress Plugin
  • From the Settings & Integrations, you need to go to the Marketing and CRM Integrations. Click on Add New Integration. Choose the integration you want. In this case, it would be Google Sheets.
google sheets WordPress integration Fluent Forms
  • Now you need to configure the settings according to your requirements. At first, give the feed a name and then enter the Spreadsheet ID. To get the Spreadsheet ID, Open your google sheet where you want to receive the entries or create a new one. The URL of your spreadsheet has its id. Check the screenshot. The marked portion is the id of this particular spreadsheet.

For example, if the spreadsheet URL is:

https://docs.google.com/spreadsheets/d/1DFuuOMFzNoFQ5EJ2JE2zB79-0uR5zVKvc0EikmvnDgk/edit#gid=0

Then the id of the spreadsheet will be:

1DFuuOMFzNoFQ5EJ2JE2zB79-0uR5zVKvc0EikmvnDgk
  • Now you need to enter your Worksheet Name carefully. One spreadsheet can have multiple Worksheets like Sheet1, Sheet2, Sheet3 or your defined name. See the screenshot to find the worksheet’s name.
how to get the worksheet name from the spreadsheet WP Fluent Forms
  • Now the final setting is the “Spreadsheet Fields“. Name the field as you want and map with the forms field. In my case, I just wanted to send the name, email, and message inputs from the form entries to the sheet. You can have as many fields as you want.
google sheets integration with WPForms

Click the “Create Google Sheet Feed” button when done. You have successfully integrated Google Sheets with your form.

Community Contribution Documentation

Was this article helpful to you?

4 1

How can we help?

Please submit a support ticket if you have any question or pre-sale questions. Our Customer support engineers will answer your query as soon as possible

Open a support ticket