⌘K
  1. Home
  2. Docs
  3. WooCommerce GSheetConnect...
  4. Feed Settings - PRO Version

Feed Settings Guide

The new Feed Setting feature has been added in WooCommerce GSheet Connector Latest Version 2.0.37.

Why Use Feed Setting Updates?

The Feed Setting feature allows you to create and manage separate Google Sheets for different types of WooCommerce data – giving you more control and flexibility over what gets synced and where.

For example, if you want to create an Order Feed specifically for Completed Orders, you can configure a feed just for that.
You can also refine and select only the fields you want in the Google Sheet header, so the generated Google Sheet contains just the data you need — nothing extra, nothing missing.

With this feature, you can:

  • Create separate feeds for Orders, Products, Product Variations, Customers, Coupons, and Subscriptions
  • Enable or disable specific fields (columns) before syncing, and even add custom extra columns
  • Generate a clean and customized Google Sheet that fits your exact reporting needs
  • Manage feeds based on custom order statuses as well (for example “Quality Check” or “Ready to Ship”)
  • Split large data sets into separate sheet tabs — for instance, one tab per order status
  • Turn on 2-Way Sync so that changes made in Google Sheets (Insert, Update, Delete) reflect back into WooCommerce
  • Automate everything with Cron Settings and Real Time Sync, so you never have to sync manually
  • Customize the look of your sheet with Header Settings (font style, size, color, freeze header, etc.)

This helps you keep your data organized and easy to manage—making it more efficient to use and analyze, whether you’re tracking sales, managing inventory, or reporting to your team.

Order Feed

The Order Feed is one of the most powerful feed types in Feed Settings. It lets you sync your WooCommerce orders to Google Sheets exactly the way you want — filtered by order status, split across multiple tabs, and formatted either order-wise or product-wise.

Add New Feed

  1. Click on the Add Feed button.
  2. Add the Feed Name.
  3. In the Select Box, choose Orders as the Feed Location and click Submit—your feed will be added successfully.
WooCommerce Google Sheets Integration Settings
Click Add Feed and enter a Feed Name to create a new Order Feed.
WooCommerce Google Sheets Integration Settings
Choose the Feed Location and click Submit to add your Order Feed.

To activate the feed, follow these steps:

  1. Ensure the Feed Status is set to Active (Required).
  2. Only if the feed is Active, you can Edit and Update it.
WooCommerce Google Sheets Integration Settings
Set the Feed Status to Active to enable editing and updating the feed.

Edit Feed Settings

When editing the feed, first check whether the feed is Active—only then will the Update option be visible. Here is what each section of the Order Feed settings does:

Choose Google Spreadsheet

Select the Google Sheet where your order data should be stored from the Sheet Name dropdown. Use the eye icon next to it to open and preview your connected Google Sheet directly. If a newly created sheet isn’t showing up in the list, click Fetch Sheets to reload all available Google Sheets from your account.

Order Status Sheet Tabs

This is where you decide which order statuses get their own dedicated tab in your Google Sheet. Turn on Select All to enable every status at once, or toggle them individually:

  • Pending Orders
  • Processing Orders
  • On Hold Orders
  • Completed Orders
  • Cancelled Orders
  • Failed Orders
  • Refunded Orders
  • Trashed Orders
  • All Orders

Enabling a status creates a new, separate tab for it inside the same Google Sheet, so your data stays organized without needing multiple spreadsheets.

Custom Order Sheet Tabs

If you use custom order statuses in WooCommerce (created by you or another plugin, such as “Quality Check” or “Ready to Ship”), they will automatically appear here. Turn them on the same way to give each custom status its own sheet tab.

How Orders Are Synced

Choose the Sync Format that best fits how you want to read your data in Google Sheets:

  • Order Wise – Each order is added as a single row, even if it contains multiple products.
  • Product Wise – Each product within an order is added as a separate row, so you can see line-item details for every product.

You can also choose the Sorting order — Ascending or Descending — and this setting applies across all tabs in the sheet.

Order Category Filter

Turn this on if you only want orders containing products from specific categories (like Accessories, Clothing, Hoodies, T-shirts, etc.) to be synced. When disabled, orders from all categories are included.

2-Way Sync Orders

Enable 2-Way Sync to sync data between WooCommerce and Google Sheets in real time — meaning changes made directly in your Google Sheet can update WooCommerce order data too. Once enabled, choose which Allowed Actions are permitted: Insert, Update, and Delete. Use the Sync from Google Sheet button to pull changes from the sheet back into WooCommerce whenever needed. Make sure your sheet is properly connected before starting 2-way sync.

