=== GSheetConnector - JetFormBuilder Google Sheets Connector ===
Contributors: westerndeal, abdullah17, gsheetconnector
Author URL: https://wordpress.org/plugins/gsheetconnector-for-jetform
Tags: form builder, google sheets, google sheet integration, contact form, google integration
Tested up to: 7.0
Requires at least: 3.6
Requires PHP: 7.4
Requires Plugins: jetformbuilder
Stable tag: 1.0.5
License: GPLv2 or later
License URI: http://www.gnu.org/licenses/gpl-2.0.html

Automatically send JetFormBuilder by Crocoblock form submissions to Google Sheets in real time with secure, simple spreadsheet integration.

== Description ==

GSheetConnector for JetFormBuilder is a powerful JetFormBuilder Google Sheet Connector plugin that helps you automatically send [JetFormBuilder](https://wordpress.org/plugins/jetformbuilder/) form submissions to [Google Sheets](https://www.google.com/sheets/about/) 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](https://www.gsheetconnector.com/jetformbuilder-google-sheet-connector-pro)

= 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.

== 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.

== Screenshots ==

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

== Frequently Asked Questions ==

= 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.

== 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.

== Changelog ==

= 1.0.5 = [27 June 2026]
- Added Freemius SDK integration

= 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
