Valid email address of recipient.

Valid email address of the sender. (must be associated with your SendGrid account)

The name added to the From email field; your name or company name.

Add a Reply-To field to your email message.

Subject of the email.

A plain-text body of the email. (This or the HTML version is required.)

HTML body of the email. (At least one of the text or HTML parameters must be provided.)

WARNING: Looping by Zapier is an advanced feature currently in Beta. Learn how to create loops here and understand limitations here.

A counter value called 'loop_iteration' will be added to each iteration of the loop. Does not affect the data to loop through. Defaults to '1'.

Set the iteration number to end the loop at here. Defaults to '1'. Cannot be less than Loop iteration counter start.

Set the amount to increment the counter for each iteration of the loop. Defaults to '1'. Cannot be '0' or negative. Must be an whole number.

Set this value to limit the number of loops performed. Data in iterations past the limit will be ignored. A number higher than 500 will be reduced to 500. A number less than 1 will halt this step.

Query results must have a unique id field so we can deduplicate records properly! Otherwise we will make a best guess. You must also include desired ordering and limiting in the query.

Note: This query must run in less than 30 seconds and it is recommended that you return no more than 5,000 rows

Usually something auto-incremented like id. Must be unique. Column names that contain a space must be enclosed within brackets [ ].

Usually something like date_updated or last_modified. This should ideally be a datetime column that is set to the current datetime whenever a row is updated.

Trigger on changes to cells in this column only. Leave blank if you want to trigger on changes to cells in all columns.

WARNING: Looping by Zapier is an advanced feature currently in Beta. Learn how to create loops here and understand limitations here.

Type loop value name(s) in the field(s) on the left. Map Line Item value(s) to loop through on the right.

Remove whitespace surrounding each individual value? Defaults to 'True'.

A counter value called 'loop_iteration' will be added to each iteration of the loop. Does not affect the data to loop through. Defaults to '1'.

Set this value to limit the number of loops performed. Data in iterations past the limit will be ignored. A number higher than 500 will be reduced to 500. A number less than 1 will halt this step.

WARNING: Looping by Zapier is an advanced feature currently in Beta. Learn how to create loops here and understand limitations here.

Type loop value name(s) in the field(s) on the left. Map and/or type values separated by a delimiter (ex: ',') on the right.

Supports Special Characters. Defaults to ','

Remove whitespace surrounding each individual value? Defaults to 'True'.

A counter value called 'loop_iteration' will be added to each iteration of the loop. Does not affect the data to loop through. Defaults to '1'.

Set this value to limit the number of loops performed. Data in iterations past the limit will be ignored. A number higher than 500 will be reduced to 500. A number less than 1 will halt this step.

We expect at least one unique (and usually autoincrement) primary key column so we can deduplicate records properly! Otherwise we will make a best guess on a random column to use to deduplicate.

Highly recommended! Usually you want the results to be most recent first so we can skim off only new results, so choose something like date_created or your autoincrement id. Column names that contain a space must be enclosed within brackets [ ].

We default to what the primary key is on the table as the unique key to deduplicate on. If you prefer another field, select it here.