Add Extra Google Sheet Columns

This section lets you add custom columns beyond the default fields, grouped into five types — Additional Order Columns, Additional Product Columns, Additional Product Variation Columns, Additional Custom Columns, and Additional Empty Columns. Select a field from the dropdown, give it a Column Name, and click ADD.

Below that, use Enable All Columns to turn every field on or off at once, or fine-tune individual fields such as Order ID, Currency, Product ID, Product Image, Product Name, Product Type, Product Meta, Product Variation, SKU, Product Quantity, Product Base Price, Product Total, Product Tax, Categories, Partial Refund Amount, Order URL, Status Updated Date, Transaction ID, Customer ID, Order Completion Date, Order Paid Date, Order Notes, Order Status, Tax Total, Order Total, Payment Method, Billing details (Name, Address, City, State, Postcode, Country, Company Name), Shipping details (Name, Address, City, State, Postcode, Country, Method, Company), Discount Total, Discount Tax, Shipping Total, Shipping Tax, Cart Tax, Coupon Codes, Email, Phone, Customer Note, Created Date, Order Total (Excl. Shipping & Charges), Customer Total Orders, Customer Total Revenue, Customer Average Order Value, and Product URL. Use the Insert, Update, and Delete buttons at the bottom to save changes to your column list.

Cron Settings

Turn on Enable Cron Sync to automatically schedule your order data sync instead of syncing manually. Choose Set Schedule or No Schedule, then pick a Schedule Type — Repeat Weekly or Run Once — and set the Date and Time. You can also enable Real Time Sync so new orders are pushed to your Google Sheet the instant they’re created.

Header Settings

Customize how your sheet headers and rows look for better readability:

  • Header Behavior:

    • Turn on Freeze Header to keep the header row visible while scrolling down.

    • Turn on Freeze Column to keep the first column fixed while scrolling to the right. This is helpful when your sheet has many columns and you want to keep key details (like name or entry ID) always visible.

  • Header Style: set the header’s font style, font size, font color, and background color.

  • Row Style: enable Row Appearance and set font style/size, plus separate colors for odd and even rows for readability.

  • Turn on View Spreadsheet if you’d like a quick link to open your synced sheet — though since it’s a normal Google Sheet, you can always download it as Excel (.xlsx) or CSV via File → Download in Google Sheets too.

Once you’re done, click Save Settings to save the Feed Settings, and the Sync Orders section will appear below.

WooCommerce Google Sheets Integration Settings
After saving your Feed Settings, use the Sync Orders section to sync your order data.

Sync Orders

From here, you can sync your WooCommerce orders to your connected Google Sheet with ease. Set a From Date and To Date range, choose the sort order (Ascending/Descending), optionally filter by a specific Order Status, and click Sync Orders to start the sync using all the settings configured above.

Product Feed

Product Feed – How & Where to Use It Effectively

The Feed Setting feature allows you to create separate product feeds based on specific product categories, helping you organize and manage your product data more efficiently.

✅ How to Use:

  • Create individual feeds for each product category (e.g., Clothing, Accessories, Electronics)
  • Select only the fields you need (like SKU, Price, Stock, etc.) to keep your data focused and clean
  • Automatically generate a dedicated Google Sheet for each feed
  • Download and share these sheets anytime for easy access

💡 Where It’s Useful:

This is especially beneficial when:

  • You have a large product inventory and want better data segmentation
  • You want to sync only specific products to your Google Sheet
  • You need organized category-wise management for updates, syncing, and tracking

This feature gives you more flexibility and control while keeping your workflow organized and clutter-free. If you also sell variable products, you may want to pair this with the Products Variation Feed below for full variation-level data.

Add New Feed

  1. Click on the Add Feed button.
  2. Add the Feed Name.
  3. In the Select Box, choose Products as the Feed Location and click Submit—your feed will be added successfully.
WooCommerce Google Sheets Integration Settings
Click Add Feed and enter a Feed Name to create a new Product Feed.

To activate the feed, follow these steps:

  1. Ensure the Feed Status is set to Active (Required).
  2. Only if the feed is Active, you can Edit and Update it.
WooCommerce Google Sheets Integration Settings
Set the Feed Status to Active to enable editing and updating the Product Feed.

Edit Feed Settings

When editing the feed, first check whether the feed is Active—only then will the Update option be visible.

Choose Google Spreadsheet

Pick your Google Sheet from the Sheet Name dropdown, preview it with the eye icon, and use Fetch Sheets if a recently created sheet isn’t listed yet.

Product Category Filter

