{"product_id":"daily-ai-news-linkedin-post-automation-newsapi-openai-sheets","title":"Daily AI News LinkedIn Post Automation (NewsAPI + OpenAI + Sheets)","description":"\u003ch3\u003eTurn nightly AI news into an approved LinkedIn post—automatically\u003c\/h3\u003e\n\u003cp\u003eThis Daily AI News LinkedIn Post Automation workflow pulls AI news every night, summarizes and selects the best story with OpenAI, drafts a LinkedIn post with a generated image, and emails it to you for approval before publishing—then logs results to Google Sheets.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eRuns nightly at 8 PM\u003c\/b\u003e using a schedule trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eFetches last day’s AI-related articles\u003c\/b\u003e from \u003cb\u003eNewsAPI\u003c\/b\u003e, splits results into items, and keeps the \u003cb\u003etop five most recent\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003eUses \u003cb\u003eOpenAI (gpt-4o-mini)\u003c\/b\u003e to produce a \u003cb\u003estrict two-sentence summary\u003c\/b\u003e for each article, then compiles a digest of those summaries.\u003c\/li\u003e\n  \u003cli\u003eUses \u003cb\u003eOpenAI (gpt-4o-mini)\u003c\/b\u003e again to \u003cb\u003echoose the single best article\u003c\/b\u003e for LinkedIn engagement from the digest and generates a \u003cb\u003epost draft\u003c\/b\u003e based on that selected story.\u003c\/li\u003e\n  \u003cli\u003eGenerates a \u003cb\u003enews-style square image\u003c\/b\u003e with \u003cb\u003eOpenAI image generation (gpt-image-1-mini)\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eEmail approval flow via Gmail\u003c\/b\u003e: sends a preview to you, then sends an approval email that waits for your \u003cb\u003eApprove\/Reject\u003c\/b\u003e response in Gmail.\u003c\/li\u003e\n  \u003cli\u003eIf \u003cb\u003eapproved\u003c\/b\u003e: publishes the post to \u003cb\u003eLinkedIn\u003c\/b\u003e, appends the approved content to a \u003cb\u003eGoogle Sheets\u003c\/b\u003e tab, and emails a success notification.\u003c\/li\u003e\n  \u003cli\u003eIf \u003cb\u003erejected\u003c\/b\u003e: appends the rejected content to a \u003cb\u003eseparate Google Sheets\u003c\/b\u003e tab and emails a rejection notification.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operators who want consistent LinkedIn presence without manually researching AI news each day.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building an AI-to-social publishing pipeline with human-in-the-loop approval.\u003c\/li\u003e\n  \u003cli\u003eTeams that need daily content logging for auditing, reporting, or iteration 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\u003cb\u003eNewsAPI\u003c\/b\u003e via HTTP Query Auth credential\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eOpenAI\u003c\/b\u003e: \u003cb\u003egpt-4o-mini\u003c\/b\u003e (text) and \u003cb\u003egpt-image-1-mini\u003c\/b\u003e (image)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eGmail\u003c\/b\u003e integration using OAuth2 for preview + Approve\/Reject handling\u003c\/li\u003e\n  \u003cli\u003eCore n8n logic uses nodes including \u003cb\u003eif\u003c\/b\u003e, \u003cb\u003eset\u003c\/b\u003e, \u003cb\u003ecode\u003c\/b\u003e, \u003cb\u003egmail\u003c\/b\u003e, \u003cb\u003elimit\u003c\/b\u003e, and \u003cb\u003emerge\u003c\/b\u003e, plus Google Sheets logging\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45850427588787,"sku":"N8N-18307","price":6.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/JHByRTBAVqZQRDg-NpXiH_vochxhEG.png?v=1786870880","url":"https:\/\/buyflowscripts.com\/products\/daily-ai-news-linkedin-post-automation-newsapi-openai-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}