Connect ClickPost and Google Sheets

ClickPost tracks shipments across many carriers and reports each status change. FlowMattic writes those updates into Google Sheets, either as a full scan history or as the latest status on each order's row. Operations and support teams can then see stuck parcels, failed deliveries and return-to-origin orders in one sheet, whichever courier is carrying them.

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 ClickPost1 trigger

Do this in Google Sheets19 actions

1. TriggerShipment Update

2. ActionAdd New Row

When ClickPost fires Shipment Update, 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

ClickPost 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 ClickPost shipment update to an order tracker

Each scan event adds a row with the AWB, order ID, carrier, status, location and time, a complete history to check when a customer asks where their parcel is.

Shipment UpdateAdd New Row

View the template

Keep only the latest status on each order row

Find the order by AWB or order ID and overwrite its status and last location, so the tracker has one line per shipment instead of dozens of scans.

Shipment UpdateLookup Row DataUpdate Row

List failed deliveries and returns for the support team

A Filter passes updates such as failed delivery or return to origin, adds them to an exceptions tab and emails support, so someone can call the customer before the parcel goes back.

Shipment UpdateFilterAdd New RowEmail (SMTP)

Write the delivered date into the order's row

When the status is delivered, find the order and fill its delivered cell. Finance can then reconcile cash on delivery and count return windows from a real date.

Shipment UpdateFilterLookup Row DataUpdate Cell Data

Compare carriers with one tab per courier partner

A Router uses the courier name so each carrier's updates fill their own tab, which makes it easier to see which partner leaves parcels stuck in transit.

Shipment UpdateRouterAdd New Row

Set up: shipment updates in a tracker

At the end, every shipment update ClickPost sends is added as a row in your Google Sheets tracker.

Build the tracker
Create a sheet with AWB, Order ID, Courier, Status, Location and Updated at columns.
Trigger on Shipment Update
Create a workflow with ClickPost and Shipment Update, and add the webhook details the trigger shows to your ClickPost account.
Wait for a real update
Book or scan a test shipment, or wait for the next status change on a live one, so FlowMattic captures the update fields.
Add the row
Connect Google Sheets, add Add New Row, map AWB, status and location to the columns, test the step and switch the workflow on.

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

From ClickPost	To Google Sheets
AWB number	AWB
Order ID	Order ID
Courier partner	Courier
Status	Status
Location	Location
Timestamp	Updated 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

Shipment Update fires on every status change, so a single parcel can add many rows. Use the latest-status example if you want one row per order.
Status names come from ClickPost's data. Check the values in a few test updates before you set the Filter for failed deliveries or returns.
The tracker reads from ClickPost. Editing a row does not change the shipment or the customer notifications ClickPost sends.

ClickPost

Integration page

Triggers (1)

Shipment UpdateTriggers when a shipment gets updated.

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

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

All carriers in one sheet

Support answers where-is-my-order questions from one tracker, whichever courier the parcel went with.

Customer addresses stay on your server

Shipment and order data go from ClickPost through your own WordPress site to Google, with no other automation company holding it.

High scan volume, flat cost

Runs are unlimited, so a store shipping thousands of parcels, each with many scans, pays nothing per update.

Common questions

Will each ClickPost scan create a new row?

With Add New Row, yes, which gives a full history. To keep one row per shipment, search the AWB with Lookup Row Data and use Update Row instead.

Can I see only problem shipments?

Yes. Put a Filter after the trigger that passes statuses such as failed delivery, return to origin or lost, and write those to an exceptions tab.

Can I match updates to my own order list?

Yes, if your sheet holds the order ID or AWB. Lookup Row Data finds the row and Update Row writes the status and location into it.

Does this work for every carrier ClickPost supports?

The trigger fires for shipment updates ClickPost reports, so any carrier connected to your ClickPost account reaches the same workflow. Route on the courier name to separate them.

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

Start automating ClickPost 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. ClickPost integration 1.0.0, Google Sheets integration 2.2.4.