Enable this to sync only specific categories — turn on individual categories such as Accessories, Clothing, For Booking, Hoodies, T-shirts, or Uncategorized. When disabled, all products across all categories will be synced. This filter applies to adding, updating, and syncing products alike.

2-Way Sync Products

Turn on Enable 2-Way Sync to allow Google Sheets to update your WooCommerce product data directly. Choose which Allowed Actions to permit — Insert, Update, Delete — and use Sync from Google Sheet to pull those changes back into WooCommerce. Make sure your sheet is properly connected before starting the 2-way sync.

Add Extra Google Sheet Columns

Add custom Additional Product Columns by selecting a field, entering a Column Name, and clicking ADD. Use Enable All Columns to toggle everything at once, or manage fields individually, including Product ID, Product Name, Product Status, Product Short Description, Product Description, Product Slug, Product Link, Product Categories, Product SKU, Product Type, Product Image, Product Tags, Product Attribute, Product Regular/Sale Price, Sale Price Dates (From/To), Product Stock, Stock Status, Weight, Height, Width, Length, Dimensions, Purchase Note, Sold Individually, Manage Product Stock, Shipping Class, Tax Status, Tax Class, Virtual Product, Date Created/Modified, Downloadable options (Downloadable, Downloadable Files, File Names, Download Limit, Download Expiry), Allow Backorders — plus variation-level fields like Product Variation ID, SKU, Image, Regular/Sale Price, Sale Price Dates, Stock, Stock Status, Weight, Dimensions, Shipping Class, Manage Product Stock, Virtual Product Variation, Description, Downloadable Product Variation, Downloadable Files, Download Limit/Expiry, Allow Backorders, Total Sale — and even Grouped Products IDs, External Product Button Text, and External Product Link for grouped/external products. Use Insert, Update, and Delete to save your changes.

Cron Settings & Real Time Sync

Enable Cron Sync to automatically schedule your product data sync — choose Set Schedule or No Schedule, then a Schedule Type (Repeat Weekly or Run Once) with a Date and Time. Turn on Real Time Sync to sync new products instantly the moment they’re created in WooCommerce.

Header Settings

Customize your sheet headers and rows to keep your product data clear and organized — Freeze Header, Header Style (Font Style, Size, Color), Row Style (Font Style, Size, Color), Freeze & Color Headers, and a View Spreadsheet toggle.

WooCommerce Google Sheets Integration Settings
Configure the Product Feed settings — sheet name, tabs, category filter, headers, and general settings — then click Submit.

Once you save the Feed Settings, the Sync Products section will appear. From there, set a From Date and To Date, choose the sort order (Ascending/Descending), and click Sync Products to sync your WooCommerce products to your connected Google Sheet with ease. Make sure the Products tab is enabled before syncing.

Products Variation Feed

If you sell variable products (like a T-shirt available in multiple sizes and colors), the Products Variation Feed lets you sync each individual variation as its own row in Google Sheets — perfect for tracking variation-level SKU, price, and stock separately from the main Product Feed.

Add New Feed

  1. Click on the Add Feed button.
  2. Add the Feed Name.
  3. In the Select Box, choose Products Variation as the Feed Location and click Submit—your feed will be added successfully.
WooCommerce Google Sheets Integration Settings
Click Add Feed and enter a Feed Name to create a new Products Variation Feed.

To activate the feed, follow these steps:

  1. Ensure the Feed Status is set to Active (Required).
  2. Only if the feed is Active, you can Edit and Update it.
WooCommerce Google Sheets Integration Settings
Set the Feed Status to Active to enable editing and updating the Products Variation Feed.

Edit Feed Settings

When editing the feed, first check whether the feed is Active—only then will the Update option be visible.

Choose Google Spreadsheet

Select your Google Sheet from the Sheet Name dropdown, use the eye icon to preview it, and click Fetch Sheets if your sheet isn’t listed yet.

2-Way Sync Products Variation

Enable 2-Way Sync to update WooCommerce product variation data directly from your Google Sheet. Once turned on, you can insert, update, or delete WooCommerce variation data straight from the sheet — just choose which Allowed Actions (Insert, Update, Delete) to permit, and use Sync from Google Sheet to pull the latest changes in.

Add Extra Google Sheet Columns

Select fields and add custom column names to include extra data in your Google Sheet. Use Enable All Columns to toggle everything at once, or manage individual fields such as Product ID, Variation ID, Product Name, Product Type, Product Categories, Product Variation Name, Product Variation SKU, Product Variation Image, Regular Price, Sale Price, Sale Price Dates (From/To), Stock, Stock Status, Weight, Dimensions, Manage Product Stock, Shipping Class, Virtual Product Variation, Description, Downloadable Product Variation, Downloadable Files, Download Limit, Download Expiry, Allow Backorders, and Total Sale. Save changes with the Insert, Update, and Delete buttons.

