GSheetConnector – JetFormBuilder Google Sheets Connector

Description

GSheetConnector for JetFormBuilder is a powerful JetFormBuilder Google Sheet Connector plugin that helps you automatically send JetFormBuilder form submissions to Google Sheets directly from your WordPress website.

This plugin creates a seamless integration between JetFormBuilder by Crocoblock and Google Sheets, allowing you to sync, organize, and manage form entries in real time without manual work or complex setup.

Whether you are collecting contact form entries, leads, registrations, bookings, inquiries, applications, or custom form data, GSheetConnector helps automate your workflow by securely sending WordPress form submissions to your selected Google Spreadsheet.

The plugin uses secure Google OAuth authentication and provides a simple setup process for connecting JetFormBuilder forms with Google Sheets.

Features

✔ Connect JetFormBuilder with Google Sheets
✔ Automatic real-time form submission sync
✔ Secure Google OAuth authentication
✔ Map form fields to Google Sheet columns
✔ Multiple feed support
✔ Multisite compatible
✔ Supports latest WordPress & PHP versions

Pro Features

✔ Manual OAuth & Service Account authentication
✔ Advanced field mapping support
✔ Auto sheet header management
✔ Sync past form submissions
✔ Multi-sheet integration support
✔ Freeze header row settings
✔ Header & row styling options

Explore the PRO version features

Why Use GSheetConnector for JetFormBuilder?

Managing form submissions manually can take time and increase the risk of missing important entries. GSheetConnector helps automate your workflow by instantly syncing JetFormBuilder submissions to Google Sheets in real time.

This plugin is useful for:

  • Contact forms
  • Lead generation forms
  • Registration forms
  • Booking forms
  • Inquiry forms
  • Feedback forms
  • Newsletter forms
  • Application forms
  • Business workflow automation

With Google Sheets integration, you can easily organize form entries, collaborate with team members, maintain backups, and manage your data more efficiently.

How to Connect JetFormBuilder with Google Sheets

Step 1: Create Your Google Sheet

➜ Log into your Google account
➜ Open Google Sheets
➜ Create a new spreadsheet
➜ Rename the spreadsheet and sheet tab if needed
➜ Copy the Sheet Name, Sheet ID, Tab Name, and Tab ID (Refer to Screenshots)

Step 2: Configure JetFormBuilder

➜ Create or edit your JetFormBuilder form
➜ Open the Google Sheets integration settings
➜ Connect your Google account securely using OAuth
➜ Enter your Google Sheet details
➜ Save your OAuth Code.

Step 3: Create Form Feeds to maps

Navigate to Form Feeds tab and create a Feed while giving a name
Edit the feed and enter the sheet details like sheet name, sheet id, tab name and tab id and click save settings

Step 4: Set up Google Sheet Columns

➜ Add column headers in the first row of your Google Sheet
➜ Use JetFormBuilder field names as column names, that’s it
➜ Now Submit a test form submission and check the sheet.

Once configured, all new form submissions will automatically appear in your selected Google Sheet, in real-time

Supported Use Cases

GSheetConnector for JetFormBuilder is ideal for:

  • Website contact forms
  • Customer inquiry management
  • Lead tracking systems
  • Event registrations
  • Appointment bookings
  • Feedback collection
  • Internal business workflows
  • Data collection automation

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 to Google APIs to send form submissions and authenticate users.

Service: Google Sheets API
Purpose: Send form submission data to Google Sheets.
Data sent: Form field values submitted by site visitors.
Endpoint: https://sheets.googleapis.com/
Terms: https://developers.google.com/terms
Privacy Policy: https://policies.google.com/privacy

Service: Google OAuth 2.0
Purpose: Authenticate the site owner’s Google account.
Endpoint: https://oauth2.googleapis.com/
Terms: https://developers.google.com/terms
Privacy Policy: https://policies.google.com/privacy

Service: Google Drive API
Purpose: Verify spreadsheet access permissions and retrieve spreadsheet metadata.
Data sent: Access token for verification requests.
Endpoint: https://www.googleapis.com/drive/v3/
Terms: https://developers.google.com/terms
Privacy Policy: https://policies.google.com/privacy

Service: Google User Info API
Purpose: Retrieve authenticated user email address.
Data sent: Access token to fetch user profile information.
Endpoint: https://www.googleapis.com/oauth2/v2/userinfo
Terms: https://developers.google.com/terms
Privacy Policy: https://policies.google.com/privacy

Service: GSheetConnector OAuth Service
Purpose: Facilitate OAuth redirect handling required for authentication.
Endpoint: https://oauth.gsheetconnector.com/
Data sent: Site URL and plugin identifier during authentication. No form submission data is transmitted.
Terms: https://www.gsheetconnector.com/terms-condition
Privacy Policy: https://www.gsheetconnector.com/privacy-policy

Privacy Policy

GSheetConnector for JetFormBuilder uses Google APIs to allow website owners to securely connect WordPress forms with Google Sheets.

The plugin does not collect, store, or transmit personal form submission data to the plugin author or external servers.

Google account authentication is handled securely using Google OAuth. Access tokens are stored only within the site’s own WordPress database and are used exclusively for authorized Google Sheets operations.

The plugin only accesses Google Sheets and related Google services after explicit administrator consent during the authentication process.

No data is sold, shared, or used for advertising purposes.

Secure Google Authentication

This plugin uses Google’s official OAuth authentication system to securely connect your website with Google Sheets.

Authentication tokens are stored securely inside your WordPress database and are only used for the actions authorized by the website administrator.

No form submission data is stored on external servers owned by the plugin author.

Captures d’écran

  • Google Sheet integration with authentication and permission setup.
  • Creating feeds and displaying the connected Sheet name and Tab name.
  • Manually adding field header names in the connected sheet and submitting the form.
  • General Settings page.
  • Role Settings configuration.
  • Beta Features section view.
  • System Status page.

Installation

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

FAQ

Why isn’t the data sent to the spreadsheet? JetFormBuilder is just spinning.

If it spins indefinitely and doesn’t send, check:

  1. Access Code is correct (see debug log)
  2. Sheet or Tab name spelling is correct
  3. Column headers follow the naming rules (use lowercase letters, no spaces, special characters, etc.)

How do I get the Google Access Code?

  • Go to JetFormBuilder > Google Sheets, click « Get Code »
  • Allow access via your Google account
  • Copy the generated code and paste it back into the plugin settings.

Avis

Il n’y a aucun avis sur cette extension.

Contributeurs & développeurs

« GSheetConnector – JetFormBuilder Google Sheets Connector » est un logiciel libre. Les personnes suivantes ont contribué à cette extension.

Contributeurs

Historique des changements

1.0.4

[15th May 2026]
– Few minor changes and tested in WordPress 7.0 beta 1 and also updated readme.

1.0.3

[13th May 2026]
– Added: Extension Tab And Error Log.

1.0.2

  • Fixed PHPCS warnings related to nonce verification
  • Improved data sanitization and validation
  • Ensured compliance with WordPress.org plugin guidelines

1.0.1

  • Solved Nonces and User Permissions Needed for Security

1.0.0

  • First public release
  • Integrates Jet Form with Google Sheets