WooCommerce + Google Sheets
A sheet works as the planning desk for the store: import products from rows, queue AI-written SEO meta tags, and pull customer lists for campaigns.
Popular ideas
Automate WooCommerce
Watch WooCommerce orders, refunds, stock levels and product reviews, keep the catalogue in step with your supplier, and get sales numbers without opening WP Admin. Lay out the rule for your AI assistant, check the steps it will take against your store, and it runs on its own from then on.
Try asking
Create a ClickRuntime automation: give me a link my supplier's feed can send products to. Match on SKU: create the WooCommerce product if it's new, otherwise update its regular price and stock quantity.
Paste it into your assistant. It tells you what it will send or change before it runs live.
Ideas
What you can automate in WooCommerce
Big and suspicious orders flagged as they arrive, refund and review alerts, low-stock and stuck-order warnings, daily and weekly sales figures, customer segments and products kept current from a feed. These are ready-made starting points. Anything else you can describe works too.
The moment it happens
Keep WooCommerce products in sync with a supplier feed
Products sent to your link are created when the SKU is new, otherwise their price and stock are updated.
See how it worksMonthly
Sort customers into champions, loyal, at-risk and lost
Once a month you see which customers buy often and recently, and which have drifted away.
See how it worksDaily
Make follow-up coupons for unfinished orders
Each evening, customers with pending orders get a unique coupon and you get the list to follow up.
See how it worksThe moment it happens
Post big WooCommerce orders to Slack
Orders above your threshold show up in Slack with the number, total and a link as they come in.
See how it worksDaily
Get a morning list of low-stock products
Products dropping under your threshold are emailed to you each morning, without repeats of ones already flagged.
See how it worksDaily
Catch orders stuck in processing
A daily email names orders that have sat in processing too long, so none get forgotten.
See how it worksDaily
Get yesterday's WooCommerce sales each morning
One email each morning gives yesterday's sales total and number of orders.
See how it worksThe moment it happens
Get refund details in Slack
Every refund, partial ones included, is posted with the order number, amount and reason.
See how it worksHourly
Hear about 1 and 2 star reviews quickly
Poor product reviews reach you within the hour, with the text, so you can respond.
See how it worksWeeklyAI
Get a weekly read on what customers say
Every Monday you learn the main complaints, the main praise and which products need attention.
See how it worksWeekly
Get weekly store numbers compared to last week
A Monday post gives revenue, orders, average order value and best sellers, each against the week before.
See how it worksThe moment it happens
Flag risky WooCommerce orders before you ship
Orders that match your warning signs are posted to Slack and noted on the order itself.
See how it worksThe moment it happens
Get an email for each new registered customer
When someone creates an account on your store, you get their name, email and location.
See how it worksThe moment it happens
Spot customers who cross a spend milestone
You're told the moment a customer's lifetime spend passes your threshold, so you can thank them.
See how it worksThe moment it happens
Announce newly published products to the team
When a product goes live, its name, price and link are posted for the team; drafts are skipped.
See how it works Your own logicAny other automation you can describe in words
Your own rules, schedule and AI steps with WooCommerce, plus any other app. Describe it and your assistant builds it.
See how to build your ownBuild your own
Build any WooCommerce automation you can describe
The ideas above are ready-made starting points, not a fixed list. Describe what WooCommerce should do 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
Check WooCommerce every 15 minutes for orders over $500 or with a shipping country different from the billing country, and flag them for review with an order note.
When a new WooCommerce order comes in, add a row to my Google Sheet with the order number, customer, items and total.
When a WooCommerce product drops below 5 in stock, log it in Google Sheets, post an alert in Slack, and save a reorder email to my supplier as a Gmail draft.
Works with
WooCommerce with the apps you already use
Store data is most useful outside the store: in a sheet for planning, in team chat when something needs a reply, and in email for reports and reorders.
See all 5 ideas
WooCommerce + Slack
Sales spikes, low stock and refund requests turn up in the team channel along with the order details needed to act.
Popular ideas
WooCommerce + Gmail
Reorder emails go out when stock runs low, refund requests get matched to their orders, and a review sentiment report reaches your inbox.
Popular ideas
WooCommerce works with hundreds of other apps
Name any of them when you ask your assistant, and your automation connects them. Over 248 apps are ready to go, and anything with an API works too.
- WordPress
- Stripe
- PayPal
- Shopify
- Mailchimp
- Klaviyo
- QuickBooks
- Xero
- ShipStation
- Shippo
- AfterShip
- Google Analytics
- HubSpot
- Trustpilot
- Airtable
- Telegram
- Facebook Pages
Beyond chat
Have WooCommerce work when you're not in the chat
Connecting WooCommerce to ChatGPT or Claude lets you ask about it while you chat. ClickRuntime handles the part that should happen on its own: checks on a schedule and actions on each new event, set up from the same chat and running after you close it.
Instant
Keep WooCommerce products in sync with a supplier feedThe moment it happens
On a schedule
Sort customers into champions, loyal, at-risk and lostMonthly
Watches for changes
Hear about 1 and 2 star reviews quicklyHourly
Setup
Connect WooCommerce
WooCommerce connects with REST API keys generated on your own WordPress site. The keys act as the WordPress user you pick and get that user's capabilities.
WooCommerce
E-commerce
- In WP Admin, go to WooCommerce, Settings, Advanced, REST API, and click Add Key.
- 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.
- Click Generate API Key and copy the Consumer key (
ck_...) and Consumer secret (cs_...). - In the ClickRuntime dashboard, open Connections & secrets and save both, together with your store's URL.
Good to know
WooCommerce limits that affect automations
- Your store must be served over HTTPS for simple key authentication. Over plain HTTP, every request has to be signed with OAuth 1.0a, which is fiddly and timing-sensitive.
- Some hosts strip the Authorization header; in that case the keys are sent as query parameters instead.
- Instant alerts rely on WooCommerce webhooks, which can only be created with a Read/Write key. With a Read key, new orders are found by checking on a schedule.
- Low-stock alerts only work for products with stock management turned on, and guest checkouts don't create customer records.
- A partial refund does not change the order status, so refund alerts read the order's refund list rather than relying on status alone.
FAQ
Questions about automating WooCommerce
What can ClickRuntime do in my WooCommerce store?
What the key's WordPress user can do. With Read it can read orders, products, customers, reviews and sales reports. With Read/Write it can also create or update products, add coupons and order notes, and set up webhooks.
Will I hear about new orders straight away?
Yes, when a webhook is set up for order events, which needs a Read/Write key. Otherwise the automation checks for new orders on a schedule.
Can it email my customers abandoned-cart coupons?
It creates a unique coupon for each pending order and emails you the list with the codes. ClickRuntime only emails you, the owner, so you choose how to send them on.
Does fraud screening use AI?
Not by default: it flags orders with rules you set, like mismatched billing and shipping countries or a high total. You can add a short AI risk note, and the weekly review-sentiment report uses AI too. Both are covered by your ClickRuntime plan with no AI key needed.
Does it work if my store is on a self-hosted WordPress site?
Yes, that is the normal case. The keys come from your own WordPress install and requests go straight to your site's REST API.
Is this a WooCommerce connector for ChatGPT or Claude?
Not for chatting with WooCommerce data. A chat connector lets your assistant read and change WooCommerce while you're in the conversation. ClickRuntime is for the work that should happen without you: you set up an automation from the chat once, and it keeps running on a schedule or on each WooCommerce event.
Related pages
Keep exploring