The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.

You must have column headers

Trigger on changes to cells in this column only. Leave this field blank if you want the Zap to trigger on changes to any cell within the row. Please note: All new rows will trigger the Zap even if the Trigger column is empty. Add a Filter step to stop the Zap from continuing if this column is empty in a new row.

The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.

The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.

Which spreadsheet should the worksheet be copied to? If left blank, it will be copied to the spreadsheet containing the original worksheet.

The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.

If a worksheet with the specified title exists, its content would be lost. Please, use with caution.

The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.

If you want to update the same row each time select a row from the dropdown box. To dynamically update the row, click open the dropdown and choose the "Custom" tab, then the "Add a search step" button.

Choose from your current custom Theme Color in your Spreadhseet, or enter a color #rrggbb in hexadecimal format.

Choose from your current custom Theme Color in your Spreadhseet, or enter a color #rrggbb in hexadecimal format.

True if the text is bold.

True if the text is italicized.

True if the text is strikethrough.

The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.

The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.

You must have column headers. See here for more information.

Let us know which column you want to search by with the value below. We will grab the latest matching row and give you all of its values.

Optionally, specify another column you want to search by. Note that if you supply this, the Zap will trigger only on rows that match both columns. (An example column might be something like Email Address or Phone Number)

An example value might be me@example.com or 555-5555

Search from bottom of the sheet?

Number of rows to return. Max is 500.

The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.

You must have column headers. See here for more information.

Let us know which columns to return. e.g. A:Z

Number of rows to return. Max is 500.

Number of the first row to return (1 is the header)

The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.

Value of the Worksheet Title to match exactly. Search is case-sensitive.

If a worksheet with the specified title exists, its content would be lost. Please, use with caution.

First name of the Customer associated with the Job

Last name of the Customer associated with the Job.

This date cannot be in the past (today or later, based on your timezone). Note: If no date has yet been determined for this Job to be fulfilled on, you may set this value as tbd (for 'To be determined' or 'To be dated'). Dispatchers will be able to set a date manually afterwards from within the web platform.

Address associated with the Job. Within this field, include the following (delimited by commas):

Civic number, Street name, Street Type (Blvd, Street, Ave, etc.),City Province or State,Postal Code or ZIP Code

Phone number associated with the Job.

We accept formatted phone numbers as well as non-formatted, i.e.:

+15062345678

+1-506-234-5678

+1 (506) 234-5678

Note: For US and Canadian phone numbers, you do not have to include the country dial code (+1). For other regions, please include the country code prefixed with '+'.

Mobile number associated with the Job (the tracking information will be sent to this number via SMS).

We accept formatted phone numbers as well as non-formatted, i.e.:

+15062345678

+1-506-234-5678

+1 (506) 234-5678

Note: For US and Canadian phone numbers, you do not have to include the country dial code (+1). For other regions, please include the country code prefixed with '+'.

A short description regarding the Job that is visible throughout the platform for Dispatchers and Operators alike.

Specify whether a Job is confirmed or pending confirmation from the Customer. For instance, Jobs marked as pending may require a call to the Customer.

Email address of the customer (the tracking information will be sent to this email).

Coordinates of the corresponding location in GeoJSON format: [latitude, longitude] (both values are of type float). If you provide this information and set skip_staging to true, we will not attempt to geocode the address, and the country code will automatically be set to the business's country.

Apartment associated with the address. It should be separated from the address itself to prevent geocoding errors when determining the location's geographical coordinates.

Postal Code or ZIP code associated with the address.

Defines the Customer's time preference for the Job's arrival at their door.

Note: There are two Time Preference modes available in the Company Settings within the platform:

Basic: Used for simple time preferences; AM and PM. Advanced: Used for more granular time preferences; morning, midday, afternoon, evening, night. If the Time Preference mode is set to Advanced, and the AM value is submitted, it will be set to morning. Similarly, if PM is submitted, it will be converted to afternoon.

Conversely, if the Time Preference mode is set to Basic, and either morning or midday are submitted, they will be converted to AM, and afternoon, evening and night will be converted to PM.

Balance owed associated with the Job (positive number with up to 2 decimal points)

Any comment or note associated with the Job.

Branch or Store ID associated with this Job. Ensure this ID is associated to an existing Branch in our platform.

Distribution Center or Warehouse ID associated with this Job. Ensure this ID is associated to an existing Distribution Center in our platform.

