=== Spreadsheet Integration – Automate Google Sheets With WordPress, WooCommerce & Most Popular Form Plugins. Also, Display Google sheet as a Table. ===
Contributors: javmah, freemius
Tags:spreadsheet,google-sheets,contact-form-7,WooCommerce,automation,Google,
Requires at least: 5.5.0
Tested up to: 6.2
Stable tag: 3.7.9
License: GPLv2 or later
License URI: http://www.gnu.org/licenses/gpl-2.0.html

Google sheet two-way sync 🔄 WordPress | WooCommerce | Contact form 7 | DB table | Google sheet as a Table.

== Description ==

= This Plugin Integrates,  Automates,  Sync & displays Google Sheets with WordPress and its most popular plugins. =

WordPress events like new user registration, delete user, new post, update post, new page, user login, user logout, new database table row along with [Advanced Custom Fields](https://wordpress.org/plugins/advanced-custom-fields/) fields. This plugin also integrates [WooCommerce](https://wordpress.org/plugins/woocommerce/), [Contact form 7](https://wordpress.org/plugins/contact-form-7/), [ninja form](https://wordpress.org/plugins/ninja-forms/), [Formidable](https://wordpress.org/plugins/formidable/), [Fluent forms](https://wordpress.org/plugins/fluentform/), [WPform](https://wordpress.org/plugins/wpforms-lite/), [gravity form](https://www.gravityforms.com/), [forminator form](https://wordpress.org/plugins/forminator/) submission events with [Google Sheets](https://www.google.com/sheets/about/). 

*This plugin also **UPDATES / CREATES** WordPress posts, pages, users, WooCommerce products, WooCommerce orders, and **Database table rows** from Google Sheets.* *

`
Spreadsheet Integration is the First & Only Google service 
account Authenticated plugin in the WordPress plugin 
repository. Now you don't have to give permission to 3rd 
party, More secure & reliable. Just share your Spreadsheet 
with your own service account. No need expensive  Zapier or 
ITTF for WordPress Google Spreadsheet Integration.

`

## 🔝 KEY FEATURES ##

1. **Unlimited integrations:** Create as many integrations as you want and collect all the data you need with as many fields you want.

2. **One click Update WordPress site:** Just click your Google Spreadsheets to update WordPress Post and Page ! Awesome !!

3. **Privacy and Security:** Very Secure, just share your google sheet with service account email address, no 3rd party authentication access, the private sheet only.

4. **Drop Down & Select:** Build the integrations of your dream with its fully featured Drop Down & Select  options. 

5. **Auto Google Spreadsheet & Worksheet:** No need to copy or past sheet name just select more safe.

6. **No restrictions on Event fields :** There is No restrictions on Event fields, you can pass your won text via fields.

7. **One Click Google Spreadsheet Columns title Create  :**  just click to create integrated sheet column titles.

8. **Auto-sync :** Auto-sync Google sheet data and display data as table content in your post or page.

9. **Google [service account](https://cloud.google.com/iam/docs/service-accounts)  Authentication :** Spreadsheet Integration is the first & only one service account Authenticated plugin in the WordPress plugin repository .

> 'The professional version of this plugin is also the Best plugin for integrating WooCommerce with Google Sheets. It supports almost all data sources of WooCommerce. You can easily sync WooCommerce event data to Google Sheets and be able to bulk update wooCommerce products from Google Sheets. You can use the professional version for 7 days as a free trial.'


## 🏆 STANDARD INTEGRATIONS EVENTS  ##

* Update WordPress Post & Page from Google Sheets.

* Contact form 7 forms submission to Google Sheets.

* WordPress New user registration to Google Sheets.

* WordPress User Profile Updates to Google Sheets.

* WordPress User Login to Google Sheets.

* WordPress User Logout to Google Sheets.

* WordPress Delete User Profile to Google Sheets.

* WordPress New post to Google Sheets.

* WordPress update post to Google Sheets.

* WordPress New page to Google Sheets.

* WordPress New Comment to Google Sheets.

* WordPress Edit Comment to Google Sheets.

* WooCommerce New order to Google Sheets (not all fields).

* WooCommerce Order status change to Google Sheets (not all fields ).

* WooCommerce new product to Google Sheets (most of the Fields not all).

* Display Google sheet on your WordPress Page and Post as a searchable and sortable table with daily auto sync.



**Thanks:** 💖 Heartiest Gratitude to all of my users who inspired me and suggest me and compliment me in many ways, you guys are Awesome. Without yours support and love it was impossible to maintain this huge codebase. Please accept my sincere thanks.


== Creating Integration ==
[youtube https://youtu.be/Cr0D_zU6adw]

== Update / Create WordPress data from Google Sheet ==
[youtube https://youtu.be/84gTttWN4vo]

== Google API and Service account Creation ==
[youtube https://youtu.be/ylUE1t3bkqs]



## 🔥 ADVANCE PROFESSIONAL INTEGRATIONS ##

1. **[WooCommerce Google Sheet Connect[PRO]](https://wordpress.org/plugins/woocommerce/):** This plugin syncs WooCommerce new order, WooCommerce Orders status Change, WooCommerce new Product and Product information update data to google sheet.


2. **[WooCommerce Product and Order Update from  Google Sheets [PRO]](https://wordpress.org/plugins/woocommerce/):** One click update your WooCommerce Products and Orders from  Google Sheet!


3. **[wordPress Meta data [PRO] ](https://developer.wordpress.org/plugins/metadata/):** In this plugins Professional version, you can able to integrate WordPress Metadata as an event data source! Wow

 
4. **[wordPress Meta data update from Google sheet [PRO] ](https://developer.wordpress.org/plugins/metadata/):** Professional version supports update Meta data from Google sheet.


5. **[Gravity Forms [PRO] ](https://www.gravityforms.com/):** This plugin sync gravity forms form submission data to google sheet.


6. **[ACF- Advanced Custom Fields [PRO]](https://wordpress.org/plugins/advanced-custom-fields/):** Spreadsheet integration supports ACF data fields.


7. **[ninja form [PRO]](https://wordpress.org/plugins/ninja-forms/):** Spreadsheet Integration supports ninja forms form submission data to google sheet.


8. **[Formidable [PRO]](https://wordpress.org/plugins/formidable/):**  Spreadsheet Integration supports Formidable forms form submission data to google sheet.


9. **[WPform [PRO]](https://wordpress.org/plugins/wpforms-lite/):** Sync WP form submission data to google sheet.


10. **[weForms [PRO]](https://wordpress.org/plugins/weforms/):** This plugin also syncs weForm form submission data to google sheet.


11. **[Forminator [PRO]](https://wordpress.org/plugins/forminator/):** This plugin also syncs Forminator form submission data to google sheet.


12. **[Fluent Forms [PRO]](https://wordpress.org/plugins/fluentform/):** This plugin also syncs Fluent Forms submission data to google sheet.


13. **[Custom Post Type UI [PRO]](https://wordpress.org/plugins/custom-post-type-ui/):** This plugin plugin supports custom post type UI as Event source.


14. **[Custom Post Type update from Google sheet [PRO]](https://wordpress.org/plugins/custom-post-type-ui/):** One click update your custom post type from connected google sheet.


15. **[wordPress database table row [PRO] ](https://codex.wordpress.org/Database_Description):** Professional version supports wordPress database table row sync to Google sheets. One click update / insert your Google sheet data to wordPress database.


16. **[wordPress create / update USER [PRO]]:** Professional version supports creating / updating user information from google sheet.*

17. **[more option on Google sheet sync [PRO]]:** Professional version supports More Frequency on google sheet sync and display as a Table in WordPress Page and Post.


== Installation ==

= Modern Way: =
1. Go to the wordPress Dashboard "Add New Plugin" section.
2. Search For "Spreadsheet Integration".
3. Install, then Activate it.
4. Follow the step-by-step documentation on settings page

= Old Way: =
1. Upload `Spreadsheet Integration` to the `/wp-content/plugins/` directory
2. Activate the plugin through the 'Plugins' menu in WordPress
3. Follow the step-by-step documentation on settings page


== Frequently Asked Questions ==

=  Where does it save logs and service account credentials?  = 
 It saves those data in the installed site database. 

=  Does this plugin support Update WordPress Post from Google Sheet?  = 
 Version 3.6.0 support update WordPress Post and page from google sheet. 

=  Does this plugin support custom post type as a data source?  = 
  Professional version 3.4.0 support custom post type as a data source.You can use MetaData as a data Source in the Professional version.

=  My service account configuration and credentials is ok but why not spreadsheets are Displaying ? = 
 You have to share your service account email address with Google spreadsheets.

=  What is google service account?  = 
 A service account is a special type of Google account intended to represent a non-human user that needs to authenticate and be authorized to access data in Google APIs.

=  How to Get more help?  = 
 If you need more help, please open a  support ticket from this plugin menu.

= Why do you sell the professional version? =
 I am a firm believer in open source and I contributed to many open source projects. I also enjoy many open-source applications. 
 This plugin's main features are FREE, only third-party plugins are in the professional version. As you know this is a large plugin,  
 I spend all my working hours on this plugin.  


== Screenshots ==

1. Overall plugin view.
2. Integration list.
3. Create new integration.
4. Settings page.
5. Google Service Account  Create new Api project.
6. Google Service Account  Create Credentials.
7. Selecting the API project.
8. Google Service Account  API list.
9. Service account credentials.

== Changelog ==

= v3.7.9 (2 September, 2023) =
* Freemius  SDK version updated.
* forminator forms error handle

= v3.7.8 (6 July, 2023) =
* Freemius  SDK version updated.

= v3.7.7 (30 Apr, 2023) =
* Bug fix.
* Freemius version Change.
* Multiple table display in a single post or page.
* 30 second of blocking is removed. Dual submission code is changed.
* Database update bug fixed.

= v3.7.6 (20 Feb, 2023) =
* Bug fix.
* Name change.
* Status update status change via AJAX.
* Remote update status change via AJAX.
* Create sheet column titles  via AJAX.

= v3.7.5 (23 Jan, 2023) =
* Improve reliability and JSON parsing

= v3.7.4 (15 Jan, 2023) =
* Display Google sheet as a Table in WordPress Post and Page.
* Google Token code change.
* Bug fix.

= v3.7.2 (16 Oct, 2022) =
* Missing features.
* Bug fix.

= v3.7.1 (30 Aug, 2022)  =
* database table syncs to google Sheets on the professional version.
* sending nested data with comma separation.
* freemius SDK version change.
* WordPress version 6.0.1 compatible.
* Forminator & Fluent Forms are added to the professional version.
* Important Note : Please update your existing integrations on edit and then save it without any change for update code.
* Bug fix.

= v3.6.1 (02 Mar, 2022) =
* freemius SDK version change.
* Bug fix.

= v3.6.0 (14 Dec, 2021)  =
* Update WordPress Post and Page from Google Sheet.
* Update wooCommerce Products and Orders from Google Sheet in professional version.
* Forminator form support in professional version.
* Fluent forms support in professional version.
* Bug fix.
* More log coverage.

= v3.5.0 (22 Jun, 2021)  =
* WooCommerce Order Item More event source in Professional version.
* WooCommerce Order Item meta on Professional version.
* Performance improvement.
* Update WooCommerce simple Product from remote Google Sheets in Professional version.
* Disable log & remove log options.
* Dual submission prevention, 30 second interval .
* JS bug fix.
* Spelling correction.

= v3.4.0 (7 Feb, 2021)  =
* Code Optimization & Structural change.
* Custom post type added in the Professional version.
* gravity form add to the  Professional version.

= v3.3.0 (11 Jan, 2021)  =
* Bug fix.
* wordPress version 5.6 compatibility.
* Comment edit Event added as data source.
* Meta Data added as data source in the Professional version.

= v3.2.0 (31 Oct, 2020)  =
* ACF fix.
* WooCommerce fix.
* ACF Fields Added to Login and Logout.

= v3.1.0 (21 Oct, 2020)  =
* CF7 Bug fix.
* CF7 New Regex.

= v3.0.0 (4 Aug, 2020)  =
* User Bug fix.
* More readable code.
* Google First Sheet Bug fix.
* Banner & Icon Change.
* Contact form 7 bug fix.

= v2.0.0 (6 July, 2020)  =
* weForm added.
* ACF bug fix.

= v1.0.0-beta.1 (21 May, 2020)  =
* Initial Release version.

== Upgrade Notice ==

Update: Please always use the updated version, All updates come with new features and bug fixes.  

