Connect Google Sheets with Gmail
Connect Google Sheets with Gmail to scale and automate your operations.
Explore automation templates
Automate Google Sheets and Gmail with Pluga integrations
When a new row is created on Google Sheets, send an email through Gmail
For each new email received in a tab or a label in Gmail, add data to a new row on a Google Sheets spreadsheet
For each new email received in a tab or a label in Gmail, update or add data in Google Sheets spreadsheet's row(s)
When a new row is created on Google Sheets, create a draft in Gmail
For each row created or updated in Google Sheets, send an email through Gmail
For each row created or updated in Google Sheets, create a draft in Gmail
Extract and register information from Gmail emails into Google Sheets
Respond to Facebook leads by email and log them in a control spreadsheet
Send a thank-you email and log the Conta Azul sale in a spreadsheet.
Log emailed briefing into a projects spreadsheet with Claude
Log emailed briefing into a projects spreadsheet with Gemini
Log emailed briefing into a projects spreadsheet with ChatGPT
Didn't find the template you wanted? Build the integration your own way. ;)
Trusted by over 10.000 amazing companies
Google Sheets and Gmail
your way
Check out the available triggers and actions in the automation of apps Google Sheets + Gmail
New added row
When a new row is added on Google Sheets
Line No.
New email in a tab or label (with attachment)
For each new email with attachments received in a tab or a label in Gmail
Email ID
ID of the thread the email belongs to.
Subheding
ID of the last email modification history record
Email in MIME type format text/plain
Email in MIME type format text/html
Email content in MIME type format text/html
Subject of the email
Sender: Name and email
Sender: Name
Sender: Email
Recipient: Names and emails
Recipient: Names
Recipient: Emails
Reply-To: name and e-mail address
Reply-To: name
Reply-To: e-mail address
Cc recipients: Names and emails
Cc recipients: Names
Cc recipients: Emails
Bcc recipients: Names and emails
Bcc recipients: Names
Bcc recipients: Emails
Internal creation date (format: YYYY-MM-DDTHH:mm.sssZ)
Internal creation date (format: DD-MM-AAAA HH:mm:ss)
Internal creation date (format: DD-MM-AAAA)
Internal creation hour (format: HH:mm:ss)
Attachment link: Single file or zipped file
Email attachments: zipped folder name
For each row created/updated
For each row created or updated in Google Sheets
Nº da linha
New email in a tab or label
For each new email received in a tab or a label in Gmail
Email ID
ID of the thread the email belongs to
Subheding
ID of the last email modification history record
Email in MIME type format text/plain
Email in MIME type format text/html
Email content in MIME type format text/html
Subject of the email
Sender: Name and email
Sender: Name
Sender: Email
Recipient: Names and emails
Recipient: Names
Recipient: Emails
Reply-To: name and e-mail address
Reply-To: name
Reply-To: e-mail address
Cc recipients: Names and emails
Cc recipients: Names
Cc recipients: Emails
Bcc recipients: Names and emails
Bcc recipients: Names
Bcc recipients: Emails
Internal creation date (format: YYYY-MM-DDTHH:mm.sssZ)
Internal creation date (format: DD-MM-AAAA HH:mm:ss)
Internal creation date (format: DD-MM-AAAA)
Internal creation hour (format: HH:mm:ss)
Insert row in spreadsheet
add data to a new row on a Google Sheets spreadsheet
Columns
Insert/update row in spreadsheet
add or update data in Google Sheets spreadsheet's row(s)
Search emails
Search emails in Gmail
Search mode
Search string
Search filters
Result limit
No records found?
Insert multiple rows in spreadsheet (only for multiple items)
add the data to multiple rows in a Google Sheets spreadsheet
Send email
send an email through Gmail
Subject Required
Message Type
Message Required
Attachments
Recipient Required
Sender Name
CC
Bcc
Reply to
Search rows in a spreadsheet
Search rows in a spreadsheet in Google Sheets
Search Column Required
Condition
Search value
Additional filters
Result limit
No rows found?
Create draft
create a draft in Gmail
Subject Required
Message type
Message Required
Attachments
To Required
Sender Name
Cc
Bcc
Reply to
Boost this flow in your workflow
With Pluga, you connect Google Sheets + Gmail to build anything from the simplest integration to the most advanced flows, with several layers of logic.
- Basic 1
Pick the source app and the trigger
Choose which app starts the automation and which event works as the trigger. For example, "For each new email received in a tab or a label in Gmail".
- Basic 2
Set the destinations and the actions
Select the apps that make up the flow with Google Sheets and what Pluga should run automatically at each step. Example: "Search rows in a spreadsheet in Google Sheets"
- Basic 3
Map the information
Point out, visually, which data from the source app should fill in each field of the destination action.
- Intermediate
Only move forward when it makes sense
Set "AND" or "OR" conditions so the automation only runs in the cases that matter
- Intermediate
Pause the flow for as long as you need
Set the automation to wait minutes, hours or days and resume the next action on its own
- Intermediate
Standardize data across apps
Adjust dates, numbers and characters to the format the next app expects to receive
- Advanced
Send data in several directions
Route each piece of data down the right path within a single flow, according to specific conditions
- Advanced
Add a code block
Run JavaScript or Python in the middle of the automation to transform data before the next step
- Advanced
Create loops
Take lists of items, go through each row and run the same action for every one of them
- Advanced
Use generative AI
Send data to an AI assistant or agent and use the response in the next step
- Advanced
Connect to (almost) any app
Send and receive data through a dedicated URL, and connect to apps that are not integrated with Pluga
- Advanced
Requests to external APIs
Query or send data to any external API inside your automation
Google Sheets
SpreadsheetConnect Google Sheets to 133+ apps with Pluga and turn your work into a productive machine. Centralize data from several apps in a single spreadsheet, keep your reports updated in real time and use the spreadsheet as a bridge between the apps you already work with.
Gmail
EmailConnect Gmail to 133+ apps with Pluga and turn your work into a productive machine. Connect your inbox to your other apps and let your messages work for you: capture leads, fire personalized follow-ups and archive conversations automatically.
