Automated water consumption tracker - stored in sheet and notify in Slack

by darrell_tw ✓ · 896 views · created 2025-02-28 · Personal Productivity, AI Chatbot

What this workflow does

This AI workflow has 16 nodes and runs on a schedule (cron =0 {{ Math.floor(Math.random() * 11) }} 8-23 * * *) (plus 1 other trigger). Along the way it connects OpenAI, Google Sheets and Slack.

How it runs

Trigger: On a schedule (cron =0 {{ Math.floor(Math.random() * 11) }} 8-23 * * *) (plus 1 other trigger).

1. Google Sheets: uses Google Sheets
2. Google Sheets: uses Google Sheets
3. slack_action_payload (Edit Fields (Set)): sets or maps fields
4. combine data (Merge): merges the data from its input branches
5. Limit: keeps the first few items
6. Summarize: summarizes / groups the items
7. slack_action_drink_data (Edit Fields (Set)): sets 5 fields: value, message_text, shortcut_url…
8. Edit Fields (Set): sets 2 fields: progress_percent, progress_image
9. Google Sheets: append
10. Send to Slack with confirm (Slack): uses Slack

…plus 4 more steps. See the full node list below.

Services it uses

OpenAIGoogle SheetsSlack

Before you upgrade to n8n 3.0

Nodes used (11)

• Edit Fields (Set)n8n-nodes-base.set
• OpenAI@n8n/n8n-nodes-langchain.openAi
• Schedule Triggern8n-nodes-base.scheduleTrigger
• Limitn8n-nodes-base.limit
• Google Sheetsn8n-nodes-base.googleSheets
• Summarizen8n-nodes-base.summarize
• Mergen8n-nodes-base.merge
• Ifn8n-nodes-base.if
• Waitn8n-nodes-base.wait
• Webhookn8n-nodes-base.webhook
• Slackn8n-nodes-base.slack

From the author

Water Reminder Workflow This workflow demonstrates how to use n8n and Slack to build an intelligent water drinking reminder system, combined with Google Sheets for data recording and OpenAI for generating personalized reminder messages. --- Google Sheet…

View the original on n8n.io → Check your own copy