Integrate Dispatch with Google Sheets to automate your work

Creates a new note.

Sends an organization an offer reminder.

Finds an existing product or service.

Finds an existing job.

Finds an existing organization. If you only dispatch jobs to a single organization you will not need to use this search as the organization will default.

Triggers when a new row is added to the bottom of a Google Team Drive spreadsheet.

Triggers when a new spreadsheet is created.

Triggers when a new row is added or modified in a spreadsheet.

Create a new column in a specific spreadsheet.

Create one or more new rows in a specific spreadsheet (with line item support).

Creates a new spreadsheet. Choose from a blank spreadsheet, a copy of an existing one, or one with headers.

Permanently deletes all data in a selected row. This action cannot be undone.

Update a row in a specific spreadsheet.

This is an advanced action which makes a raw HTTP request that includes this integration's authentication.

Finds a worksheet by title.

Find a specific spreadsheet row based on a column and value. If found, it returns the entire row. Optionally, create a new row if no match is found.

Finds or creates a specific lookup row.

Creates or Updates an organization. This requires elevated privileges i.e. authentication using the "Client ID" - if you require access to this API please reach out to

Creates or Updates a user (field worker or dispatcher).

Finds an existing customer.

Finds an existing job offer.

Finds an existing technician or dispatcher.

Triggers when a new row is added to the bottom of a spreadsheet.

Triggers when a new row is added or modified in a spreadsheet - works best with Team Drives.

Triggers when a worksheet is created in a spreadsheet.

Create a new row in a specific spreadsheet.

Creates a new worksheet by copying an existing worksheet.

Creates a new worksheet in a Google Sheet.

Format a row in a specific spreadsheet.

Update one or more rows in a specific spreadsheet (with line item support).

Find up to 500 rows based on a column and value as line items.

Return up to 500 rows as a single JSON value or as line items.

Finds or creates a specific find worksheet.