Create Content Strategies with Dual AI Research Agents using SerpApi, GPT-4 & Sheets

Go to Workflow
0 views
Built by Marth - Business Automation Marth - Business Automation
Created on June 05, 2026

Description

How It Works ⚙️

This workflow is a comprehensive, two-AI-agent system that acts as a virtual research and content team. It automates the entire process of turning a single topic into an actionable content strategy.

AI Agent 1 (The Researcher): The workflow starts with a manual trigger where you input a research topic. An HTTP Request node then acts as the first agent, performing a web search (e.g., using a Google Search API) to gather the most relevant articles and data.
Data Aggregation: The raw data from the web search is then consolidated into a single, clean text block using a Function node. This makes the information digestible for the second AI agent.
AI Agent 2 (The Strategist): A second OpenAI node takes the aggregated data and acts as the strategist. It analyzes the content and uses a sophisticated prompt to generate a list of 5 specific and actionable content ideas.
Distribution & Notification: The generated ideas are then automatically sent to two separate destinations. Each idea is logged into a Google Sheets database, which serves as your content calendar. A Slack notification is also sent to your marketing team, immediately alerting them to the new ideas.

How to Set Up 🛠️

Import the Workflow: Copy the provided workflow JSON and import it into your n8n instance.
Configure Credentials:
Google Search: Add your API Key.
OpenAI: Add your API Key.
Google Sheets: Add your OAuth2 credential.
Slack: Add your Bot Token credential.
Customize Workflow Nodes:
Node 1 (Manual Trigger): You will input your research topic here to start the workflow.
Node 7 (Google Sheets): Replace [YOUR SPREADSHEET ID] and [YOUR SHEET NAME] with your own content calendar details.
Node 8 (Slack): Replace [YOUR SLACK CHANNEL ID] with the channel where your team receives marketing updates.
Save & Activate: Once all settings and credentials are configured, save the workflow and click the "Inactive" toggle in the top-right corner to make it live.

Nodes Used (4)

Code
n8n-nodes-base.code
Google Sheets
n8n-nodes-base.googleSheets
OpenAI
@n8n/n8n-nodes-langchain.openAi
Slack
n8n-nodes-base.slack