{
  "name": "Automated job scraping with SerpAPI, Gemini AI filter & email notifications",
  "nodes": [
    {
      "id": "650f7afc-f4f7-42f3-9eb8-0de7403c20c0",
      "name": "Append or update row in sheet1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1504,
        1056
      ]
    },
    {
      "id": "85ed38d3-6edc-4bac-af9f-78622fc10162",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -704,
        928
      ]
    },
    {
      "id": "dc165df2-93bd-44ce-af53-db963e474ba4",
      "name": "Wait",
      "type": "n8n-nodes-base.wait",
      "position": [
        832,
        1056
      ]
    },
    {
      "id": "7445db62-3077-4e0a-876b-95100dcb78e8",
      "name": "Edit Fields",
      "type": "n8n-nodes-base.set",
      "position": [
        -480,
        928
      ]
    },
    {
      "id": "15330745-329f-4c45-8fc3-936603384748",
      "name": "Split Out5",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        112,
        1232
      ]
    },
    {
      "id": "07ea0147-2e49-4e09-8870-fab13fee464a",
      "name": "HTTP Request5",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -112,
        1232
      ]
    },
    {
      "id": "4c1ba99f-cca4-487e-bc40-eecbf5375f81",
      "name": "Split Out6",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        112,
        624
      ]
    },
    {
      "id": "21950c50-831f-46a1-8c33-775fb951e2a6",
      "name": "HTTP Request6",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -112,
        624
      ]
    },
    {
      "id": "97a8418d-89c5-42b5-83ab-68317850e651",
      "name": "HTTP Request7",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -112,
        768
      ]
    },
    {
      "id": "2d3c54af-6276-40bb-8c55-31e0f4736ede",
      "name": "Split Out7",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        112,
        768
      ]
    },
    {
      "id": "26a8790c-d671-4126-a3f7-9c391c8792f5",
      "name": "HTTP Request8",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -112,
        912
      ]
    },
    {
      "id": "517a617d-ab02-4240-9ac7-f812407a7df8",
      "name": "Split Out8",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        112,
        912
      ]
    },
    {
      "id": "5acf57d7-df20-4505-84b5-174cae9638f2",
      "name": "HTTP Request9",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -112,
        1040
      ]
    },
    {
      "id": "74ed4234-b86c-45d4-b57b-98e80b1b98e2",
      "name": "Split Out9",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        112,
        1040
      ]
    },
    {
      "id": "a906301c-8305-459d-9bb8-1f6b557642ae",
      "name": "Merge2",
      "type": "n8n-nodes-base.merge",
      "position": [
        336,
        832
      ]
    },
    {
      "id": "a7b2e517-aa56-4647-b206-cae0aab6bf86",
      "name": "Compare Datasets1",
      "type": "n8n-nodes-base.compareDatasets",
      "position": [
        560,
        1104
      ]
    },
    {
      "id": "67fcf85d-23f4-4e51-a06d-395bb05f7b1c",
      "name": "Get row(s) in sheet2",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        336,
        1216
      ]
    },
    {
      "id": "d7c39d3f-b21c-4811-a31c-541a99f45f40",
      "name": "AI Agent",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        1008,
        1056
      ]
    },
    {
      "id": "a1fb2d9d-b9b6-4f54-b33c-4a71001051e8",
      "name": "Google Gemini Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
      "position": [
        1040,
        1184
      ]
    },
    {
      "id": "f56c06db-3a2c-4e6f-b0a3-38c820e6faa8",
      "name": "Switch",
      "type": "n8n-nodes-base.switch",
      "position": [
        1280,
        1056
      ]
    },
    {
      "id": "380cc3c6-22f3-4b80-a7d5-b6783e2b3e05",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -768,
        784
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "1c776d8d-b321-4337-8b31-b421f0a52891",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -304,
        32
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "107b2649-4c9b-4089-b0cc-19f590d09a8b",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        288,
        1104
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "54ed8857-60f0-4617-ab3a-c04b15b26f28",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1264,
        928
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "cc087cdc-1651-4d99-b2c3-1cf210225ef0",
      "name": "Update row in sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        32,
        1808
      ]
    },
    {
      "id": "81e36bfc-9ee0-477e-82ea-b8d22412c90e",
      "name": "When Executed by Another Workflow",
      "type": "n8n-nodes-base.executeWorkflowTrigger",
      "position": [
        -304,
        1584
      ]
    },
    {
      "id": "9d31f1e0-caaf-4e5e-a17a-9e0728868324",
      "name": "Send a message1",
      "type": "n8n-nodes-base.microsoftOutlook",
      "position": [
        128,
        1584
      ]
    },
    {
      "id": "55e283a5-91a8-4e77-b20d-7c9ca035334e",
      "name": "Aggregate",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        0,
        1584
      ]
    },
    {
      "id": "bd2ba049-10a4-4747-8d1c-0d9bb04af467",
      "name": "Get row(s) in sheet3",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -160,
        1584
      ]
    },
    {
      "id": "771c250e-28f5-4f5c-93b3-8676f452da60",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -592,
        1472
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "63fa240c-8bb5-4124-a8d5-666c64d3f02d",
      "name": "Sticky Note7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        512,
        928
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "0d86e789-c7b8-49c2-9b44-9172ec0f1381",
      "name": "Sticky Note14",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -16,
        1712
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "26d48f17-87b0-479d-b494-7eda28269a6f",
      "name": "Call sub workflow",
      "type": "n8n-nodes-base.executeWorkflow",
      "position": [
        1728,
        1056
      ]
    },
    {
      "id": "70c5aa29-2503-476c-b58f-8d93fa051a6e",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1200,
        512
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "c957cbba-aafb-47af-ad39-c2fe88e67e44",
      "name": "My CTA Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1920,
        576
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    }
  ],
  "connections": {
    "Wait": {
      "main": [
        [
          {
            "node": "AI Agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Merge2": {
      "main": [
        [
          {
            "node": "Compare Datasets1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Switch": {
      "main": [
        [
          {
            "node": "Append or update row in sheet1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "AI Agent": {
      "main": [
        [
          {
            "node": "Switch",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Aggregate": {
      "main": [
        [
          {
            "node": "Send a message1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Out5": {
      "main": [
        [
          {
            "node": "Merge2",
            "type": "main",
            "index": 4
          }
        ]
      ]
    },
    "Split Out6": {
      "main": [
        [
          {
            "node": "Merge2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Out7": {
      "main": [
        [
          {
            "node": "Merge2",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Split Out8": {
      "main": [
        [
          {
            "node": "Merge2",
            "type": "main",
            "index": 2
          }
        ]
      ]
    },
    "Split Out9": {
      "main": [
        [
          {
            "node": "Merge2",
            "type": "main",
            "index": 3
          }
        ]
      ]
    },
    "Edit Fields": {
      "main": [
        [
          {
            "node": "HTTP Request6",
            "type": "main",
            "index": 0
          },
          {
            "node": "HTTP Request7",
            "type": "main",
            "index": 0
          },
          {
            "node": "HTTP Request8",
            "type": "main",
            "index": 0
          },
          {
            "node": "HTTP Request9",
            "type": "main",
            "index": 0
          },
          {
            "node": "HTTP Request5",
            "type": "main",
            "index": 0
          },
          {
            "node": "Get row(s) in sheet2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "HTTP Request5": {
      "main": [
        [
          {
            "node": "Split Out5",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "HTTP Request6": {
      "main": [
        [
          {
            "node": "Split Out6",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "HTTP Request7": {
      "main": [
        [
          {
            "node": "Split Out7",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "HTTP Request8": {
      "main": [
        [
          {
            "node": "Split Out8",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "HTTP Request9": {
      "main": [
        [
          {
            "node": "Split Out9",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Edit Fields",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Compare Datasets1": {
      "main": [
        [
          {
            "node": "Wait",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get row(s) in sheet2": {
      "main": [
        [
          {
            "node": "Compare Datasets1",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Get row(s) in sheet3": {
      "main": [
        [
          {
            "node": "Update row in sheet",
            "type": "main",
            "index": 0
          },
          {
            "node": "Aggregate",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Gemini Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "AI Agent",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Append or update row in sheet1": {
      "main": [
        [
          {
            "node": "Call sub workflow",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When Executed by Another Workflow": {
      "main": [
        [
          {
            "node": "Get row(s) in sheet3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}