Description
GSheetConnector for JetFormBuilder is an addon plugin — a bridge between your WordPress based JetFormBuilder forms and Google Sheets.
When a visitor submits a Jet Form on your website, their data is also sent to your connected Google Sheet.
Features
✔ Connect JetFormBuilder with Google Sheets
✔ Automatic form submission sync
✔ No coding required
✔ Secure Google OAuth authentication
✔ Map form fields to sheet columns
✔ Supports multiple feeds
📝 JetFormBuilder ➜ to ✍️ Google Sheets
Easily connect your Jet 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 Jet 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 Jet 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 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 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 JetForm uses Google APIs to allow users to connect their WordPress site with Google Sheets.
This plugin does not collect or transmit personal data to the plugin author or any external servers. Google account authentication and access to Google Sheets are handled securely using Google OAuth.
Access tokens required for Google authentication are stored securely in the site’s own WordPress database and are used only to perform actions requested by the site administrator.
The plugin only accesses Google Sheets and Google Drive data after explicit user consent during the Google authorization process.
No data is sold or shared with third parties, and no data is stored on the plugin author’s servers.
Installation
- Upload
gsheetconnector-for-jetformto/wp-content/plugins/, or install via Plugins > Add New > Search. - Activate the plugin via the ‘Plugins’ screen.
- Go to
Jet Form > Google Sheetsand click “Get Code” to authorize and connect to Google Sheets. - 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:
- Access Code is correct (see debug log)
- Sheet or Tab name spelling is correct
- 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.
- Go to
Reviews
There are no reviews for this plugin.
Contributors & Developers
“GSheetConnector for JetFormBuilder” is open source software. The following people have contributed to this plugin.
ContributorsTranslate “GSheetConnector for JetFormBuilder” into your language.
Interested in development?
Browse the code, check out the SVN repository, or subscribe to the development log by RSS.
Changelog
1.0.3
- 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