Automate LinkedIn Posts with Claude AI, DALL-E Images & Google Sheets Approval

How it works

This workflow automates your entire LinkedIn content strategy, from ideation to publishing.

• Daily Idea Generation: Every day, the workflow uses an advanced AI agent (Anthropic's Claude model) to generate a new, viral-optimized LinkedIn post idea, complete with a title, full text, and a detailed image description. It analyzes your past posts from a Google Sheet to ensure content is fresh and aligns with one of your four content pillars: timeless principles, case studies, growth hacks, or controversial ads.
• AI Image Creation: It then uses OpenAI's DALL-E to create a custom, high-quality image based on the generated description and a style reference image you provide, ensuring brand consistency.
• Review & Approval Workflow: The generated post and its accompanying image are automatically saved as a new row in a Google Sheet, marked with a "review" status. This gives you full editorial control.
• Automated Publishing: Once you approve a post by changing its status to "ready" in the Google Sheet, a separate part of the workflow picks it up and automatically publishes it to your LinkedIn profile at a scheduled time.
• Status Tracking: After publishing, the workflow updates the status in your Google Sheet to "posted," so you always have a clear overview of your content pipeline.

Set up steps

This workflow integrates several services. Follow these steps to get it running:

1. Copy the Google Sheet: Make a copy of the AI Posts Content Machine Google Sheet template and select your copy in the Get Past Ideas, Save Post, Get Ready Posts, and Update Status nodes.
2. Set Up Credentials: You will need to create and add API credentials for the following services within the corresponding n8n nodes:
   • Google Sheets & Google Drive: Create a Google credential.
   • Anthropic: Add your API key in the Anthropic Chat Model node.
   • OpenAI: Add your API key as a Header Auth credential in the OpenAI Image node.
   • Perplexity AI: Add your API key as a Header Auth credential inside the Perplexity Research sub-workflow.
   • LinkedIn: Create a LinkedIn credential.
3. Customize Your Content:
   • In the Idea Generator node, adjust the system prompt to reflect your specific audience, topics, and content style.
   • Create a folder in Google Drive for your post images. Add a reference image to this folder that defines your desired visual style.
   • Paste the shareable link to your style reference image into the Image Style node.
4. Activate the Workflow: Enable the workflow to start the automated content creation and publishing process.