AI Content Generation Factory with Google Sheets & OpenAI - n8n Workflow

• Content Marketing Managers needing to scale AI content creation.


• Agencies handling large volumes of guest post outreach.


• Developers looking for advanced examples of OpenAI and Google Sheets integration within an n8n workflow.


• Anyone seeking effective n8n templates for data-driven content automation.

This powerful n8n workflow template solves the problem of manual content creation and tracking. By using Google Sheets as the central management system, users can queue up hundreds of topics, notes, and desired statuses. The automation uses a scheduled or manual n8n trigger to scan the sheet, identify tasks marked 'Start', and dynamically generate unique, targeted content via the OpenAI API. This workflow not only generates the content but also ensures seamless data logging and status updates back to the source sheet, providing a clean, end-to-end automation cycle. This is an essential n8n node setup for high-throughput content factories.

The automated process initiates via a manual Start n8n trigger. First, the workflow uses a Google Sheets n8n node to perform a lookup operation, reading all pending content tasks from the 'Planning' tab. Next, an If n8n node filters these incoming items, ensuring that only rows where the 'Status' column equals 'Start' proceed down the main path of the n8n workflow. A subsequent Set n8n node formats a detailed prompt, injecting the 'Topic' and 'Note' fields from the sheet data into the required structure (in this specific case, requesting the post in German). The prepared prompt is then sent to the OpenAI n8n node which utilizes the text-davinci-003 model to generate the guest post content. Upon successful generation, a Google Sheets n8n node appends the resulting AI text to the 'Generated' tab for archival. Finally, the last Google Sheets n8n node updates the status of the original row in the 'Planning' sheet to 'Finished', ensuring that this specific task is not reprocessed by the n8n workflow on future executions.

1. Import the n8n workflow: Copy the provided JSON and import it into your n8n instance using the 'Import from JSON' option.


2. Set up Google Sheets Credentials: The workflow requires credentials for two Google Sheets n8n nodes. Ensure you have an active Google Sheets OAuth2 API credential linked and select it for the 'Read Planning Sheet,' 'Save Post to Sheet,' and 'Mark as Finished' nodes.


3. Set up OpenAI Credentials: The 'OpenAI - Generate Post' n8n node requires an OpenAI API key. Create a new credential or select an existing one.


4. Prepare Your Google Sheet: Ensure your spreadsheet (ID: 1PiygWwVov4WzA8qvUOaZ9N1G9JgtgmpYy0w8ty3CHd0) has two tabs: 'Planning' (with columns like Topic, Note, Status) and 'Generated'.


5. Test the n8n trigger: Manually execute the Start n8n trigger after setting a row's status to 'Start' in your Planning sheet.

Start Trigger (n8n trigger): A manual n8n trigger used to initiate the workflow run.
Read Planning Sheet (Google Sheets n8n node): Function is to look up data from the range Planning!A1:E1000, fetching all potential content tasks.
Filter Status = Start (If n8n node): A core logic n8n node that filters incoming items, allowing only those where the 'Status' column value is exactly 'Start' to proceed for generation.
Format Prompt (Set n8n node): Dynamically constructs the input prompt for the AI, embedding Topic and Note variables to ensure customized output. This is crucial for guiding the OpenAI n8n node.
OpenAI - Generate Post (OpenAI n8n node): Sends the custom prompt to the text-davinci-003 model to generate the guest post content with a max token limit of 1000 and a temperature of 0.7.
Save Post to Sheet (Google Sheets n8n node): Appends the newly generated content to the 'Generated' sheet, logging the result of the n8n workflow step.

• Mark as Finished (Google Sheets n8n node): Updates the 'Status' column in the original 'Planning' sheet for the corresponding rowIndex to 'Finished', completing the lifecycle tracked within this robust n8n workflow.