Data Processing & Analysis

0655 Code Postgres Update Scheduled

Scheduled

High

Nodes

Scheduled

Trigger

High

Complexity

7/22/2025

Added

Workflow Overview

Total Nodes

Node Types

schedule Trigger

Schedule Trigger

1 node

http Request

EXTRACT CAMPAIGN DATA, FETCH ALL CAMPAIGNS

2 nodes

split In Batches

Loop Over Items, Loop Over Items1

2 nodes

postgres

UPDATE CAMPAIGN, UPSERT CAMPAIGN ACTIVITY, HUBSPOT TABLE, SEARCH, Postgres1, UPDATE HUBSPOT ACTIVITY TABLE, Postgres

7 nodes

merge

Merge

1 node

code

Code

1 node

hubspot

HubSpot

1 node

sticky Note

Sticky Note, Sticky Note1, Sticky Note2, Sticky Note3, Sticky Note4

5 nodes

set

SET SMARTLEAD API KEY

1 node

google Sheets

Google Sheets

1 node

Workflow JSON

62.33 KB

{
  "meta": {
    "instanceId": "a2435d996b378e3a6fdef0468d70285e3aa0fbd0004de817bfc80e80afee4e7b"
  },
  "name": "0655 Code Postgres Update Scheduled",
  "nodes": [
    {
      "id": "8a4ba8b8-b76e-4572-becd-e7f8fbea2651",
      "name": "EXTRACT CAMPAIGN DATA",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        500,
        960
      ],
      "parameters": {
        "url": "=https://server.smartlead.ai/api/v1/campaigns/{{ $json.id }}/leads-export",
        "options": {
          "batching": {
            "batch": {
              "batchSize": 0
            }
          }
        },
        "sendQuery": true,
        "queryParameters": {
          "parameters": [
            {
              "name": "api_key",
              "value": "={{ $json['API KEY'] }}"
            }
          ]
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "90011ed6-180d-4170-8932-ac3aa7d0e5df",
      "name": "FETCH ALL CAMPAIGNS",
      "type": "n8n-nodes-base.httpRequest...

Showing first 1000 characters. Click "Expand" to view the full JSON.