Email yourself a weekly summary from a spreadsheet
Read a Google Sheet on a schedule, total up the week's numbers, and send a plain-language email summary every Monday morning.
What this looks like
One step on screen at a time. Read it, do it, tap Next.
Email yourself a weekly summary from a spreadsheet
Step 1 of 11
Create the workflow and add a Schedule Trigger
Create a workflow, name it, then add a Schedule Trigger. Set it to run weekly on the day and hour you want the email to land.
Checkpoint
A Schedule Trigger sits on the canvas set to weekly.
Before you begin
Tick these off as you sort them. Stopping halfway to create an account is how a fifteen-minute build becomes an hour.
0 of 7 ready
Ticks are saved on this device, so you can come back to them.
- Have ready
One row per record, column names in row 1. This walkthrough assumes a date column and a numeric amount column.
- Account
The same account connects both the Sheets node and the Gmail node, so one OAuth sign-in covers both.
- Have ready
Start with only your own address. Add colleagues once you trust the numbers.
- Know-howOptional
One short JavaScript snippet does the totalling. It is provided in full — you only need to paste it.
- Time
Longer if your sheet's column names need renaming in the code step.
The basics — ticked once, remembered everywhere
- Account
Either the hosted version or a self-hosted install. Everything here works the same on both — the only visible difference is the shape of your webhook URLs.
Create a workspace - Know-how
Adding a node, connecting two of them, and pressing Execute. If any of that is new, the free primer covers it in about ten minutes.
- Credential
You will paste at least one secret during setup. A password manager beats a notes app, and it stops you pasting a live key into a chat window by accident.
The shape of the workflow
The nodes you will end up with, left to right, in the order you add them.
4 things to set here- 1Schedule Trigger — the trigger — everything starts here
- 2Google Sheets — Add the Google Sheets node
- 3Google Sheets — Point it at your sheet
- 4Google Sheets — Pull the rows in
Skip the node hunting
Import a starter file with every node for this build already on the canvas, named after its step and wired in order, each one carrying a sticky note with the values to enter. You still connect your own accounts and fill the fields — that is what the walkthrough takes you through — but you never start at a blank canvas.
In n8n: Workflows → Import from file.
What you will build
Jump straight to any step, or print the list and tick it off beside your n8n tab.
If something goes wrong
Everything ready?
Start walkthrough