Log all new subscriptions to Google Sheets for analytics
Every new WooCommerce Subscriptions subscription is written to a row in Google Sheets, so you can build charts, pivot tables and growth reports on your recurring sign-ups.
WooCommerce Subscriptions
Google Sheets2 steps Setup ~5 min Used on 1.2k sites Free to import
What this workflow does
WooCommerce Subscriptions shows you each subscription in the WordPress admin, but analysis usually happens in a spreadsheet: sign-ups per week, which plans sell, how billing periods compare. Exporting by hand gets old. This workflow writes each new subscription to Google Sheets as it is created.
The WooCommerce Subscriptions trigger fires when a new subscription is created on your store. FlowMattic passes the subscription details to Google Sheets, where the Add New Row step writes them to the columns you map, such as date, customer, product and recurring total.
The sheet records subscriptions as they start. Renewals, cancellations and status changes do not touch it, so it tracks sign-ups rather than live subscriber counts. Each row is added once and not updated later. Create a test subscription after import to see which fields the trigger provides before you set up your columns.
Weekly sign-up reports
You chart new subscriptions per week from the sheet and share the chart with your team every Monday.
Comparing plans
A pivot table on the product column shows which subscription plans people choose most often.
Data for an outside analyst
An analyst who has no access to your WordPress admin works from the shared spreadsheet instead.
How this workflow runs
What happens at each step once the workflow is on, and what you need before you import it.
WooCommerce Subscriptions Subscription CreatedFires when a new subscription is created in WooCommerce Subscriptions. The subscription and customer details are passed on for mapping.
- Google Sheets Add New Row
Writes the new subscription to a row in the spreadsheet you choose. Connect your Google account and map each subscription value to a column.
What you need
- FlowMatticCore
- WooCommerce Subscriptions PluginPlugin
- Google Sheets AccountAccount
After importing, map your own data. To keep the template universal, not every step is pre-filled. Open each step in the builder and connect your accounts and fields (channels, lists, sheets, recipients) before you switch the workflow on.
Make it yours
Changes worth making after you import it.
- Create column headers for date, customer email, product, billing period and recurring total before mapping, so every row has the same layout for analysis.
- Build a second workflow on the Subscription Cancelled trigger that writes to another tab, so you can compare starts with stops.
- Keep the raw rows on one tab and build charts on another, so new rows never shift your formulas.
Questions about this workflow
Do subscription renewals add rows to Google Sheets?
No. The trigger is Subscription Created, so only new subscriptions are logged. Renewal payments do not start this workflow.
Will cancelled WooCommerce subscriptions be removed from the sheet?
No. Rows are added when subscriptions are created and are never changed. Track cancellations with a separate workflow if you need them.
Are existing subscriptions copied into the sheet?
No. Only subscriptions created after you turn the workflow on are added. Add older subscriptions to the sheet by hand if you need the full history.
Which WooCommerce subscription details can I log?
The values the Subscription Created trigger provides. Create a test subscription and check Task History to see them, then map the ones you want.
More Spreadsheets & Data workflows
Other ready-to-import templates from the same category.
Import this workflow into your WordPress site
Download the JSON, import it from the Workflows screen and connect your accounts. Every run stays on your server, with no per-task fees.
30-day money-back guarantee Unlimited workflows and runs Self-hosted