Sending emails from Sheets in Google Sheets - Step-by-Step Guide

Introduction

This feature helps you send emails directly from your Google Sheets. It saves time by automating email sending based on your spreadsheet data without switching apps.

When you want to send personalized emails to a list of contacts stored in your sheet.

When you need to send reminders or notifications automatically from your spreadsheet data.

When you want to send a summary report by email based on your sheet's calculations.

When you manage event invitations and want to email attendees from the sheet.

When you want to send follow-up emails after collecting responses in your sheet.

Steps

Step 1: Open

- Google Sheets file where you want to send emails

Your spreadsheet is ready for adding email script

Step 2: Click

- Extensions menu, then select Apps Script

The Apps Script editor opens in a new tab

Step 3: Delete any code in the script editor and type

- Apps Script editor

You have a blank script to write your email sending code

💡 Use simple code like MailApp.sendEmail to send emails

Step 4: Copy and paste this example code

- Apps Script editor

Code is ready to send emails from sheet data

💡 Replace placeholders with your actual sheet column names and email content

Step 5: Click

- Save icon in Apps Script editor

Your script is saved

Step 6: Click

- Run menu, then select your function name

Script runs and sends emails based on your sheet data

💡 The first time you run, you will need to authorize the script to send emails

Step 7: Return

- Google Sheets tab

You see your sheet and can check if emails were sent

Before vs After

Before

Sheet has columns with email addresses and message details but no emails sent

After

Emails are sent to addresses listed in the sheet with personalized messages

Settings Reference

Authorization

📍 Apps Script editor when running script first time

Allow the script to send emails on your behalf

Default: Prompt on first run

Trigger setup

📍 Apps Script editor > Triggers (clock icon)

Automate when emails are sent without manual running

Default: No trigger by default

Common Mistakes

Not authorizing the script to send emails

The script cannot send emails without permission and will fail silently

Run the script and follow the authorization prompts to allow email sending

Using wrong column names or ranges in the script

Emails may be sent with wrong or empty data

Check your sheet column headers and update the script to match exactly

Running the script without testing on a small sample

You might send many unwanted emails by mistake

Test the script on a few rows before sending to all contacts

Summary

You can send emails directly from Google Sheets using Apps Script.

Write and run a simple script to automate email sending based on your sheet data.

Remember to authorize the script and test carefully before sending many emails.