n8n Workflow: AI-Powered Ad Creation with Google Sheets, OpenAI, and HTTP Requests

This n8n workflow automates the process of generating content, likely for ads or social media reels, by leveraging data from Google Sheets and the power of OpenAI's language models. It includes conditional logic and HTTP requests, suggesting interaction with external services for content generation or publishing.

What it does

This workflow streamlines content generation and potentially publishing through the following steps:

1. Triggers on Chat Message: The workflow is initiated when a chat message is received, suggesting an interactive or command-driven start.
2. Fetches Data from Google Sheets: It reads data from a specified Google Sheet, likely containing prompts, ad parameters, or other source content.
3. Applies Conditional Logic: An If node evaluates the incoming data, allowing for different branches of the workflow based on specific conditions.
4. Generates Content with OpenAI: For items that pass the conditional check, it uses OpenAI to generate text-based content. This could be ad copy, reel scripts, or descriptions.
5. Performs HTTP Request: It makes an HTTP request, which could be used to send the generated content to another API (e.g., a video generation service like Veo3, or a social media publishing platform).
6. Includes a Wait Step: A Wait node is present, which might be used to introduce a delay between actions, possibly to respect API rate limits or allow time for external processes to complete.
7. Includes Sticky Notes: Sticky notes are present within the workflow, indicating areas for comments or documentation directly within the n8n canvas.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running n8n instance.
• Google Sheets Account: With access to the spreadsheet containing your data. You'll need to configure Google Sheets credentials in n8n.
• OpenAI API Key: For the OpenAI node to generate content. You'll need to configure OpenAI credentials in n8n.
• External API Endpoint: An endpoint for the HTTP Request node, depending on where you intend to send the generated content (e.g., a video creation API, a social media API).
• Chat Service: The Chat Trigger node implies integration with a chat service (e.g., Telegram, Slack, custom chat interface) that can send messages to n8n.

Setup/Usage

1. Import the workflow: Download the provided JSON and import it into your n8n instance.
2. Configure Credentials:
   • Google Sheets: Set up your Google Sheets OAuth2 or API key credentials.
   • OpenAI: Set up your OpenAI API Key credentials.
3. Configure Nodes:
   • Chat Trigger: Configure the Chat Trigger node to listen for messages from your desired chat service.
   • Google Sheets: Specify the Spreadsheet ID, sheet name, and the operation you want to perform (e.g., "Read Data").
   • If: Adjust the conditions in the If node to match your specific logic for routing data.
   • OpenAI: Configure the OpenAI node with the desired model, prompt, and any other parameters for content generation. You'll likely use expressions to dynamically insert data from previous nodes into the prompt.
   • HTTP Request: Configure the URL, method (e.g., POST), headers, and body of the HTTP request to interact with your external service.
   • Wait: Adjust the wait duration as needed.
4. Activate the Workflow: Once configured, activate the workflow to start processing chat messages and generating content.