Cigo Tracker + Google Sheets

Create Spreadsheet

Create a blank spreadsheet or duplicate an existing spreadsheet. Optionally, provide headers.

Delete Spreadsheet Row

Deletes the content of a row in a specific spreadsheet. Deleted rows will appear as blank rows in your spreadsheet. Please use with caution.

API Request (Beta)

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

Find Worksheet

Finds a worksheet by title.

Lookup Spreadsheet Row

Finds a row by a column and value. Returns the entire row if one is found.

Find or Create Row

Finds or creates a specific lookup row.

Create Job Action

Create a new Job Action for an existing Job with a specific {jobID}.

Update a Job Action

Update an existing Job Action while its parent Job is still in staging, new or the Job has not yet been assigned to an Itinerary.

Find Location

Retrieve Location details by its ID.

Find Vehicle

Retrieve Vehicle details by its ID.

Search for Job API IDs

Create Worksheet

Create a blank worksheet with a title. Optionally, provide headers.

Format Spreadsheet Row

Format a row in a specific spreadsheet.

Lookup Spreadsheet Rows (output as Line Items)

Finds many matched rows (500 max.) by a column and value.

Get Many Spreadsheet Rows (Advanced, output as Line Items)

Returns many rows (500 max.) as a single JSON value and flat rows (line items).

Find or Create Worksheet

Finds or creates a specific find worksheet.

Create Job

Create a new Job in the staging area (also known as the Import Tool) to be reviewed by your Dispatcher(s). The staging area can be skipped if the Job is created with skip_staging set to true. However, if you do not provide the Job's precise coordinates, we will automatically geocode the address you provided.

Retrieve an Action for a Job

Retrieve a specific action for a Job.

Update Job

Update an existing Job while it is still in staging, new or not yet assigned to an Itinerary.

Find Job

Retrieve an existing Job whether it is in staging or it has been validated by your dispatcher(s).

Find Operator

Retrieve an Operator's details by its ID.

Retrieve All Actions for a Job

Retrieve all actions for a Job.