Google Sheets + Kontent.ai

Create rows in Google Sheets spreadsheets for new Kontent Kentico variants

In projects of every size, it's important to know what happens to your content and when. This process will record a new entry in an audit log in Google Sheets containing the operation (create/delete/restore), the full ID of the variant, and the time. Having an automated audit log will bring peace of mind to your project managers, allowing them to review operations in the case of unexpected changes.

When this happens...
Variant Created, Deleted or Restored
Triggers when a language variant is created, deleted, or restored.
TriggerInstant
automatically do this!
Create Spreadsheet Row
Create a new row in a specific spreadsheet.
ActionWrite

Try this template

Free forever for core features
14 day trial for premium features & apps

Supported triggers and actions

What does this mean?

- Webhook name
  Enter a webhook name which will appear in the Kontent.ai admin UI.
- Events to watch
  Fires only when these events are performed on a taxonomy group. Leave blank for all events.
- Taxonomy group code name
  Fires only for the group of the give code name. Leave blank for all taxonomy groups.
Trigger
Instant
Try It
- Webhook name
  Enter a webhook name which will appear in the Kontent.ai admin UI.
- Events to watch
  Fires only when these events are performed on a language variant. Leave blank for all events.
- Language
  Fires only for variants of the given languages. Leave blank for all languages.
Trigger
Instant
Try It
- Content item
  Select the content item to update.
  For a custom value use compound content item id in a form of "[item id]/[language id]"
- Workflow stepsRequired
  Select a workflow step to which the content item should move.
  More about workflow in Kontent.ai ...
Action
Write
- LanguageRequired
- Search info
  Search by field
  You can search the item by a particular field value.
- Search valueRequired
  Value to match in the search field. The value must match exactly.
Action
Write
- Search info
  Search by value
  You can search for the asset based on several values.
- Search fieldRequired
  Select the field based on which the asset should be found.
- Search operatorRequired
  Select how the search value should be matched.
- Search valueRequired
  Value to match in the search field. The value must match exactly.
Action
Search

- Search info
  Search by value
  You can search for the language based on several values.
- Search fieldRequired
  Select the field based on which the language should be found.
- Search operatorRequired
  Select how the search value should be matched.
- Search valueRequired
  Value to match in the search field. The value must match exactly.
Action
Search
- LanguageRequired
- Content typeRequired
  Note: dynamic values from other steps cannot be used here
- Search info
  Search by field
  You can search the item by a particular field value.
- Search valueRequired
  Value to match in the search field. The value must match exactly.
- Content item nameRequired
  Name of the content item. Displays in content inventory. Shared by all language variants.
- External ID
  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 ...
- Elements
  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 ...
Action
Search or write

- No Team Drive
  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.
- SpreadsheetRequired
- WorksheetRequired
  You must have column headers
Trigger
Instant
Try It
- Drive
  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.
- SpreadsheetRequired
- WorksheetRequired
  You must have column headers
- Trigger Column
  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.
Trigger
Scheduled
Try It
- Drive
  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.
- SpreadsheetRequired
Trigger
Scheduled
Try It
- Drive
  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.
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
  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.
- Spreadsheet Containing the Worksheet to CopyRequired
- Worksheet to CopyRequired
- Copy To
  Which spreadsheet should the worksheet be copied to? If left blank, it will be copied to the spreadsheet containing the original worksheet.
Action
Write
- Drive
  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.
- SpreadsheetRequired
- TitleRequired
- Headers
- Overwrite?
  If a worksheet with the specified title exists, its content would be lost. Please, use with caution.
Action
Write
- Drive
  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.
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
  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.
- Background Color
  Choose from your current custom Theme Color in your Spreadhseet, or enter a color #rrggbb in hexadecimal format.
- Text Color
  Choose from your current custom Theme Color in your Spreadhseet, or enter a color #rrggbb in hexadecimal format.
- Text Bold
  True if the text is bold.
- Text Italic
  True if the text is italicized.
- Text Strikethrough
  True if the text is strikethrough.
Action
Write
- Drive
  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.
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
  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.
- SpreadsheetRequired
- WorksheetRequired
  You must have column headers. See here for more information.
- Lookup ColumnRequired
  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.
- Lookup ValueRequired
- Supporting Lookup Column
  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)
- Supporting Lookup Value
  An example value might be me@example.com or 555-5555
- Bottom-Up
  Search from bottom of the sheet?
- Row Count
  Number of rows to return. Max is 500.
Action
Search
- Drive
  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.
- SpreadsheetRequired
- WorksheetRequired
  You must have column headers. See here for more information.
- ColumnsRequired
  Let us know which columns to return. e.g. A:Z
- Row CountRequired
  Number of rows to return. Max is 500.
- First Row
  Number of the first row to return (1 is the header)
Action
Search
- Drive
  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.
- SpreadsheetRequired
- TitleRequired
  Value of the Worksheet Title to match exactly. Search is case-sensitive.
- Headers
- Overwrite?
  If a worksheet with the specified title exists, its content would be lost. Please, use with caution.
Action
Search or write

- Webhook name
  Enter a webhook name which will appear in the Kontent.ai admin UI.
- Events to watch
  Fires only when these events are performed on a language. Leave blank for all events.
- Language
  Fires only for variants of the given languages. Leave blank for all languages.
Trigger
Instant
Try It
- Webhook name
  Enter a webhook name which will appear in the Kontent.ai admin UI.
- Workflow stepsRequired
  Fires for the selected workflow steps.
- Language
  Fires only for variants of the given languages. Leave blank for all languages.
