n8n LinkedIn Content Factory: Auto-Generate Posts with GPT-5, DALL-E & Google Sheets

This n8n workflow automates the creation and management of LinkedIn content. It leverages the power of Google Sheets for content scheduling, OpenAI (GPT-5) for generating post text, and OpenAI (DALL-E) for creating accompanying images. The workflow ensures a consistent content pipeline for your LinkedIn presence.

What it does

This workflow performs the following key steps:

1. Schedules Content Generation: Triggers on a predefined schedule (e.g., daily, weekly) to check for new content requests.
2. Reads Content Requests from Google Sheets: Fetches data from a specified Google Sheet, likely looking for new rows marked for content generation.
3. Generates Post Text with OpenAI (GPT-5): Uses the OpenAI node to generate compelling LinkedIn post text based on prompts or data from the Google Sheet.
4. Generates Images with OpenAI (DALL-E): Utilizes the OpenAI node again to create relevant images for the LinkedIn posts, based on descriptions or themes from the generated text or Google Sheet.
5. Combines Text and Image Data: Merges the generated text and image information into a single data structure.
6. Uploads Images to Google Drive: Stores the generated images in a designated Google Drive folder for archival or further use.
7. Updates Google Sheet: Marks the processed rows in the Google Sheet, potentially adding links to the generated image or the post content.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running instance of n8n.
• Google Sheets Account: With a spreadsheet set up to manage content requests (e.g., columns for topic, status, generated text, image URL).
• Google Drive Account: For storing the generated images.
• OpenAI API Key: With access to GPT-5 (for text generation) and DALL-E (for image generation).
• n8n Credentials: Configured for Google Sheets, Google Drive, and OpenAI.

Setup/Usage

1. Import the Workflow: Download the provided JSON and import it into your n8n instance.
2. Configure Credentials:
   • Set up your Google Sheets credential.
   • Set up your Google Drive credential.
   • Set up your OpenAI credential with your API key.
3. Configure Nodes:
   • Schedule Trigger: Adjust the schedule to your desired frequency for checking new content requests.
   • Google Sheets (Read):
     • Specify the Spreadsheet ID and Sheet Name where your content requests are located.
     • Configure the read operation to fetch new or pending content requests.
   • OpenAI (GPT-5):
     • Configure the "Chat" model (or "Completions" if using an older version) to generate LinkedIn post text.
     • Craft effective prompts using data from the Google Sheet (e.g., {{ $json.topic }}) to guide the AI.
   • OpenAI (DALL-E):
     • Configure the "Image" model to generate images.
     • Use prompts based on the generated text or original topic to create relevant visuals.
   • Google Drive (Upload):
     • Specify the Folder ID where the generated images should be saved.
     • Map the image data from the OpenAI node to the upload operation.
   • Google Sheets (Update):
     • Configure this node to update the status of the processed rows in your Google Sheet.
     • Add columns for the generated text and the Google Drive image URL.
4. Activate the Workflow: Once configured, activate the workflow to start automating your LinkedIn content generation.