Google Sheets Integration
Steps to integrate Google Sheets with WP Fluent Forms
- Activate the Google Sheets module
- Get the Google Sheets access code
- Copy & paste it in Google Sheets settings
- Setup the integration feed & add Spreadsheet ID
- Add Worksheet Name
- Map all the form fields
- 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.
- 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.
- 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.
- 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.
- 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.
- 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:
Then the id of the spreadsheet will be:
- 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.
- 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.
Click the “Create Google Sheet Feed” button when done. You have successfully integrated Google Sheets with your form.