Supports HTML.

Supports HTML.

Defaults to yes.

You can use positive or negative numbers, like 4 or -3. The number you enter will be added to or subtracted from the current quantity.

You can use positive or negative numbers, like 4 or -3. The quantity will be set to the number you enter.

The customer to update.

Setting any tags here will replace all existing tags for this customer.

If "Yes", taxes won't be applied at checkout for this customer.

E.g. "KY" or "MI"

Country is required if the other address fields are filled.

Defaults to "no".

If "Yes", taxes won't be applied at checkout for this customer.

Product to add this variant to.

What should Shopify do when inventory is exhausted: deny sales or continue selling?

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.

You must have column headers

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

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.

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.

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.

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.

Which spreadsheet should the worksheet be copied to? If left blank, it will be copied to the spreadsheet containing the original worksheet.

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.

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.

E.g. "KY" or "MI"

Country is required if the other address fields are filled.

Defaults to "no".

If "Yes", taxes won't be applied at checkout for this customer.

An email for your customer.

Only used if you select a product variant below.

Requires a Product chosen above. If you choose a variant, you can still fill in the Product Title and the Product Price to override the regular values.

To use this, please also enter a value in the "Discount - Amount" field.

The "Discount - Type" field determines how this value is used. For a fixed amount, enter 5.00 to discount $5.00. For a percentage, enter .25 to discount 25%.

Defaults to "Custom discount". For the discount to be applied, you must also enter values for Discount Type and Amount.

Extra metadata about the order, defined as key/value pairs. For example, Favorite color: Blue.

Should an order confirmation be sent to the customer?

Should a fulfillment confirmation be sent to the customer?

How do you want your inventory to update with this order? Default is "Bypass".

Where the order originated.

Can use html elements.

Comma Separated list of tags. Will replace existing.

Creates a single product variation in Shopify and assigns the price to this variation.

URL of one or more images to use for this product.

Defaults to yes.

Defaults to yes.

Product to choose the variant for.

Can use html elements.

Comma Separated list of tags.

The date and time when the product was published. This must be a date in the past. Defaults to the current date if left blank.

Creates a single product variation in Shopify and assigns the price to this variation.

What should Shopify do when inventory is exhausted: deny sales or continue selling?

URL of an image to use for this new product.

Defaults to yes.

Defaults to yes.

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

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 use this trigger with a Sheet that resides in your Google Team Drive, you have to workaround the issue using these steps.

You must have column headers

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.

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.

The column position (zero-based) to insert. If not set, append to the right by default.

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.