n8n SEO Keyword Analysis and Filter Workflow

This n8n workflow automates the process of analyzing SEO keywords from a Google Sheet, classifying them using an AI model, and then filtering them based on specific criteria. It's designed to help SEO specialists efficiently manage and categorize keywords, ensuring only relevant ones are processed further.

What it does

This workflow performs the following key steps:

1. Triggers Manually: The workflow is initiated manually, allowing for on-demand analysis.
2. Reads Keywords from Google Sheet: It fetches SEO keywords from a specified Google Sheet.
3. Classifies Keywords with AI: Each keyword is sent to an OpenAI Chat Model for classification, determining if it's a "Brand" or "Non-Brand" keyword.
4. Filters Keywords: Keywords are then filtered based on their classification.
   • One branch processes "Brand" keywords.
   • Another branch processes "Non-Brand" keywords.
5. Aggregates Filtered Keywords: The filtered keywords from both branches are aggregated back into a single stream.
6. Extracts Data from File (Placeholder): A placeholder node for extracting data from a file is present, though not actively connected in the provided JSON. This suggests potential for future expansion to process file-based keyword lists.
7. Edits Fields (Placeholder): A placeholder node for editing fields is present, though not actively connected in the provided JSON. This suggests potential for future data manipulation.
8. Writes to Google Drive (Placeholder): A placeholder node for writing data to Google Drive is present, though not actively connected in the provided JSON. This suggests potential for future output to cloud storage.

Prerequisites/Requirements

• n8n Instance: A running n8n instance.
• Google Sheets Account: To store and retrieve your SEO keywords.
• OpenAI API Key: For the OpenAI Chat Model node to classify keywords.
• Google Drive Account (Optional, for future enhancements): If you plan to use the Google Drive node.

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 credential to allow n8n to read data from your spreadsheet.
   • OpenAI Chat Model: Provide your OpenAI API Key in the credentials for the OpenAI Chat Model node.
3. Configure Google Sheets Node:
   • Specify the Spreadsheet ID and Sheet Name where your SEO keywords are located.
   • Ensure your keywords are in a column that can be easily referenced (e.g., "Keyword").
4. Configure OpenAI Chat Model:
   • Review the prompt used for classification to ensure it aligns with your definition of "Brand" and "Non-Brand" keywords. Adjust if necessary.
5. Configure Filter Nodes:
   • The "If" node is configured to check the output of the OpenAI Chat Model. Verify the conditions match the expected output format of your AI classification (e.g., {{ $json.classification === 'Brand' }}).
6. Execute the Workflow: Click "Execute workflow" in the Manual Trigger node to run the analysis.
7. Review Results: After execution, you can inspect the output of the Aggregate node to see the classified and filtered keywords.

Note: The Extract from File, Edit Fields, and Google Drive nodes are currently disconnected placeholders. To use them, you would need to connect them into the workflow and configure their respective operations.