- Content type for samples
  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.
Trigger
Instant
Try It
- LanguageRequired
- Content typeRequired
  Note: dynamic values from other steps cannot be used here
- Content item nameRequired
  Name of the content item. Displays in content inventory. Shared by all language variants.
- External ID
  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 ...
- Elements
  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 ...
Action
Write
- LanguageRequired
- Content typeRequired
  Note: dynamic values from other steps cannot be used here
- Search info
  Search by field
  You can search the item by a particular field value.
- Search valueRequired
  Value to match in the search field. The value must match exactly.
- Elements
  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 ...
Action
Write
- LanguageRequired
- Content typeRequired
  Note: dynamic values from other steps cannot be used here
- Search info
  Search by field
  You can search the item by a particular field value.
- Search valueRequired
  Value to match in the search field. The value must match exactly.
Action
Search
- Step nameRequired
  Name of the workflow step, the search is case insensitive. If an exact match is not found, searches as a substring.
Action
Search
- Drive
  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.
- SpreadsheetRequired
- WorksheetRequired
  You must have column headers
Trigger
Scheduled
Try It
- Drive
  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.
Trigger
Scheduled
Try It
- No Team Drive
  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.
- SpreadsheetRequired
- WorksheetRequired
  You must have column headers
- Trigger Column
  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.
Trigger
Instant
Try It
- Drive
  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.
- SpreadsheetRequired
- WorksheetRequired
- Column NameRequired
- Index
  The column position (zero-based) to insert. If not set, append to the right by default.
Action
Write
- Drive
  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.
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- TitleRequired
- Spreadsheet to Copy
  Create a duplicate of an existing spreadsheet.
- Headers
  These Headers are ignored if a "Spreadsheet to Copy" is selected.
Action
Write
- Drive
  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.
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
  Use a search step before this to get the row to delete.
Action
Write
- Drive
  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.
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
  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.
Action
Write
- Api Docs Info
  API docs for Google Sheets are located here https://developers.google.com/sheets/api/reference/rest
- HTTP MethodRequired
- URLRequired
  Requests can only be made to domains associated by this application.
- Query String Parameters
  These params will be URL-encoded and appended to the URL when making the request.
- Headers
  Authentication headers are included automatically
- Additional Request Headers
  Zapier will apply these optional headers and values to the request in addition to any headers created as part of the authentication mechanism.
- Body
  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.
Action
Write
- Drive
  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.
- SpreadsheetRequired
- TitleRequired
  Value of the Worksheet Title to match exactly. Search is case-sensitive.
Action
Search
- Drive
  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.
- SpreadsheetRequired
- WorksheetRequired
  You must have column headers. See here for more information.
- Lookup ColumnRequired
  Specify the column we should search for cells which match the Lookup Value.
- Lookup ValueRequired
- Supporting Lookup Column
  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)
- Supporting Lookup Value
  An example value might be me@example.com or 555-5555
- Bottom-Up
  Search from bottom of the sheet? In other words, pick the most recent match?
Action
Search
- Drive
  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.
- SpreadsheetRequired
- WorksheetRequired
  You must have column headers. See here for more information.
- Lookup ColumnRequired
  Specify the column we should search for cells which match the Lookup Value.
- Lookup ValueRequired
- Supporting Lookup Column
  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)
- Supporting Lookup Value
  An example value might be me@example.com or 555-5555
- Bottom-Up
  Search from bottom of the sheet? In other words, pick the most recent match?
Action
Search or write

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Learn more

Related categories

Similar apps

Zoho Creator

App Builder, Zoho

Smartsheet

Spreadsheets

Quip

Documents

About Kontent.ai

Kontent.ai is a Content-as-a-Service platform that gives you all the headless CMS benefits while empowering marketers at the same time.

Related categories

Developer Tools

Get started for free

You can't add more hours to the day. Zapier is the next best thing.

By signing up, you agree to Zapier's terms of service and privacy policy.

Google Sheets + Kontent.ai

Create rows in Google Sheets spreadsheets for new Kontent Kentico variants

Taxonomy Group Changed

Webhook name

Events to watch

Taxonomy group code name

Variant Created, Deleted or Restored

Webhook name

Events to watch

Language

Change Language Variant Workflow Step

Content item

Workflow stepsRequired

Delete Language Variant

LanguageRequired

Search info

Search by field

Search valueRequired

Find Asset

Search info

Search by value

Search fieldRequired

Search operatorRequired

Search valueRequired

Find Language

Search info

Search by value

Search fieldRequired

Search operatorRequired

Search valueRequired

Find or create content item

LanguageRequired

Content typeRequired

Search info

Search by field

Search valueRequired

Content item nameRequired

External ID

Elements

Content item variant elements

New Spreadsheet Row

No Team Drive

SpreadsheetRequired

WorksheetRequired

New or Updated Spreadsheet Row (Team Drive)

Drive

SpreadsheetRequired

WorksheetRequired

Trigger Column

New Worksheet

Drive

SpreadsheetRequired

Create Spreadsheet Row

Drive

SpreadsheetRequired

WorksheetRequired

Copy Worksheet

Drive

Spreadsheet Containing the Worksheet to CopyRequired

Worksheet to CopyRequired

Copy To

Create Worksheet

Drive

SpreadsheetRequired

TitleRequired

Headers

Overwrite?

Format Spreadsheet Row

Drive

SpreadsheetRequired

WorksheetRequired

RowRequired

Background Color

Text Color

Text Bold

Text Italic

Text Strikethrough

Update Spreadsheet Row(s)

Drive

SpreadsheetRequired