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.

Triggers only on events containing the search term. Note: Search operators such as AND or OR do not work here. If you search for more than one word (e.g. apple banana) we will only find events with both apple AND banana in them, rather than events that contains apple OR banana.

When setting up, make sure this calendar has at least one event updated in the last 3 hours.

Do you want us to trigger on each instance of a recurring event if the series is updated?

Triggers only on events containing the search term. Note: Search operators such as AND or OR do not work here. If you search for more than one word (e.g. apple banana) we will only find events with both apple AND banana in them, rather than events that contains apple OR banana.

The title of the calendar.

Note: You must be able to edit the selected calendar from the Google Calendar account you connected. See this help doc for more information.

Summary of the new event

Description of the new event

Location of the new event

If "Yes," automatically creates a video meeting link for the event.

Date and time of when this event starts. See this help doc for more information.

Date and time of when this event ends.

Select a frequency to make this event repeating.

The event will repeat only until this date, if set.

Limit the number of times this event repeats.

What color will be assigned to this event on your calendar? Note: you can only select a color from the list of event colors provided from your calendar. This setting will only affect your calendar, not attendees' calendars. See this help doc for more information.

This email address will be invited to attend the event.

Use your calendar's default reminders, or set specific below (can be empty).

To use these you have to set "Use Default Reminders?" to "no".

Set the number of minutes before the event, to send reminders (max is 40320: 4 weeks in minutes).

Note: You must be able to edit the selected calendar from the Google Calendar account you connected. See this help doc for more information.

Event you want to update

Summary of the new event

Description of the new event

Location of the new event

Date and time of when this event starts. See this help doc for more information.

Date and time of when this event ends.

Select a frequency to make this event repeating.

The event will repeat only until this date, if set.

Limit the number of times this event repeats.

What color will this event show up as on the calendar? Note: you can only select a color from the provided list of event colors from your calendar. See this help doc for more information.

This email address will be invited to attend the event. Note that if you provide email addresses here, they will replace all the existing attendees on the event.

Use your calendar's default reminders, or set specific below (can be empty).

To use these you have to set "Use Default Reminders?" to "no". Note these will replace all existing reminders, if set.

Set the number of minutes before the event, to send reminders (max is 40320: 4 weeks in minutes).

API docs for Google Calendar are located here https://developers.google.com/calendar/api/v3/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.

Note: You must be able to edit the selected calendar from the Google Calendar account you connected. See this help doc for more information.

Will search across the event name and description. Does not include canceled events. If there are multiple matches, the earliest event will be returned. Note: Search operators such as AND or OR do not work here. If you search for more than one word (e.g. apple banana) we will only find events with both apple AND banana in them, rather than events that contains apple OR banana.

Limit matches by start time. Can be something like +1 month to only show events with a start time later than in a month from now.

Limit matches by end time. Can be something like +1 month to only show events with an end time later than in a month from now.

Summary of the new event

Description of the new event

Location of the new event

If "Yes," automatically creates a video meeting link for the event.

Date and time of when this event starts. See this help doc for more information.

Date and time of when this event ends.

Select a frequency to make this event repeating.

The event will repeat only until this date, if set.

Limit the number of times this event repeats.

What color will be assigned to this event on your calendar? Note: you can only select a color from the list of event colors provided from your calendar. This setting will only affect your calendar, not attendees' calendars. See this help doc for more information.

This email address will be invited to attend the event.

Use your calendar's default reminders, or set specific below (can be empty).

To use these you have to set "Use Default Reminders?" to "no".

Set the number of minutes before the event, to send reminders (max is 40320: 4 weeks in minutes).

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?

When testing, make sure there's at least one event cancelled event in the last 3 hours.

How far before the event do you want us to trigger? For starter and free plans, this should be 16 minutes or more. For higher plans, 6 minutes or more.

Triggers only on events containing the search term. Note: Search operators such as AND or OR do not work here. If you search for more than one word (e.g. apple banana) we will only find events with both apple AND banana in them, rather than events that contains apple OR banana.

Note: You must be able to edit the selected calendar from the Google Calendar account you connected. See this help doc for more information.

Event you want to update

Insert a single email address to invite one person (ann@gmail.com). Insert a comma-separated list of email addresses to invite multiple people (ann@gmail.com, maria@gmail.com)

Note: You must be able to edit the selected calendar from the Google Calendar account you connected. See this help doc for more information.

Specify which event you want to delete.

Send notifications about the deletion of the event.

Note: You must be able to edit the selected calendar from the Google Calendar account you connected. See this help doc for more information.

Plain text description of event. Google parses this string to create the event. eg. 'Dinner with Michael 7pm on 07/23/2012' or 'Meet Ash 03:30PM tomorrow'

Specify email addresses to invite to attend this event.

Determines which App Extensions will appear in the dropdown below.

Will search across the event name and description. Does not include canceled events. If there are multiple matches, the earliest event will be returned. Note: Search operators such as AND or OR do not work here. If you search for more than one word (e.g. apple banana) we will only find events with both apple AND banana in them, rather than events that contains apple OR banana.

Limit matches by start time. Can be something like +1 month to only show events with a start time later than in a month from now.

Limit matches by end time. Can be something like +1 month to only show events with an end time later than in a month from now.