{
  "name": "Analyze Zoom phone call recordings with Gemini and log results to Google Sheets",
  "nodes": [
    {
      "id": "c1ac5764-5a77-4105-bc2c-224badb11721",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -224,
        -240
      ],
      "parameters": {
        "width": 580,
        "height": 660,
        "content": "### Analyze Zoom phone recordings with Gemini AI\nThis workflow grabs your Zoom Phone call recordings, sends them to Gemini for analysis, backs them up to Google Drive, and logs everything in a spreads"
      }
    },
    {
      "id": "12116eca-f4b4-4c4e-bc0e-8469676ff2b0",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        368,
        -240
      ],
      "parameters": {
        "width": 460,
        "height": 650,
        "content": "## Fetch Zoom recordings\nPulls recent phone recordings from the Zoom API and splits them into individual items for processing."
      }
    },
    {
      "id": "0ec1e3ce-7526-499d-b07f-4dcc7675fb45",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        848,
        -240
      ],
      "parameters": {
        "width": 786,
        "height": 650,
        "content": "## Prepare & download\nBuilds a clean filename from the caller name + timestamp, then downloads the actual audio file."
      }
    },
    {
      "id": "fbd4def3-d02a-48fc-bffb-eda5c1f9fad6",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1648,
        -240
      ],
      "parameters": {
        "width": 582,
        "height": 650,
        "content": "## Analyze with Gemini AI\nThe audio goes to both Google Drive (backup) and Gemini (analysis) in parallel. Gemini returns a structured JSON with the call stage and improvement advice."
      }
    },
    {
      "id": "fd90ece7-4eb1-4122-b062-590d93c76a77",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2256,
        -240
      ],
      "parameters": {
        "width": 360,
        "height": 650,
        "content": "## Log results\nCombines the Gemini analysis with caller metadata and the Drive link, then appends a row to your tracking spreadsheet."
      }
    },
    {
      "id": "e064d2f3-25c8-4985-bf3d-8b3316f78440",
      "name": "Get Zoom Phone Recordings",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        672,
        -128
      ]
    },
    {
      "id": "570be236-0816-4287-81b4-5ad3cb1c6709",
      "name": "Loop Over Items",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        1104,
        -128
      ]
    },
    {
      "id": "b854e9de-3ca5-457a-a279-2205f3ad23cf",
      "name": "Build File Name",
      "type": "n8n-nodes-base.set",
      "position": [
        1328,
        -48
      ]
    },
    {
      "id": "941bbcab-c18b-4856-aa4f-4ad5f961ef37",
      "name": "Download Recording",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1520,
        -48
      ]
    },
    {
      "id": "bb98c913-9b85-4b88-b47f-482c9e6e0e34",
      "name": "Upload to Google Drive",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        1712,
        -48
      ]
    },
    {
      "id": "bab6320f-cb6a-426d-9b3e-3e906cdbd79f",
      "name": "Upload Audio to Gemini",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1728,
        208
      ]
    },
    {
      "id": "eb7f11da-47a1-491c-bf05-63a44f9936cb",
      "name": "Analyze Call with Gemini",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1920,
        208
      ]
    },
    {
      "id": "79fa4644-956c-4207-8bb0-bc65b36c0dc4",
      "name": "Merge Drive Link + Analysis",
      "type": "n8n-nodes-base.merge",
      "position": [
        2096,
        192
      ]
    },
    {
      "id": "4cc6f30f-4b58-4322-98ae-f78c50c1f166",
      "name": "Format Results",
      "type": "n8n-nodes-base.set",
      "position": [
        2288,
        192
      ]
    },
    {
      "id": "0f60ec22-da9c-438b-a23f-4c26826e58a5",
      "name": "Log to Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2464,
        192
      ]
    },
    {
      "id": "e68e2ece-e4d2-418b-9b69-446fd4f3ce96",
      "name": "Run Every Hour",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        448,
        -128
      ]
    },
    {
      "id": "a5a8a6d8-a337-4c7b-bb9c-2a613fe5d3a6",
      "name": "Process Each Recording",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        880,
        -128
      ]
    }
  ],
  "connections": {
    "Format Results": {
      "main": [
        [
          {
            "node": "Log to Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Run Every Hour": {
      "main": [
        [
          {
            "node": "Get Zoom Phone Recordings",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Build File Name": {
      "main": [
        [
          {
            "node": "Download Recording",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items": {
      "main": [
        [],
        [
          {
            "node": "Build File Name",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Download Recording": {
      "main": [
        [
          {
            "node": "Upload to Google Drive",
            "type": "main",
            "index": 0
          },
          {
            "node": "Upload Audio to Gemini",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Log to Google Sheets": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Process Each Recording": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Upload Audio to Gemini": {
      "main": [
        [
          {
            "node": "Analyze Call with Gemini",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Upload to Google Drive": {
      "main": [
        [
          {
            "node": "Merge Drive Link + Analysis",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Analyze Call with Gemini": {
      "main": [
        [
          {
            "node": "Merge Drive Link + Analysis",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Get Zoom Phone Recordings": {
      "main": [
        [
          {
            "node": "Process Each Recording",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Merge Drive Link + Analysis": {
      "main": [
        [
          {
            "node": "Format Results",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}