Fetch keyword from Google Sheet and classify them using AI

Who is this template for

This template is for marketers, SEO specialists, or content managers who need to analyze keywords to identify which ones contain references to a specific area or topic, in this case – IT software, services, tools, or apps.

Use case

Automating the process of scanning a large list of keywords to determine if they reference known IT products or services (like ServiceNow, Salesforce, etc.), and updating a Google Sheet with this classification. This helps in categorizing keywords for targeted SEO campaigns, content creation, or market analysis.

How this workflow works

1. Fetches keyword data from a Google Sheet 2. Processes keywords in batches to prevent rate limiting 3. Uses an AI agent (OpenAI) to analyze each keyword and determine if it contains a reference to an IT service/software 4. Updates the original Google Sheet with the results in a "Service?" column 5. Continues processing until all keywords are analyzed

Set up steps

1. Connect your Google Sheets account credentials 2. Set the Google Sheet document ID (currently using "Copy of Sheet1 1") 3. Configure the OpenAI API credentials for the AI agent 4. Adjust the batch size (currently 6) if needed based on your API rate limits 5. Ensure the Google Sheet has the required columns: "Number", "Keyword", and "Service?"