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

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.

One Click Authentication

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

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/

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.

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.

Freeze Header

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

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.

Compatibility with WooCommerce Third-Party Plugins

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.

Automatic Updates

You must have a valid license key to update automatically.

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.