{
  "name": "Track coupon points with Google Sheets, Drive Storage, and Gmail weekly summary",
  "nodes": [
    {
      "id": "59e7faf4-d3ed-4422-92b3-e1bcaac0bb8f",
      "name": "Upload file",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        -528,
        336
      ]
    },
    {
      "id": "3b72e912-8bc1-4cc9-a24d-81b67207ceea",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -752,
        656
      ]
    },
    {
      "id": "d9463e4e-e7dc-4335-bf72-0b58ee871e3b",
      "name": "calcDate",
      "type": "n8n-nodes-base.code",
      "position": [
        -528,
        208
      ]
    },
    {
      "id": "453d7da8-74c4-4182-a899-85eb154b9607",
      "name": "Get row(s) in sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -528,
        656
      ]
    },
    {
      "id": "122edb03-03ae-446d-98d3-8e12e46c4332",
      "name": "Send a message",
      "type": "n8n-nodes-base.gmail",
      "position": [
        160,
        656
      ]
    },
    {
      "id": "41752228-49fe-40bc-a0dc-5d00f7a0c1b8",
      "name": "filteredRows",
      "type": "n8n-nodes-base.code",
      "position": [
        -288,
        656
      ]
    },
    {
      "id": "6dfdcc94-ca0b-4edf-b1b5-75baf14fba55",
      "name": "rewrite",
      "type": "n8n-nodes-base.code",
      "position": [
        -64,
        656
      ]
    },
    {
      "id": "46d71fc4-9f17-4635-8f0b-692d7ee3e0d7",
      "name": "Merge",
      "type": "n8n-nodes-base.merge",
      "position": [
        -288,
        272
      ]
    },
    {
      "id": "4ab00a13-cc29-4d63-8b09-5dccc5909876",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1264,
        96
      ],
      "parameters": {
        "width": 448,
        "height": 720,
        "content": "## Coupon Points Tracker\nThis workflow helps you keep track of every loyalty point you should receive from your coupon activity. Upload screenshots, log all coupon details in Google Sheets, and get we"
      }
    },
    {
      "id": "2b89a51c-9324-4aa4-a6ab-a767d0d307d2",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -800,
        96
      ],
      "parameters": {
        "width": 1152,
        "height": 384,
        "content": "## Saving Coupon Data and Screenshots\nWhen you submit a coupon, the workflow automatically stores both your coupon details and any uploaded screenshots. The screenshot is first uploaded to Google Driv"
      }
    },
    {
      "id": "bb0a9cc8-b5a6-4bc4-82e3-0764f61d1973",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -800,
        512
      ],
      "parameters": {
        "width": 1152,
        "height": 304,
        "content": "## Weekly Claimable Points Check\nOnce a week, a scheduled trigger runs automatically to check which of your stored coupons have reached their claimable date. The workflow looks through the Google Shee"
      }
    },
    {
      "id": "7e8d7622-6c5d-468b-b7b3-49cd2a394394",
      "name": "Tracking Form",
      "type": "n8n-nodes-base.formTrigger",
      "position": [
        -752,
        272
      ]
    },
    {
      "id": "1dca24f0-285d-402e-a961-33e757934d12",
      "name": "Append row in sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        160,
        272
      ]
    },
    {
      "id": "fe2a2a00-3f37-4ca1-b38a-3091b4d577f5",
      "name": "Clean Set",
      "type": "n8n-nodes-base.set",
      "position": [
        -64,
        272
      ]
    }
  ],
  "connections": {
    "Merge": {
      "main": [
        [
          {
            "node": "Clean Set",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "rewrite": {
      "main": [
        [
          {
            "node": "Send a message",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "calcDate": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Clean Set": {
      "main": [
        [
          {
            "node": "Append row in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Upload file": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "filteredRows": {
      "main": [
        [
          {
            "node": "rewrite",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Tracking Form": {
      "main": [
        [
          {
            "node": "Upload file",
            "type": "main",
            "index": 0
          },
          {
            "node": "calcDate",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Get row(s) in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get row(s) in sheet": {
      "main": [
        [
          {
            "node": "filteredRows",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}