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.

If no, only messages sent by users will trigger the Zap. If yes, messages sent by users and slackbots will trigger the Zap.

Warning: Slackbots don't have profiles. If yes, don't depend on user profile information being present. Also, avoid Zap loops where Zaps trigger and post slackbot messages to the same channel!

Only channels you are a member of will appear in this list. If you can't find your channel, click the Load More button or switch to the Custom tab and enter the channel's ID. Once live, the trigger will work even if you are not a member of the channel. Note: This trigger only supports attachment information for messages generated by bots. If you need to retrieve attachment information from non-bots, see this help document.

If no, only messages sent by users will trigger the Zap. If yes, messages sent by users and slackbots will trigger the Zap.

Warning: Slackbots don't have profiles. If yes, don't depend on user profile information being present. Also, avoid Zap loops where Zaps trigger and post slackbot messages to the same channel!

Only channels you are a member of will appear in this list. If you can't find your channel, click the Load More button or switch to the Custom tab and enter the channel's ID. Once live, the trigger will work even if you are not a member of the channel.

Trigger on files created by a single user.

Trigger when files are shared with you. Please note that this will trigger on created files as well.

Only channels you are a member of will appear in this list. If you can't find your channel, click the Load More button or switch to the Custom tab and enter the channel's ID. Once live, the trigger will work even if you are not a member of the channel.

If no, only messages sent by users will trigger the Zap. If yes, messages sent by users and slackbots will trigger the Zap.

Warning: Slackbots don't have profiles. If yes, don't depend on user profile information being present. Also, avoid Zap loops where Zaps trigger and post slackbot messages to the same channel!

Only triggers when this reaction is added to a message. Use the dropdown to select one of your team's custom emoji or select Use a Custom Value and enter the name of a standard emoji. Use this cheat sheet for reference and be sure not to include the colons. Note that you cannot use an emoji's alias in this field.

Only triggers on reactions added on messages in this public channel. Only channels you are a member of will appear in this list. If you can't find your channel, click the Load More button or switch to the Custom tab and enter the channel's ID. Once live, the trigger will work even if you are not a member of the channel.

Only triggers on reactions added by this user.

Toggle to send to multiple users.

Specify text of the message to send. Check out the formatting help doc for advanced options.

If you choose no, this message will appear to come from you. Direct messages are always sent by bots.

Specify the bot name which appears as a bold username above the message inside Slack. Defaults to Zapier. When using Schedule At, this field will be ignored by slack.

Either an image url or an emoji available to your team (surrounded by :). For example, https://site.com/icon_256.png or :robot_face:. When using Schedule At, this field will be ignored by slack.

If you choose yes, a link to this Zap will be added to the end of the message, making it easy for you and your team to edit the Zap with one click.

If specified, this will upload the given image URL to Slack and attach it to the message separately.

Should Slack try to automatically expand links in this message? For example: turn a YouTube link into a playable widget.

If no, any usernames and channels mentioned won't be linked (or mentioned). Also affects @channel and @group. Unfortunately, @here notifications cannot be sent by Zapier.

Schedule the message to be posted later. Cannot be more than 120 days in the future. If you do schedule a message, rather than post it immediately, this Zap step will not return a ts or permalink field. This option does not support Bot Name and Bot Icon customization and will default to Zapier as bot name and icon.

Only channels you are a member of will appear in this list. If you can't find your channel, click the Load More button or switch to the Custom tab and enter the channel's ID. Once live, the trigger will work even if you are not a member of the channel.

Specify text of the message to send. Check out the formatting help doc for advanced options.

If you choose no, this message will appear to come from you. Direct messages are always sent by bots.

Specify the bot name which appears as a bold username above the message inside Slack. Defaults to Zapier. When using Schedule At, this field will be ignored by slack.

Either an image url or an emoji available to your team (surrounded by :). For example, https://site.com/icon_256.png or :robot_face:. When using Schedule At, this field will be ignored by slack.

If you choose yes, a link to this Zap will be added to the end of the message, making it easy for you and your team to edit the Zap with one click.

If specified, this will upload the given image URL to Slack and attach it to the message separately.

Should Slack try to automatically expand links in this message? For example: turn a YouTube link into a playable widget.

