Connect Prodigi and Google Sheets

Prodigi prints and ships your products and reports each change in an order's status. FlowMattic writes those changes to Google Sheets, so your store team has one tracker showing where every print order is, which ones are stuck, and when each one shipped, without opening the Prodigi dashboard.

Try FlowMattic free See example workflows

7 triggers 19 actions 5 example workflows 2 ready-made templates Unlimited runs

Try a pairing

When this happens in Prodigi1 trigger

Do this in Google Sheets19 actions

1. TriggerOrder Status

2. ActionAdd New Row

When Prodigi fires Order Status, FlowMattic runs Add New Row in Google Sheets with the data from that event.

You build this in the FlowMattic workflow builder on your own site. See the setup steps

Prodigi and Google Sheets workflows you can build

Each one uses only triggers and actions the two integrations ship today, plus FlowMattic's own tools. Where the library has a ready-made template, import it instead of building from scratch.

Ready-made template

Log every Prodigi order status change

Each change adds a dated row, giving you a full history of every order from received to shipped for support questions.

Order StatusAdd New Row

View the template

Keep one row per order with its current status

Find the order by ID and overwrite its status column, so the tracker shows where each order stands now.

Order StatusLookup Row DataUpdate Row

Email the customer when their print has shipped

A Filter passes only shipped updates. The workflow looks up the customer's email by order ID in your sheet and sends a note with Email (SMTP).

Order StatusFilterLookup Row DataEmail (SMTP)

Move problem orders to a separate tab

A Router sends cancelled or on-hold orders to an Attention tab, so someone checks the artwork or address before the customer asks.

Order StatusRouterAdd New Row

Record the date each order shipped

Date/Time Formatter writes the status time as a plain date, so you can work out days from order to dispatch in the sheet.

Order StatusDate/Time FormatterLookup Row DataUpdate Row

Set up: a log of status changes

At the end, every status change on a Prodigi order adds a row to your tracker.

Prepare the tracker
Create headers such as Order ID, Merchant reference, Status, Changed at and Customer email.
Connect Google Sheets
Under Connects, add a Google account that can edit the tracker.
Choose Order Status
Create a workflow with the Prodigi Order Status trigger and complete the setup shown in the trigger step.
Place a test order
Place a real or test order so FlowMattic captures a status change.
Map the row
Add Google Sheets Add New Row, map the order fields, test the step and switch the workflow on.

Import the ready-made template Beginner, about 5 min to set up

From Prodigi	To Google Sheets
Order ID	Order ID
Merchant reference	Merchant reference
Status	Status
Status time	Changed at

Triggers and actions in this pair

A trigger starts a workflow. An action is something FlowMattic does in the app as a step.

Good to know

Order Status fires on every change, so one order produces several events. Use the update workflow if you want a single row per order.
The shipped email needs the customer's address in your sheet. Add it when the order is created in your store.
Status names come from Prodigi. Check a captured event before setting Filter or Router conditions.

Prodigi

Integration page

Triggers (1)

Order StatusTriggers when the order status changes.

Google Sheets

Integration page

Triggers (6)

New Spreadsheet RowTrigger when a new row is added to the spreadsheet
New Or Updated Spreadsheet RowTrigger when a row is updated in the spreadsheet
Deleted Spreadsheet RowTrigger when a row is deleted from the spreadsheet
Update Cell DataTrigger when any cell is updated in the spreadsheet
Update Specific Cell DataTrigger when a specific cell is updated in the spreadsheet
Update Specific Column ValueTrigger when a specific column value is updated in the spreadsheet

Actions (19)

Add New RowAdd a new row with mapped data
Update RowUpdate existing row in specific spreadsheet with mapped data
Delete RowDelete row by ID in specific spreadsheet
Clear Row DataClear data or row by ID in specific spreadsheet
Lookup Row DataSearch for data in specific spreadsheet
Get Cell DataGet data for particular cell in specific spreadsheet
Update Cell DataUpdate data for particular cell in specific spreadsheet
Get Row CountGet total number of rows in specific spreadsheet
Get Row DataGet rows data from the sheet based on specified range
Create Spreadsheet ColumnCreate a new column in specific spreadsheet
Create New SheetCreate a new sheet in specific spreadsheet
Import CSV or JSON to Existing SheetImport CSV or JSON data to existing sheet in specific spreadsheet
Copy SheetCopy a sheet to another or within the same spreadsheet
Get RowsRetrieve rows in JSON format for use with Iterator
Export sheet to CSVExport the selected sheet to CSV format and save to WordPress Media Library
Export Sheet to ExcelExport the spreadsheet to Excel (.xlsx) format and save to WordPress Media Library
Export Sheet to PDFExport the spreadsheet to PDF format and save to WordPress Media Library
Export Sheet to OpenDocumentExport the spreadsheet to OpenDocument (.ods) format and save to WordPress Media Library
Export Sheet to TSVExport the selected sheet to TSV format and save to WordPress Media Library

Why run this pair with FlowMattic

Prodigi and Google Sheets connect through FlowMattic on your own site, with no separate automation account in the middle and no charge per run.

Order data on your server

Order details pass through your WordPress site to the tracker, with no extra automation service in the middle.

Busy seasons cost the same

Runs are unlimited, so a holiday rush with many status changes needs no bigger plan.

Support answers from one sheet

Anyone answering where's-my-order emails reads the tracker without a Prodigi login.

Common questions

How do I track Prodigi orders in Google Sheets?

Create a workflow with the Prodigi Order Status trigger and add Google Sheets Add New Row, or Lookup Row Data and Update Row for one row per order. Map the order ID and status.

Can I tell customers when their order ships?

Yes. Add a Filter for the shipped status, find the customer's email in your sheet by order ID and send the message with Email (SMTP).

Can I see stuck orders?

Yes. Use a Router on the status to send cancelled or on-hold orders to their own tab, so they get checked first.

Can the sheet create or cancel Prodigi orders?

No, these workflows only read status changes from Prodigi and write them to the sheet. Orders are still placed and changed in Prodigi or your store.

Did not find your answer? You can browse the help center or ask us directly.

Start automating Prodigi and Google Sheets

Install FlowMattic, connect both accounts and import a template. Every run stays on your own server.

Try FlowMattic free See pricing

30-day money-back guarantee Unlimited workflows and runs Self-hosted

Reviewed 27 Oct 2026. The example workflows are written with AI from the real triggers and actions of both integrations and checked against them. Prodigi integration 1.0.0, Google Sheets integration 2.2.4.