When a new order is created in WooCommerce, loop through the line items using Iterator, call WooCommerce PHP function wc_get_product to get the product data for the product ID, and add details to Google Spreadsheet
Each WooCommerce order is unpacked line by line with Iterator, enriched with full product data via PHP Functions, and logged to Google Sheets, giving you an itemized sales record with zero manual entry.
WooCommerce
Iterator
PHP Functions by FlowMattic
Google SheetsFree · import into FlowMattic in one click
Every step, explained
Import the template and this whole chain runs on autopilot — here's exactly what happens on each run.
Built to own, not to rent
No-code setup
Import the JSON, connect your accounts, and go live in minutes. Every step is pre-mapped — you only add your own credentials.
Runs on your server
Self-hosted on your WordPress install. No per-task fees, no data leaving your infrastructure, no monthly SaaS bill.
Fully customizable
Open it in the visual builder and reshape it — add branches, swap apps, insert filters. A starting point, not a cage.
Related workflows
Other ready-to-import automations from the FlowMattic library.
Ready to automate your WordPress site?
Download this workflow free, or grab FlowMattic and own every automation on your site — no per-task fees, ever.