Better Sheets

MailApp

What it does

Send email as the user running the script without full Gmail API access.

Methods used

.sendEmail()

4 Related snippets

Official Google docs

Explore

Related methods

.sendEmail()
Sends a simple email as the script runner.
.getRemainingDailyQuota()
Returns how many emails the script can still send today.

More Apps Script

3 Better Sheets tutorials

5 Ways To Use Google Sheets for Advanced Project Management

Here are 5 advanced ways to manage projects inside of Google Sheets Man...

Intermediate

COUNTIF() FILTER() IF() INDEX() ISBLANK() +3 more

Automate Emails

Set up automated email notifications based on Google Sheets data. Super ...

Beginner

Automatic Calculations

Create custom scripts to make your spreadsheets more like tools.

Beginner

Related blog posts

Written guides about MailApp in Google Apps Script.

Browse the blog

Email Yourself a Cell from a Google Sheet, Every Day

I'll show you how to email yourself one single cell data. That's one sheet, one cell, one email every single day.

Read post →

Simply Email Yourself From a Google Sheet

I wanted to share with you one of the simplest apps scripts that has immense power. Email! You can email others, but you can also email yourself.

Read post →

Automated Project Management in Google Sheets

When you have multiple people working on multiple tasks, and you want everyone to be on the page, what do you do? You can use a Google Sheet. But managing projects can be an intimidating task in Google Sheets. It's a lot of data entry, right? Especially when you have multiple people working on different tasks with different statuses across different projects. Data entry for multiple projects, with different people, tasks, and statuses – it gets messy fast! I'm no stranger to these issues...

Read post →