{
  "name": "Automate travel agent outreach with web scraping, OpenAI, and Google Sheets",
  "nodes": [
    {
      "id": "e6b6b5d8-ae51-42e6-8f14-fa94b3b9cc5a",
      "name": "When clicking ‘Test workflow’",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -360,
        360
      ]
    },
    {
      "id": "29628132-3a79-4512-b1dd-ed5574e69363",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -340,
        -280
      ],
      "parameters": {
        "width": 580,
        "height": 140,
        "content": "## This is workflow of scrapping list of travel agents website...\n  \n**use this for scrapping different sites that has information in standard format information information** "
      }
    },
    {
      "id": "a7575f0a-db6a-48e1-9fb8-01f8e543589b",
      "name": "Split Out",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        240,
        -100
      ]
    },
    {
      "id": "3cb85d6b-b0e9-4ca9-a4a1-7b241909eccc",
      "name": "Send Email",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        680,
        360
      ]
    },
    {
      "id": "19d9b52b-5ca8-4027-98fe-d3e36fb9e229",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -360,
        200
      ],
      "parameters": {
        "width": 580,
        "height": 120,
        "content": "## Read Scrapped and Stored Records in SpreadSheet and Send Survey Email \n** Simple Read and Compose Personalised email and send..."
      }
    },
    {
      "id": "57827b6b-5f62-4b17-99ce-d14b4d0c27bb",
      "name": "Google Sheet - Data Store",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        440,
        -100
      ]
    },
    {
      "id": "eef292a7-b539-4b38-935e-27b7f6e1e871",
      "name": "Google Sheet Data Store",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -120,
        360
      ]
    },
    {
      "id": "5428022b-1492-4ed0-8fa7-a13f1b6dd9be",
      "name": "OpenAI1 Mail Composer",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        100,
        360
      ]
    },
    {
      "id": "13922526-19c5-495a-ba65-3cb0c77a1816",
      "name": "OpenAI Standardise Data",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        -120,
        -100
      ]
    },
    {
      "id": "f6fda879-81e2-4aa6-ada4-5fff6e645ba4",
      "name": "Google Sheet Update Records",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        460,
        360
      ]
    },
    {
      "id": "c6ab2fe5-8876-4673-a5f3-6eacd4625a4c",
      "name": "HTTP Scrape Website",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -340,
        -100
      ]
    }
  ],
  "connections": {
    "Split Out": {
      "main": [
        [
          {
            "node": "Google Sheet - Data Store",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "HTTP Scrape Website": {
      "main": [
        [
          {
            "node": "OpenAI Standardise Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI1 Mail Composer": {
      "main": [
        [
          {
            "node": "Google Sheet Update Records",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheet Data Store": {
      "main": [
        [
          {
            "node": "OpenAI1 Mail Composer",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Standardise Data": {
      "main": [
        [
          {
            "node": "Split Out",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheet Update Records": {
      "main": [
        [
          {
            "node": "Send Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When clicking ‘Test workflow’": {
      "main": [
        [
          {
            "node": "Google Sheet Data Store",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}