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.

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?

Pick which type of object you want to watch for new items of (Note: we do our best to support all objects, but due to their complex nature, some may not work flawlessly).

Pick which type of object you want to watch for updated records of (Note: we do our best to support all objects, but due to their complex nature, some may not work flawlessly).

Pick which type of object you want to update (Note: we do our best to support all objects, but due to their complex nature, some may not work flawlessly)

The Content Document ID of a file that has been uploaded to a library in Salesforce CRM Content or Salesforce Files

Specifies whether this file is available to all users, internal users, or shared users.

Pick the type of object you want to attach the file to (Note: we do our best to support all objects, but due to their complex nature, some may not work flawlessly).

Defaults to false if left blank.

Pick the type of object if you want to attach the file to (Note: we do our best to support all objects, but due to their complex nature, some may not work flawlessly).

Pick which type of object you want to create (Note: we do our best to support all objects, but due to their complex nature, some may not work flawlessly)

Search for or select the record you'd like to update. Use Custom Value to select a record from a previous step. If using the Search, click "Refresh Fields" below to update the available input fields.

Pick which type of object you want to update (Note: we do our best to support all objects, but due to their complex nature, some may not work flawlessly)

Search for or select the record you'd like to update. Use Custom Value to select a record from a previous step. If using the Search, click "Refresh Fields" below to update the available input fields.

API docs for Salesforce are located here https://developer.salesforce.com/docs/atlas.en-us.api_rest.meta/api_rest/resources_list.htm

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.

Pick which type of object you want to search for. You can only search for multiple records which are all the same object type.

Select the format of search results to be returned. If multiple search values are provided, the choice will be applied to each search value.

Pick which type of object you want to create (Note: we do our best to support all objects, but due to their complex nature, some may not work flawlessly)

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.

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.

This trigger works on Salesforce objects with less than 104,000 records. If the "Field Updated to" is specified, the limit applies to only the records with the value specified. Check how many records you have in your account by following the steps under Viewing Storage Usage. You can also setup a Zap with the New Outbound Message trigger to workaround this limit.

Pick which type of object you want to watch for changes on.

Select which campaign to add contact. If using the Search for this field, click "Refresh Fields" below to make sure all fields are available to you.

If using the Search for this field, click "Refresh Fields" below to make sure all fields are available to you.

Select which campaign to add lead. If using the Search for this field, click "Refresh Fields" below to make sure all fields are available to you.

If using the Search for this field, click "Refresh Fields" below to make sure all fields are available to you.

Pick which type of object you want to create (Note: we do our best to support all objects, but due to their complex nature, some may not work flawlessly)

Search for or select the lead you'd like to update. Use Custom Value to select a lead from a previous step. If using the Search, click "Refresh Fields" below to update the available input fields.

Pick which type of object you want to update (Note: we do our best to support all objects, but due to their complex nature, some may not work flawlessly)

Search for or select the record you'd like to update. Use Custom Value to select a record from a previous step. If using the Search, click "Refresh Fields" below to update the available input fields.

Pick which type of object you want to search for.

Pick which type of object you want to search for.

Enter a SOQL WHERE clause. See our help docs for Tips and Examples.