This workflow automates the process of creating and publishing engaging LinkedIn posts with AI-generated images, sourced from Google Sheets entries. It begins with a Google Sheets trigger that monitors a specific sheet for new or pending post entries. If a post’s status is ‘pending’, the workflow continues to generate a tailored LinkedIn post using an AI language model, which crafts a compelling message based on a given title.

Next, an image is created based on the post content using Google’s Gemini AI. The image depicts a modern workspace with coding and Flutter development themes, designed to be visually appealing for social media. The image is uploaded to Google Drive and shared publicly, then linked back to the spreadsheet for record-keeping.

Finally, the workflow makes an authenticated request to LinkedIn’s API, uploading the image and the generated post content to publish the update on LinkedIn. Once posted, the status in the Google Sheet is updated to ‘posted’, completing the automation loop.

This workflow is particularly useful for social media teams and content creators looking to streamline their content publishing process, ensuring regular, AI-enhanced updates with minimal manual effort.

Node Count	11 – 20 Nodes
Nodes Used	@n8n/n8n-nodes-langchain.agent, @n8n/n8n-nodes-langchain.googleGemini, @n8n/n8n-nodes-langchain.lmChatGoogleGemini, @n8n/n8n-nodes-langchain.outputParserStructured, code, googleDrive, googleSheets, googleSheetsTrigger, httpRequest, if, limit