Send a daily product newsletter with Google Sheets and Gmail

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 1. Runs every day at 08:00 on a schedule. 2. Reads all rows from the newsletterproducts sheet in Google Sheets. 3. Keeps only products whose senddate matches today’s date and stops if none are found. 4. Builds an HTML email and subject line containing a card for each product (image, description, and optional referral link). 5. Reads the subscriber list from the newsletterrecipients sheet in Google Sheets. 6. Sends the generated newsletter to each recipient individually using Gmail.

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