Connect Onfleet and Google Sheets

Onfleet dispatches your drivers and tracks every delivery task. FlowMattic writes Onfleet task and driver events into Google Sheets from your WordPress site, so dispatchers, store managers and customer service can see which deliveries were created, who took them, which were completed and which failed, in a sheet they can sort by day.

Try FlowMattic free See example workflows

25 triggers 19 actions 6 example workflows 2 ready-made templates Unlimited runs

Try a pairing

When this happens in Onfleet19 triggers

Do this in Google Sheets19 actions

1. TriggerNew Task Created

2. ActionAdd New Row

When Onfleet fires New Task Created, 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

Onfleet 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 new Onfleet task

Each delivery task becomes a row with recipient, address, time window and task ID, the base list that later events update.

New Task CreatedAdd New Row

View the template

Write the driver's name when a task is assigned

Look up the task ID and fill in the assigned driver or team, so store staff can tell a customer who is bringing the order.

Task AssignedLookup Row DataUpdate Cell Data

Mark each task completed with the time

When the driver completes the delivery, the row gets a completion time from Date/Time Formatter, so daily delivery counts come straight from the sheet.

Task CompletedLookup Row DataDate/Time FormatterUpdate Row

Keep a failed deliveries list for customer service

Every failed task is added to a Failed tab with the recipient and notes, so customer service can rebook the delivery and contact the customer.

Task FailedAdd New Row

Log delayed tasks and warn the dispatcher

When a task's delay passes your threshold, it is written to a Delays tab and an email goes to the dispatcher on shift.

Task Delay TimeAdd New RowEmail (SMTP)

Record recipients who opt out of SMS

Opt-outs are added to a list so the store knows not to text that customer from other tools either.

SMS Recipient Opt-OutAdd New Row

Set up: new tasks as rows

At the end, every new Onfleet task is written to your Google Sheet as one row.

Prepare the sheet
Add a header row such as Task ID, Created, Recipient, Phone, Address, Window, Driver and Completed.
Connect Google Sheets
Under Connects, add a Google Sheets connection with an account that can edit the delivery sheet.
Start with New Task Created
Create a workflow with the Onfleet New Task Created trigger, follow its setup instructions and create a test task so FlowMattic captures the fields.
Add New Row
Add Google Sheets Add New Row, map the task fields to the columns, test the step and switch the workflow on.

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

From Onfleet	To Google Sheets
Task ID	Task ID
Time created	Created
Recipient name	Recipient
Recipient phone	Phone
Destination address	Address
Complete after and before	Window

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

Each Onfleet event is its own trigger. Build the task log first, then add the assigned, completed and failed workflows that update it.
Keep the Onfleet task ID in every row. Without it, Lookup Row Data cannot find the task a later event belongs to.
Driver ETA and Driver Arriving, or Closer Than can fire often on busy routes. Use them for alerts rather than writing each one to the sheet.

Onfleet

Integration page

Triggers (19)

New Task CreatedTriggers when a new task is created.
Task CompletedTriggers when a task is completed.
Task ClonedTriggers when a task is cloned.
Task UpdatedTriggers when a task is updated.
Task StartedTriggers when a task is started.
Task Delay TimeTriggers when a task delay time is greater than or equal to.
Task AssignedTriggers when a task is assigned to a driver or a team.
Task UnassignedTriggers when a task is unassigned from a driver or a team.
Task DeletedTriggers when a task is deleted.
Task FailedTriggers when a task is failed.
Worker CreatedTriggers when a worker is created.
Worker DeletedTriggers when a worker is deleted.
Auto-Dispatch Job CompletedTriggers when an auto dispatch job is completed.
Driver Arriving, or Closer ThanTriggers when a driver is arriving or closer than certain meters.
Driver ETATriggers when a driver ETA is less than or equal to.
Driver Status ChangedTriggers when driver status changes.
SMS Recipient Opt-OutTriggers when an sms recipient opts out.
SMS Recipient Response MissedTriggers when a recipient response is missed.
Task Batch Created Job CompletedTriggers when a task batch created job is completed.

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

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

Recipient details stay on your server

Customer names, phones and addresses pass from Onfleet through your own WordPress site into the sheet, not through an outside automation account.

Peak days cost the same

Runs are unlimited, so a holiday week with hundreds of deliveries and every status change needs no bigger plan.

Answers for the shop counter

Store staff can check a sheet to tell a customer who has their order and when it was delivered, without a dispatcher login.

Common questions

Can Google Sheets show the status of each Onfleet delivery?

Yes. Add each task with New Task Created, then use Task Assigned, Task Completed and Task Failed workflows that find the row by task ID and update it.

Can I count deliveries per driver?

Yes. Write the driver's name on the row when the task is assigned and the time when it completes, then use a pivot table to count completed tasks per driver.

Can failed deliveries alert customer service?

Yes. Start with Task Failed, add the task to a Failed tab with Add New Row, and add an Email (SMTP) step that tells the customer service inbox.

Should I log every driver location event?

Usually not. Driver ETA and arrival events can arrive often while a driver is on the road. Keep the sheet for task events and use those for alerts.

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

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