Cron Settings

Enable Cron Sync to automatically schedule your product variation data sync — pick Set Schedule or No Schedule, then a Schedule Type (Repeat Weekly or Run Once) with a Date and Time. Turn on Real Time Sync to sync new product variations instantly to your Google Sheet as soon as they’re created.

Header Settings

Customize your sheet headers and rows to keep your product variation data clear and organized, using the same Header Behavior, Header Style, and Row Style options available across all feed types.

WooCommerce Google Sheets Integration Settings
Configure the Products Variation Feed settings and click Submit.

Once saved, use the Sync Products Variation section — set a From Date and To Date, choose the sort order, and click Sync Products Variation to sync variations to Google Sheets. Make sure the Product Variations tab is enabled first.

Customers Feed

The Customers Feed lets you export your WooCommerce customer list to its own Google Sheet — useful for building mailing lists, analyzing repeat buyers, or sharing customer data with your sales/marketing team, without mixing it into your Order Feed.

Add New Feed

  1. Click on the Add Feed button.
  2. Add the Feed Name.
  3. In the Select Box, choose Customers as the Feed Location and click Submit—your feed will be added successfully.
WooCommerce Google Sheets Integration Settings
Click Add Feed and enter a Feed Name to create a new Customers Feed.

To activate the feed, follow these steps:

  1. Ensure the Feed Status is set to Active (Required).
  2. Only if the feed is Active, you can Edit and Update it.
WooCommerce Google Sheets Integration Settings
Set the Feed Status to Active to enable editing and updating the Customers Feed.

Edit Feed Settings

When editing the feed, first check whether the feed is Active—only then will the Update option be visible.

  • Choose Google Spreadsheet – Select the Google Sheet where your customer data should be stored, using the Sheet Name dropdown, eye icon preview, and Fetch Sheets button as needed.
  • Google Sheet Tab Name – Activate the Google Sheet Tab Name as per your requirement.
  • Add Extra Google Sheet Columns – Select and enable the fields you need, such as Customer ID, Name, Email, Phone, Billing/Shipping details, Total Orders, and Total Spend, and add custom columns with your own names.
  • Cron Settings – Enable Cron Sync to schedule automatic syncing (Repeat Weekly or Run Once), or turn on Real Time Sync so new customers are added to your sheet instantly.
  • Header Settings – Customize header and row font style, size, and color for a clean, readable sheet.
  • Click the Submit button.
WooCommerce Google Sheets Integration Settings
Configure the Customers Feed settings and click Submit.

Once saved, the Sync Customers section will appear, letting you sync your WooCommerce customer list to your connected Google Sheet whenever you need it.

Coupons Feed

The Coupons Feed keeps a clean record of every discount coupon in your store — great for tracking active promotions, expiry dates, and usage limits in one place, separate from your Order or Product feeds.

Add New Feed

  1. Click on the Add Feed button.
  2. Add the Feed Name.
  3. In the Select Box, choose Coupons as the Feed Location (Feed Type) and click Submit—your feed will be added successfully.
WooCommerce Google Sheets Integration Settings
Click Add Feed and enter a Feed Name to create a new Coupons Feed.

To activate the feed, follow these steps:

  1. Ensure the Feed Status is set to Active (Required).
  2. Only if the feed is Active, you can Edit and Update it.
WooCommerce Google Sheets Integration Settings
Set the Feed Status to Active to enable editing and updating the Coupons Feed.

Edit Feed Settings

When editing the feed, first check whether the feed is Active—only then will the Update option be visible.

  • Choose Google Spreadsheet – Pick your Google Sheet from the Sheet Name dropdown, preview with the eye icon, or Fetch Sheets if it’s not listed yet.
  • Google Sheet Tab Name – Activate the Google Sheet Tab Name as per your requirement.
  • Add Extra Google Sheet Columns – Enable the coupon fields you want to track, such as Coupon Code, Discount Type, Coupon Amount, Expiry Date, Usage Limit, Usage Count, Minimum/Maximum Spend, and Applicable Products/Categories, plus any custom columns you add.
  • Cron Settings – Schedule automatic syncing or enable Real Time Sync so new coupons appear in your sheet as soon as they’re created.
  • Header Settings – Style your header and row fonts for a clean, easy-to-read sheet.
  • Click the Submit button.
WooCommerce Google Sheets Integration Settings
Configure the Coupons Feed settings and click Submit.

