WooCommerce Google Sheet Connector

Description

This plugin is a bridge between your WooCommerce orders and Google Sheets.

Homepage | Documentation | Support | Demo | Premium Version

Whenever any new order is placed a new row with the order details will be added or moved to the appropriate Google Sheet Tabs as per the order status.

Click here and Check the Backend Features with one click => https://tastewp.com/new/?pre-installed-plugin-slug=woocommerce&pre-installed-plugin-slug=wc-gsheetconnector

Still haven’t purchased ? Get it Now

Check Live Demo

Demo Link

Google Sheet URL to Check submitted Data

How to Use this Plugin

Step: 1 – In Google Sheets
* Log into your Google Sheets.
* Create a new sheet and name it. ( You can also select existing sheet while setting the connection as per Step 3).

Step: 2 – In WordPress Admin
* Navigate to WooCommerce > Google Sheet > Integration Tab
* Authenticate with Google using new “Google Access Code” while clicking on “Get Code”
* Make Sure to ALLOW Google Permissions for Google Drive and Google Sheets and then copy the code and paste in Google Access Code field, and Hit Save & Authenticate.
* Now fetch the sheet details by clicking “Click here to fetch Sheet details to be set at WooCommerce settings.”

Step: 3 – Connect with Google Sheet
* Navigate to WooCommerce > Google Sheet > WooCommerce Data Settings.
* Select the appropriate Sheet from the “Google Sheet Name” dropdown box.
* Select WooCommerce Order Status to create Sheet Tabs and add headers to your selected Google Sheet.
* Lastly test by ordering any product and putting it to a different order states ( Processing, Hold etc).

Screenshots

  • Google Sheet Integration without authentication.
  • Permission page if user is already logged-in to there account.
  • Permission popup-1 after logged-in to your account.
  • Permission popup-2 after logged-in to your account.
  • After successful integration - Displays "Currently Active".
  • WooCommerce Google Sheet settings page.

Installation

  1. Upload “wc-gsheetconnector” to the “/wp-content/plugins/” directory, OR “Site Admin > Plugins > New > Search > GSheetConnector WooCommerce > Install`.
  2. Activate the plugin through the ‘Plugins’ screen in WordPress.
  3. Use the Admin Panel > WooCommerce > Google Sheet > Integration screen to connect to Google Sheets by entering the Access Code. You can get the Access Code by clicking the “Get Code” button.
    Enjoy!

FAQ

New Submitted Orders are not showing in my Configured Sheet?

If the new submitted orders never shows in your Sheet then one of these things might be the reason:
1. Wrong access code or did not allowed permission to Google Drive and Google Sheets(Check debug log under Integration Tab)
2. Not Entered Correct Sheet Name, Sheet ID or Tab Name, Tab ID (Please verify once)
Please double-check those items and hopefully getting them right will fix the issue.

View Debug log is empty under Integration Tabs

Make sure to enable debug log from wp-config.php if submitted order is not showing in sheet, It will helps to show the conflict issue (if there is any) or shows what is making an issue.

Reviews

November 15, 2021
I live with Google Drive and Google Sheet. I don't like reading feedbacks from customers and over every email. This plugin is best for getting Contact forms in Google Sheet which comes with us on any mobile device - Additionally very organized. Thank you GSheetConnector.
Read all 1 review

Contributors & Developers

“WooCommerce Google Sheet Connector” is open source software. The following people have contributed to this plugin.

Contributors

Changelog

  • 1.2.1 (18-09-2021)
  • Resolved Notice Error for WooCommerce as a required plugin.

  • 1.2 (12-09-2021)

  • Freemius Integration.

  • 1.1 (18-11-2021)

  • Fixed : Errors throws while updating orders without changing order status.
  • Added Validation For Google Settings Form.

  • 1.0 Released Initial version