AutomationFlowsAI & RAG › Daily Team Progress Checks & Reports with Slack, Chatgpt and Google Sheets

Daily Team Progress Checks & Reports with Slack, Chatgpt and Google Sheets

BySatoshi @satoshi on n8n.io

This workflow is a daily progress check flow that runs automatically at 17:00. It integrates Google Sheets, Slack, and ChatGPT to automate progress inquiries to team members and generate daily reports.

Cron / scheduled trigger★★★★☆ complexityAI-powered16 nodesGoogle SheetsSlackOpenAI
AI & RAG Trigger: Cron / scheduled Nodes: 16 Complexity: ★★★★☆ AI nodes: yes Added:

This workflow corresponds to n8n.io template #11345 — we link there as the canonical source.

This workflow follows the Google Sheets → OpenAI recipe pattern — see all workflows that pair these two integrations.

The workflow JSON

Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →

Download .json
{
  "id": "kvozxSSAzfyEPaRr",
  "name": "Daily Team Progress Checks & Reports with Slack, ChatGPT and Google Sheets",
  "tags": [],
  "nodes": [
    {
      "id": "b6595cbe-34d0-42b4-9e34-02b070d49b28",
      "name": "Group Member Info",
      "type": "n8n-nodes-base.function",
      "position": [
        3088,
        416
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "cd18efd2-802e-4795-8cf3-c49aa2f870a5",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2544,
        272
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "2883cbef-1e17-469d-9b0b-90f312f801cb",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3312,
        272
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "19a5691c-206c-46f4-8f29-b040c03ea7e9",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2544,
        656
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "ed521b11-4a89-4ce5-8ea6-6186b2ee387a",
      "name": "Sticky Note7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3360,
        656
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "6f631cef-cc0f-4144-a50b-1e4d158598c8",
      "name": "Sticky Note8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1472,
        208
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "b4ff22e3-b1f4-46fb-a958-650f061c2dd2",
      "name": "Start Daily at 17:00",
      "type": "n8n-nodes-base.cron",
      "position": [
        2400,
        432
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "011376fb-81c5-49ba-b45e-9da15c032f97",
      "name": "Get Project WBS",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2592,
        432
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "2dbcba3d-cf23-4182-be4e-83f821fef28e",
      "name": "Filter Uncompleted Tasks",
      "type": "n8n-nodes-base.if",
      "position": [
        2800,
        432
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "4cd14193-389b-4a77-b634-f79107cfd190",
      "name": "Send Messages to Members",
      "type": "n8n-nodes-base.slack",
      "position": [
        3648,
        416
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "cbe8eb29-c391-4dab-8de3-78f8a04fe953",
      "name": "Wait 30 Minutes for Member Replies",
      "type": "n8n-nodes-base.wait",
      "position": [
        2576,
        752
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "583fe0db-60f0-4155-ba03-c1337e0960d8",
      "name": "Agent: Compile Report Summary",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        2800,
        752
      ],
      "parameters": {},
      "typeVersion": 1.8
    },
    {
      "id": "1ae081f6-a10a-473a-b326-4dacdde0358d",
      "name": "Generate Daily Report",
      "type": "n8n-nodes-base.function",
      "position": [
        3168,
        752
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "d836b3f7-a483-453f-8ee9-14f0b3cf27e5",
      "name": "Send Report to Client",
      "type": "n8n-nodes-base.slack",
      "position": [
        3440,
        752
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "0aa0bcd9-3b16-424a-85b1-bda1d358b451",
      "name": "Agent: Update task status reminders",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        3344,
        416
      ],
      "parameters": {},
      "typeVersion": 1.8
    },
    {
      "id": "e8c927c4-af08-41e1-8abe-0f2bf8439894",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        576,
        208
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "4da33b36-8555-4041-a491-49051e78e921",
  "connections": {
    "Get Project WBS": {
      "main": [
        [
          {
            "node": "Filter Uncompleted Tasks",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Group Member Info": {
      "main": [
        [
          {
            "node": "Agent: Update task status reminders",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Start Daily at 17:00": {
      "main": [
        [
          {
            "node": "Get Project WBS",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Generate Daily Report": {
      "main": [
        [
          {
            "node": "Send Report to Client",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter Uncompleted Tasks": {
      "main": [
        [
          {
            "node": "Group Member Info",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send Messages to Members": {
      "main": [
        [
          {
            "node": "Wait 30 Minutes for Member Replies",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Agent: Compile Report Summary": {
      "main": [
        [
          {
            "node": "Generate Daily Report",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait 30 Minutes for Member Replies": {
      "main": [
        [
          {
            "node": "Agent: Compile Report Summary",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Agent: Update task status reminders": {
      "main": [
        [
          {
            "node": "Send Messages to Members",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
Pro

For the full experience including quality scoring and batch install features for each workflow upgrade to Pro

About this workflow

This workflow is a daily progress check flow that runs automatically at 17:00. It integrates Google Sheets, Slack, and ChatGPT to automate progress inquiries to team members and generate daily reports.

Source: https://n8n.io/workflows/11345/ — original creator credit. Request a take-down →

More AI & RAG workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.

AI & RAG

Imagine a dedicated financial expert tirelessly working behind the scenes, sifting through every transaction, every investment move, and every accounting entry. That's exactly what this automated syst

HTTP Request, Google Sheets, OpenAI +3
AI & RAG

This workflow automatically collects the latest technology news, filters for emerging topics, and uses AI to score relevance and generate clean, ready-to-share content. It helps you focus on high-impa

RSS Feed Read, OpenAI, Google Sheets +1
AI & RAG

(n8n + Google Sheets + OpenAI + Slack)

Google Sheets, Slack, OpenAI
AI & RAG

Automate your social media content pipeline from idea to scheduled post. This workflow reads content ideas from a Google Sheet, uses OpenAI to generate platform-optimized posts for LinkedIn, X (Twitte

Google Sheets, OpenAI, HTTP Request +2
AI & RAG

Property management companies, building managers, and inspection teams who want to automate recurring property inspections, improve issue tracking, and streamline reporting.

Google Sheets, OpenAI, Gmail +2