Back to Templates

Automate Weekly US Trademark Reports with USPTO API and Google Drive CSV Export

Created by

Created by: iamvaar || iamvaar

iamvaar

Last update

Last update 2 days ago

Categories

Share


Title:
⚙️ Deep Dive: Automating Weekly US Trademark Reports with n8n, RapidAPI & Google Drive (No-Code Workflow)


Full Breakdown Post:

In this in-depth walkthrough, we're exploring a powerful no-code automation built entirely using n8n, that automatically fetches the latest US trademark registrations every 7 days, saves them to a CSV, and uploads that file to your Google Drive — no manual effort required.

Whether you're a startup founder, legal tech builder, or data analyst, this type of automation can save you hours every week and give you a real-time pulse on newly registered trademarks in the US.


⚙️ What This Workflow Does:

Every week, the workflow automatically:

  1. Triggers on a schedule

  2. Calculates the date range (today and 7 days prior)

  3. Fetches trademark data from the USPTO via a RapidAPI endpoint

  4. Splits the API response into individual rows

  5. Converts it into a CSV file

  6. Uploads the file to Google Drive with a dynamic name like:

    Active TM (2025-07-29 - 2025-08-05).csv
    

🔍 Node-by-Node Breakdown


1. Schedule Trigger

  • Node: Schedule Trigger
  • Purpose: Starts the workflow every 7 days

2. Date & Time

  • Node: Date & Time
  • Purpose: Captures the current timestamp in ISO format to use for calculations.

3. Manual (Set Start & End Dates)

  • Node: Set

  • Purpose: Assigns two dynamic values:

    • Start_Date: Current date minus 7 days
    • End_Date: Current date (today)

4. HTTP Request: Get Trademark Data

  • Node: HTTP Request
  • Method: POST

This returns an array of trademark records from USPTO's database that were registered in the past week.


5. Split the Array into Items

  • Node: Code

This takes the results array from the HTTP response and flattens it so that each trademark record becomes its own item in n8n's context.


6. Convert to CSV File

  • Node: Convert to File
  • File Name: test.csv (you can change this dynamically if needed)

This node takes all the individual trademark JSON objects and generates a CSV file out of them.


7. Upload to Google Drive

  • Node: Google Drive

  • Folder ID: Your target folder’s ID

  • Dynamic Name:

    =Active TM ({{ $('Manual').item.json.Start_Date }} - {{ $('Manual').item.json.End_Date }})
    

This uploads the generated CSV file directly into your specified Google Drive folder with the correct name and date range.


🧠 Why This is Powerful

  • Zero maintenance once configured
  • Always fresh trademark data weekly
  • Ideal for market research, brand monitoring, IP tracking
  • Fully serverless... all you need is n8n, a RapidAPI key, and Google Drive access

🛡️ Disclaimer

DISCLAIMER: THIS IS FOR EDUCATIONAL PURPOSES ONLY. THE CREATOR IS NOT LIABLE FOR ANY LOSSES OR DAMAGES CAUSED BY MISUSE OF THIS WORKFLOW.


🚀 Final Thoughts

With this one workflow, you're building a production-grade automation pipeline that would otherwise take a full dev sprint to manually script and deploy.

Use it, extend it, and plug it into other workflows like:

  • Auto-emailing the report
  • Pushing to Google Sheets
  • Generating insights via AI

n8n is your playground — this is just the beginning.