Turn a keyword list in Google Sheets into clear labels fast. It checks each term and flags if it includes a known software or tool name. Ideal for SEO and ads teams that need branded versus generic splits.

When you click run, the flow reads rows from your sheet, processes six keywords at a time, and adds a short pause to avoid API limits. An AI model from OpenAI reviews each keyword using a simple rule and returns a yes or no in a structured format. The result is written back to the Service? column next to the matching Number. The loop continues until all items are checked, so your sheet stays clean and complete.

Setup is simple. Connect Google Sheets and OpenAI, point to your sheet, and set a short delay that fits your API plan. Expect faster keyword research, fewer errors, and a clear view of brand terms for negative lists, campaign targeting, and reporting. Most teams can cut hours of manual review and make better choices with up to date data.

• Manual start for safe test runs before scaling
• Reads keywords directly from a chosen Google Sheets tab
• Processes six rows per batch with a loop until all rows are done
• Adds a short wait between batches to prevent API rate limiting
• Uses an OpenAI chat model to decide if a keyword includes a known software or tool name
• Parses AI output into a simple yes or no field using a structured parser
• Updates the Service? column in Google Sheets using the Number field to match rows

• Reduce manual review from 4 hours to 10 minutes for a 500 keyword list
• Automate up to 100 percent of brand vs generic checks
• Improve labeling accuracy by 90 percent with structured AI output
• Avoid API timeouts with controlled batch size and pauses
• Keep one source of truth by writing results back to Google Sheets

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Google Sheets and OpenAI. See the Tools Required section above for links to create accounts with these services.
3. Prepare your Google Sheet with columns named Number, Keyword, and Service?. Make sure Number is unique for each row.
4. Open the Google Sheets Read node. In the Credential to connect with dropdown, click Create new credential and follow the on screen steps to sign in with Google and grant access.
5. Open the Google Sheets Update node and create the same Google Sheets credential if prompted. Pick the same document and sheet tab used in the read node.
6. Open the OpenAI Chat Model node. In the Credential to connect with dropdown, click Create new credential. Create an API key in your OpenAI account and paste it in. Save the credential.
7. In the Google Sheets Read node, select your spreadsheet and the correct sheet tab. Confirm the fields include Number and Keyword.
8. In the Update node, confirm that Number maps to the row you want to update and Service? maps to {{$json.output.Isservice}}.
9. Check the Split in Batches node. Keep batch size at 6 or change it to match your OpenAI rate limits.
10. Open the Wait node and set a short delay between batches, such as 2 to 5 seconds, to prevent rate limits.
11. Click Test workflow. Watch a few rows update in the Service? column. If nothing updates, check column names, credentials, and that the sheet has data.
12. If you see rate limit errors, increase the wait time or reduce the batch size. If updates go to the wrong rows, verify the Number field values are unique and exactly match in both read and update steps.