Send a daily product newsletter with Google Sheets and Gmail

Description

Quick Overview
This workflow runs daily at 08:00, pulls products scheduled for today from Google Sheets, generates an HTML newsletter email, and sends it to each subscriber via Gmail.

How it works
Runs every day at 08:00 on a schedule.
Reads all rows from the newsletter_products sheet in Google Sheets.
Keeps only products whose send_date matches today’s date and stops if none are found.
Builds an HTML email and subject line containing a card for each product (image, description, and optional referral link).
Reads the subscriber list from the newsletter_recipients sheet in Google Sheets.
Sends the generated newsletter to each recipient individually using Gmail.

Setup
Create or copy a Google Sheets document with newsletter_products (including a send_date column) and newsletter_recipients (including an email column).
Add a Google Sheets OAuth2 credential in n8n and paste your Google Sheet ID into the Config step.
Add a Gmail OAuth2 credential and confirm the sender mailbox to use for sending the newsletter.
Add products and recipients to the sheet, run a test execution, and adjust the schedule/timezone if needed before activating.