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.

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.

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?

Specify which workspace/organization.

You may have to select a workspace if you get errors when loading Projects.

Specify which workspace/organization.

Specify which workspace/organization.

You need to choose a project before you can choose a task.

You must have a custom template saved in a Workspace or Team. https://asana.com/guide/help/premium/custom-templates

Either search for an existing task, or "Use a Custom Value" and select the "Task ID" if the task was created by a previous step in this Zap.

You can use human readable dates like: "tomorrow" or "next week Tuesday". Cannot be used with Due At. Ignores time.

You can use human readable dates like: "tomorrow" or "next week Tuesday". Cannot be used with Due On. Considers time.

Specify which project.

Specify which task.

Specify your text.

Workspace must be specified to get dropdown selections in the Task, Project and Section list below. Not required if you will be using custom values to set the fields below.

Task to be moved to a project's section. The dropdown here will only include tasks that are assigned to you, but you can use this action with any task in the workspace selected above by specifying a "Custom Value" for this task field..

Project to which to move the task. Tasks can only be moved to projects in the same workspace..

Section to which to move the task. Task will be moved to the bottom of the section. If section is not specified for a list-type project, the task will be moved to the no section area of the project. If the section is not specified for a board-type project, the task will be added to the first column of the board.

API docs for Asana are located here https://asana.com/developers/api-reference/

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 existing project that contains the task to be found.

The name of the section to find (exact match first, fuzzy match second).

This is the last, long number in the address bar when you view a Task or in the Task Link you can copy.

The name of the project to find (exact match first, fuzzy match second).

If you choose an Organization, you must specify a team. A team is used to group related projects and people together.

Specify one or more projects to search for an existing task.

The name of the task to find (exact match first, fuzzy match second).

Add the task to this Section within the Project. This can only be used when one Project is selected above.

You can format the description using markdown syntax:
# Heading 1
## Heading 2

**bold text**
*italicized text*
~~strikethrough~~
> blockquote

Ordered List
1. First item
2. Second item
3. Third item

Unordered List
- First item
- Second item
- Third item

Code: `code`
Link: [title](https://www.example.com)

Note: Only the above syntax items will generate rich text in a task description.

Default false. If you have issues with XML errors, set this to true to resolve those.

You can use human readable dates like: "tomorrow" or "next week Tuesday". Cannot be used with Due At. Ignores time.

You can use human readable dates like: "tomorrow" or "next week Tuesday". Cannot be used with Due On. Considers time.

Can only be set if the Assignee is also set.

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.

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.

Required if no project is selected below. May be needed to avoid errors when selecting a Project below.

Required if on the Asana Free plan.

Specify which project to watch for new stories.

Specify which task. If blank, defaults to stories on the project itself only, but NOT all stories on all tasks.

You may have to select a workspace if you get errors when loading Tags below.

Please specify a project, tag, or workspace of the task that you are duplicating.

The name of the new task.

One or more fields to be included in the duplicated task

An existing section in the project after which the new section should be inserted. This field cannot be used in combination with "Section to Insert Before." Please use one or the other.

An existing section in the project before which the new section should be inserted. This field cannot be used in combination with "Section to Insert After." Please use one or the other.

If you choose an Organization, you must specify a team. A team is used to group related projects and people together.

Add the task to this Section within the Project. This can only be used when one Project is selected above.

You can format the description using markdown syntax:
# Heading 1
## Heading 2

**bold text**
*italicized text*
~~strikethrough~~
> blockquote

Ordered List
1. First item
2. Second item
3. Third item

Unordered List
- First item
- Second item
- Third item

Code: `code`
Link: [title](https://www.example.com)

Note: Only the above syntax items will generate rich text in a task description.

Default false. If you have issues with XML errors, set this to true to resolve those.

You can use human readable dates like: "tomorrow" or "next week Tuesday". Cannot be used with Due At. Ignores time.

You can use human readable dates like: "tomorrow" or "next week Tuesday". Cannot be used with Due On. Considers time.

Can only be set if the Assignee is also set.

Either search for an existing task, or "Use a Custom Value" and select the "Task ID" if the task was created by a previous step in this Zap.

Cannot be used if Due At field is filled in.

Cannot be used if Due On field is filled in.

Can only be set if the Assignee is also set.

The name of the project to find (exact match first, fuzzy match second).

Specify one or more projects to search for an existing task.

The name of the task to find (exact match first, fuzzy match second).

Paginated results are only available if workspace is selected.

The existing project that contains the task to be found.

The name of the task to find (exact match first, fuzzy match second).

Add the task to this Section within the Project. This can only be used when one Project is selected above.

You can format the description using markdown syntax:
# Heading 1
## Heading 2

**bold text**
*italicized text*
~~strikethrough~~
> blockquote

Ordered List
1. First item
2. Second item
3. Third item

Unordered List
- First item
- Second item
- Third item

Code: `code`
Link: [title](https://www.example.com)

Note: Only the above syntax items will generate rich text in a task description.

Default false. If you have issues with XML errors, set this to true to resolve those.

You can use human readable dates like: "tomorrow" or "next week Tuesday". Cannot be used with Due At. Ignores time.

You can use human readable dates like: "tomorrow" or "next week Tuesday". Cannot be used with Due On. Considers time.

Can only be set if the Assignee is also set.

This is the last, long number in the address bar when you view a Task or in the Task Link you can copy.

Add the task to this Section within the Project. This can only be used when one Project is selected above.

You can format the description using markdown syntax:
# Heading 1
## Heading 2

**bold text**
*italicized text*
~~strikethrough~~
> blockquote

Ordered List
1. First item
2. Second item
3. Third item

Unordered List
- First item
- Second item
- Third item

Code: `code`
Link: [title](https://www.example.com)

Note: Only the above syntax items will generate rich text in a task description.

Default false. If you have issues with XML errors, set this to true to resolve those.

You can use human readable dates like: "tomorrow" or "next week Tuesday". Cannot be used with Due At. Ignores time.

You can use human readable dates like: "tomorrow" or "next week Tuesday". Cannot be used with Due On. Considers time.

Can only be set if the Assignee is also set.