Quick overview
This workflow runs daily, reads unchecked slogans from Google Sheets, searches live USPTO trademark records via an Apify actor, and writes a risk verdict plus matching owner and serial number back to the sheet.
How it works
- Runs every day at 9:00 AM on a schedule trigger.
- Reads rows from a Google Sheets tab named “Slogans” where the “Verdict” column is empty.
- Processes each slogan one at a time and runs Magnova’s “USPTO Trademark Search” Apify actor to fetch up to 10 LIVE trademark records for the phrase.
- Compares the returned marks against the slogan and assigns a verdict of “RISK — live trademark match” for an exact match in IC 016/021/024/025, “CHECK — similar live mark” for phrase-containing matches in those classes, or “No live match found” otherwise.
- Updates the same Google Sheets row by matching on the “Slogan” column and writing the verdict, owner, and serial number.
Setup
- Create or choose a Google Sheet with columns Slogan, Verdict, Owner, and Serial (in a tab named “Slogans”) and add your Google Sheets credentials in n8n.
- Paste your Google Sheets document URL/ID into the Google Sheets nodes and confirm the correct sheet/tab is selected.
- Add your Apify API token credentials and ensure the workflow can run the actor ID I8KvtBliDeyVghVzU.
- (Optional) Adjust the schedule time, Apify maxResults, or maxTotalChargeUsd limit to fit your usage and cost controls.