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?

Enter a webhook name which will appear in the Kontent.ai admin UI.

Fires only when these events are performed on a language. Leave blank for all events.

Fires only for variants of the given languages. Leave blank for all languages.

Enter a webhook name which will appear in the Kontent.ai admin UI.

Fires for the selected workflow steps.

Fires only for variants of the given languages. Leave blank for all languages.

If you select a content type, the samples from this trigger will be of that type. If empty, the first found items will be provided.

Note: dynamic values from other steps cannot be used here

Name of the content item. Displays in content inventory. Shared by all language variants.

Any unique identifier for the item in the external system. Can be used to link the content item for future updates. Read more about external ID ...

Content item variant elements

The following inputs represent elements of a chosen content type as defined in Kontent.ai. Element data is stored per language version.

Read more about elements ...

Note: dynamic values from other steps cannot be used here

Search by field

You can search the item by a particular field value.

Value to match in the search field. The value must match exactly.

Content item variant elements

The following inputs represent elements of a chosen content type as defined in Kontent.ai. Element data is stored per language version.

Read more about elements ...

Note: dynamic values from other steps cannot be used here

Search by field

You can search the item by a particular field value.

Value to match in the search field. The value must match exactly.

Name of the workflow step, the search is case insensitive. If an exact match is not found, searches as a substring.

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.

Enter a webhook name which will appear in the Kontent.ai admin UI.

Fires only when these events are performed on a taxonomy group. Leave blank for all events.

Fires only for the group of the give code name. Leave blank for all taxonomy groups.

Enter a webhook name which will appear in the Kontent.ai admin UI.

Fires only when these events are performed on a language variant. Leave blank for all events.

Fires only for variants of the given languages. Leave blank for all languages.

Select the content item to update.

For a custom value use compound content item id in a form of "[item id]/[language id]"

Select a workflow step to which the content item should move.

More about workflow in Kontent.ai ...

Search by field

You can search the item by a particular field value.

Value to match in the search field. The value must match exactly.

Search by value

You can search for the asset based on several values.

Select the field based on which the asset should be found.

Select how the search value should be matched.

Value to match in the search field. The value must match exactly.

Search by value

You can search for the language based on several values.

Select the field based on which the language should be found.

Select how the search value should be matched.

Value to match in the search field. The value must match exactly.

Note: dynamic values from other steps cannot be used here

Search by field

You can search the item by a particular field value.

Value to match in the search field. The value must match exactly.

Name of the content item. Displays in content inventory. Shared by all language variants.

Any unique identifier for the item in the external system. Can be used to link the content item for future updates. Read more about external ID ...

Content item variant elements

The following inputs represent elements of a chosen content type as defined in Kontent.ai. Element data is stored per language version.

Read more about elements ...