Send emails via Gmail when Google Sheets rows are updated

After you set this Zapier integration up, a Gmail email will be automatically sent to any recipient (including yourself) when a row is added to a Google Sheets spreadsheet. This works great with Google Forms and Google Sheets alike.

How It works

1. Create a Google spreadsheet or form to trigger Gmail emails from.
2. Anytime you want a send an email, just add another row in the spreadsheet.

If you use Google Forms, when anyone fills out the form that will send an email too. Or, if you want to get really fancy, you can use another Zap to populate the spreadsheet. The sky is the limit!

What You Need

• Google Spreadsheet account
• Gmail account

Have you had important emails get lost amongst the hundreds of other emails you receive each day? This Zapier integration takes new Gmail emails from a specific sender and then adds the contents to a new row in a Google Sheets spreadsheet. You'll be able to quickly and easily read emails from a specific address without them getting lost in your ever-growing inbox.

How this Gmail-Google Sheets integration works

1. You receive a new email in Gmail matching your search criteria.
2. Zapier adds the contents of this email to a new row in a Google Sheets spreadsheet.

Apps involved

• Gmail
• Google Sheets

Email has been around for a long time, and many of us still use our inboxes as a makeshift to-do list — but there's a better way. Set up this multi-step Gmail-Trello-Google Sheets integration to trigger an automated workflow as soon as you star an email on Gmail, creating a new card on Trello so you can keep track of what needs to get done and adding a row to a Google spreadsheet so your record-keeping is always up-to-date and accurate. Star away! We'll handle the rest.

How It Works

1. A new email is starred on Gmail
2. Zapier automatically creates a card on Trello...
3. ...and adds a row to a spreadsheet on Google Sheets

What You Need

• Google account
• Trello account

Need to get your leads processed fast? Use this Zapier integration to capture a lead via a webhook, then add the lead information to Google Sheets and send an update email via Gmail.

How It Works

1. Webhook with lead information is sent to Zapier
2. Webhooks by Zapier "catches" the webhook
3. Zapier adds new lead information as a new row to Google Sheets
4. Zapier sends an email with lead information via Gmail

What You Need

1. Application to send webhook
2. Webhooks by Zapier
3. Google Sheets
4. Gmail

Spreadsheets make excellent repositories when you're gathering information for your outreach. Once you're happy with what you've put together, use this Google Sheets-Gmail integration to kick off your workflow: change a column on your sheet to signify you're ready, and the Zap will trigger. It will then create a draft email for you on Gmail, complete with custom copy and values from your spreadsheet so everything is ready for a final scan and to be sent off.

How It Works

1. A row is updated on Google Sheets
2. Zapier automatically creates a new draft email on Gmail

What You Need

• Google Sheets account
• Gmail account

Do you find yourself updating clients, customers, or coworkers on the status of a project or case? If you're writing and sending the emails yourself, you can actually let Zapier do it all for you. With this Zap, when you update a Trello card—say, check off an item in your checklist—Zapier will look up a row in Google Sheets, where you can house specific, pre-written messages. Then, Zapier will use those messages in your email and send it off in Gmail.

How this integration works:

1. A Trello card is updated
2. Zapier finds a corresponding row in Google Sheets
3. Zapier sends an email through Gmail

Apps involved

• Trello
• Google Sheets
• Gmail

Automatically monitor important Google Sheets documents when you use this automation. Set it up, and every time a new row is added to a selected Google Sheets spreadsheet, Zapier will send a new email via Gmail. Never miss an important update to your spreadsheets again.

How It Works

1. A new row is added to a specific sheet in Google Sheets
2. Zapier sends a new email via Gmail

What You Need

• Google account
• Gmail account

Evaluating resume information on a shared spreadsheet is a great way to compare applicants. However, manually entering information from received resumes into a spreadsheet can take up valuable time. Once set up, this integration will automatically parse resume information via CandidateZip from your Gmail attachments and add the information to a Google Sheets spreadsheet.

