{"product_id":"n8n-newsletter-automation-google-sheets-tavily-openai","title":"n8n Newsletter Automation: Google Sheets + Tavily + OpenAI","description":"\u003ch3\u003eWeekly newsletter drafts, automated end-to-end with Google Sheets, Tavily, and OpenAI\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically selects the next “Ready” newsletter topic from your Google Sheets calendar, researches it with \u003cstrong\u003eTavily\u003c\/strong\u003e, drafts a \u003cstrong\u003ethree-section HTML newsletter\u003c\/strong\u003e with \u003cstrong\u003eOpenAI\u003c\/strong\u003e, and creates a \u003cstrong\u003edraft campaign in MailerLite\u003c\/strong\u003e—then writes the campaign ID back to the sheet.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns weekly on a schedule\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads your Google Sheets newsletter calendar\u003c\/strong\u003e and picks the earliest row marked \u003cem\u003eReady\u003c\/em\u003e that is due today or earlier (UTC) and has \u003cem\u003eno Campaign ID\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003eMarks the selected row as \u003cstrong\u003eIn progress\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eUses \u003cstrong\u003eTavily\u003c\/strong\u003e to research the main newsletter topic.\u003c\/li\u003e\n  \u003cli\u003eUses \u003cstrong\u003eOpenAI\u003c\/strong\u003e to generate a newsletter title and \u003cstrong\u003eexactly three section topics\u003c\/strong\u003e based on the Tavily sources.\u003c\/li\u003e\n  \u003cli\u003eFor each section, performs a focused \u003cstrong\u003eTavily\u003c\/strong\u003e search and uses \u003cstrong\u003eOpenAI\u003c\/strong\u003e to write the section with \u003cstrong\u003eone cited source URL\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOptionally\u003c\/strong\u003e calls \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to evaluate user-provided image URLs and pick one image.\u003c\/li\u003e\n  \u003cli\u003eValidates and renders the result into \u003cstrong\u003eplain HTML\u003c\/strong\u003e, then creates a \u003cstrong\u003edraft campaign\u003c\/strong\u003e in \u003cstrong\u003eMailerLite\u003c\/strong\u003e for the specified \u003cstrong\u003eAudience Group ID\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eWrites the \u003cstrong\u003eMailerLite Campaign ID\u003c\/strong\u003e back to Google Sheets and updates the row status to \u003cstrong\u003eDraft\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eTurn a weekly content calendar into automatic, on-time newsletter drafts without manual research.\u003c\/li\u003e\n  \u003cli\u003eSaaS teams maintaining consistent publishing workflows across topics, with status tracking in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers who want a clear n8n pipeline connecting Google Sheets, Tavily research, OpenAI writing, and MailerLite drafts.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e for scheduling data: Content ID, Topic, Planned Date, Status, Audience Group ID, Image URLs, Campaign ID.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTavily\u003c\/strong\u003e for web research (main topic + per-section searches).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI\u003c\/strong\u003e for newsletter title and three-section HTML generation.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOptional\u003c\/strong\u003e \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e image evaluation.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMailerLite\u003c\/strong\u003e draft campaign creation and Campaign ID write-back to the sheet.\u003c\/li\u003e\n  \u003cli\u003en8n nodes include \u003cstrong\u003eSet\u003c\/strong\u003e, \u003cstrong\u003eCode\u003c\/strong\u003e, \u003cstrong\u003eHTTP Request\u003c\/strong\u003e, and \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (with batch splitting).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46326520086707,"sku":"N8N-21833","price":37.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/P8yz-6B3u7wbrp9oOF0GT_nKCEkGWH.png?v=1793351255","url":"https:\/\/buyflowscripts.com\/products\/n8n-newsletter-automation-google-sheets-tavily-openai","provider":"N8N Commerce","version":"1.0","type":"link"}