GSheetConnector for FluentForm

GSheetConnector for FluentForm is an addon plugin—a bridge between your WordPress based Fluent Form forms and Google Sheets.

When a visitor submits a Fluent Form on your website, their data is also sent to your connected Google Sheet.

📝 Fluent Form ➜ to ✍️ Google Sheets

Easily connect your Fluent Forms to Google Sheets without writing code. This plugin helps you avoid manual errors by guiding you through the setup of sheet names and column headers step-by-step.

⚡️ How to Use this Plugin

• Step 1: In Google Sheets
  ➜ Log into your Google Account and open Google Sheets.
  ➜ Create a new Sheet and name it.
  ➜ Use or rename the default tab.
  ➜ Copy the Sheet Name, Sheet ID, Tab Name, and Tab ID (Refer to Screenshots)

• Step 2: In WordPress Admin
  ➜ Create or edit the Fluent Form you want to sync.
  ➜ Navigate to the “Google Sheets” tab.
  ➜ Paste the copied Sheet and Tab names and click “Save”.

• Step 3: Set up Google Sheet Columns
  ➜ In Row 1 of your Google Sheet, use “date” as the first column.
  ➜ Use Fluent Form field names (submission tags) as headers for the remaining columns.

Important Notes

➜ Ensure names and spellings match exactly between your Sheet and form settings. Mismatches may result in sync failure.

External services

This plugin connects Fluent Forms with Google Sheets using Google APIs.

1. Google APIs (Sheets & Drive)

– Purpose: Send form submissions to Google Sheets.
– Data: Selected form submission data is sent. Tokens (and sheet details in Pro) are stored only in the site’s own database.
– Scopes: spreadsheets, drive.file
– Terms: https://policies.google.com/terms
– Privacy: https://policies.google.com/privacy

1. Google OAuth 2.0

– Purpose: Secure authentication with Google.
– Data: Authentication requests and tokens (stored locally).
– Terms: https://developers.google.com/terms
– Privacy: https://policies.google.com/privacy

1. GSheetConnector Auth Service

– Purpose: Facilitate Google OAuth connection.
– Data: Only site URL and plugin ID during authentication. No form data stored.
– Terms: https://www.gsheetconnector.com/terms-condition
– Privacy: https://www.gsheetconnector.com/privacy-policy

1. Upload gsheetsconnector-for-fluentform to /wp-content/plugins/, or install via Plugins > Add New > Search.
2. Activate the plugin via the ‘Plugins’ screen.
3. Go to Fluent Form > Google Sheets and click “Get Code” to authorize and connect to Google Sheets.
4. Paste the Access Code and save.