Onfleet, atSpoke, Google Sheets Integrations

atSpoke
Google Sheets
Onfleet
Try Integromat for FREE
No credit card. You'll love it.

What is Integromat?

GmailWatch emailsGoogle SheetsAdd a rowGmailIterate attachmentsRouterFacebookCreate a postArchiveCreate an archiveDropboxUpload a fileDocuments onlyImages onlyWhen new email arrivesAdd a row to a sheetProcess attachmentsone by one ...Post images to pageZip all documentsUpload archive

Integromat will automate processes that you currently handle manually. It is not only capable of connecting apps but can also transfer and transform data. It works 24 hours a day, seven days a week and does not require your intervention. Simply set Integromat to do what you want and let it work for you. Save your time!

Triggers

Onfleet

Watch Recipient SMS Response Missed INSTANT

Triggers when the recipient responds to a notification via SMS, but the organization is unable to handle it at that time.

Onfleet

Watch Task Arrival INSTANT

Triggers when worker is arriving, at or closer than the threshold value provided, in meters.

Onfleet

Watch Task Assigned INSTANT

Triggers when a task has been assigned to a worker.

Onfleet

Watch Task Cloned INSTANT

Triggers when a task has been cloned.

Onfleet

Watch Task Completed INSTANT

Triggers when a task has been completed by the worker.

Onfleet

Watch Task Created INSTANT

Triggers when a new task is created.

Onfleet

Watch Task Delayed INSTANT

Triggers when the delay time is greater than or equal to the threshold value provided, in seconds.

Onfleet

Watch Task Deleted INSTANT

Triggers when a task is deleted.

Onfleet

Watch Task ETA INSTANT

Triggers when a worker ETA is less than or equal to the threshold value provided, in seconds.

Onfleet

Watch Task Failed INSTANT

Triggers when a task has failed.

Onfleet

Watch Task Started INSTANT

Triggers when a task has been started by a worker.

Onfleet

Watch Task Unassigned INSTANT

Triggers when a task has been unassigned from a worker.

Onfleet

Watch Task Updated INSTANT

Triggers when a task has been updated, including assignment, feedback, and attachment (photo, signature) changes.

Onfleet

Watch Worker Duty INSTANT

Triggers when a worker status has changed (0 for off-duty, 1 for on-duty).

atSpoke

Watch New Requests INSTANT

Triggers when a new request is created.

atSpoke

Watch New Resources INSTANT

Triggers when a new resource is created.

atSpoke

Watch Requests Updated INSTANT

Triggers when a request is updated.

Google Sheets

Perform a Function INSTANT

Receives data passed to the function INTEGROMAT used in a sheet. Sheets Add-On required.

Google Sheets

Watch Changes INSTANT

Triggers when a cell is updated. Watches only changes made in Google Sheet app. Sheets Add-On required.

Google Sheets

Watch Rows

Watches for new rows.

Actions

Onfleet

Create a Task

Creates a new task in the Onfleet dashboard.

Onfleet

Delete a Task

Deletes a task by its ID.

Onfleet

Get a Task

Returns a task's information by its ID.

Onfleet

Make an API Call

Performs an arbitrary authorized API call.

Onfleet

Update a Task

Updates a task by its ID.

atSpoke

Create a Request

Creates a new atSpoke request.

atSpoke

Create a Resource

Creates a new atSpoke resource.

atSpoke

Delete a Request

Deletes a request.

atSpoke

Delete a Resource

Deletes a resource.

atSpoke

Get a Request

Gets a request.

atSpoke

Get a Resource

Gets a resourse.

atSpoke

Get a User

Looks up a user by email address or ID.

atSpoke

Make an API Call

Performs an arbitrary authorized API call.

atSpoke

Update a Request

Updates a request.

atSpoke

Update a Resource

Updates a resource.

atSpoke

Update a User

Updates a user.

Google Sheets

Add a Row

Appends a new row to the bottom of the table.

Google Sheets

Add a Sheet

Adds a new sheet.

Google Sheets

Clear a Cell

Cleares a specific cell.

Google Sheets

Clear a Row

Clears values from a specific row.

Google Sheets

Copy a Sheet

Copies a sheet to another spreadsheet.

Google Sheets

Create a Spreadsheet

Creates a new spreadsheet.

Google Sheets

Create a Spreadsheet from a Template

Creates a new spreadsheet from a template sheet.

Google Sheets

Delete a Row

Deletes a specific row.

Google Sheets

Delete a Sheet

Deletes a specific sheet.

Google Sheets

Get a Cell

Gets a specific cell.

Google Sheets

Make an API Call

Performs an arbitrary authorized API call.

Google Sheets

Perform a Function - Responder

Returns processed data as a result of the INTEGROMAT function. Sheets Add-On required.

Google Sheets

Update a Cell

Updates a specific cell.

Google Sheets

Update a Row

Updates a row.

Searches

Onfleet

Search Tasks

Searches for tasks or lists them all.

atSpoke

List Requests

Returns a list of requests.

atSpoke

List Resources

Returns a list of resources.

atSpoke

List Users

Returns a list of users.

Google Sheets

Get Range Values

Gets a range content.

Google Sheets

List Sheets

Gets a list of all sheets in a spreadsheet.

Google Sheets

Search Rows

Returns results matching the given criteria.

Google Sheets

Search Rows (Advanced)

Returns results matching the given criteria. This module doesn't return a row number.