Back to Templates
How it works
This workflow automatically creates a weekly report of tasks. Every Friday morning, it collects all task details from Airtable, checks progress, and prepares a summary. It also highlights important or late tasks and sends the report to Slack, email, and saves it for record.
Step-by-step
-
Trigger & fetch
- Schedule: Every Friday 9AM – Triggers the workflow automatically every Friday at 9 AM.
- Airtable: Fetch This Week – Collects all task records from the Airtable base for the current week.
-
Analysis & formatting
- Code: Analyze & Format – Checks all tasks, detects fields, calculates completion rate, identifies overdue and urgent items, and builds the full Slack message with an
{{AI_SUMMARY}}placeholder.
- Code: Analyze & Format – Checks all tasks, detects fields, calculates completion rate, identifies overdue and urgent items, and builds the full Slack message with an
-
AI summary generation
- OpenAI: Generate AI Summary – Sends the weekly stats to GPT-4.1-mini with a structured prompt to produce a concise 2–3 sentence plain-English project manager summary.
-
Merge & prepare
- Code: Merge AI Summary – Injects the AI summary into the Slack message and prepares urgent alert messages for overdue or high-priority tasks.
-
Parallel output actions
- Slack: Post Weekly Digest – Posts the full formatted digest to a Slack channel with mrkdwn formatting.
- Gmail: Send Digest Email – Sends an HTML-formatted email with stats cards, AI summary, and a task table.
- Google Sheets: Log Weekly Stats – Appends week range, totals, completion rate, overdue count, AI summary, and status to a tracking sheet.
-
Conditional urgent alert
- IF: Has Urgent or Overdue? – Checks if overdue or urgent task count is greater than zero.
- Slack: DM Urgent Alert – Sends a separate urgent action-required message to Slack if flagged items exist.
- Gmail: Send Urgent Alert – Sends a red-header alert email listing overdue and urgent counts if flagged items exist.
Why use this?
- Eliminates manual weekly reporting by automatically collecting, analyzing, and summarizing all Airtable task data
- Keeps the entire team informed across Slack and Email every Friday without lifting a finger
- AI-generated summaries give instant clarity on project health and what needs attention
- Logs every weekly digest to Google Sheets for long-term trend tracking and reporting
- Sends a separate urgent alert so critical or overdue tasks never get buried in the digest