Auto-generate & schedule LinkedIn posts from Google Sheets with GPT-4o

Target audience

Solo creators, PMs, and content teams who queue LinkedIn ideas in Google Sheets and want them posted on a fixed schedule with AI-generated copy.

How it works

The workflow runs on a schedule (Mon/Wed/Fri at 09:30). It pulls the first Google Sheet row with Status = Pending, generates a LinkedIn-ready post from Post title using an OpenAI prompt, publishes to your LinkedIn profile, then updates the same row to Done and writes the final post back to the sheet.

Prerequisites (use your own credentials)

Google Sheets (OAuth2) with access to the target sheet LinkedIn OAuth2 tied to the account that should post — set the person field to your profile’s URN in the LinkedIn node OpenAI API key for the Chat Model node Store secrets in n8n Credentials. Never hard-code keys in nodes.

Google Sheet structure (exact columns)

Minimum required columns