Create daily AI news LinkedIn posts using OpenAI, NewsAPI, Gmail and Google Sheets

Quick overview

This workflow runs nightly, pulls AI news from NewsAPI, uses OpenAI to summarize and select a top story, generates a LinkedIn post and image, and emails you for approval before publishing to LinkedIn and logging the result to Google Sheets.

How it works

1. Runs every night at 8 PM using a schedule trigger.
2. Fetches the last day’s AI-related articles from NewsAPI, splits them into items, and keeps the top five most recent.
3. Uses OpenAI (gpt-4o-mini) to generate a strict two-sentence summary for each article and compiles a digest of the summarized articles.
4. Uses OpenAI (gpt-4o-mini) to choose the single best article for LinkedIn engagement from the digest and produce a post draft based on the selected story.
5. Uses OpenAI image generation (gpt-image-1-mini) to create a news-style square image to accompany the post, then emails a preview and sends an approval email that waits for your Approve/Reject response in Gmail.
6. If approved, publishes the post to LinkedIn, appends the approved content to a Google Sheets tab, and emails a success notification.
7. If rejected, appends the rejected content to a separate Google Sheets tab and emails a rejection notification.

Setup

1. Add a NewsAPI.org API key as an HTTP Query Auth credential and ensure it’s used by the NewsAPI request.
2. Add an OpenAI API credential with access to gpt-4o-mini (text) and gpt-image-1-mini (image).
3. Connect Gmail via OAuth2 and replace the recipient email address in the Gmail nodes with your own.
4. Connect LinkedIn via OAuth2 and set the correct LinkedIn person identifier for posting.
5. Connect Google Sheets, set the target spreadsheet and ensure it contains Approved and Rejected tabs with the columns Date, Title, Summary, LinkedIn Post, and Status.