n8n OpenAI LinkedIn & WordPress Automation with Sheets

Turn one content request into an OpenAI-written LinkedIn post or WordPress draft—complete with an AI thumbnail and Sheets-tracked approval

This n8n workflow collects your content brief, uses OpenAI to generate a LinkedIn post or a WordPress blog (plus a matching thumbnail), saves everything to Google Sheets/Drive for tracking, and publishes on approval via a webhook.

What this workflow does

• Collects a brief via an n8n form with the chosen format, categories, tone, topic source, and thumbnail preferences.
• Generates content with OpenAI (gpt-4o-mini) as structured JSON, including:
  • Title
  • HTML body
  • Plain-text copy
  • Hashtags/keywords
  • An image prompt for the thumbnail
• Creates a thumbnail with OpenAI (gpt-image-1), converts it to base64 for preview, and uploads the image to Google Drive.
• Tracks the draft in Google Sheets by appending metadata such as a unique contentId, status, and the Drive file ID.
• Displays a styled preview page embedding the thumbnail and content, with a publish button that triggers a webhook.
• Publishes on approval:
  • The publish webhook checks Google Sheets; if the draft status isn’t READY, it stops with an “already processed/invalid” response.
  • Otherwise, it downloads the thumbnail from Google Drive and:
    • Publishes to LinkedIn with the image, or
    • Creates a WordPress draft using the WordPress REST API, uploading the media and setting it as the featured image.
• Marks the draft as PROCESSED in Google Sheets and returns a confirmation response.

Use cases

• SaaS marketing teams generating consistent LinkedIn posts from standardized briefs.
• Operators producing weekly WordPress drafts with an AI thumbnail and a human approval step.
• Automation engineers needing an n8n workflow that ties OpenAI, Google Sheets tracking, and publishing to LinkedIn/WordPress.

Technical details

• n8n nodes/workflow logic: if, set, form, switch, webhook, and a workflow that calls LinkedIn-related publishing steps.
• OpenAI integrations: gpt-4o-mini for structured JSON content generation; gpt-image-1 for thumbnail creation.
• Storage & tracking: Google Sheets (status/contentId/Drive file ID) and Google Drive (thumbnail upload/download).
• Publishing targets: LinkedIn publishing with image, and WordPress via the WordPress REST API to create draft posts with featured media.