Apps Script gives you access to Gmail through the GmailApp service, letting you send emails, read threads, create drafts, apply labels, and much more — all without leaving your script.
In this series, we follow the Acme Corp sales team. They send deal confirmation emails to customers, weekly digest emails to sales reps, and automated follow-ups based on deal status — all driven from their Sales Tracker spreadsheet.
All examples in this series use a Sales Tracker Google Sheet with the following columns:
| Customer Name | Product | Amount | Region | Sales Rep | Status | Date | |
|---|---|---|---|---|---|---|---|
| Sarah Johnson | [email protected] | Pro Plan | 299 | North | Alex Martinez | Closed | 2024-03-15 |
| Mark Chen | [email protected] | Enterprise Plan | 999 | East | Jordan Lee | In Progress | 2024-03-18 |
| Lisa Park | [email protected] | Starter Plan | 99 | South | Sam Rivera | Closed | 2024-03-20 |