Automated task reminders & daily recaps using Google Sheets and Slack
What This Workflow Does This workflow transforms Google Sheets into a lightweight productivity engine and connects it to Slack for automated reminders and daily recaps. No extra SaaS, no extra cost – just a simple sys...
Template notes
What This Workflow Does This workflow transforms Google Sheets into a lightweight productivity engine and connects it to Slack for automated reminders and daily recaps. No extra SaaS, no extra cost – just a simple system that keeps you on track and accountable.
---
Pre-conditions / Requirements Before you start, make sure you have: - A Google account with access to Google Sheets. - A Slack workspace where you can post reminders and summaries. - An n8n instance (self-hosted or cloud) with: - Google Sheets credentials connected. - Slack credentials connected.
---
How It Works 1. Task Tracking in Google Sheets - Add tasks with columns: Task ID, Task Name, Due Date, Status, and Why it matters. - The workflow checks for tasks that are due soon or overdue.
2. Automated Slack Reminders - Every 15 minutes, the workflow scans for tasks due in the next 30 minutes. - Slack sends a ping with the task name, deadline, and reason.
3. Daily Recap at 6 PM - Slack posts a summary of how many tasks you completed vs how many are still pending. - Encourages reflection and accountability.
4. Duplicate Protection - Each task has a "Last Reminder Sent" column so you don’t get spammed with repeat messages.