List of Invoice numbers associated with this Job

The number of labels associated with this Job. Note: This variable is used exclusively with our label printing integration. Do not set this if it is not enabled.

External system reference ID associated with this Job for your convenience. This ID should be unique for every new Job. If you do not provide one, we will automatically generate a unique Job ID.

External system for Customer reference ID associated with this Job. This only applies if skip_staging is set to true. If you do not provide one, we will automatically generate one (this only applies if the Job is matched to a Customer that does not already exist in our system).

If true, the Job created will skip the staging area (Import Tool). If you did not specify the geo-coordinates of this Job, we will automatically geocode the address you've provided. For invalid addresses that fail geocoding, the Job creation will be rejected and you will receive a 400 error response code.

Type of Job. If not set, the Job type will be delivery.

string <= 10 characters A short description regarding the Job that is visible throughout the platform for Dispatchers and Operators alike

Specify whether a Job is confirmed or pending confirmation from the Customer. For instance, Jobs marked as pending may require a call to the Customer.

Last name of the Customer associated with the Job.

Phone number associated with the Job.

We accept formatted phone numbers as well as non-formatted, i.e.:

+15062345678

+1-506-234-5678

+1 (506) 234-5678

Note: For US and Canadian phone numbers, you do not have to include the country dial code (+1). For other regions, please include the country code prefixed with '+'.

Mobile number associated with the Job (the tracking information will be sent to this number via SMS).

Email address of the customer (the tracking information will be sent to this email).

Address associated with the Job. Within this field, include the following (delimited by commas):

Civic number Street name Street Type (Blvd, Street, Ave, etc.) City Province or State Postal Code or ZIP Code

Coordinates of the corresponding location in GeoJSON format: [latitude, longitude] (both values are of type float). If you provide this information and set skip_staging to true, we will not attempt to geocode the address, and the country code will automatically be set to the business's country.

Apartment associated with the address. It should be separated from the address itself to prevent geocoding errors when determining the location's geographical coordinates.

Postal Code or ZIP code associated with the address.

Balance owed associated with the Job (positive number with up to 2 decimal points).

Any comment or note associated with the Job.

Branch or Store ID associated with this Job. Ensure this ID is associated to an existing Branch in our platform.

Distribution Center or Warehouse ID associated with this Job. Ensure this ID is associated to an existing Distribution Center in our platform.

Set the approximate Time Frame within which the Job should be started and operators should be on Customer site.

Note: Do not set these values if you want the platform to automatically calculate accurate time frame start and end values based on the Itinerary route and traffic data.

The number of labels associated with this Job. Note: This variable is used exclusively with our label printing integration. Do not set this if it is not enabled.

External system reference ID associated with this Job for your convenience. This ID should be unique for every new Job. If you do not provide one, we will automatically generate a unique Job ID.

External system for Customer reference ID associated with this Job. This only applies if skip_staging is set to true. If you do not provide one, we will automatically generate one (this only applies if the Job is matched to a Customer that does not already exist in our system).

If true, the Job created will skip the staging area (Import Tool). If you did not specify the geo-coordinates of this Job, we will automatically geocode the address you've provided. For invalid addresses that fail geocoding, the Job creation will be rejected and you will receive a 400 error response code.

If you want to use this trigger with a Sheet that resides in your Google Team Drive, you have to workaround the issue using these steps.

You must have column headers

Trigger on changes to cells in this column only. Leave this field blank if you want the Zap to trigger on changes to any cell within the row. Please note: All new rows will trigger the Zap even if the Trigger column is empty. Add a Filter step to stop the Zap from continuing if this column is empty in a new row.

The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.

The column position (zero-based) to insert. If not set, append to the right by default.

Create a duplicate of an existing spreadsheet.

These Headers are ignored if a "Spreadsheet to Copy" is selected.

The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.

Use a search step before this to get the row to delete.

The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.

If you want to update the same row each time select a row from the dropdown box. To dynamically update the row, click open the dropdown and choose the "Custom" tab, then the "Add a search step" button.

API docs for Google Sheets are located here https://developers.google.com/sheets/api/reference/rest

Requests can only be made to domains associated by this application.

These params will be URL-encoded and appended to the URL when making the request.

Authentication headers are included automatically

Zapier will apply these optional headers and values to the request in addition to any headers created as part of the authentication mechanism.

