This workflow automates the initial keyword research. It takes a topic and intent, gathers relevant keywords and metrics from Google, and compiles them into a Google Sheet for your review and approval.

✅ Prerequisites

Before running this workflow, ensure you have completed the setup in the Tooling & Prerequisites Guide:

• n8n is running.
• All credentials (Google OAuth, Telegram API, RapidAPI Header Auth) are configured in your n8n instance.
• Your Google Drive folder structure has been created.

🗺️ Workflow Schema

[Manual Start: Topic/Intent] -> [Create Google Sheet] -> [Fetch Keywords (Parallel)] -> [Merge & Format] -> [Update Sheet] -> [Limit Number of Items] -> [Notify User]

▶️ Input: How to Start the Workflow

This workflow is triggered manually.

1. Open the System: In n8n, open the file JSON file and find the workflow 1.
2. Set Topic and Intent: Find the node named Set Topic & Intent.
3. Enter Your Details: In the parameters, fill in the topic and intent values with your article idea. For example:
   • topic: ai tools
   • intent: informational article on how to choose AI tools
4. Execute: Click Execute Workflow near the “Trigger Manually” node to run it.

⚙️ Step-by-Step Breakdown