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.

Determines which App Extensions will appear in the dropdown below.

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.

If you do not select a board, only activities performed by you will trigger the zap. If you choose a board, activities on all cards on that board will trigger the zap, including cards you are not a member of.

Further filter activity by list. Requires a board to be selected.

Only trigger for this type of activity/action.

Choosing a board will trigger only for cards due on that board.

How far before the due time do you want us to trigger? Note: The Trello API requires ~60 seconds for updates on cards to appear.

Only trigger for new checklists in this board.

Pick a board that contains the card with the checklist you want to add an item to.

Filter cards below by list. Requires a board to be selected.

Pick the card with the checklist you want to add an item to.

Pick the checklist you want to add an item to.

You can choose a specific number if you want.

Trello uses Markdown formatting syntax.

Pick a color label to apply to the card.

Type names for custom labels (non-existing will be created).

You can choose a specific number if you want.

Requires a board to be selected.

Use a comma to separate multiple files.

Use a comma to separate multiple URLs.

Leave this blank if you don't want to add a checklist.

Pick a board that contains the card you want to add an attachment to.

Filter cards below by list. Requires a board to be selected.

Pick the card to add the attachment to.

Use a comma to separate multiple files.

Use a comma to separate multiple URLs.

Pick a board that contains the card you want to move.

Filter cards below by list. Requires a board to be selected.

Pick the card to move.

Pick the board that has the list you would like the card to move to. Defaults to the board the card is currently in.

Pick the list to move the card to.

Pick a board that contains the card you want to update. A board must be selected if you want custom fields to be shown as options below.

Filter cards below by list. Requires a board to be selected.

Pick the card to update.

Leave this blank if you do not want to update the name.

Leave this blank if you do not want to update the description. Trello uses Markdown formatting syntax.

Leave this blank if you do not want to update the due date.

Leave this blank if you do not want to update the position. Pick the position of the card in the list (can be top, bottom, or a positive number)

Choose a board to close.

Pick a board that contains the card with the checklist item you want to complete.

Filter cards below by list. Requires a board to be selected.

Pick the card with the checklist item you want to complete.

Pick the checklist which has the item you want to complete.

Pick the checklist item you want to complete.

Pick a board that contains the card with the checklist you want to add an item to.

Filter cards below by list. Requires a board to be selected.

Pick the card with the checklist you want to add an item to.

Pick the checklist you want to add an item to.

Pick a board that contains checklist you're looking for.

Filter cards below by list. Requires a board to be selected.

Pick the card that contains the checklist you're looking for.

Search by matching Checklist Name.

An Organization must be chosen if the "organization" option is chosen.

Choose "Yes" to allow any team member to join this board without being invited (only applicable to team boards). To apply this setting, the "Permission Level" field can't be blank or set to Private.

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.

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?

Choosing a board will trigger on all new cards on that board.

Requires a board to be selected.