Once saved, the Sync Coupons section will appear, so you can sync all your WooCommerce coupons to your connected Google Sheet in one click.

All Feed

The All Feed is the most complete feed type — it combines Orders, Products, Categories, and more into a single, fully configurable feed. It’s ideal if you’d rather manage one master feed instead of separate ones for the Order, Product, and Coupons feeds.

Add New Feed

  1. Click on the Add Feed button.
  2. Add the Feed Name.
  3. In the Select Box, choose All as the Feed Location and click Submit—your feed will be added successfully.
WooCommerce Google Sheets Integration Settings
Click Add Feed and enter a Feed Name to create a new All Feed.

To activate the feed, follow these steps:

  1. Ensure the Feed Status is set to Active (Required).
  2. Only if the feed is Active, you can Edit and Update it.
WooCommerce Google Sheets Integration Settings
Set the Feed Status to Active to enable editing and updating the All Feed.

Edit Feed Settings

When editing the feed, first check whether the feed is Active—only then will the Update option be visible. The All Feed brings together almost every setting from the Order Feed, Product Feed, Products Variation Feed, and Customers Feed into one place, so you can manage all your WooCommerce data from a single feed and a single Google Sheet.

Choose Google Spreadsheet

Select the Google Sheet where you want to store your data from the Sheet Name dropdown. Use the eye icon to view your connected Google Sheet, and click Fetch Sheets if your sheet is not listed yet, so all available Google Sheets get loaded.

Order Status Sheet Tabs

Turn on Select All to enable every order status at once, or toggle them individually — Pending Orders, Processing Orders, On Hold Orders, Failed Orders, Completed Orders, Cancelled Orders, Refunded Orders, and Trashed Orders. Just like in the Order Feed, each enabled status gets its own dedicated tab in your Google Sheet.

Custom Order Sheet Tabs

Any custom order statuses you use (for example “Quality Check” or “Ready to Ship”) will appear here. Enable custom order statuses to create a separate Google Sheet tab for each one.

Other Sheet Tabs To Enable

Beyond orders, the All Feed lets you turn on additional sheet tabs to organize and manage your data more easily — enable All Products, All Products Variation, and All Customers to include those data types as separate tabs within the same Google Sheet.

How Orders Are Synced

Choose the Sync Format — Order Wise (each order as a single row) or Product Wise (each product in an order as its own row) — and set the Sorting to Ascending or Descending, exactly as in the Order Feed.


Sheet Charts – WooCommerce PRO Guide

Charts Introduction

Looking at rows of order data is not always the easiest way to understand how your store is performing. With the Sheet Charts feature in GSheetConnector for WooCommerce Pro, you can turn your WooCommerce data into visual charts directly inside your Google Sheet.

You simply choose which charts you want and what type they should be. The plugin creates the chart tabs in your Google Sheet and keeps them updated automatically as new WooCommerce orders come in. No manual chart creation or formula work is needed.

Available Charts

The Sheet Charts section provides three charts for your WooCommerce data:

  • Sales Orders: Shows the number of completed orders for each year.
  • Total Orders: Shows the total number of orders received in each year.
  • Products Sold: Shows the number of products sold in each year.

Available Chart Types

For each chart, you can choose one of the following chart types:

  • Bar Chart: Best for comparing values between different years.
  • Line Chart: Best for seeing how your numbers go up or down over time.
  • Pie Chart: Best for seeing how each year contributes to the whole.
Note : Before using Sheet Charts, make sure your Google account is connected and your WooCommerce orders are already being synced to your Google Sheet.

How to Enable Sheet Charts

Follow the steps below to create charts in your Google Sheet:

  1. Go to your WordPress Dashboard and open GSheetConnector → Settings for WooCommerce.
  2. Scroll down to the Sheet Charts section.
  3. Turn on the toggle for the chart you want to create: Sales Orders, Total Orders, or Products Sold.
  4. Select the chart type you want for it: Bar, Line, or Pie. The selected type is highlighted with a blue underline.
  5. Repeat the same steps for the other charts if you want to enable them.
  6. Click on the Save button to apply your settings.
Sheet Charts settings in WooCommerce GSheetConnector Pro
Turn on a chart and choose its type: Bar, Line, or Pie.
After saving, the plugin automatically creates a separate tab for each enabled chart in your Google Sheet. These charts and tabs are kept up to date as new WooCommerce orders come in.

Understanding Each Chart

1. Sales Orders

This chart shows how many orders were completed in each year. In your Google Sheet, a tab named Sales Orders is created with two columns: Year and Completed Orders. The chart is drawn from this data.

