This plugin hasn’t been tested with the latest 3 major releases of WordPress. It may no longer be maintained or supported and may have compatibility issues when used with more recent versions of WordPress.

WPAppsDev – GSheet Order Automation

Description

WooCommerce Google Spreadsheet Integration Plugin to connect with Google Sheets!!!

Are you seeking a solution to efficiently record your WooCommerce order details in a Google Sheet? Look no further; our WooCommerce Google Spreadsheet Integration plugin simplifies the process of automating order management from WooCommerce to Google Spreadsheet. With ease and efficiency, you can now effortlessly synchronize your WooCommerce orders with Google Spreadsheet. Our Google Sheets integration ensures you are always one step ahead with faster and more efficient sales order management.

This plugin is a bridge between your WooCommerce online store orders and Google Sheets. Whenever any new order is placed in WooCommerce a new row with the order details will be added to the selected Google Sheet.

Key Features

  1. Seamless Order Recording: The ability of this plugin to automatically enter WooCommerce orders into Google Spreadsheets is its core functionality. With a few clicks, you can enable automatic synchronization between your online store and your Google Sheets document. There will be no more data entry by hand.

  2. Real-Time Updates: Real-time updates will keep you up to date. When an order is placed on your WooCommerce store, the plugin quickly transmits all pertinent order information, such as customer data, product information, and pricing, straight to your Google Sheets document. This guarantees that you’re always using the most up-to-date and accurate information.

  3. Custom Column Labels: With the help of our plugin, you can easily personalize a Google Spreadsheet document. You can structure your data exactly how you want, making it more meaningful and applicable to your business, by having the option to customize column labels.

  4. Historical Data Import: Don’t worry about missing out on historical data. Our plugin is equipped to handle historical data imports, ensuring that all your past orders are neatly organized within your Google Sheets document, creating a comprehensive order history.

  5. Data Security: Your data’s security is a top priority. The plugin employs robust encryption methods to safeguard sensitive customer and sales information during the transfer process. Rest easy knowing that your data is protected at every step.

  6. Easy Setup and Maintenance: No need for advanced technical skills. The WooCommerce Google Sheets Integration plugin offers a user-friendly setup wizard to guide you through the initial configuration. Ongoing maintenance is hassle-free, with automatic updates ensuring compatibility with the latest WooCommerce and Google Sheets versions.

  7. Time and Cost Savings: By automating order management, you’ll free up valuable time and resources that can be better utilized in growing your business. Say goodbye to data entry tasks and hello to increased productivity and efficiency.

CHECK LIVE DEMO

Demo Site Link

Check submitted Data Google Sheet URL

HOW TO USE THIS PLUGIN

Step: 1 – LogIn Google Account

➜ Log into your Google Account.
➜ Create a new Google Project. How to create project?

Step: 2 – In WordPress Admin

➜ Navigate to WooCommerce > Settings > Google Sheet
➜ Fill Up Google settings information from your created Google project.
➜ Authenticate with Google using Google Oauth
➜ Make Sure to ALLOW Google Permissions for Google Drive and Google Sheets
➜ Now create new spreadsheet from settings panel
➜ Add spreadsheet label and save.

Plugin Configuration

Screenshots

  • Connect Google Auth
  • Create Google SpreadSheet
  • Configure SpreadSheet Label 1
  • Configure SpreadSheet Label 2
  • Set SpreadSheet Label
  • Reset SpreadSheet Label
  • SpreadSheet Store Data

Installation

Easy way:
1. Go to WP Admin – Plugins – Add New
2. Search for “WPAppsDev – GSheet Order Automation”
3. Install the plugin and then Activate it

or Manual way:
1. Download the plugin zip file
2. Extract it
3. Upload the plugin directory to wp-content/plugins
4. Activate WPAppsDev – GSheet Order Automation plugin from WP Admin – Plugins

FAQ

Does it need any plugin other than WooCommerce for integration?

No plugins are needed except WooCommerce.

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:

Wrong access code or did not allowed permission to Google Drive and Google Sheets.
Please double-check those items and hopefully getting them right will fix the issue.

Reviews

28 Febroary 2024
Impressive plugin for sure! It has some great features. For instance, there is no limit on order synchronization.But a basic column is missing in this plugin. I haven’t tested the plugin yet. Just looking at the video, I see there is no column for very important data like order status. It would be great to have another column to show the payment method. Best wishes.
Read all 1 review

Contributors & Developers

“WPAppsDev – GSheet Order Automation” is open source software. The following people have contributed to this plugin.

Contributors

Changelog

1.0.0

** Initial release.