Weekly USPTO Trademark Reports to Google Drive CSV
Automates weekly fetching of US trademark data via USPTO API, generates CSV reports, and uploads to Google Drive. Saves hours of manual research for legal and market analysts.
This n8n workflow automates the retrieval of the latest US trademark registrations from the USPTO API every 7 days using RapidAPI. It calculates a dynamic date range (past 7 days to today), fetches the data via POST request, processes the response into individual records, formats them into a CSV file with a timestamped name like 'Active TM (2025-07-29 - 2025-08-05).csv', and uploads it directly to your Google Drive.
Key benefits include eliminating manual data collection, ensuring consistent weekly insights without effort, and providing ready-to-analyze CSV files for tools like Excel or Google Sheets. It's ideal for startup founders monitoring competitors, legal professionals tracking new filings, data analysts in market research, or anyone needing real-time pulses on US trademarks.
The workflow features a Schedule Trigger for reliability, Date & Time nodes for precise ranges, HTTP Request for API integration, data splitting and formatting logic, and seamless Google Drive upload. No coding required—setup credentials for RapidAPI and Google Drive, and it runs autonomously, scaling effortlessly for business intelligence needs.
New buyers can create an account from the cart to unlock a controlled $10 first-purchase credit on eligible orders of $25+.
Secure checkout powered by Stripe
Tags
Support
How to import this workflow into n8n
- 1Purchase or download the workflow to get the n8n workflow JSON file.
- 2In your n8n instance, open Workflows and choose "Import from File" (or paste the JSON with Ctrl+V on the canvas).
- 3Open each node marked with a credential warning and connect your own accounts and API keys.
- 4Run the workflow once manually to verify the data flow, then toggle it to Active.
Related File & Document Management workflows
- Automate Invoice Data Extraction to Airtable with OCR and AI$14.99
- Save new Gmail attachments to Google Drive$3.99
- Automate PDF Invoice Creation from Google Sheets Using PDF.co$4.99
- Create Custom PDF Documents from Templates with Gemini & Google Drive$24.99
- Automatically Save and Organize Outlook Email Attachments in OneDrive Folders$9.99
- Automate Invoice Data Extraction from Google Drive to Google Sheets with Mistral OCR$14.99
More from Nora Brennan
Need this deployed? We'll set it up for you.
Our automation experts deploy this workflow in your stack, connect your accounts, and verify it works — or build a custom solution from scratch.