Use it when: You want to know how many orders were successfully completed each year.

Sales Orders pie chart in Google Sheet
Sales Orders chart (Pie) created in the Sales Orders tab.

2. Total Orders

This chart shows the total number of orders received in each year. In your Google Sheet, a tab named Total Orders is created with two columns: Year and Total Orders.

Use it when: You want to compare the overall order volume of your store from year to year.

Total Orders bar chart in Google Sheet
Total Orders chart (Bar) created in the Total Orders tab.

3. Products Sold

This chart shows the number of products sold in each year. In your Google Sheet, a tab named Products Sold is created with two columns: Year and Products Sold.

Use it when: You want to track how your product sales are growing or falling over time.

Products Sold line chart in Google Sheet
Products Sold chart (Line) created in the Products Sold tab.

Which Chart Type Should You Choose?

Chart Type Best For Example
Bar Comparing values side by side Compare Total Orders of 2024 and 2025
Line Tracking growth or decline over time See if Products Sold is rising or falling
Pie Seeing each year’s share of the total See which year had the most Completed Orders

How to Change the Chart Type

You can change the chart type at any time:

  1. Go to the Sheet Charts section in the plugin settings.
  2. Click on a different chart type icon (Bar, Line, or Pie) for the chart you want to change.
  3. Click on the Save button.
  4. Open your Google Sheet and check the updated chart in its tab.

How to Turn Off a Chart

  1. Go to the Sheet Charts section in the plugin settings.
  2. Turn off the toggle of the chart you do not need.
  3. Click on the Save button.
Note :

  • Charts are created for the options that are turned on. Turn on only the charts you need.
  • You must click Save after changing any chart option, otherwise the chart will not be created or updated.
  • The charts and their data update automatically as new WooCommerce orders come in, so you do not need to refresh or recreate them.
  • The charts are created in your connected Google Sheet. Open the sheet and click the chart tab (Sales Orders, Total Orders, or Products Sold) to see them.

Order Category Filter

Select specific categories to sync specific orders — toggle categories like Accessories, Clothing, Hoodies, For Booking, T-shirts, and Uncategorized. If disabled, all orders will be synced to Google Sheets regardless of category.

Product Category Filter

Select categories to sync specific products, the same way as the Order Category Filter above. If disabled, all products will be synced to Google Sheets.

2-Way Sync (Orders, Products, Products Variation, Customers & Coupons)

The All Feed gives you a separate 2-Way Sync block for each data type, so you can control them independently:

  • 2-Way Sync Orders – Enable 2-Way Sync to update WooCommerce orders directly from your Google Sheet.
  • 2-Way Sync Products – Enable 2-Way Sync to update WooCommerce products directly from your Google Sheet.
  • 2-Way Sync Products Variation – Enable 2-Way Sync to update WooCommerce product variations directly from your Google Sheet.
  • 2-Way Sync Customers – Enable 2-Way Sync to update WooCommerce customers directly from your Google Sheet.
  • 2-Way Sync Coupons – Enable 2-Way Sync to update WooCommerce coupons directly from your Google Sheet.

For each block, once enabled, you can insert, update, or delete WooCommerce data directly from your Google Sheet — just choose the Allowed Actions (Insert, Update, Delete) you want to permit, and use the Sync from Google Sheet button to pull those changes in. Make sure your sheet is properly connected before starting any of these syncs.

Add Extra Google Sheet Columns

Select fields and add custom column names to include extra data in your Google Sheet. This section is grouped into five column types — Additional Order Columns, Additional Product Columns, Additional Product Variation Columns, Additional Custom Columns, and Additional Empty Columns — pick a field from the dropdown, name the column, and click ADD.

Use Enable All Columns to switch every field on or off in one click, or fine-tune them individually. This list mirrors the combined field sets already covered under the Order Feed’s Add Extra Google Sheet Columns and Product Feed’s Add Extra Google Sheet Columns sections — covering order details (Order ID, Currency, Status, Totals, Billing & Shipping info, Payment Method, Coupons, Customer details, etc.), product details (Product ID, Name, SKU, Categories, Price, Stock, etc.), and product variation details, all together in a single, unified column list.

Header Settings

Customize your sheet headers and rows to keep your data clean and organized:

Header Settings

