{"product_id":"ai-weekly-newsletter-automation-in-n8n-sheets-tavily-openrouter","title":"AI Weekly Newsletter Automation in n8n: Sheets + Tavily + OpenRouter","description":"\u003ch3\u003eAutomate your weekly newsletter end-to-end in n8n—research with Tavily, write with OpenRouter (OpenAI), and email it from Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically finds (or selects) a newsletter topic, gathers three recent news results via \u003cstrong\u003eTavily\u003c\/strong\u003e, drafts a complete three-section newsletter with \u003cstrong\u003eOpenRouter (OpenAI) models\u003c\/strong\u003e, formats it as HTML, and sends it to your subscriber list through \u003cstrong\u003eGmail\u003c\/strong\u003e—every week.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a weekly schedule\u003c\/strong\u003e using a schedule trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads Google Sheets\u003c\/strong\u003e for rows where \u003cem\u003eAction = \"Generate\"\u003c\/em\u003e and uses the provided \u003cem\u003eNewsletter Topic\u003c\/em\u003e when present.\u003c\/li\u003e\n  \u003cli\u003eIf no manual topic is provided, it \u003cstrong\u003esearches Reddit via Tavily\u003c\/strong\u003e and uses an \u003cstrong\u003eOpenRouter (OpenAI) model\u003c\/strong\u003e to pick a \u003cstrong\u003esingle\u003c\/strong\u003e newsletter topic, then writes that topic back to Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates a unique hex ID\u003c\/strong\u003e, updates the queued row in Google Sheets with the ID\/source, and performs \u003cstrong\u003eTavily research\u003c\/strong\u003e to fetch \u003cstrong\u003ethree recent news results\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eUses \u003cstrong\u003eOpenRouter (OpenAI)\u003c\/strong\u003e to plan an \u003cstrong\u003eissue title\u003c\/strong\u003e and \u003cstrong\u003eexactly three\u003c\/strong\u003e section topics, then runs \u003cstrong\u003eTavily searches per topic\u003c\/strong\u003e and writes each section with citations.\u003c\/li\u003e\n  \u003cli\u003eMerges the sections into an \u003cstrong\u003eemail-ready subject and body\u003c\/strong\u003e, saves the final title\/content, and marks the row as \u003cstrong\u003eDONE ✅\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eConverts the newsletter to styled HTML\u003c\/strong\u003e, reads recipients from a separate Google Sheets leads file, and \u003cstrong\u003esends via Gmail\u003c\/strong\u003e with a short wait between messages.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eWeekly SaaS updates: generate consistent, cited newsletters for your users without manual research.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers: maintain a repeatable n8n pipeline that links queue management (Google Sheets) to publishing (Gmail).\u003c\/li\u003e\n  \u003cli\u003eOperators: batch-send newsletters to a subscriber list while tracking status in Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Google Sheets (read\/write), Gmail (send), OpenRouter (OpenAI models), Tavily (HTTP Header Auth).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow nodes:\u003c\/strong\u003e if, set, code, wait, gmail, merge.\u003c\/li\u003e\n  \u003cli\u003eKey logic: topic selection (manual or Reddit via Tavily), hex ID creation, three-result research, three-section planning\/writing, HTML conversion, and queued status updates.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45865754755251,"sku":"N8N-18394","price":45.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/lBMDQA_Ex2iB487K_B3vI_GjywbxEv.png?v=1787043722","url":"https:\/\/buyflowscripts.com\/products\/ai-weekly-newsletter-automation-in-n8n-sheets-tavily-openrouter","provider":"N8N Commerce","version":"1.0","type":"link"}