{
  "name": "Filter for positive Google reviews using Telegram, web form & Google Sheets",
  "nodes": [
    {
      "id": "22c9f809-df01-4dd2-aa0f-893d2aed3a17",
      "name": "Initial User Message",
      "type": "n8n-nodes-base.telegramTrigger",
      "position": [
        -1040,
        -448
      ]
    },
    {
      "id": "7f7f07f5-fcc7-4fd9-ad9c-51d55ed559bd",
      "name": "Fetch Rows from sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -848,
        -448
      ]
    },
    {
      "id": "5f204297-2a27-4b40-a5f8-a91de5b65d2f",
      "name": "Updates customer details",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -416,
        -624
      ]
    },
    {
      "id": "33002dd5-2c11-4216-939b-4041a6013f59",
      "name": "Updates Status",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -16,
        -624
      ]
    },
    {
      "id": "3259cacc-d95a-48c4-be74-704f517b93a3",
      "name": "Already claimed offer msg",
      "type": "n8n-nodes-base.telegram",
      "position": [
        -224,
        -352
      ]
    },
    {
      "id": "c7d82216-0388-4f2d-bc4d-33bc76c9f9db",
      "name": "Feedback message",
      "type": "n8n-nodes-base.webhook",
      "position": [
        -864,
        -64
      ]
    },
    {
      "id": "3b4d326b-400f-4899-b9b9-5c8f5acf8525",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1136,
        -144
      ],
      "parameters": {
        "width": 912,
        "height": 256,
        "content": "## Feedback Review to Google Sheets"
      }
    },
    {
      "id": "e74201cb-d0eb-40d9-8107-98e298a81719",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -208,
        -144
      ],
      "parameters": {
        "width": 832,
        "height": 256,
        "content": "## Tracking for Link Click"
      }
    },
    {
      "id": "8e3a7e0b-6250-496e-9975-023e417d749d",
      "name": "Link Click Track",
      "type": "n8n-nodes-base.webhook",
      "position": [
        48,
        -64
      ]
    },
    {
      "id": "94bf1a7a-8c39-44aa-a6ce-9cd2d08c794d",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1136,
        -752
      ],
      "parameters": {
        "width": 1760,
        "height": 592,
        "content": "## Initial Customer Funneling and Review Message Workflow"
      }
    },
    {
      "id": "b7bee03a-5c93-44da-ac42-cf18eb7dd0ad",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -1024,
        240
      ]
    },
    {
      "id": "6f4c36e7-12e0-4efa-83af-1eacfc0f81e8",
      "name": "Get row(s) in sheet1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -816,
        240
      ]
    },
    {
      "id": "d7a5e922-79cc-4136-a1a6-32b4be2f3a35",
      "name": "Loop Over Items",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        -608,
        240
      ]
    },
    {
      "id": "c5597f2d-3926-4bac-8fd7-148f294e537f",
      "name": "if 23 hours passed",
      "type": "n8n-nodes-base.if",
      "position": [
        -176,
        240
      ]
    },
    {
      "id": "897e5fba-45fe-49dd-a699-9701aede5614",
      "name": "update status to follow up sent",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        368,
        240
      ]
    },
    {
      "id": "2fb51e66-cd53-4bc0-bb34-c3a281ceeb3b",
      "name": "2 hours delay for feedback",
      "type": "n8n-nodes-base.wait",
      "position": [
        208,
        -624
      ]
    },
    {
      "id": "87e5713a-d453-4a0f-a41a-bf66739f77ed",
      "name": "checks if customer exists in sheets",
      "type": "n8n-nodes-base.if",
      "position": [
        -656,
        -448
      ]
    },
    {
      "id": "93c8d4cb-6221-4419-a8db-99de0a40a10f",
      "name": "checks if they still didn't claim the offer",
      "type": "n8n-nodes-base.if",
      "position": [
        -416,
        -336
      ]
    },
    {
      "id": "1eac73dc-0dad-4ced-a845-650b3b3bdcab",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1136,
        128
      ],
      "parameters": {
        "width": 1760,
        "height": 352,
        "content": ""
      }
    },
    {
      "id": "2b97bfa6-9bf3-4e83-a0b4-c2c3d303f801",
      "name": "Timestamp to Boolean",
      "type": "n8n-nodes-base.set",
      "position": [
        -368,
        240
      ]
    },
    {
      "id": "bef8f6b9-fc5a-4f75-a647-434d41a14760",
      "name": "Send Review Page Link",
      "type": "n8n-nodes-base.telegram",
      "position": [
        384,
        -624
      ]
    },
    {
      "id": "58c7b89f-0d97-442f-b3e0-c6c629c44465",
      "name": "Send Incentive Offer",
      "type": "n8n-nodes-base.telegram",
      "position": [
        -224,
        -624
      ]
    },
    {
      "id": "6670b4ae-b24c-46a7-aebb-0d769776ae40",
      "name": "Send Review Link Reminder",
      "type": "n8n-nodes-base.telegram",
      "position": [
        112,
        240
      ]
    },
    {
      "id": "be79b0fd-ac32-4891-b5c8-2b0a0b98fd7d",
      "name": "Update Status to 'Clicked'",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        256,
        -64
      ]
    },
    {
      "id": "eb9a1614-0506-42c1-bfd3-643de8670ebf",
      "name": "Save Private Feedback to Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -656,
        -64
      ]
    },
    {
      "id": "75613bca-9dc4-4140-ab10-80b52a02247f",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2144,
        -1232
      ],
      "parameters": {
        "width": 560,
        "height": 416,
        "content": "=========================\n Positive Google Reviews only Using Telegram with Google Sheets\n=======================================\nFor any questions or support, please contact:\n    anirudh.n.aeran@gmai"
      }
    },
    {
      "id": "416e3b5e-6d47-4d62-8442-83edb03c4437",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2144,
        -768
      ],
      "parameters": {
        "width": 416,
        "height": 960,
        "content": "## Try It Out!\n\n**This workflow is your personal reputation manager. It intelligently filters customer feedback from Telegram, encouraging 4+ star reviews to be posted on Google while capturing negati"
      }
    },
    {
      "id": "0f409df6-2adb-4292-b824-674aa292abbd",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1136,
        -944
      ],
      "parameters": {
        "width": 272,
        "height": null,
        "content": "### Note:\nHere in this workflow we're using a free discount of 5% up to $xx method to funnel the customer to our database. You can replace this with any stratagy"
      }
    },
    {
      "id": "7df82cf7-f836-4a46-bd4d-4e9579cc3b53",
      "name": "Sticky Note7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1408,
        -80
      ],
      "parameters": {
        "width": 256,
        "height": 112,
        "content": "**-->This flow will send the feedback from the webpage to sheets (this can be database)**"
      }
    },
    {
      "id": "972ac8ba-73e0-4fbf-8c87-607d21b5f4b7",
      "name": "Sticky Note8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        656,
        -80
      ],
      "parameters": {
        "width": 256,
        "height": 96,
        "content": "**-->This flow will update the status to \"clicked\" if the link is opened.**"
      }
    },
    {
      "id": "2c6714a7-3622-4cf1-8e71-456c22819fa3",
      "name": "Sticky Note9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -784,
        -944
      ],
      "parameters": {
        "width": 320,
        "height": null,
        "content": "### -->Dynamic Link\n**The review link sent to each customer is unique. This is ensured by add ?userId={a unique id} at the end of the website URL. Here the telegram id of the customer is the Uid we ar"
      }
    },
    {
      "id": "c2ccc53f-fbbc-4bfe-b692-0e7d7eb907fa",
      "name": "Sticky Note10",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1456,
        160
      ],
      "parameters": {
        "width": 304,
        "height": 288,
        "content": "**This flow will check on a 5 minute interval basis if the timestamp has exceeded the \"23 hour mark\" to send a follow up to the customers who didn't click the link. \n\nWhen Using Telegram the 23 hour c"
      }
    },
    {
      "id": "af651e46-8818-42e0-8a5a-7587b143b422",
      "name": "Sticky Note11",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        656,
        -752
      ],
      "parameters": {
        "width": 288,
        "height": 320,
        "content": "### Create Telegram Bot\n1. Message the official BotFather on Telegram and send the command /newbot.\n\n2. Follow the prompts to set a display name and a unique username (which must end in bot).\n\n3. BotF"
      }
    }
  ],
  "connections": {
    "Updates Status": {
      "main": [
        [
          {
            "node": "2 hours delay for feedback",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items": {
      "main": [
        [],
        [
          {
            "node": "Timestamp to Boolean",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Feedback message": {
      "main": [
        [
          {
            "node": "Save Private Feedback to Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Link Click Track": {
      "main": [
        [
          {
            "node": "Update Status to 'Clicked'",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Get row(s) in sheet1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "if 23 hours passed": {
      "main": [
        [
          {
            "node": "Send Review Link Reminder",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get row(s) in sheet1": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Initial User Message": {
      "main": [
        [
          {
            "node": "Fetch Rows from sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send Incentive Offer": {
      "main": [
        [
          {
            "node": "Updates Status",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Timestamp to Boolean": {
      "main": [
        [
          {
            "node": "if 23 hours passed",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch Rows from sheet": {
      "main": [
        [
          {
            "node": "checks if customer exists in sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Updates customer details": {
      "main": [
        [
          {
            "node": "Send Incentive Offer",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send Review Link Reminder": {
      "main": [
        [
          {
            "node": "update status to follow up sent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "2 hours delay for feedback": {
      "main": [
        [
          {
            "node": "Send Review Page Link",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "update status to follow up sent": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "checks if customer exists in sheets": {
      "main": [
        [
          {
            "node": "Updates customer details",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "checks if they still didn't claim the offer",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "checks if they still didn't claim the offer": {
      "main": [
        [
          {
            "node": "Already claimed offer msg",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Send Incentive Offer",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}