AutomationFlowsWeb Scraping › Automate Weekly Us Trademark Reports with Uspto API and Google Drive CSV Export

Automate Weekly Us Trademark Reports with Uspto API and Google Drive CSV Export

Byiamvaar @iamvaar on n8n.io

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

Cron / scheduled trigger★★★★☆ complexity7 nodesHTTP RequestGoogle Drive
Web Scraping Trigger: Cron / scheduled Nodes: 7 Complexity: ★★★★☆ Added:

This workflow corresponds to n8n.io template #7024 — we link there as the canonical source.

This workflow follows the Google Drive → HTTP Request recipe pattern — see all workflows that pair these two integrations.

The workflow JSON

Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →

Download .json
{
  "meta": {
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "53bb2ee2-d72c-43ff-996f-25a602bc3bd3",
      "name": "Convert to File",
      "type": "n8n-nodes-base.convertToFile",
      "position": [
        384,
        -80
      ],
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "7697d7d4-8f39-4d71-9dac-801175b6ba33",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -832,
        -80
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "a1cc8d70-6349-4b93-95eb-38f6e09f1017",
      "name": "Get Latest TradeMarks ~ 7 days",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -144,
        -80
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "329e52a4-9ae7-48a3-96a1-b3cd4faa7deb",
      "name": "Date & Time",
      "type": "n8n-nodes-base.dateTime",
      "position": [
        -624,
        -80
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "85e97837-9502-4b44-9cbb-c4561ca362ab",
      "name": "Split the array into individual items",
      "type": "n8n-nodes-base.code",
      "position": [
        128,
        -80
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "9e8a22db-0053-4a83-b0e3-2c638d903490",
      "name": "Manual",
      "type": "n8n-nodes-base.set",
      "position": [
        -416,
        -80
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "a27a7a4d-84a8-40af-a487-0956d07b1e5b",
      "name": "Upload file",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        592,
        -80
      ],
      "parameters": {},
      "typeVersion": 3
    }
  ],
  "connections": {
    "Manual": {
      "main": [
        [
          {
            "node": "Get Latest TradeMarks ~ 7 days",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Date & Time": {
      "main": [
        [
          {
            "node": "Manual",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Convert to File": {
      "main": [
        [
          {
            "node": "Upload file",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Date & Time",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Latest TradeMarks ~ 7 days": {
      "main": [
        [
          {
            "node": "Split the array into individual items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split the array into individual items": {
      "main": [
        [
          {
            "node": "Convert to File",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
Pro

For the full experience including quality scoring and batch install features for each workflow upgrade to Pro

About this workflow

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

Source: https://n8n.io/workflows/7024/ — original creator credit. Request a take-down →

More Web Scraping workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.

Web Scraping

This workflow creates a daily, automated backup of all workflows in a self-hosted n8n instance and stores them in Google Drive. Instead of exporting every workflow on every run, it uses content hashin

HTTP Request, Google Drive, Data Table +1
Web Scraping

This workflow automatically creates daily backups of all n8n workflows and stores them in Google Drive, using the n8n API to export workflows and a scheduled retention policy to keep storage organized

Google Drive, HTTP Request
Web Scraping

Tags: Marketing, Image Processing, Automation

Google Drive, HTTP Request
Web Scraping

LunaJoy - Post-Meeting Auto Analysis (Daily). Uses googleCalendar, googleDrive, httpRequest. Scheduled trigger; 9 nodes.

Google Calendar, Google Drive, HTTP Request
Web Scraping

Birthday Automation - Production (Fixed). Uses stopAndError, httpRequest, emailSend, bannerbear. Scheduled trigger; 86 nodes.

Stop And Error, HTTP Request, Email Send +1