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. An n8n automation workflow template by Robin.

Categories

Tags

Capabilities

• 3 nodes
• 14 views