If no, any usernames and channels mentioned won't be linked (or mentioned). Also affects @channel and @group. Unfortunately, @here notifications cannot be sent by Zapier.

Schedule the message to be posted later. Cannot be more than 120 days in the future. If you do schedule a message, rather than post it immediately, this Zap step will not return a ts or permalink field. This option does not support Bot Name and Bot Icon customization and will default to Zapier as bot name and icon.

Include a file to send along with your message. NOTE: Bot names/icons cannot be customized when sending a File.

If you want this to be part of a thread, you'll need the timestamp (Ts) of the parent message. For example: 1345232312616.1231232.

If you get the message from a trigger, select "use a custom value" from the dropdown and connect accordingly by selecting the Ts field.

Otherwise, add a search step and fetch the message you want.

If true, posts in the thread and channel. See here for more info. Ignored unless the message is part of a thread.

Fields left blank will be ignored.

Fields left blank will be ignored.

Fields left blank will be ignored.

Changing a user's email address will send an email to both the old and new addresses, and also post a slackbot to the user informing them of the change.

Update selected values on this user's profile. This argument may only be specified by team admins on paid teams. Defaults to your status, when blank.

Determines which App Extensions will appear in the dropdown below.

Search query to use for finding matching messages. See the Slack Search Documentation for more information on constructing a query.

Sort messages by their match strength or by their date. Default is score.

Sort matching messages in ascending or descending order. Default is descending.

Search is case-insensitive

For most responses, we prettify the result we get from Slack. If we're missing a field you're expecting, set this to true

The leading @ is optional

For most responses, we prettify the result we get from Slack. If we're missing a field you're expecting, set this to true

Customer's email.

Customer's password.

Customer email address.

Payment status.

Fulfilment status.

Payment Method.

Order total cost.

Order tax $.

Order comments.

Shipping rate.

Shipping Person Name.

Shipping Method Name.

Shipping Person Company Name.

Shipping Person Street.

Shipping Person City.

Shipping Person Country Code.

Shipping Person Postal Code.

Shipping Person State or Province Code.

Shipping Person Phone.

Full name.

Company name.

Address.

Billing Person City.

Two-letter country code.

Postal/ZIP code.

State code, e.g. NY.

Phone number.

Order subtotal. Includes the sum of all products’ cost in the order (item’s price x quantity)

Payment processor name

Discount applied to order using a coupon

