Skip to content
ClickRuntime

Connect Google Sheets to WooCommerce

Shop owners use Google Sheets for product lists, stock counts and reports, while WooCommerce runs the store. Connecting the two lets you manage products from a sheet, improve listings with AI, and keep daily sales and customer lists where you can analyse them.
Add to ChatGPTAdd to Claude
Works inChatGPTClaudeClaude CodeCursorCodexVS CodeGemini CLIZedopencodeAny MCP client

Ideas

What you can do with Google Sheets and WooCommerce

Manage WooCommerce products from a sheet and keep sales and customer data in Sheets. These are ready-made starting points. Anything else you can describe works too.
Every 30 minutesAI

Write SEO titles and descriptions for your products

Products you list in a sheet get AI-written SEO titles and meta descriptions in WooCommerce, with progress tracked in the sheet.

See how it works
Every 15 minutesAI

Add products to WooCommerce from a sheet

New rows in your product sheet become WooCommerce products with AI-written descriptions, and stock changes in the sheet are kept in sync.

See how it works
Every 30 minutes

Clean up product images from a sheet queue

Products you list in a sheet get new clean-background images made and attached in WooCommerce.

See how it works
Every hour

Build customer lists for new-category campaigns

When you add a new product category, customers who bought related products are pulled into a sheet, ready for a campaign.

See how it works
On a schedule

Log daily WooCommerce sales in a sheet

Each night the day's orders and revenue are added to a sheet and posted to Slack.

See how it works Your own logic

Any other automation you can describe in words

Your own rules, schedule and AI steps with Google Sheets and WooCommerce, plus any other app. Describe it and your assistant builds it.

See how to build your own

Build your own

Build any Google Sheets and WooCommerce automation you can describe

The ideas above are ready-made starting points, not a fixed list. Describe what should happen between Google Sheets and WooCommerce in your own words, with your conditions, other apps or an AI step, and your assistant writes it, tests it and runs it on ClickRuntime.

  • Your own rules

    Conditions, thresholds, filters and exceptions, written the way you'd explain them to a colleague.

  • Any number of apps

    One automation can read from one app and update several others. Over 248 apps are ready, and anything with an API works too.

  • AI where it helps

    Summaries, classification, extraction and drafts use ClickRuntime's built-in AI, with no extra key.

  • On a schedule or on each event

    Runs as often as every 5 minutes, or the moment an app sends an event, and keeps track of what it already handled.

For example, ask your assistant

Only push a price change to WooCommerce if it differs by less than 30 percent from the current price; otherwise flag the row for review.

Each Monday, add a tab with last week's best and worst selling products by revenue.

Use cases

Why people connect Google Sheets and WooCommerce

How the two apps work together

  • WooCommerce can send webhooks for new orders and product changes to your trigger link, or the script checks every few minutes.
  • Orders and product data are written to Google Sheets rows.
  • Rows marked ready in the sheet are sent to WooCommerce to create or update products.

  • Store owners editing products in bulk

    Prices, stock and descriptions edited in a sheet are pushed to WooCommerce. Large changes take minutes.

  • Bookkeepers exporting orders

    New orders are added to a sheet with totals, tax and shipping. Monthly reporting is ready.

  • Merchandisers planning launches

    New products added as rows are created as drafts in WooCommerce. Launches are prepared in one place.

  • Owners tracking stock

    Daily stock levels per SKU go to a sheet. Reorder decisions use real numbers.

More apps

Google Sheets, WooCommerce and other apps in one automation

An automation isn't limited to two apps. Add the next step in another app and it runs as part of the same automation.

Large order alerts

Add every WooCommerce order to my sheet and post orders over $500 to #sales.

Daily sales to QuickBooks

Each night, total today's WooCommerce orders from my sheet and create a QuickBooks sales receipt.

Low stock email

When stock for a SKU in my sheet drops below its reorder point, email my supplier from Gmail.

Setup

Connect Google Sheets and WooCommerce once

Every idea on this page uses the same two connections, so you set them up once. If one is missing, your assistant tells you and links to the right place.

Google Sheets

Spreadsheets

  1. In the ClickRuntime dashboard, open Connections and choose Google Sheets.
  2. Sign in with your Google account and allow access.
  3. Pick the spreadsheets the automation may use. It can't see any other file in your Drive.

WooCommerce

E-commerce

  1. In WP Admin, go to WooCommerce, Settings, Advanced, REST API, and click Add Key.
  2. Choose the user the key acts as and set the permission to Read/Write, which is needed for creating products, coupons and webhooks. Read is enough for reports.
  3. Click Generate API Key and copy the Consumer key (ck_...) and Consumer secret (cs_...).
  4. In the ClickRuntime dashboard, open Connections & secrets and save both, together with your store's URL.

FAQ

Questions about connecting Google Sheets and WooCommerce

How does ClickRuntime connect to my store?
With a WooCommerce REST API key, which you create under WooCommerce settings and save in your ClickRuntime dashboard.
Can it change products in my store?
Yes, if the key has read and write access. For reports only, a read-only key is enough.
Will it create a product twice?
No. The product ID is written back to the row, and rows with an ID are updated instead of created.
Does it work with any WooCommerce theme?
Yes. It talks to WooCommerce directly, so your theme and most plugins make no difference.
Can it update variations?
Yes. Variable products and their variations can be read and updated through the WooCommerce REST API.
Does it handle refunds?
Yes. Refunds can be logged to the sheet as their own rows or update the order row.
What keys does it need?
A WooCommerce REST API key and secret with read or read/write access, saved in the ClickRuntime dashboard.

Related pages

Keep exploring

Tell your assistant what Google Sheets and WooCommerce should do together

Free plan. No credit card.

Add to ChatGPTAdd to Claude