Describe the problem/error/question
Hi everyone. I’m brand new to n8n and have it running in a Docker container on a Synology NAS in my home lab and externally accessible via Cloudflare tunnel.
I have a scenario in Make that I’m trying to replicate in n8n. The source is a Google sheet with donation information and includes first name, last name, email, donation amount and donation date. The end output will be one or more Gmail emails being sent out.
A given donor may donate more than once in a given year and so will have multiple rows on the spreadsheet, but only one email should be sent per donor based on email address. The body of the message will have a line for each donation with donation date and donation amount.
I have the Google sheet node working in n8n and I connected an aggregator node to it because that’s the next module in Make, but that might not be right in n8n.
So, what nodes do I need to use in n8n such that the rows in the sheet that have the same email address combine in to one, but also gathering up each donation date and donation amount to be output in the email body?
As an example:
Dear John Doe,
bunch of boiler plate
Below are the donations for 2024:
1/2/2024: $50.00
2/5/2024: $50.00
4/5/2024: $50.00
I hope my explanation of what I’m trying to do in n8n makes sense!
Information on your n8n setup
- 1.76.1
- Database postgres:
- n8n EXECUTIONS_PROCESS setting (default: own, main):
- Running n8n via Docker on a Synology NAS:
- Synology:
Thanks very much for the help!
David