Customize how your sheet headers and rows look for better readability:

  • Header Behavior:

    • Turn on Freeze Header to keep the header row visible while scrolling down.

    • Turn on Freeze Column to keep the first column fixed while scrolling to the right. This is helpful when your sheet has many columns and you want to keep key details (like name or entry ID) always visible.

  • Header Style: set the header’s font style, font size, font color, and background color.

  • Row Style: enable Row Appearance and set font style/size, plus separate colors for odd and even rows for readability.

  • Turn on View Spreadsheet if you’d like a quick link to open your synced sheet — though since it’s a normal Google Sheet, you can always download it as Excel (.xlsx) or CSV via File → Download in Google Sheets too.

Once you’re happy with the settings, click Save Settings to save everything.

WooCommerce Google Sheets Integration Settings
Configure the All Feed settings — covering orders, products, categories, and headers — then click Submit.

Google Sheets Data Sync

Select the WooCommerce data you want to sync — Orders, Products, Customers, Coupons, or Subscriptions. Only the selected data types will be synced to Google Sheets. Because the All Feed combines everything, you’ll see a separate sync box for each enabled data type:

  • Sync Orders – Set a From Date and To Date, choose Ascending/Descending order, and click Sync Orders.
  • Sync Products – Set a date range and order, then click Sync Products.
  • Sync Products Variation – Set a date range and order, then click Sync Products Variation.
  • Sync Customers – Set a date range and order, then click Sync Customers.
  • Sync Coupons – Set a date range and order, then click Sync Coupons.

This way, a single All Feed can keep your Orders, Products, Product Variations, Customers, and Coupons all in sync with one connected Google Sheet — no need to manage five separate feeds.

WooCommerce Subscriptions Feed

Enable Subscription Option in Feed Settings

To activate the WooCommerce Subscriptions option in Feed Settings, follow these steps:

  1. First, activate the WooCommerce Subscriptions plugin along with WooCommerce.
  2. Once activated, go to the Feed Settings option and click on Add Feed.
  3. In the Select Box, the Subscriptions option will appear.
  4. Now, you can create a WooCommerce Subscriptions Feed.
WooCommerce Google Sheets Integration Settings
Once WooCommerce Subscriptions is active, the Subscriptions option appears in the Feed Location select box.

Add New Feed

  1. Click on the Add Feed button.
  2. Add the Feed Name.
  3. In the Select Box, choose Subscriptions as the Feed Location and click Submit—your feed will be added successfully.
WooCommerce Google Sheets Integration Settings
Click Add Feed and enter a Feed Name to create a new WooCommerce Subscriptions Feed.

To activate the feed, follow these steps:

  1. Ensure the Feed Status is set to Active (Required).
  2. Only if the feed is Active, you can Edit and Update it.
WooCommerce Google Sheets Integration Settings
Set the Feed Status to Active to enable editing and updating the Subscriptions Feed.

Edit Feed Settings

When editing the feed, first check whether the feed is Active—only then will the Update option be visible.

Choose Google Spreadsheet

Select your Google Sheet from the Sheet Name dropdown, preview it with the eye icon, or click Fetch Sheets to load all available Google Sheets if your sheet isn’t listed.

Add Extra Google Sheet Columns

Select fields and add custom column names to include extra subscription data in your Google Sheet. Use Enable All Columns to turn on everything at once, or pick and choose from a detailed field list including Subscription ID, Status, Customer ID, Customer Name, Start Date, End Date, Billing Period, Billing Interval, Trial End Date, Next Payment Date, Renewal Enabled, Total Order Count, Total Shipped Items, Total Earned, Total Refunded, Tax Amount, Coupon Amount, Product Names, Product IDs, Variation Names, Variation IDs, Cancellation Reason, Notes, Payment Method, Shipping Address, Coupon Code, Switched Subscriptions, New Subscriptions, Number of Resubscribes, Number of Renewals, Subscriptions Ended, Cancellations, Signup Totals, Resubscribe Totals, Renewal Totals, and Switch Totals — giving you a complete picture of your subscription business in one sheet.

Cron Settings

Enable Cron Sync to automatically schedule your subscriptions data sync — pick Set Schedule or No Schedule, then a Schedule Type (Repeat Weekly or Run Once) with a Date and Time. Turn on Real Time Sync so new subscriptions sync to your Google Sheet the moment they’re created.

Header Settings

Customize your sheet headers and rows to keep your subscriptions data clear and organized, using the same Header Behavior, Header Style, and Row Style controls available across all feed types.

WooCommerce Google Sheets Integration Settings
Configure the WooCommerce Subscriptions Feed settings and click Submit.

Once saved, use the Sync Subscriptions section — set a From Date and To Date, choose the sort order, and click Sync Subscriptions to push your subscription data to Google Sheets. Make sure the Customers tab is enabled before syncing, since subscription data links back to customer records.

Syncing Settings

