Automate Google Sheets with Gmail

Unlock the superpowers of Google Sheets + Gmail and automate your tasks without having to write a single line of code.

Google Sheets and Gmail
your way

Check out the available triggers and actions in the automation of apps Google Sheets + Gmail

Google Sheets-modal-icon

New added row

When a new row is added on Google Sheets

How it works:

Whenever something happens on the source app

All happening in a single automation! ✨

Google Sheets-icon

New added row

When a new row is added on Google Sheets

Trigger

Information from Google Sheets that can be used and sent to other apps.

Line No.

Gmail-modal-icon

New email in a tab or with a label

For each new email received in a tab or with a label in Gmail

How it works:

Whenever something happens on the source app

All happening in a single automation! ✨

Gmail-icon

New email in a tab or with a label

For each new email received in a tab or with a label in Gmail

Trigger

Information from Gmail that can be used and sent to other apps.

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

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)

Gmail-modal-icon

New email with attachment(s)

For every new email with attachment(s) received in Gmail

How it works:

Whenever something happens on the source app

All happening in a single automation! ✨

Gmail-icon

New email with attachment(s)

For every new email with attachment(s) received in Gmail

Trigger Premium

Information from Gmail that can be used and sent to other apps.

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

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)

Attachments links single file or zipped files

Email attachments: zipped folder name

Google Sheets-modal-icon

Insert row in spreadsheet

add data to a new row on a Google Sheets spreadsheet

How it works:

Whenever something happens on the source app

1.

All happening in a single automation! ✨

Google Sheets-icon

Insert row in spreadsheet

add data to a new row on a Google Sheets spreadsheet

Action

Fields in Google Sheets that can receive information from other apps.

Columns

Gmail-modal-icon

Create draft

create a draft in Gmail

How it works:

Whenever something happens on the source app

1.

All happening in a single automation! ✨

Gmail-icon

Create draft

create a draft in Gmail

Action

Fields in Gmail that can receive information from other apps.

Subject Required

Message type

Message Required

Attachments

To Required

Cc

Bcc

Reply to

Google Sheets-modal-icon

Update/insert row in spreadsheet

update or add data in Google Sheets spreadsheet's row(s)

How it works:

Whenever something happens on the source app

1.

All happening in a single automation! ✨

Google Sheets-icon

Update/insert row in spreadsheet

update or add data in Google Sheets spreadsheet's row(s)

Action

Gmail-modal-icon

Send email

send an email through Gmail

How it works:

Whenever something happens on the source app

1.

All happening in a single automation! ✨

Gmail-icon

Send email

send an email through Gmail

Action

Fields in Gmail that can receive information from other apps.

Subject Required

Message Type

Message Required

Attachments

Recipient Required

CC

Bcc

Reply to

Didn't find your use case? Send suggestion.

Automate Google Sheets and Gmail
with Pluga integrations

Explore automation templates

Trusted by over 10.000 amazing companies

How to integrate apps with Pluga?

Pluga allows you to integrate two or more apps in a simple, practical way without needing to type a single line of code. Here are the steps to automate your tasks and start focusing on what really matters.

  • Trigger and source app of the automation

    What is the automation trigger?

    The trigger is the step that initiates automation. In the integration process, it is selected after choosing the source app. For example, if you choose Facebook Lead Ads as the source app, the trigger could be: For each response on an advertisement.

  • Action and destination app of the automation

    What is an action within an automation?

    The action serves as a response to the previously selected trigger. That is, it occurs once the trigger is activated. For example, in an automation between Facebook Lead Ads (source) and Google Sheets (destination), as soon as the trigger “For each response on an advertisement” is activated in the source app, the action “Add data to a new row on a spreadsheet” will be carried out in the destination app.

  • Information mapping of the automation

    How does information mapping work?

    Information mapping is where you configure which captured information from the source app will be sent to each field in the destination app(s).

    For example, in an automation between Facebook Lead Ads and Google Sheets, this step is where you will determine which contact information should fill in the spreadsheet fields.

  • Automation with multiple actions among more than two apps

    Is it possible to have more than one action?

    With Pluga, you can create automations by integrating several apps at once. For example, you can integrate Facebook Lead Ads + Google Sheets + Slack, so when the trigger is activated, the first action is executed and a notification is sent via Slack.

Automate Google Sheets + Gmail
and say goodbye to manual (and tedious) tasks!

By connecting the apps you use through Pluga, you can automate various processes in your routine and
have time for tasks that really matter.

Automatic transfer of your contacts' information to other apps

Automating the transfer of your contact base (leads) information to other apps can greatly facilitate tasks that involve managing them.

At Pluga, you can do this with ease and also helps optimize the work of people, avoiding possible human errors.

Card with contact information being sent to other apps

Automate your sales tracking

With the help of Pluga's automations, you can put your business's sales control on autopilot. This way, tasks surrounding inventory, finance, and logistics can be more aligned and optimized, directly impacting your customer's satisfaction.

Data from a new sale being sent to a spreadsheet

Automated financial control

Dealing with finances requires a lot of attention. For this, integrating apps can be a great ally! With Pluga, you can connect your financial management software and payment methods to other apps to automate tasks involving the organization of your finances.

Data from a new charge being sent to an invoicing app

Reduce communication noise - and rework!

If your company uses any type of internal communication tool, it's possible to automate the routine of notifications and alerts within it.

At Pluga, for example, you can connect this software to your project management platform so that every time a task changes status, this is communicated in a channel. In other words, it increases productivity, reduces communication noise, and avoids possible rework.

Automatic notification in the internal communication app

Customized alerts for customers

Often, personalized communication is what will captivate a customer to keep them interested in your brand. But doing this manually is almost impossible. Using Pluga, you can send these notifications automatically without losing personalization.

Automatic message sent to the customer's WhatsApp
Google Sheets-icon

Google Sheets

Spreadsheet

Google Sheets is Google's online spreadsheet app that allows users to create, edit, share, and collaborate on documents both synchronously and asynchronously. It's a versatile tool for any type and size of business, serving purposes from CRM to inventory management spreadsheets.

Integrations with Google Sheets Visit Google Sheets
Gmail-icon

Gmail

Email

Gmail is one of the most popular email services in the world and one of Google's earliest apps. With this software, users can easily create and send messages.

Integrations with Gmail Visit Gmail

Frequently Asked Questions

  • With Pluga, you can easily automate Google Sheets com Gmail . Just follow these steps:

    • 1. Log in or sign up (for free) on Pluga and click on “Create automation”;
    • 2. Select the source app and trigger;
    • 3. Select the destination app and action;
    • 4. Make the necessary adjustments, specifying which data will be sent to one app to another.

  • By automating Google Sheets with Gmail on Pluga, you can automate various manual tasks that reduce productivity for those who perform them, while also avoiding human errors. The best part is that the process is simple and doesn’t require typing a single line of code.

  • On Pluga, you can make several automations for free with the free plan. Additionally, you have the option to try all the features for 7 days at no cost to create automations between Google Sheets, Gmail, and even other apps.

    We also offer three other plans, with prices ranging from $17 to $65 per month, which include premium automations and features, as well as a higher volume of events and automations. For companies with specific needs, we have the Enterprise plan, designed to offer customized solutions beyond the resources available in other plans.

    Check Pluga's pricing page for more details.