Zapier will pass this along raw. If you would like to provide complex JSON, try a "Code by Zapier" step to build the structure and pass it along here. For example, {"foo": "bar"} is perfectly valid.

The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.

Value of the Worksheet Title to match exactly. Search is case-sensitive.

The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.

You must have column headers. See here for more information.

Specify the column we should search for cells which match the Lookup Value.

Optionally, specify another column you want to search by. Note that if you supply this, the Zap will trigger only on rows that match both columns. (An example column might be something like Email Address or Phone Number)

An example value might be me@example.com or 555-5555

Search from bottom of the sheet? In other words, pick the most recent match?

The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.

You must have column headers. See here for more information.

Specify the column we should search for cells which match the Lookup Value.

Optionally, specify another column you want to search by. Note that if you supply this, the Zap will trigger only on rows that match both columns. (An example column might be something like Email Address or Phone Number)

An example value might be me@example.com or 555-5555

Search from bottom of the sheet? In other words, pick the most recent match?

ID associated with the Action (i.e. SKU, Serial Number, etc.).

"delivery" "return" "pickup" "installation" "service" "exchange" Type of Action.

Description of the Action.

Value of the Action as a positive number with up to 2 decimal points.

Unit weight of the Action in kg or ft (depending on the account settings) as a positive number with up to 2 decimal points.

Unit volume of the Action in kg or ft (depending on the account settings) as a positive number with up to 2 decimal points.

Piece count of the Action as a positive integer (i.e. quantity of 1 for a table, that comes in 3 boxes has a piece count of 3)

The (optional) unit of the piece count.

Note: In order to be able to use custom units, the relevant toggle in the Job Creation Options section of the Company Settings must be enabled.

Quantity of the Action as a positive integer.

The (optional) unit of the quantity.

Note: In order to be able to use custom units, the relevant toggle in the Job Creation Options section of the Company Settings must be enabled.

Estimated time to complete the Action (in minutes) as a positive integer.

Stop Location ID (this value will only be saved if the Action type is pickup, return or exchange)

Invoice Number associated specifically with this Action

Shipping label barcode

External system reference ID associated with this Job Action for your convenience. This ID should be unique for every new Job Action. If you do not provide one, we will automatically generate a unique Job Action ID.

ID associated with the Action (i.e. SKU, Serial Number, etc.).

Description of the Action.

Value of the Action as a positive number with up to 2 decimal points.

Unit volume of the Action in kg or ft (depending on the account settings) as a positive number with up to 2 decimal points.

Unit volume of the Action in kg or ft (depending on the account settings) as a positive number with up to 2 decimal points.

Piece count of the Action as a positive integer (i.e. quantity of 1 for a table, that comes in 3 boxes has a piece count of 3).

The (optional) unit of the piece count.

Note: In order to be able to use custom units, the relevant toggle in the Job Creation Options section of the Company Settings must be enabled.

Quantity of the Action as a positive integer

The (optional) unit of the quantity.

Note: In order to be able to use custom units, the relevant toggle in the Job Creation Options section of the Company Settings must be enabled.

Estimated time to complete the Action (in minutes) as a positive integer.

Stop Location ID (this value will only be saved if the Action type is pickup, return or exchange)

Invoice Number associated specifically with this Action

Shipping label barcode

External system reference ID associated with this Job Action for your convenience. This ID should be unique for every new Job Action. If you do not provide one, we will automatically generate a unique Job Action ID.

Start Date (in ISO-8601 format),

Note: If you want to find Jobs where the date has not yet been determined, set this value to tbd.

End Date (in ISO-8601 format),

Note:

This date should be greater or equal to the start_date. If you've set start_date to tbd, this value will be ignored.

string <= 255 characters Filter by last name that may have been set on one or many Jobs

Filter by phone number that may have been set on one or many Jobs

Filter by quick description that may have been set on one or many Jobs

Filter by invoice number that may have been set on one or many Jobs

Filter by barcode that may have been set on one or many Jobs actions and returns Job ID

Filter by job system reference ID that may have been set on one or many Jobs

Filter by confirmation status of Jobs

Branch or Store ID associated with one or many Jobs. Ensure this ID is associated to an existing Branch in our platform.

Distribution Center or Warehouse ID associated with one or many Jobs. Ensure this ID is associated to an existing Distribution Center in our platform.