How this Gmail-CandidateZip-Google Sheets integration works

1. New resume attachment in Gmail is received
2. CandidateZip converts resume attachment to fields
3. Zapier inserts resume fields as a new row on Google Sheets

Apps involved

• Gmail
• CandidateZip
• Google Sheets

Receiving emails from leads, customers, or partners and want to learn more about them? Use this integration and whenever a new Gmail email is starred, the sender's data will be automatically enriched using Lead Score by Zapier with information like name, company, company size, location and more. Afterward, the enriched data will be automatically logged on a Google Sheets spreadsheet so you can view it at your convenience.

How this Gmail-Lead Score by Zapier-Google Sheets

1. A new email in Gmail is starred
2. Zapier enriches the customer data with info like company, company size, name, and more
3. Zapier logs the customer data to a designated Google Sheets spreadsheet

Apps involved

• Gmail
• Lead Score by Zapier
• Google Sheets

If you're using a spreadsheet to track all those leads, set up this Google Sheets-Gmail integration to automate the outreach process. It will then trigger whenever you add a new row on Google Sheets, automatically preparing a new draft email for you on Gmail. From there you can make sure the dynamic content was added to your template as you needed, and hit send!

How It Works

1. A new row is added on Google Sheets
2. Zapier automation creates a new draft email on Gmail

What You Need

• Google account

Emails that start conversations are valuable records. Use this Gmail-Google Sheets integration to track them automatically. Once it's been set up, Zapier will add a new row to Google Sheets whenever a new thread starts on Gmail, storing all the relevant information for your archives.

How It Works

1. A new thread starts on Gmail
2. Zapier automation adds a new row on Google Sheets

What You Need

• Google account

Getting a handle on how customers view your product, support, and company is invaluable, giving you a cheat sheet to creating the experience they crave. Use this Zap to get these insights automatically. After you set it up, new lines on a Google Sheet will be added to Airtable. When the Airtable record is updated, Zapier will send out an email alerting the team to check in.

How this Google Sheets-Airtable-Gmail integration works

1. New lines are added to a Google Sheet
2. Zapier creates a new Airtable record with that data
3. Zapier sends out an email to designated recipients.

Apps involved

• Google Sheets
• Airtable
• Gmail

Manually searching for customer data and updating your Streak boxes can be a thing of the past with Zapier! With this Zap, when new threads start in Gmail, Zapier will find the matching customer in Google Sheets and then find and update their box in Streak. We're not saying it's magic...but it's magic.

How this Gmail-Google Sheets-Streak integration works

1. New threads start in Gmail
2. Zapier looks up a row in Google Sheets
3. Zapier finds a box in Streak
4. Zapier updates this box in Streak

Apps involved

• Gmail
• Google Sheets
• Streak
• Streak

Evaluating resume information on a shared spreadsheet is a great way to compare applicants. However, manually entering information from received resumes into a spreadsheet can take up valuable time. Once set up, this integration will automatically parse detailed resume information via CandidateZip from your Gmail attachments and add the information to a Google Sheets spreadsheet.

How this Gmail-CandidateZip-Google Sheets integration works

1. New resume attachment in Gmail is received
2. CandidateZip converts resume attachment to fields
3. Zapier inserts detailed resume fields as a new row of Google Sheets

Apps involved

• Gmail
• CandidateZip
• Google Sheets

HR departments can sometimes receive an overwhelming number of performance review emails in very short periods. With this Zapier integration activated, you can analyze new Gmail emails that match a search (e.g. "performance reviews) with MeaningCloud Deep Categorization technology and add them to a Google Sheets spreadsheet automatically for easy analysis.

Note: This Zapier integration uses a premium vertical pack to categorize texts. You can start a free 30-day trial on the MeaningCloud website.

How it works

1. A new performance review is received in the target Gmail account
2. MeaningCloud categorizes its text according to a task-specific model.
3. Zapier saves the results in a Google Sheets spreadsheet.

Apps involved

• Gmail
• MeaningCloud
• Google Sheets