Before syncing products, orders, customers, or any data to Google Sheets, it’s essential to first use the Integration with Google Manual Method Authentication. This ensures that if you’re dealing with large volumes of data, you won’t encounter any Google quota limit issues.
WooCommerce Google Sheets Integration Settings
Enable Sync settings in WooCommerce Google Sheet Connector before syncing feed data.
Note: If you have a large volume of data exceeding 1,000 rows, you must manually add more rows to the sheet, as shown in the image below.
WooCommerce Google Sheets Integration Settings
Manually add more rows to your Google Sheet when your data exceeds 1,000 rows.

Once your feeds are set up and syncing correctly, it’s a good idea to periodically check your Order Feed, Product Feed, and other feed statuses on the Sheet Sync Feeds list to make sure everything stays Active and up to date.

Related Guides

If you haven’t completed these steps yet, or if you run into any issues while configuring your feeds, check out the following related guides:

Frequently Asked Questions

What is the Feed Setting feature in WooCommerce GSheet Connector?

Feed Setting lets you create and manage separate Google Sheets for different types of WooCommerce data — such as specific order statuses, product categories, customers, coupons, or subscriptions — instead of syncing everything into one single sheet.

Which version of the plugin includes the Feed Setting feature?

The Feed Setting feature was introduced in WooCommerce GSheet Connector version 2.0.37. Make sure your plugin is updated to this version or later to access it.

How do I create a new feed?

Go to the Feed Settings section, click the Add Feed button, enter a Feed Name, choose the Feed Location from the select box, and click Submit. Your new feed will be created and listed.

Why can't I edit or update my feed?

You can only Edit and Update a feed once its Feed Status is set to Active. If the feed is not Active, the Edit and Update options will not be available.

What is the difference between Order Feed, Product Feed, and All Feed?

An Order Feed syncs data related only to orders (with options like Order Status Sheet Tabs and Order Category Filter). A Product Feed syncs product data (with options like Product Category Filter). An All Feed combines multiple data types — orders, products, categories, and more — into a single configurable feed.

What is the difference between Order Wise and Product Wise sync format?

Order Wise adds each order as a single row in your Google Sheet, even if it has multiple products. Product Wise adds each product within an order as its own separate row, so you can see line-item level details for every product sold.

Can I create separate Google Sheet tabs for each order status?

Yes. In the Order Feed’s Order Status Sheet Tabs section, you can enable statuses like Pending, Processing, On Hold, Completed, Cancelled, Failed, Refunded, and Trashed individually, and each one will get its own tab in the same Google Sheet. Custom order statuses can be enabled the same way under Custom Order Sheet Tabs.

What does 2-Way Sync do?

2-Way Sync allows changes made directly in your Google Sheet — such as inserting, updating, or deleting rows — to update your WooCommerce data automatically. You can control exactly which actions (Insert, Update, Delete) are allowed for each feed.

Can I create a feed for WooCommerce Subscriptions?

Yes. First activate the WooCommerce Subscriptions plugin alongside WooCommerce. Once active, the Subscriptions option will appear in the Feed Location select box when you click Add Feed, allowing you to create a dedicated Subscriptions Feed.

Can I create multiple feeds for different product categories?

Yes. This is one of the main benefits of the Product Feed — you can create individual feeds for categories like Clothing, Accessories, or Electronics, each generating its own dedicated Google Sheet with only the fields you select.

Where does the Sync option appear after creating a feed?

Once you save your Feed Settings, the corresponding Sync section (such as Sync Orders, Sync Products, Sync Products Variation, Sync Customers, Sync Coupons, or Sync Subscriptions) will appear, allowing you to sync that feed’s data to your connected Google Sheet.

Can I schedule my feeds to sync automatically?

Yes. Every feed type includes Cron Settings, where you can enable Cron Sync and choose to Repeat Weekly or Run Once at a set Date and Time. You can also enable Real Time Sync so new data syncs to your Google Sheet the instant it’s created in WooCommerce.

Why should I use Manual Integration before syncing large amounts of data?

Using the Manual Integration (OAuth) authentication method with your own Google Cloud Project helps you avoid hitting Google’s API quota limits, which is especially important when syncing large volumes of data across multiple feeds.

What happens if my Google Sheet exceeds 1,000 rows?

Google Sheets has a default row limit. If your feed’s data exceeds 1,000 rows, you’ll need to manually add more rows to the sheet so new synced entries have space to be written.

Still not using GSheetConnector?
Quick and easy setup ⚙️ seamlessly import your settings from any other Google Sheets plugin!
👉 Learn more about the Pro Version | Download the Free Version