Skip to content
Flowmanic
AI ContentAI-PoweredStructurally Validated

AI Newsletter Digest

Add interesting links and a short note to a Google Sheet as you find them during the week. Every Monday morning, AI turns your curated list into a complete newsletter — subject line, intro, one section per link — and sends it, no writing session required.

Automation flow

How it works

  1. 1Every Monday at 8 AM, the workflow reads your Curated Links sheet.
  2. 2Only rows marked Pending are kept — this is your queue for the week.
  3. 3The links and notes are combined into one block of text.
  4. 4That text is sent to the AI, which writes a full newsletter: subject line, intro, one section per link, and a sign-off — as clean HTML.
  5. 5The finished newsletter is sent immediately.

Services used

Google SheetsAI API (OpenAI-compatible)Gmail

What you'll need

  • An n8n Cloud or self-hosted account
  • A Google account (Sheets)
  • An OpenAI API key (or any compatible AI API)
  • A Gmail account, or a mailing-list address (a Google Group alias works well as YOUR_NEWSLETTER_LIST_EMAIL if you want one send to fan out to many subscribers)

What's included

  • Turns weekly link-hoarding into a finished newsletter
  • Bring your own AI API key
  • Works with any mailing-list address, including Google Group aliases
  • Full HTML email output, ready to send as-is

Estimate what this could save you

3.6 hours/month

$108/month in your time

A rough estimate based on what you enter above — not a guarantee. Actual time saved depends on your process.

Make it yours

  • Add a step after "Parse AI Response" that updates the Status column on used rows to Sent, so old links don't get rescheduled — swap in a Google Sheets "update" node using a row-matching lookup.
  • Split into a Set node that catches an empty-links week and skips sending rather than emailing a blank digest.
  • Swap Gmail for a proper email service (Brevo, Mailchimp, ConvertKit) if you're sending to a large list — Gmail's daily send limits fit well under ~500 recipients per day on Workspace, less on free Gmail.

Questions about this template

$19one-time

Secure checkout via Polar. Delivered by email instantly.

Structurally validated: automatically checked for valid n8n format before every deploy.

Difficulty
Medium
Setup time
~20 min
Integrations
3
Node count
7
Format
.json + guide