The zap will trigger every time this task is completed.

Select an Automated task to add an instance to sites.

Select a site for the task instance to be added.

Update the Description and use Markdown for formatting.

Choose a specific date or use Zapier modifiers to set a future due date.

Trail is a checklist and compliance app to guide hospitality teams through their day

Trail

Customize the private email address associated with your mailbox. Be sure to use lowercase and numbers only. Just forward emails to this address to trigger this Zap. *Want to receive to your own email address? Try Mailgun, IMAP, Mandrill, or Gmail instead.*

In order to trigger when emails are opened, this must be paired with a separate Zap using the **Send Outbound Email** action, with the **Enable Read Receipts?** field set to `True`.

To test with a live email, send an email to yourself using your **Send Outbound Email** action (with read receipts enabled) and open it, then test this trigger immediately for samples. If you don't need to test with live data, click Skip Test to use static test data.

**Trial or Free Zapier plan:**

 - Emails sent during [testing](https://help.zapier.com/hc/en-us/articles/18811411817741-Test-Zap-steps "https://help.zapier.com/hc/en-us/articles/18811411817741-Test-Zap-steps") are sent to the [Zapier account email address](https://help.zapier.com/hc/en-us/articles/8496274581517-Change-your-Zapier-account-email-address "https://help.zapier.com/hc/en-us/articles/8496274581517-Change-your-Zapier-account-email-address"). Once published, emails go to the intended recipients (To, CC, BCC).
 - You can send a maximum of 5 emails per account per day.

**Paid Zapier plan:**

 - You can send a maximum of 10 emails per account per hour.

Can be a comma separated list of emails. Limited to 5.

You can place HTML in here and we will send it as is. If this is plain text, we will try to convert it to some very basic HTML for greater client compatibility.

A file object to be attached to the email. Plain text content will converted into a txt file and attached. Please note, if the file is over ~10mb or so, you should explore using other email sending techniques (like Gmail or SMTP).

This will be your "display name" when sending. *Want to send from your own email address? Try Mailgun, IMAP, Mandrill or Gmail apps instead.*

Specify a reply address other than your own.

Set this to "yes" if your emails are received without line breaks or spacing.

Want to be notified when this email is opened? Set this to to `True` and set up a Zap using the `New Read Receipt` trigger.

Send and receive email via a custom Zapier email address at "zapiermail.com". This is great for triggering off of emails and sending custom emails. (Max of 10 email sends per hour.)

Have direct access to your own email servers? Check out our IMAP and SMTP services!

Email by Zapier

Select the Google Drive location of your spreadsheet. Choose between My Drive or a Shared Drive; the former is the default.

Worksheets must have column headers. Learn more about [spreadsheet formatting](https://help.zapier.com/hc/en-us/articles/8496276985101-Work-with-Google-Sheets-in-Zaps).

If you are using a spreadsheet in a Shared Drive, use the "New or Spreadsheet Row (Team Drive)" trigger instead. [Learn more](https://help.zapier.com/hc/en-us/articles/21613796877325-Google-Sheets-Zap-is-triggering-on-rows-in-a-sheet-on-another-Team-Drive#h_01HFYJ2F77WX1QNSGFY88AQGSK)

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.

If you are using a spreadsheet in a Shared Drive, use the “New or Update Spreadsheet Row (Team Drive)” trigger instead. [Learn more](https://help.zapier.com/hc/en-us/articles/21613796877325-Google-Sheets-Zap-is-triggering-on-rows-in-a-sheet-on-another-Team-Drive#h_01HFYJ2F77WX1QNSGFY88AQGSK)

Worksheets must have headers. Learn more about [spreadsheet formatting](https://help.zapier.com/hc/en-us/articles/8496276985101-Work-with-Google-Sheets-in-Zaps).

Select the column you want to search within. The specified lookup value will be compared to values in this column to find a matching row.

Enter the value to search for in the lookup column. This will be used to find the spreadsheet row.

Optional: Specify an additional column to filter your search. When used, the Zap will only trigger for rows matching both columns.

Enter the value to search for in the supporting lookup column. This value, combined with the lookup value, will be used to find a matching spreadsheet row.

Search from the last row of the spreadsheet up. Select "True" to enable.

Enter the number of rows you want to retrieve. Maximum of 500 rows.

Value of the Worksheet Title to match exactly. Search is case-sensitive.

Specify the columns you want to include. Use letter ranges (A:Z)

Specify the number of the first row to retrieve. Row 1 is considered the header.

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

Enter the column number where you want to insert the column. Use 0 for column A, 1 for column B, etc. Leave blank to add a column at the end.

Select a spreadsheet to copy the worksheet to. Leave blank to copy to the original spreadsheet’s location.

Enter column headers for your new spreadsheet. These will be ignored if “Spreadsheet to Copy” is selected.

Worksheets must have headers. Learn more about [spreadsheet formatting](https://help.zapier.com/hc/en-us/articles/8496276985101-Work-with-Google-Sheets-in-Zaps). 

Select a row or enter the Row ID as a [custom value](https://help.zapier.com/hc/en-us/articles/8496241696141-Add-custom-values-to-dropdown-menu-fields-in-Zaps). This row will have all of its data permanently deleted.

Select the Row ID to update the same row each time the Zap runs or set the Row ID as a [custom value](https://help.zapier.com/hc/en-us/articles/8496241696141-Add-custom-values-to-dropdown-menu-fields-in-Zaps#01H7FR09FBEAKK4ZZP678QDE9T) to update different rows.

The background color for the row. Choose from your current custom Theme Color in your Spreadsheet, or select a predefined color.

The text color for the row. Choose from your current custom Theme Color in your Spreadsheet, or select a predefined color.

Select the Row ID to update the same row each time the Zap runs. Or set the Row ID as a [custom value](https://help.zapier.com/hc/en-us/articles/8496241696141-Add-custom-values-to-dropdown-menu-fields-in-Zaps#01H7FR09FBEAKK4ZZP678QDE9T) to update different rows. 

Requests can only be made to domains associated by this application. View [documentation](https://help.zapier.com/hc/en-us/articles/12899607716493) for more details.

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.

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Being able to collect, track, and analyze your data is essential for any business. Using Google Sheets with Zapier, you can automatically create and edit spreadsheets with data from other apps you use. Zapier can monitor changes in your Google Sheets and quickly share your important data with stakeholders. When you put Zapier to work with Google Sheets, you can connect Google Sheets to other apps, automating all of your spreadsheet tasks to save you time.

Here are some creative ways to use Google Sheets with Zapier:

Google Sheets

Zapier Tables is a no-code database built for automation.

Zapier Tables

Zoho Creator is an online database builder. Its easy drag-n-drop interface lets you create custom applications for every data collection need, define workflow and also configure business rules that are unique to your business.

Zoho Creator

Smartsheet is a leading cloud-based platform for work execution, enabling teams and organizations to plan, capture, manage, automate, and report on work at scale, resulting in more efficient processes and better business outcomes.

Smartsheet

Quip is a modern productivity suite that enables you and your team to collaborate on any device. It works across iPhone, iPad, Android phones and tablets, and the desktop web. Quip has a simple and elegant interface that combines documents and messages into a single chat-like “thread” of updates, making collaboration immediate and easy. You can share documents, tables, checklists, and more so multiple people can edit and discuss together in a single, shared workspace.

Quip

Organize anything with Airtable, a modern database created for everyone. Airtable is a fast and flexible way to create tables to keep track of anything, from sales leads to vacation planning to inventory management.

Airtable

Microsoft's Excel is a spreadsheet application used by millions of users across the world. It is part of the Office ecosystem and is considered the industry standard for spreadsheets. 

Only files on OneDrive for Business (available with Office 365 and Sharepoint server) are supported at this time with Zapier.

Microsoft Excel

When a maintenance issue is logged at a site, use this workflow to notify the maintenance team to attend the site. This also updates a google sheet which can be used to track repair.

Google Sheets + Trail + Email by Zapier

Create Google Sheets spreadsheet rows and send emails for new tasks completed in Trail

Supported triggers and actions

Task Completed

New Inbound Email

Send Outbound Email

Create Task

New Read Receipt

About Google Sheets

Related categories

Similar apps

Zapier Tables

Zoho Creator

Smartsheet

About Trail

Related categories

About Email by Zapier

Related categories

Related Zap Templates

Related Zap Templates