{
  "name": "Track Pipedrive deals in Google Sheets for sales pipeline reporting",
  "nodes": [
    {
      "id": "da1b90d1-a828-484d-85f7-d67c9463d4de",
      "name": "Get many deals1",
      "type": "n8n-nodes-base.pipedrive",
      "position": [
        -528,
        7312
      ]
    },
    {
      "id": "94915914-ea83-49c3-8f82-e60213af604a",
      "name": "Sticky Note12",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -624,
        6912
      ],
      "parameters": {
        "width": 288,
        "height": 544,
        "content": "### 2️⃣ Connect Pipedrive\n1. In **Pipedrive** → **Personal preferences → API** → copy your **API token**  \n   - URL shortcut: `https://{your-company}.pipedrive.com/settings/personal/api`  \n2. In **n8n"
      }
    },
    {
      "id": "e206c83f-d4e9-421e-b84c-7ef3200357ed",
      "name": "When clicking ‘Execute workflow’",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -656,
        7312
      ]
    },
    {
      "id": "845b7a0b-d4bc-4041-8c76-0c4d7dec578b",
      "name": "Categorize stages",
      "type": "n8n-nodes-base.code",
      "position": [
        -192,
        6912
      ]
    },
    {
      "id": "a9191249-7b71-4218-ac59-4e6586f9c7f6",
      "name": "Today's Date",
      "type": "n8n-nodes-base.code",
      "position": [
        -144,
        7376
      ]
    },
    {
      "id": "c8317b16-77f2-4d03-b727-63d59ae6d0f1",
      "name": "Merge",
      "type": "n8n-nodes-base.merge",
      "position": [
        64,
        7088
      ]
    },
    {
      "id": "a6d7d5de-64e3-42b8-8fe3-eb49c4809b31",
      "name": "Sticky Note13",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        400,
        6848
      ],
      "parameters": {
        "width": 352,
        "height": 384,
        "content": "### 2️⃣ Prepare Your Google Sheet\n#### Connect your Data in Google Sheets\n- Use this format: **[Sample Sheet](https://docs.google.com/spreadsheets/d/1u0i-sfPxmfmm5YMU3ekEdQgdOHA6OgnbI-VwuRMDq4Q/edit?g"
      }
    },
    {
      "id": "80f49397-1db1-44bf-b768-4abe02dc9a97",
      "name": "Sticky Note58",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -688,
        6688
      ],
      "parameters": {
        "width": 1488,
        "height": 928,
        "content": "# 📋 Pipedrive → Google Sheets  \n\nThis workflow pulls deals from **Pipedrive**, categorizes them by stage, and logs them into a **Google Sheet** for reporting and tracking.  "
      }
    },
    {
      "id": "e6e97e79-a17e-4c5a-9779-a82fc7f5d12f",
      "name": "Sticky Note15",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1136,
        6688
      ],
      "parameters": {
        "width": 400,
        "height": 928,
        "content": "\n\n## ⚙️ Setup Instructions  \n\n### 1️⃣ Connect Pipedrive  \n1. In **Pipedrive** → **Personal preferences → API** → copy your **API token**  \n   - URL shortcut: `https://{your-company}.pipedrive.com/sett"
      }
    },
    {
      "id": "14a3cd0a-d1b1-4a57-82fa-4a2e05d7cd1a",
      "name": "Store in google",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        528,
        7072
      ]
    },
    {
      "id": "d7536de3-e3cc-41cf-a60d-2b295358cbde",
      "name": "Set Fields",
      "type": "n8n-nodes-base.set",
      "position": [
        272,
        7088
      ]
    }
  ],
  "connections": {
    "Merge": {
      "main": [
        [
          {
            "node": "Set Fields",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set Fields": {
      "main": [
        [
          {
            "node": "Store in google",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Today's Date": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Get many deals1": {
      "main": [
        [
          {
            "node": "Categorize stages",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Categorize stages": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When clicking ‘Execute workflow’": {
      "main": [
        [
          {
            "node": "Get many deals1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}