How to email each person only their rows from a Google Sheet
By Jake Marsh · Updated
To email each person only their rows from a Google Sheet, put each row's recipient email in a column, create a report in Scheduled Sheet Reports, and under the recipients choose One email per address in this column with that column's header or letter. Each address gets its own email with the header row and only the rows that have their address, as a table, PDF, Excel file or CSV.
Set up the sheet
| Order | Customer | Amount | Status | Rep email |
|---|---|---|---|---|
| 1041 | Hill Farms | 1,200 | Open | ana@example.com |
| 1042 | Bay Supply | 640 | Open | ben@example.com |
| 1043 | Oak & Co | 2,310 | Late | ana@example.com |
| 1044 | Pine Ltd | 90 | Open | ana@example.com; cara@example.com |
Here Ana gets orders 1041, 1043 and 1044, Ben gets 1042, and Cara gets 1044. A cell can hold several addresses separated by commas or semicolons, and that row goes to each of them.
Rows with an empty email cell aren't sent to anyone.
Steps
- Open Extensions, Scheduled Sheet Reports, Open reports, then New report.
- Pick What to send: the tab or range that holds the rows, including the header row.
- Choose One email per address in this column and type the column's header, such as
Rep email, or its letter, such asE. - Pick Send as. A table in the email body is usually best for a short list; add a PDF or Excel file if they'll print or work with it.
- Write a subject like
Your open orders, {{date}}. - Set When, for example every weekday around 8 AM.
- Click Preview. It lists every email that will go out and who it's for, so you can check that each person gets the right rows before anything is sent.
- Click Save and schedule.
Use a filter view of the data
Often only some rows should go out, such as open orders. Make a tab that pulls just those rows with a formula, for example =FILTER(Orders!A:E, Orders!D:D<>"Closed"), and point the report at that tab. Then tick Skip when there are no data rows, so a person with nothing open that day gets nothing.
Things to know
- Each person's email goes only to them: no Cc or Bcc is added, so nobody sees the other recipients or their rows.
- One report can send up to 50 separate emails. For more people, split the list into two reports.
- Every email counts toward your Google account's daily recipient limit: 100 a day on personal Gmail, 1,500 on Google Workspace.
- One send of the report counts as one trial use, however many people it goes to.
What it costs
Scheduled Sheet Reports is $6.99 a month or $59 a year per Google account. Free trial: 20 scheduled sends or 14 days, whichever comes first. No card needed. Every plan and the install link are on the Scheduled Sheet Reports page.
Scheduled Sheet Reports
Email a range or a whole sheet on a schedule, with a stop button that always works $6.99 a month or $59 a year per Google account.
Questions
Can I send a manager a copy of everyone's rows?
Make a second report on the same tab, addressed to the manager, without splitting. They get the full list.
What if someone's address is typed wrong?
Their rows go to the address as typed. Preview shows every address before you save, which is the easiest place to catch it.
Can I change the message per person?
The subject and message are the same for everyone, and can include tokens such as {{date}} or a cell value. The rows are what differ.
Is this the same as a mail merge?
A mail merge writes one personal message per row. This sends each person a report of their rows, which suits lists like orders, tasks or accounts where one person owns several rows.
More Scheduled Sheet Reports guides
- How to email a Google Sheet as a PDF automatically
- How to send an email when a Google Sheets cell crosses a limit