It Requires installing and activating the WooCommerce plugin before using GSheetConnector For WooCommerce!
WooCommerce Installation Documentation

Download Free WooCommerce Google Sheet

WooCommerce Google Sheet Connector

Name: WooCommerce Google Sheet Connector - WooCommerce Orders to Google Sheets
Brand: GSheetConnector
SKU: Woo-GSheet
Price: 39 USD
Availability: InStock
Rating: 4.9 (250 reviews)

WooCommerce Google Sheet Connector is a powerful, flexible, and best connector plugin, a bridge between WooCommerce and Google Sheet. GSheetConnector For the WooCommerce plugin sync with your WooCommerce Orders, Products, Customers, Coupons, and Events to a single Google Spreadsheet.

WooCommerce Orders within one single Google Sheet
Auto Order ID / Edit Orders – Order wise data
Enable / Disable Sheet Headers, Edit Sheet Headers – Freeze Headers
Manage all orders in a single sheet with all 7 order statuses.
Each status will create separate sheets and automatically orders based on the order ID
Sync Orders, Background Row Color, Download & Sync Spreadsheet
Secure and latest google library.

Features of WooCommerce Google Sheet Connector

Up-to date Google sheets API

One of the features you get with the latest API is the ability to format content in Google Sheets. when using woocommerce.

Google Sheets API Settings

Create New Client ID and Client Secret Keys from google developer project, It can be accessed from https://console.cloud.google.com/

One Click Authentication

Get spreadsheet and Worksheet list directly in your google sheet settings with one-click authentication, which helps to connect easily.

Authenticated Email Display

Mostly, users confused or forget about which Gmail account is integrated with GSheet, for security reasons, displayed the authenticated email on the settings page.

Quick Configuration

The Configuration of the form to the sheet is very easy. Just follow the steps provided by the plugin and you will get data on the sheet.

Click & Fetch Sheets Automated

This option helps to fetch sheets automatically from your google authenticated account. No need of finding sheetname and tab name and enter manually. If you have too many sheets in your account, you can use Manual option.

Creating New Spreadsheets & Sheets

Once the user will select the create new sheet option, New Spreadsheet within Google drive with the desired name, it will auto-create the new spreadsheet and sheets based on the status of the order on the settings page.

Orders Tab Google Sheet Settings

Configure Google Sheets settings to handle various order types: pending, processing, on-hold, etc.

Custom Order Status

Configure Google Sheets settings to manage custom order statuses in your Google Spreadsheet using the “Custom Order Status for WooCommerce” addon plugin.

All Orders, All Products Setting

Configure Google Sheets settings to manage all orders, products, product variations, and coupons.

Orders rows management and sorting

Manage rows by selecting either “Products” or “Orders”. Choose between “Ascending” and “Descending” sorting options.

Product Category Filter

You can choose whether to manage Google Spreadsheets product-category wise.

Orders Header Setting

Extra Header Related To Order: Add additional fields in Google Sheets related to orders, e.g., user IP address.
Extra Header Related To Order’s Product: Add extra fields in Google Sheets related to order products, e.g., tax class.
Custom Static Headers: Include extra static headers in Google Sheets, e.g., IP Address, Site Name.
Custom Static Blank Headers: Add extra blank fields in Google Sheets for additional columns, e.g., tax class.

The Orders Header’s tab contains headers related to orders. Enabling product header fields will create headers in Google Sheets. Use the Check All feature to create all fields in Google Sheets with one click.

Products Header Setting

The Products Header’s tab contains headers related to products. Enabling product header fields will create headers in Google Sheets. Use the Check All feature to create all fields in Google Sheets with one click.

Products Variation Header Setting

The Products Header’s tab contains headers related to product variations. Enabling product variation header fields will create headers in Google Sheets. Use the Check All feature to create all fields in Google Sheets with one click.

Customer Header Setting

The Customer Header’s tab contains headers related to customers. Enabling customer header fields will create headers in Google Sheets. Use the Check All feature to create all fields in Google Sheets with one click.

Coupons Header Setting

The Coupons Header’s tab contains headers related to coupons. Enabling coupon header fields will create headers in Google Sheets. Use the Check All feature to create all fields in Google Sheets with one click.

Manage Orders Status wise

Users can easily manage all the orders with one Google Spreadsheet to make their business effective and also Google Spreadsheet can manage their Inventory Orders.

Custom Ordering

It helps to change the order of columns while simply dragging and dropping options. The ultimate option is given for quick arranging the columns within the WordPress dashboard.

Enable / Disable Order Status

There are checkboxes for each order status, which can be easily enabled/disabled to create and manage order status within the google spreadsheet.

Sheet Headers Sorting

Users can sort the sheet headers row in the way they want to from the general settings page.

All Orders Status

By enabling the “All in one” option you can enable all sheets of the Google Spreadsheet. All the customer order status sheets will automatically create one sheet in the spreadsheet.

Background Row Color

This feature allows users to add background row color in an odd & even manner, it is calculated as per their order id.

Freeze Header

Users can easily freeze the header row (first row) of the sheet with setting page option.

Sync Orders

Synchronize orders in ascending or descending order for a specific time period.

Sync Products

Synchronize products in ascending or descending order for a specific time period.

Sync Products Variation

Synchronize product variations in ascending or descending order for a specific time period.

Sync Customers

Synchronize customers in ascending or descending order for a specific time period.

Sync Coupons

Synchronize coupons in ascending or descending order for a specific time period.

Download Google Sheet (Orders,Products,Customers)

You can download your Google Sheet containing orders, products, and customer data for offline use.

Role Management

GSheetConnector allows a few custom capabilities which will allow the Administrator to better manage access/use of the Google Sheet Tab under contact forms.

Capabilities/ Role Management are permissions systems. Roles are assigned capabilities that define what that role can do or can’t do. It will show all the roles of the website and you can give access to view the tab for specific roles, to change/modify to connect with sheets.

Multi Languages

This plugin supports multi-languages as well!

Support WordPress multisite

With the use of a Multisite, you’ll also have a new level of user-available: the Super Admin. And can work in multi-sites

Automatic Updates

You must have a valid license key to update automatically.

Compatibility with WooCommerce Third-Party Plugins

Compatibility with third-party WooCommerce plugins.

Latest WordPress & PHP Support

It supports the latest version of PHP 7.x and WordPress, while also compatible with older versions. However, it’s recommended to use the latest versions of PHP and WordPress for optimal performance and security.

Excellent Priority Support

We provide quick support and also help users to configure plugins on their website free of cost. You can contact via online chat given on the website, either you can drop an email at [email protected] along with that complete documentation is available from installing to configure, you can refer step by step guide given in the link