See llms.txt for all machine-readable content.

Back to Templates

Check print-on-demand slogans for USPTO trademarks with Google Sheets and Apify

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

  1. Runs every day at 9:00 AM on a schedule trigger.
  2. Reads rows from a Google Sheets tab named “Slogans” where the “Verdict” column is empty.
  3. 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.
  4. 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.
  5. Updates the same Google Sheets row by matching on the “Slogan” column and writing the verdict, owner, and serial number.

Setup

  1. 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.
  2. Paste your Google Sheets document URL/ID into the Google Sheets nodes and confirm the correct sheet/tab is selected.
  3. Add your Apify API token credentials and ensure the workflow can run the actor ID I8KvtBliDeyVghVzU.
  4. (Optional) Adjust the schedule time, Apify maxResults, or maxTotalChargeUsd limit to fit your usage and cost controls.