Create researched newsletter drafts from Google Sheets with Tavily, OpenAI, and MailerLite
n8n · Marketing · checked 2026-10-29
Quick overview This workflow runs weekly, reads a Google Sheets newsletter calendar to pick one due “Ready” topic, researches it with Tavily, drafts a three-section HTML newsletter using OpenAI and optional Gemini image analysis, then creates a draft campaign in MailerLite and writes the campaign ID back to the sheet. How it works Runs weekly on a schedule. Reads rows from a Google Sheets calendar and selects the earliest topic that is marked Ready, due today or earlier (UTC), and has no Campaign ID. Marks the selected row as In progress in Google Sheets and uses Tavily to research the main newsletter topic. Uses OpenAI to generate a newsletter title and exactly three section topics based on the Tavily sources.
At a glance
- Brand
- n8n
- Jobs
- Marketing
- Sources
- 1
Dimensions
- Brands: n8n
- Agents: n8n · Visit via /go/
- Occupations: Marketing
- Industries: cross-industry
- Tasks: research, drafting, inbox
Sources
- https://n8n.io/workflows/21833 · fetched 2026-10-29 — “Quick overview This workflow runs weekly, reads a Google Sheets newsletter calendar to pick one due “Ready” topic, researches it with Tavily, drafts a three-section HTML newsletter”
Last checked 2026-10-29. Description source: harvest.