URL of the page when order was placed (without hash (#) part)

Sum of discounts based on subtotal. Is included into the "discount" field

Unique customer internal ID (if the order is placed by a registered user)

Determines if the order is hidden (removed from the list). Applies to unfinished orders only.

Sum of discounts based on customer group. Is included into the "discount" field

The sum of discount based on subtotal AND customer group. Is included into the "discount" field

The sum of all applied discounts except for the coupon discount.

URL that the customer came to the store from

The date/time of order placement, e.g 2014-06-06 18:57:19 +0000

The name of group (membership) the customer belongs to

Shipping tracking code

Message from the payment processor if any. It is present and visible in order details only if order status is not paid. When order becomes paid, "paymentMessage" is cleared

Transaction ID / invoice number of the order in the payment system (e.g. PayPal transaction ID)

Private note about the order from store owner. Ignored when creating orders with public token

Order pickup time in the store date format, e.g.: "2017-10-17 05:00:00 +0000"

"true" if customer has accepted email marketing and you can use their email for promotions. If value is "false", you can’t use this email for promotions

"true" if no email notifications are sent to customer. If "false" or empty, then email notifications are sent to customer according to store mail notification settings. This field does not influence admin email notifications

Set "true" if order is fulfilled in an external system; Ecwid will hide fulfillment status change feature and ability to set tracking number within Ecwid Control Panel in order details. Set "false" to manage order fulfillment within Ecwid Control Panel

Corresponding order number in an external system where order is fulfilled. Use together with the "externalFulfillment" field

Amount of product items in stock.

Set as "true" to make Unlimited stock for the product and to not track product inventory.

Base product price.

Product’s sale price displayed strike-out in the customer frontend

Product weight in the units defined in store settings. Leave empty for intangible products

"true" to make product enabled, "false" otherwise. Disabled products are not displayed in the storefront.

Product description in HTML

Search term. Ecwid will look for this term in: order number, external transaction id, vendor order number, customer billing and shipping address, customer email, shipping tracking code, item SKUs, item names, item selected options, affiliate Id, private admin notes. If your keywords contain special characters, it may make sense to URL encode them before making a request

Order number(s) separated by a comma. If this field is not empty, other filters are ignored

Order number with prefix/suffix defined by admin

Customer email used to place the order

Customer ID used to place the order

"true" if customer has accepted email marketing. "false" otherwise

Filter order results by "refererId" field in order details

Comma-separated list of productIds. Use it to find orders with specific products by their IDs

The code of coupon applied to order

Minimum product price

Maximum product price

Order placement date/time (lower bound). Supported formats: UNIX timestamp

Order placement date/time (upper bound). Supported formats: UNIX timestamp

Order last update date/time (lower bound). Supported formats: UNIX timestamp

Order last update date/time (upper bound). Supported formats: UNIX timestamp

Payment method used by customer

Shipping method chosen by customer

Customer search term. Used to search in customer name and email only. If your keywords contain special characters, it may make sense to URL encode them before making a request

Customer's email.

Customer register date/time (lower bound). Supported formats: UNIX timestamp. Examples: 1447804800

Customer register date/time (upper bound). Supported formats: UNIX timestamp

Customer last update date/time (lower bound). Supported formats: UNIX timestamp

Customer last update date/time (upper bound). Supported formats: UNIX timestamp

Customer's password.

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?

Choose yes to trigger when someone creates a new name for an existing emoji.

Linked mentions of this user will trigger the zap. Make sure to specify a value for one or both of username or a highlight word. Specifying both a username and a highlight word means that both the linked username and word need to be included in a message to trigger the zap.

Mentions of this word will trigger the zap. Case insensitive. Make sure to specify a value for one or both of username or a highlight word. Specifying both a username and a highlight word means that both the linked username and word need to be included in a message to trigger the zap.

If no, only messages sent by users will trigger the Zap. If yes, messages sent by users and slackbots will trigger the Zap.

Warning: Slackbots don't have profiles. If yes, don't depend on user profile information being present. Also, avoid Zap loops where Zaps trigger and post slackbot messages to the same channel!

The actual reminder text that should be sent to yourself or a user. To include URLs, Slack uses this syntax.

Slack parses natural language like "in 15 minutes" or "every Thursday". Times are relative to when the Zap actually runs.

Pick a user to remind. If you pick no one, you will be reminded.

Only channels you are a member of will appear in this list. If you can't find your channel, click the Load More button or switch to the Custom tab and enter the channel's ID. Once live, the trigger will work even if you are not a member of the channel.

Specify text of the message to send. Check out the formatting help doc for advanced options.

If you choose no, this message will appear to come from you. Direct messages are always sent by bots.

Specify the bot name which appears as a bold username above the message inside Slack. Defaults to Zapier. When using Schedule At, this field will be ignored by slack.

Either an image url or an emoji available to your team (surrounded by :). For example, https://site.com/icon_256.png or :robot_face:. When using Schedule At, this field will be ignored by slack.

If you choose yes, a link to this Zap will be added to the end of the message, making it easy for you and your team to edit the Zap with one click.

If specified, this will upload the given image URL to Slack and attach it to the message separately.

Should Slack try to automatically expand links in this message? For example: turn a YouTube link into a playable widget.

If no, any usernames and channels mentioned won't be linked (or mentioned). Also affects @channel and @group. Unfortunately, @here notifications cannot be sent by Zapier.

Schedule the message to be posted later. Cannot be more than 120 days in the future. If you do schedule a message, rather than post it immediately, this Zap step will not return a ts or permalink field. This option does not support Bot Name and Bot Icon customization and will default to Zapier as bot name and icon.

Include a file to send along with your message. NOTE: Bot names/icons cannot be customized when sending a File.

If you want this to be part of a thread, you'll need the timestamp (Ts) of the parent message. For example: 1345232312616.1231232.

If you get the message from a trigger, select "use a custom value" from the dropdown and connect accordingly by selecting the Ts field.

Otherwise, add a search step and fetch the message you want.

If true, posts in the thread and channel. See here for more info. Ignored unless the message is part of a thread.

Name for the channel to be created. Channel names are normalized by converting to lowercase, replacing any non-allowed characters with hyphens or underscore, and truncating to 80 characters.

Slack will auto-link @names and #channels where applicable.

Leave empty to clear.

Use any emoji that's available in your Slack team, with leading and trailing :.

If emoji is blank when text isn't, :speech_balloon: is used by default. If both text and emoji are empty, your status will be cleared.

Provide a specific date & time for this status to expire. Statuses will not expire by default.

You can also specify a duration for this status by entering in a value like in 60 minutes, for example. Check out other ways you can use this field here.

Note: Zapier's Slack app supports a limited set of OAuth scopes/permissions, thus many of Slack's API endpoints aren't currently feasible.

API docs for Slack are located here https://api.slack.com/methods

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.

Search is case-insensitive

For most responses, we prettify the result we get from Slack. If we're missing a field you're expecting, set this to true

We search the normalized name, so don't worry about accents

For most responses, we prettify the result we get from Slack. If we're missing a field you're expecting, set this to true

Filter when payment status is...

What fulfillment status will trigger this Zap?

Filter when payment status is...

What fulfillment status will trigger this Zap?

Filter when payment status is...

What fulfillment status will trigger this Zap?

Coupon title.

Unique coupon code, length limit is 128 characters.

Discount amount. 0 is default.

Discount type: absolute, percent, on shipping, absolute and on shipping, percent and on shipping. Default is absolute.

Discount coupon state: ACTIVE, PAUSED, EXPIRED or USEDUP. Default is ACTIVE.

The date of coupon launch. 2014-06-06 08:00:00 +0400.

Coupon expliration date, e.g. 2014-06-06 08:00:00 +0400.

The minimum order subtotal the coupon applies to.

Number of uses limitation: UNLIMITED, ONCEPERCUSTOMER, SINGLE. The default is UNLIMITED.

Application limit for discount coupons.

Number of uses.

Deprecated. Use applicationLimit instead. Coupon usage limitation flag identifying whether the coupon works for all customers or only repeat customers

The list of product IDs the coupon can be applied to

The list of category IDs the coupon can be applied to

Product SKU.

Amount of product items in stock.

Product weight in the units defined in store settings.

True to make product enabled, false otherwise. Disabled products are not displayed in the store front.

Set as "true" to make Unlimited stock for the product and to not track product inventory.

Product’s sale price displayed strike-out in the customer frontend

"true" if product requires shipping, "false" otherwise

The minimum 'warning’ amount of the product items in stock, if set. When the product quantity reaches this level, the store administrator gets an email notification.

Customer search term. Used to search in customer name and email only. If your keywords contain special characters, it may make sense to URL encode them before making a request

Customer register date/time (lower bound). Supported formats: UNIX timestamp. Examples: 1447804800

Customer register date/time (upper bound). Supported formats: UNIX timestamp

Customer last update date/time (lower bound). Supported formats: UNIX timestamp

Customer last update date/time (upper bound). Supported formats: UNIX timestamp

Search term. Use quotes to search for exact match. Ecwid searches products over multiple fields: title, description, SKU, product options, category name, gallery image descriptions, attribute values (except for hidden attributes).

Product or variation SKU. Ecwid will return details of a product containing that SKU, if SKU value is an exact match. If SKU is specified, other search parameters are ignored, except for product ID.

Internal Ecwid product ID or multiple productIds separated by a comma. If this field is specified, other search parameters are ignored.

"true" to get only enabled products, "false" to get only disabled products

Search term. Use quotes to search for exact match. Ecwid searches products over multiple fields: title, description, SKU, product options, category name, gallery image descriptions, attribute values (except for hidden attributes).

Product SKU.

Internal Ecwid product ID or multiple productIds separated by a comma. If this field is specified, other search parameters are ignored.

True to make product enabled, false otherwise. Disabled products are not displayed in the store front.

Amount of product items in stock.

Product weight in the units defined in store settings.

Set as "true" to make Unlimited stock for the product and to not track product inventory.

Product’s sale price displayed strike-out in the customer frontend

"true" if product requires shipping, "false" otherwise

The minimum 'warning’ amount of the product items in stock, if set. When the product quantity reaches this level, the store administrator gets an email notification.