Generate Influencer Posts with GPT-4, Google Sheets, and Media APIs

This n8n workflow automates the process of generating influencer social media posts using AI, managing data in Google Sheets, and potentially interacting with media APIs. It's designed to streamline content creation for influencer marketing campaigns.

What it does

This workflow, once triggered, performs the following key steps:

1. Triggers on Form Submission: Initiates the workflow when a form is submitted, likely containing details for a new influencer post generation request.
2. Extracts Data from File: Processes a file, possibly a spreadsheet or CSV, to extract relevant data for the influencer posts.
3. Aggregates Data: Combines and structures the extracted data into a usable format for the AI agent.
4. Generates Content with AI Agent: Utilizes an AI Agent (likely GPT-4 via OpenAI) to generate social media post content based on the aggregated data.
   • AI Chat Model: Specifies the use of an OpenAI Chat Model (e.g., GPT-4) for content generation.
   • Think Tool: Incorporates a "Think" tool, suggesting the AI agent performs internal reasoning or planning before generating the final output.
   • Structured Output Parser: Ensures the AI's output is parsed into a predefined structured format (e.g., JSON), making it easy to use in subsequent steps.
5. Splits Out Data: Deconstructs the structured AI output into individual items for further processing.
6. Filters Data: Applies conditions to filter the generated posts, potentially based on content quality, keywords, or other criteria.
7. Merges Data: Combines filtered data, possibly integrating it with original input or other generated elements.
8. Interacts with Google Sheets: Reads from or writes to Google Sheets, likely to update the status of post generation, store generated content, or retrieve influencer details.
9. Makes HTTP Requests: Executes HTTP requests, which could be used to interact with various media APIs (e.g., image generation, video platforms, social media publishing APIs) to enrich or publish the generated content.
10. Executes Sub-workflow: Calls another n8n workflow, allowing for modularity and reuse of common functionalities.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running instance of n8n.
• OpenAI API Key: For the AI Agent and OpenAI Chat Model nodes to generate content.
• Google Account: With access to Google Sheets for data management. You will need to configure Google Sheets credentials in n8n.
• Credentials for any Media APIs: If the HTTP Request node is used to interact with specific media platforms (e.g., Instagram, TikTok, YouTube), you will need the appropriate API keys or authentication tokens.

Setup/Usage

1. Import the workflow: Download the JSON provided and import it into your n8n instance.
2. Configure Credentials:
   • Set up your OpenAI API Key credential in n8n.
   • Configure your Google Sheets credential (OAuth2 is recommended for Google services).
   • Add any necessary HTTP Request credentials for external media APIs.
3. Customize Nodes:
   • On form submission: Configure the form fields to match your input requirements.
   • Extract from File: Adjust the file extraction settings (e.g., file format, column mappings).
   • AI Agent: Review and adjust the prompt, tools, and model settings to fine-tune content generation.
   • Structured Output Parser: Ensure the schema matches the expected output format from your AI agent.
   • Filter: Define your filtering logic and conditions.
   • Google Sheets: Specify the spreadsheet ID, sheet name, and operations (e.g., append row, update row) as needed.
   • HTTP Request: Configure the URLs, headers, and body for any external API calls.
   • Execute Sub-workflow: Select the sub-workflow you wish to call and map the input data.
4. Activate the workflow: Once configured, activate the workflow to start automating your influencer post generation.