Have you considered using a third-party tool for such tasks? For example, Coupler.io might be a perfect solution for you. The only thing, it wouldn’t work by a trigger (like order fulfillment) but by a schedule: Coupler supports automated data refresh feature that can be set up in a way of custom schedule, so you can choose how often your data should be refreshed (minimum every 15 minutes).
Topic summary
Exporting fulfilled-order data from Shopify Flow to Google Sheets, with a need to map fields (e.g., Name, Email, Currency, Subtotal, Taxes) similar to the standard orders CSV.
Guidance provided:
- Use Flow’s “Add a variable” picker to insert the correct Liquid placeholders.
- Variable names follow the Admin GraphQL API (Order object), so the API docs are the authoritative reference.
Key limitation/clarification:
- Flow cannot loop over nested lists (e.g., Orders → LineItems), so sending one Google Sheets row per line item using a For Each is not supported. High-frequency row writes could also overwhelm the Sheets API, which is part of why this feature isn’t available.
Recommended approach/workarounds:
- Prefer streaming per-order updates using the Order trigger and add a row per order, instead of scheduled batch jobs.
- A third-party tool (Coupler.io) can schedule data refreshes (at least every 15 minutes) but isn’t trigger-based.
Status:
- Users can proceed with per-order rows and map fields via the variable picker/GraphQL docs. Batch weekly exports with per-line-item rows remain unsupported in Flow. The thread concludes with a plan to switch to the per-order trigger.