Create and schedule LinkedIn posts from Google Sheets with Gemini and DALL·E

Overview This n8n automation is a complete LinkedIn Content Engine that turns simple topic ideas into fully written, visual, and scheduled posts. It features a "Human-in-the-Loop" design, meaning AI handles the heavy lifting of writing and image creation, but nothing goes live until you manually approve it in Google Sheets.

How It Works The system runs two separate workflows in parallel:

1. The "Creator" Workflow

Input: Detects when you add a new topic to your "Content Calendar" Google Sheet.

Brand Alignment: Pulls your specific "Brand Voice" guidelines from a separate tab to ensure the AI sounds like you.

Creation: Uses Gemini Flash 1.5 to write the post and DALL-E 3 to generate a matching professional image.

Drafting: Uploads the image to ImgBB and saves the full draft back to your sheet with a status of "Draft."

2. The "Publisher" Workflow