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

This addon plugin sends JetFormBuilder form submissions directly to your selected Google Sheet.

== Description ==

GSheetConnector for JetFormBuilder is an addon plugin — a bridge between your [WordPress](https://wordpress.org/) based [JetFormBuilder](https://wordpress.org/plugins/jetformbuilder/) forms and [Google Sheets](https://www.google.com/sheets/about/).

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.

== 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 Shown with Authentication along with Permissions.
2. How to create feeds and display the Sheet name and Tab name.
3. Entering the Field Header Names Manually in the Connected Sheet and Submitting the form.
4. General Settings.
5. Role Settings.
6. Beta features view.
7. System Status.

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

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