This integration makes it easy to trigger an email via Gmail for updates in a Google Spreadsheet. You can trigger an email based on any update or specific updates to a certain column.
How it works
- Add or update a row in your spreadsheet
- Zapier will automatically trigger an email via Gmail
What You Will Need
- A Google Spreadsheet account
- A Gmail account
Why Zapier?
Get started for free—14 day trial of premium features and apps.
No coding required—automate any of 1,500+ apps in minutes.
Enterprise-level security—connect mission-critical apps.
Save new Gmail emails matching certain traits to a Google Spreadsheet
Often it's helpful to store, backup and organize emails matching certain characteristics to a Google Spreadsheet. This Gmail Google Sheets integration makes it a breeze to setup a simple rule (i.e. emails from: boss@work.com) and automatically save them as a new row in a Google Spreadsheet so you have them backed up and for reference later - add your rules to the "search string" field while setting up this Zap, and we'll do the rest.
Add new incoming Gmail emails that match a label to Google Sheets as new rows
Email inboxes are great for viewing conversations, while spreadsheets make it easy to manipulate and store data. Get the best of both worlds for your emails with this Gmail-Google Sheets integration by Zapier!
Set it up and we'll watch Gmail for you, triggering the automation with every new email you label and adding its data to a new row on Google Sheets to build a per-label index of your messages.
How It Works
- A new label is added to an email on Gmail
- Zapier automation creates a new row on Google Sheets
What You Need
- Gmail account
- Google Sheets account
Log new Gmail emails from a specific sender to Google Sheets spreadsheet
Emails can get lost in your inbox, if you need to keep a record of emails received from a specific sender, this automation is just the ticket. After you set it up, new emails from a sender you designated will be added to a Google Sheet. That way, you'll always have a record on hand.
*Note: This Zapier integration doesn't log emails you may have already received from the specified sender, but only new emails you receive from them after this Zapier integration has been setup.
How this Gmail-Google Sheets integration works
- A new email is received from a specified sender
- Zapier adds new rows in Google Sheets
Apps involved
- Gmail
- Google Sheets
Add new rows to Google Sheets for new emails on Gmail
If you're looking for an external backup for your emails on Gmail, spreadsheets are always a solid option. Zapier's Gmail-Google Sheets integration can do all the work for you, too. Every new email you receive on Gmail will trigger the Zap after setup, automatically passing the information over to Google Sheets and adding your email to a new row, safe and sound.
How It Works
- A new email is received on Gmail
- Zapier automation adds a new row on Google Sheets
What You Need
- Gmail account
- Google Sheets account
Send a Gmail email for new Google Sheet spreadsheet rows
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
- Create a Google spreadsheet or form to trigger Gmail emails from.
- 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
Take new Gmail emails from a specific sender and add them to a Google Sheets spreadsheet
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
- You receive a new email in Gmail matching your search criteria.
- Zapier adds the contents of this email to a new row in a Google Sheets spreadsheet.
Apps involved
- Gmail
- Google Sheets
Create Trello cards and Google Sheets rows for new starred emails on Gmail
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
- A new email is starred on Gmail
- Zapier automatically creates a card on Trello...
- ...and adds a row to a spreadsheet on Google Sheets
What You Need
- Google account
- Trello account
Add new lead information to Google Sheets and Gmail from a webhook
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
- Webhook with lead information is sent to Zapier
- Webhooks by Zapier "catches" the webhook
- Zapier adds new lead information as a new row to Google Sheets
- Zapier sends an email with lead information via Gmail
What You Need
- Application to send webhook
- Webhooks by Zapier
- Google Sheets
- Gmail
Prepare draft emails for updated rows on Google Sheets
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
- A row is updated on Google Sheets
- Zapier automatically creates a new draft email on Gmail
What You Need
- Google Sheets account
- Gmail account
Send Gmail emails when there's new activity in a Trello card
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:
- A Trello card is updated
- Zapier finds a corresponding row in Google Sheets
- Zapier sends an email through Gmail
Apps involved
- Trello
- Google Sheets
- Gmail
Share Google Sheets rows via Gmail messages
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
- A new row is added to a specific sheet in Google Sheets
- Zapier sends a new email via Gmail
What You Need
- Google account
- Gmail account
Add new Google Sheets rows for CandidateZip parsed Gmail resume attachments
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
- New resume attachment in Gmail is received
- CandidateZip converts resume attachment to fields
- Zapier inserts resume fields as a new row on Google Sheets
Apps involved
- Gmail
- CandidateZip
- Google Sheets
Get more info about senders of starred Gmail emails with Lead Score by Zapier and log it in 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
- A new email in Gmail is starred
- Zapier enriches the customer data with info like company, company size, name, and more
- Zapier logs the customer data to a designated Google Sheets spreadsheet
Apps involved
- Gmail
- Lead Score by Zapier
- Google Sheets
Create drafts on Gmail for new rows on 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
- A new row is added on Google Sheets
- Zapier automation creates a new draft email on Gmail
What You Need
- Google account
Add rows on Google Sheets when new Gmail threads start
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
- A new thread starts on Gmail
- Zapier automation adds a new row on Google Sheets
What You Need
- Google account
Track new survey responses and alert a team via email
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
- New lines are added to a Google Sheet
- Zapier creates a new Airtable record with that data
- Zapier sends out an email to designated recipients.
Apps involved
- Google Sheets
- Airtable
- Gmail
Look up a Google Sheet row and find & edit a box in Streak from new Gmail threads
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
- New threads start in Gmail
- Zapier looks up a row in Google Sheets
- Zapier finds a box in Streak
- Zapier updates this box in Streak
Apps involved
- Gmail
- Google Sheets
- Streak
- Streak
Add new Google Sheets rows for detailed CandidateZip parsed Gmail resume attachments
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
- New resume attachment in Gmail is received
- CandidateZip converts resume attachment to fields
- Zapier inserts detailed resume fields as a new row of Google Sheets
Apps involved
- Gmail
- CandidateZip
- Google Sheets
Analyze the Voice of the Employee in the emails received related to your employees' performance reviews.
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
- A new performance review is received in the target Gmail account
- MeaningCloud categorizes its text according to a task-specific model.
- Zapier saves the results in a Google Sheets spreadsheet.
Apps involved
- Gmail
- MeaningCloud
- Google Sheets
Create and email new Veem contacts with Google Sheets and Gmail
Tired of manually creating Veem contacts and emailing them with further instructions? With this Zapier automation, just add a row to Google Sheets, and your contact will be created in Veem and sent an email in Gmail. Start on-boarding new clients and contractors with ease!
It's easy to connect Gmail + Google Sheets and requires absolutely zero coding experience—the only limit is your own imagination.
Triggers when you receive a new email that matches a search string you provide.
Create (but do not send) a new email message.
Triggers when you receive a new email and label it within two days.
Create and send a new email message.
Triggers when you receive a new attachment (triggers once per attachment).
Create a blank worksheet with a title. Optionally, provide headers.
Triggers when you receive a new email and star it within two days.
Create a new row in a specific spreadsheet.
Triggers when a new thread starts.
Update a row in a specific spreadsheet.
Use our free platform to build a single Zapier integration and instantly connect your app with 1,500+ others.
Become a Zapier Integration Partner