Send a daily product newsletter with Google Sheets and Gmail
Automates daily product newsletter creation and sending using Google Sheets and Gmail.
Open template Updated 2026-06-24
What this workflow does
This n8n workflow automates daily newsletter distribution by triggering on a fixed schedule, filtering matching products from Google Sheets, building an HTML email, and sending it individually via Gmail.
It is intended for marketers and businesses that store product schedules and subscriber lists in Google Sheets and require consistent, hands-free email delivery.
Who is this for?
Marketing teams, product managers, and solo creators who maintain product data in Google Sheets and want to send daily newsletters without manual effort.
What problem it solves
Manually compiling and emailing daily product updates is time-consuming and error-prone. This workflow automates pulling today's products, building an HTML email, and sending it to subscribers.
Live workflow preview
Interactive canvas of every node and connection — scroll and click to explore. Powered by n8n's preview.
Open the template on n8n to import and run it. View source template →
What it automates
E-commerce daily drops
Pull new arrivals scheduled for today from a product sheet and email them to subscribers each morning.
Affiliate promotions
Send personalized referral-link newsletters for products whose send_date matches the current day.
Content curation
Share curated product recommendations stored in Sheets with a subscriber list via Gmail.
How the workflow works
The 3 nodes in this automation, in order.
- 1Google SheetsgoogleSheets
- 2Gmailgmail
- 3Codecode
Apps & integrations used
Google SheetsGmail
How to set up Send a daily product newsletter with Google Sheets and Gmail
- 1Add a Schedule trigger node set to run daily at 08:00.
- 2Connect a Google Sheets node to read all rows from the newsletter_products sheet.
- 3Add a Filter node to keep only rows where send_date equals today's date.
- 4Use a Function or Set node to build the HTML email body and subject from the filtered products.
- 5Add another Google Sheets node to read the newsletter_recipients sheet.
- 6Connect a Gmail node to send the generated email to each recipient individually.
How to customize this workflow
- →Change the Schedule trigger time or switch to a different recurrence.
- →Add extra columns from Sheets into the HTML card template.
- →Insert a conditional node to skip sending if no products match today's date.
- →Replace the HTML builder with a simple text version for plain-text emails.
Send a daily product newsletter with Google Sheets and Gmail: pros & cons
Pros
- +Uses only native n8n Google Sheets and Gmail nodes
- +Runs reliably on a fixed daily schedule
- +Sends emails individually to avoid spam flags
- +Easy to maintain with data stored in familiar Sheets
Cons
- –HTML email must be built manually in the workflow
- –Requires two separate Google Sheets tabs to be pre-populated
- –No built-in unsubscribe or analytics handling
Did you find this helpful?
Frequently asked questions
It automatically sends a daily HTML newsletter containing products scheduled for that day using data from Google Sheets.
User reviews
Verified reviews from the community shape this listing's rating.
Loading reviews…
Similar workflows
Other marketing automations worth a look.