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.
Every week, the workflow automatically:
Triggers on a schedule
Calculates the date range (today and 7 days prior)
Fetches trademark data from the USPTO via a RapidAPI endpoint
Splits the API response into individual rows
Converts it into a CSV file
Uploads the file to Google Drive with a dynamic name like:
Active TM (2025-07-29 - 2025-08-05).csv
Schedule Trigger
Date & Time
Node: Set
Purpose: Assigns two dynamic values:
Start_Date
: Current date minus 7 daysEnd_Date
: Current date (today)HTTP Request
This returns an array of trademark records from USPTO's database that were registered in the past week.
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.
Convert to File
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.
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.
DISCLAIMER: THIS IS FOR EDUCATIONAL PURPOSES ONLY. THE CREATOR IS NOT LIABLE FOR ANY LOSSES OR DAMAGES CAUSED BY MISUSE OF THIS WORKFLOW.
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:
n8n is your playground — this is just the beginning.