Daily team progress checks & reports with Slack, ChatGPT and Google Sheets

Overview

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.

--- Overall Workflow Steps Triggered every day at 17:00. Reads the specified WBS management sheet. Automatically sends a Slack DM to each member based on their Slack ID. After 30 minutes, retrieves and aggregates progress information for the day. Sending Report to Slack Channel (e.g., "daily-report"). The report includes the date, each member’s progress, comments, etc.

--- Sample Output Individual Member DM “Hello Sato-san, could you briefly share today’s progress?”

Team Report Sample

📅 2025/10/20 Daily Progress Report ✅ Sato: Task A completed, B at 80% ✅ Suzuki: Design review completed ⚠️ Tanaka: API test delayed (Reason: data not received)

--- Maintenance Tips To avoid Slack rate limits, it is recommended to add a few seconds delay between messages Update node settings when Google Sheets column names change When using ChatGPT API, adjust temperature and maxtokens as needed

--- Setup Instructions 1. Google Sheets API authenticated (OAuth2) Obtain the Spreadsheet ID of the target sheet. 2. Slack Bot Token with chat:write, users:read, im:write permissions 3. OpenAI API Key registered 4. WBS sheet must include the following columns: Name Slack ID or Email Today Progress Remarks