Automate Gmail with Make.com and Google Sheets

With make.com you can automatically send personalized emails from Google Sheets without writing code. This guide walks you step by step through building a simple automation that triggers whenever a new row is added and then sends a custom Gmail message based on the data in that row.

Using an automation like this saves time, reduces manual work, and helps you avoid copy‑paste mistakes when sending updates, notifications, or confirmations straight from your spreadsheet.

What you need before starting on Make.com

Before you build this workflow, prepare the following:

• A free or paid make.com account
• Access to Google Sheets
• Access to Gmail (a Google account)
• A simple spreadsheet with at least an email column

Your Google Sheet can include extra columns for name, subject, or custom message text. These columns will later be mapped to the email fields in your scenario on make.com.

Set up your Google Sheet for Make.com automation

Create or open a Google Sheet that will act as your source of email data.

1. Add column headers in the first row, for example:

   • A: Email
   • B: Name
   • C: Subject
   • D: Message

2. Enter a few sample rows so you can test the scenario later on make.com.

3. Confirm that all email addresses are valid and that you have permission to contact the recipients.

Clear and consistent headers help you easily map data from Google Sheets into Gmail fields during scenario configuration on make.com.

Create a new scenario in Make.com

Now you are ready to build the automation on make.com.

1. Log in to your make.com account.

2. Click the button to create a new scenario.

3. On the canvas, you will add and connect modules. The first module will watch your Google Sheet, and the second module will send an email through Gmail.

Add the Google Sheets trigger module in Make.com

The scenario starts with a trigger module that detects new or updated rows in Google Sheets.

1. On the scenario canvas in make.com, click the plus icon and search for Google Sheets.

2. Select a trigger such as Watch Rows or a similar option that monitors your spreadsheet.

3. Connect your Google account if prompted, and grant the necessary permissions.

4. Choose the specific spreadsheet and worksheet that hold your email data.

5. Configure any filters, for example to watch only new rows or rows that meet a certain condition.

Once configured, the Google Sheets module will pass the values from each row into the rest of your make.com scenario whenever it detects a qualifying change.

Add the Gmail action module in Make.com

After setting up the trigger, you need an action to send the email through Gmail.

1. Click the plus icon to the right of your Google Sheets module in make.com.

2. Search for Gmail and choose an action such as Send an email.

3. Connect your Gmail account and approve access.

4. Map the fields from Google Sheets to Gmail:

   • To: Map the column that holds the recipient email address.
   • Subject: Map your subject column or enter a fixed subject line.
   • Content: Map your message column and optionally insert the name column for personalization.

Field mapping is the key step in make.com that turns raw spreadsheet data into a dynamic email message.

Map dynamic email content with Make.com

To make each email personalized, use variable fields from the Google Sheet inside your Gmail content.

• Open the Gmail module settings in make.com.

• In the email body, insert items from the row, such as:

  • Recipient name
  • Custom message text
  • Any other details like dates, order IDs, or links

• Combine static text with mapped fields, for example: “Hi {{Name}}, your order {{Order ID}} has been shipped.”

With this mapping, every time the scenario runs on make.com, the email body is automatically built from the data in the corresponding row.

Test and run your Make.com scenario

Before enabling the automation, test everything from end to end.

1. In make.com, click the option to run the scenario once.

2. Add a new test row in your Google Sheet that matches the expected structure.

3. Watch the scenario log to confirm that the Google Sheets module detects the row and passes it to Gmail.

4. Check the Gmail mailbox of the recipient to verify that the email arrived with the correct subject and content.

If the email or data mapping is not correct, adjust the modules in make.com and run the test again until the result looks right.

Turn on scheduling in Make.com

Once testing is complete, you can schedule the scenario so it runs automatically.

1. Open the scenario details in make.com.

2. Enable scheduling and choose how often it should check the Google Sheet, such as every 5 minutes or every hour.

3. Save and activate the scenario.

From this point, make.com regularly monitors the sheet and sends emails via Gmail based on new or updated rows without further manual work.

Use cases for Google Sheets and Make.com

This integration can support many business and personal workflows, including:

• Sending confirmation emails for form responses stored in a sheet
• Notifying customers about order status or shipping updates
• Sharing progress reports or task updates with team members
• Sending follow‑up emails for training or onboarding lists

Because make.com is flexible, you can expand the same scenario with filters, conditions, or extra steps to branch logic or update related systems.

Optimize and extend your Make.com workflow

After the base automation is running, consider improving it further.

• Add filters: In make.com, only send emails when a specific column contains a certain value.
• Prevent duplicates: Mark rows as “sent” and filter them out on future runs.
• Log errors: Add a step that writes failed attempts to another sheet for review.
• Integrate more apps: Extend the scenario to also update a CRM, send a Slack notification, or post to another tool.

If you need broader automation strategy support or help designing complex workflows that combine several tools, you can explore consulting services from Consultevo for additional guidance.

Next steps with Make.com

Once you are comfortable sending automated emails from Google Sheets, browse other modules on make.com to connect forms, databases, project management tools, and marketing platforms. The same principles of triggers, actions, and data mapping apply across countless use cases, allowing you to build powerful no‑code automations tailored to your needs.

Need Help With Make.com?

If you want expert help building, automating, or scaling your Make scenarios, work with ConsultEvo — certified workflow and automation specialists.

Get Help