=== Spreadsheet Integration – Connect Google Sheets With WordPress, WooCommerce & Most Popular Form Plugins. === Contributors: javmah Tags: Google, spreadsheet,Integration,google-sheets,form,WooCommerce,Contact-form-7, ninja-form, Formidable, WPforms Requires at least: 4.0.1 Tested up to: 5.5.3 Stable tag: 5.4.0 License: GPLv2 or later License URI: http://www.gnu.org/licenses/gpl-2.0.html Spreadsheet Integration, Integration Google Sheets With WordPress, WooCommerce & Most Popular Form Plugins via Google API and Service Account. == Description == WordPress [Google Sheets](https://www.google.com/sheets/about/) Integration, Connects WordPress events and it's most popular plugin with Google Spreadsheet via Google API and Service Account. WordPress events like new user registration, Delete user, New post, Update post, a New page, a user log in, and user logout along with [Advanced Custom Fields](https://wordpress.org/plugins/advanced-custom-fields/) fields. It 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/) & [WPform](https://wordpress.org/plugins/wpforms-lite/) submission events. ` 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 = * **Unlimited integrations:** Create as many integrations as you want and collect all the data you need with as many fields you want. * **Drop Down & Select:** Build the integrations of your dream with its fully featured Drop Down & Select options. * **Auto Google Spreadsheet & Worksheet:** No need to copy or past sheet name just select more safe. * **No restrictions on Event fields :** There is No restrictions on Event fields, you can pass your won text via fields. * **One Click Google Spreadsheet Columns title Create :** just click to create integrated sheet column titles. * **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 . * **Privacy and Security:** Very Secure, just share your google sheet with service account email address, no 3rd party authentication access, the private sheet only. == Creating Integration == [youtube https://youtu.be/Cr0D_zU6adw] == Google API and Service account Creation == [youtube https://youtu.be/ylUE1t3bkqs] = Standard integrations events & Data Fields are: = * **WordPress New user registration, User Profile Updates, User Login, User Logout ,Delete User Profile to Google Sheets Integration events are:** * User ID * User Name * User First Name * User Last Name * User Nickname * User Display Name * Event Name * User Description * User Email * User Last Login * User Registration Date * User Role * **WordPress New post, update post & New page to Google Spreadsheet Integration events are:** * Post ID * Post Author ID * Post Author User name * Post Author Display Name * Post Author Email * Post Title * Post Date * Post Date GMT * Post Content * Post Excerpt * Post Status * Event Name * Comment Status * Ping Status * Post Password * Post Name * To Ping * Pinged * Post Modified * Post Modified GMT * Post Parent * Guid * Menu Order * Post Type * Post Mime Type * Comment Count * Filter * **WordPress Comment to Google Spreadsheet Integration events are:** * Comment ID * Comment Date * Comment Author * Comment Author Email * Comment Author Url * Comment Content * Comment Type * Comment User ID * Comment Author IP * Comment Agent * Comment Date * Comment Date GMT * Filtered * Comment Approved = 3rd Party plugin integrations is NOT Free, supported plugin events are = * **[WooCommerce](https://wordpress.org/plugins/woocommerce/) New product to Google Spreadsheet Integration events are:** * Product ID * Type * Name * Slug * Date created * Date modified * Status * Event name * Featured * Catalog visibility * Description * Short description * SKU * Menu order * Virtual * Permalink * * Price (professional version) * Regular price (professional version) * Sale price (professional version) * Date on sale from (professional version) * Date on sale to (professional version) * Total sales (professional version) * * Tax status (professional version) * Tax class (professional version) * Manage stock (professional version) * Stock quantity (professional version) * Stock status (professional version) * Back orders (professional version) * Sold individually (professional version) * Purchase note (professional version) * * Shipping class id (professional version) * Weight (professional version) * Length (professional version) * Width (professional version) * Height (professional version) * Dimensions (professional version) * Attributes (professional version) * Default attributes (professional version) * Categories (professional version) * Category ids (professional version) * Tag ids (professional version) * Image id (professional version) * Image (professional version) * Gallery image ids (professional version) * **WooCommerce New Order & Order Status Change to Google Spreadsheet Integration events are:** * Order ID * Cart tax (professional version) * Currency (professional version) * Discount tax (professional version) * Discount total (professional version) * Fees (professional version) * Shipping tax (professional version) * Shipping total (professional version) * Subtotal (professional version) * Subtotal to display (professional version) * Tax totals (professional version) * Taxes (professional version) * Total (professional version) * Total discount (professional version) * Total tax (professional version) * Total refunded (professional version) * Total tax refunded (professional version) * Total shipping refunded (professional version) * Item count refunded (professional version) * Total qty refunded (professional version) * Remaining refund amount (professional version) * Items (professional version) * Item count (professional version) * Downloadable items (professional version) * Customer id (professional version) * User id (professional version) * User (professional version) * Customer ip address (professional version) * Customer user agent (professional version) * Created via (professional version) * Customer note (professional version) * Date created (professional version) * Date modified (professional version) * Date completed (professional version) * Date paid (professional version) * Billing first name * Billing last name * Billing company * Billing address 1 * Billing address 2 * Billing city * Billing state * Billing postcode * Billing country * Billing email * Billing phone * Shipping method * Shipping first name * Shipping last name * Shipping company * Shipping address 1 * Shipping address 2 * Shipping city * Shipping state * Shipping postcode * Shipping country * Address * Shipping address map url * Formatted billing full name * Formatted shipping full name * Formatted billing address * Formatted shipping address * Payment method (professional version) * Payment method title (professional version) * Transaction id (professional version) * Checkout payment url (professional version) * Checkout order received url (professional version) * Cancel order url (professional version) * Cancel order url raw (professional version) * Cancel endpoint (professional version) * View order url (professional version) * Edit order url (professional version) * Status * Event name * **[Contact form 7](https://wordpress.org/plugins/contact-form-7/) form Submission to Google Spreadsheet** * Text fields * Text Area fields (professional version) * Number (professional version) * tel (professional version) * **[ninja form](https://wordpress.org/plugins/ninja-forms/) Submission to Google Spreadsheet** * Text fields * Text Area fields (professional version) * Number (professional version) * tel (professional version) * **[Formidable](https://wordpress.org/plugins/formidable/) form Submission to Google Spreadsheet** * Text fields * Text Area fields (professional version) * Number (professional version) * tel (professional version) * **[WPform](https://wordpress.org/plugins/wpforms-lite/) Submission to Google Spreadsheet** * Text fields * Text Area fields (professional version) * Number (professional version) * tel (professional version) * **[weForms](https://wordpress.org/plugins/weforms/) Submission to Google Spreadsheet** * Text fields * Text Area fields (professional version) * Number (professional version) * tel (professional version) * **[ACF- Advanced Custom Fields](https://wordpress.org/plugins/advanced-custom-fields/) Advanced Custom Fields to Google Spreadsheet** * All Custom Fields (professional version) * **Upcoming integration are** * Option Monster. * More From Plugins. == Installation == This section describes how to install the plugin and get it working. e.g. 1. Upload `wpgsi` folder to the `/wp-content/plugins/` directory 2. Activate the plugin through the 'Plugins' menu in WordPress == Frequently Asked Questions == = Where does it save logs and service account credentials? = It saves those data in the installed site database. = How to Get more help? = If you need more help, please open a help ticket for this plugin menu. == Screenshots == 1. Integration list. 2. Create new integration. 3. Settings page 4. Google Service Account Create new Api project 5. Google Service Account API list 6. Google Service Account Create Credentials == Changelog == = 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 == Nothing here right now