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?

If no (and by default) this trigger will only fire the first time a user opens an email.

When samples are pulled in the next step for this trigger, the GROUPINGS data will be static, dummy data ("Example Group Category 1"). Use the example Group values to setup your Zap, and the data should reflect appropriately when the Zap runs.

When samples are pulled in the next step for this trigger, the GROUPINGS data will be static, dummy data ("Example Group Category 1"). Use the example Group values to setup your Zap, and the data should reflect appropriately when the Zap runs.

Examples: Conference Lead, Influencer, or Donor (Tag length is limited to 100 characters).

The email address of the subscriber you want to subscribe to this audience. Please don't type an email address in this field, instead this should use a value from a previous step in your Zap. Learn more here.

If yes, a confirmation email will be sent to the address before they appear on the chosen audience.

If no, the Zap will skip/halt this step if the subscriber exists, otherwise overwrites data sent.

Determines what changes to make to the subscriber's groups/interests.

• Add Only The group(s) specified below will be added to the subscriber's existing groups/interests.
• Replace All All of the subscriber's existing groups will be cleared, and replaced with the groups selected below.
• Replace Matching Clears any existing group selections only for the groups specified below. Learn more here.

This should be a two letter language code (ISO639-1) See here for the list of language codes.

The tag(s) to which the subscriber will be added. Tags will be added to any existing tags on existing subscribers.

The email address of the person you want to remove from this tag. Note: the email address must already be subscribed to the audience, or this will fail.

The email address of the subscriber you want to add a note to. The email address must already be subscribed to the audience.

The content of the note. Note length is limited to 1,000 characters.

API docs for Mailchimp are located here https://mailchimp.com/developer/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 email address of the Subscriber you want to find.

Limit your search to this specific Audience.

Examples: Conference Lead, Influencer, or Donor (Tag length is limited to 100 characters).

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.

Select a link from your campaign to track. It's not currently possible to trigger on all link clicks for a campaign with a single Zap.

If no (and by default) this trigger will only fire the first time a user clicks a link in your campaign.

To prevent timeout errors, please ensure the list of customers for this store does not exceed 3000.

If specified, will only trigger on orders created in this store. Otherwise, will default to all orders in your account.

To prevent timeouts, please ensure the list of subscribers in the segment/tag does not exceed 3000.

Select the audience you want to send the campaign to.

Select which segment or tag you want to send the campaign to. If no segment/tag is selected, the campaign will be sent to the entire audience selected above.

This snippet will appear in the inbox after the subject line.

Supports *|MERGETAGS|* for recipient name, such as *|FNAME|*, *|LNAME|*, *|FNAME|* *|LNAME|*, etc.

Select either a template or provide HTML email content, you cannot provide both. If both fields are left blank, the campaign draft will have no content.

Select either a template or provide HTML email content, you cannot provide both. If both fields are left blank, the campaign draft will have no content.

The email address of the subscriber for the custom event. The email address must already be subscribed to the audience.

Must be 2-30 characters in length. Note: Letters, numbers, underscores, hyphens, and any spaces between are considered valid characters. Any invalid characters will be ignored.

Additional properties for this event (e.g. "User Type: Premium", "Preferred Communication: Email", etc). Note: Letters, numbers, underscores, hyphens, and any spaces between are considered valid characters. Any invalid characters in the first column only will be ignored.

The email address of the subscriber you want to unsubscribe from this audience.

Completely delete this contact from MailChimp? (No: just unsubscribe them)