Automate LinkedIn Posts with OpenAI & Google Sheets in n8n

Revolutionize Your LinkedIn Strategy with OpenAI & Google Sheets Automation

Supercharge your LinkedIn content strategy with an intelligent automation workflow that harnesses the power of OpenAI and Google Sheets in n8n. Seamlessly generate compelling LinkedIn post ideas, craft visually appealing editorial images, and automate the entire publishing process to elevate your LinkedIn presence effortlessly.

What this workflow does

• Scheduled Reading: On a predefined schedule, the workflow reads past LinkedIn post ideas from Google Sheets, using recent topics for contextual inspiration.
• Content Generation: Utilizes an OpenAI chat model to create a fresh LinkedIn post concept in JSON format, which is then parsed into structured fields for clarity and precision.
• Image Creation: Downloads a reference image from Google Drive and employs OpenAI to generate a new editorial image fitting the 4:5 ratio, storing the final image back in Google Drive for consistency.
• Data Management: Appends both the newly generated post content and image link to a Google Sheets "LinkedIn posts" sheet, noting them as ready for publication.
• Automated Posting: On a separate schedule, the workflow retrieves the ready posts from Google Sheets, downloads their images, and publishes the content directly to your LinkedIn organization while updating the spreadsheet status to posted.

Use cases

• Marketing Teams: Automate your content pipeline to keep your LinkedIn feed active with minimal manual intervention.
• SaaS Operators: Enhance your brand's social media strategy by effortlessly maintaining a consistent flow of innovative LinkedIn posts.
• Automation Engineers: Showcase the power of integration by streamlining cross-platform operations from content creation to social media publishing.

Technical details

• Tools Used: n8n, OpenAI, Google Sheets, Google Drive
• Nodes Utilized: set, code, wait, limit, merge, filter
• Requirements: OpenAI credentials with access to GPT-4.1 and GPT-image-1-mini models, Google Sheets and Drive OAuth connections