使用Google Sheets和Slack的自动化任务提醒与每日总结

• •Slack Bot Token 或 Webhook URL
• •Google Sheets API 凭证

{
  "meta": {
    "instanceId": "f01290caa6c024522b0ed5bb2d09cea02bb113d8970b898b340ca3d74255326e",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "6173c474-bdf3-4066-a7f3-0d6aa59c4a96",
      "name": "开始：Cron 触发器",
      "type": "n8n-nodes-base.cron",
      "notes": "Runs every 15 minutes to check tasks in Google Sheets.",
      "position": [
        -288,
        176
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "ad92e170-65ed-41a3-909d-063c1d02bdd7",
      "name": "从 Google Sheets 获取任务",
      "type": "n8n-nodes-base.googleSheets",
      "notes": "Reads all tasks from the `Tasks` sheet.",
      "position": [
        -32,
        176
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "id",
          "value": "={{ SHEET_TAB }}"
        },
        "documentId": {
          "__rl": true,
          "mode": "id",
          "value": "={{{GOOGLE_SHEET_WORKSHEET}}}"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "GOOGLE_SHEET_ID",
          "name": "YOUR_GOOGLE_SHEET_ACCOUNT"
        }
      },
      "typeVersion": 3
    },
    {
      "id": "126d822b-85b2-4c5c-87e1-6d759d9bf2b8",
      "name": "检查任务截止时间",
      "type": "n8n-nodes-base.if",
      "notes": "Checks if task is due within the next 30 minutes.",
      "position": [
        224,
        176
      ],
      "parameters": {
        "conditions": {
          "dateTime": [
            {
              "value1": "={{$json[\"Due Date\"]}}",
              "value2": "={{$now.plus({ minutes: 30 }).format('yyyy-MM-dd hh:mm')}}",
              "operation": "before"
            }
          ]
        }
      },
      "typeVersion": 1
    },
    {
      "id": "2a958536-cb0a-4a01-a1e0-4253a474c2b1",
      "name": "更新最后提醒发送时间",
      "type": "n8n-nodes-base.googleSheets",
      "notes": "Updates the `Last Reminder Sent` column in Sheets to avoid duplicate reminders.",
      "position": [
        464,
        272
      ],
      "parameters": {
        "options": {},
        "fieldsUi": {
          "values": [
            {
              "column": "Last Reminder Sent",
              "fieldValue": "={{ $now.format('yyyy-MM-dd HH:mm') }}"
            }
          ]
        },
        "operation": "update",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/{{GOOGLE_SHEET_ID}}/edit#gid=0",
          "cachedResultName": "Tasks"
        },
        "documentId": {
          "__rl": true,
          "mode": "id",
          "value": "={{GID}}"
        },
        "valueToMatchOn": "={{ $json[\"Task ID\"] }}",
        "columnToMatchOn": "Task ID"
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "GOOGLE_SHEET_ID",
          "name": "YOUR_GOOGLE_SHEET_ACCOUNT"
        }
      },
      "typeVersion": 3
    },
    {
      "id": "c43df2f4-ec79-4b57-ac57-30ca2d822cfe",
      "name": "每日回顾触发器",
      "type": "n8n-nodes-base.cron",
      "notes": "Triggers daily recap at 6 PM.",
      "position": [
        -288,
        480
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "0171cb17-54c7-4dd4-8243-ed97a9237bd4",
      "name": "获取已完成任务",
      "type": "n8n-nodes-base.googleSheets",
      "notes": "Reads all tasks for recap.",
      "position": [
        -64,
        480
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/{{GOOGLE_SHEET_ID}}/edit#gid=0",
          "cachedResultName": "Tasks"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "17vTZDnZ_37_xlgs-RB_ekIhLi_c-2rpXOI5BaomD0k8",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/{{GOOGLE_SHEET_ID}}/edit?usp=drivesdk",
          "cachedResultName": "Productivity & Time Tracking Sheet"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "GOOGLE_SHEET_ID",
          "name": "YOUR_GOOGLE_SHEET_ACCOUNT"
        }
      },
      "typeVersion": 3
    },
    {
      "id": "f852d299-3f23-4755-aaa6-e16745925160",
      "name": "发送 Slack 提醒",
      "type": "n8n-nodes-base.slack",
      "position": [
        464,
        96
      ],
      "webhookId": "f775ed72-9f3a-4ffc-bdfc-ba464037cdb1",
      "parameters": {
        "text": "=⚡ Reminder: Task *{{$json[\"Task Name\"]}}* is due at {{$json[\"Due Date\"]}}.|Reason: {{$json[\"Why it matters\"]}}",
        "select": "channel",
        "otherOptions": {}
      },
      "credentials": {
        "slackApi": {
          "id": "SLACK_ID",
          "name": "YOUR_SLACK"
        }
      },
      "typeVersion": 2.3
    },
    {
      "id": "55101bb4-a1ec-490b-b3f6-a5969e4512c0",
      "name": "发送 Slack 提醒1",
      "type": "n8n-nodes-base.slack",
      "position": [
        160,
        480
      ],
      "webhookId": "f775ed72-9f3a-4ffc-bdfc-ba464037cdb1",
      "parameters": {
        "text": "=📊 Daily Recap:\nCompleted tasks today: {{ ($json[\"Status\"] || \"\").match(/Completed/g)?.length || 0 }}\nPending tasks: {{ ($json[\"Status\"] || \"\").match(/In Progress|Not Started/g)?.length || 0 }}",
        "select": "channel",
        "otherOptions": {}
      },
      "credentials": {
        "slackApi": {
          "id": "SLACK_ID",
          "name": "YOUR_SLACK"
        }
      },
      "typeVersion": 2.3
    },
    {
      "id": "7ab80956-b706-428d-b152-26cc9738eddd",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1392,
        -304
      ],
      "parameters": {
        "width": 960,
        "height": 1504,
        "content": "# 📝 Rize Lite – Google Sheets + Slack 生产力追踪器"
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "Daily Recap Trigger": {
      "main": [
        [
          {
            "node": "Fetch Completed Tasks",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Start: Cron Trigger": {
      "main": [
        [
          {
            "node": "Fetch Tasks from Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Check Task Deadlines": {
      "main": [
        [
          {
            "node": "Send a Slack Reminder",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Update Last Reminder Sent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch Completed Tasks": {
      "main": [
        [
          {
            "node": "Send a Slack Reminder1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch Tasks from Google Sheets": {
      "main": [
        [
          {
            "node": "Check Task Deadlines",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}