Library / Tasks & Project Management
Tasks & Project Management
Track Water Intake in Google Sheets with Slack Reminders
On a schedule, it asks you in Slack to drink, records each drink you log in Google Sheets, and has OpenAI summarize progress against your target.
What it does
## When User interact the drink button. Record the drink value to sheet and send back the iOS health log water url to start the shortcut Note for Shortcut: The shortcul url will be like shortcuts://run-shortcut?name=darrell_water&input=%7B%22value%22%3A100%2C%22time%22%3A%222025-03-04T16%3A10%3A15%22%7D It's url encoded. The decoded version will be: shortcuts://run-shortcut?name=darrell_water&input={"value":100,"time":"2025-03-04T16:10:15"} We can see it pass the shortcut name and input with json string value. This will be used in iOS shortcut
The steps
- slack_action_payload
- slack_action_drink_data
- OpenAI
- Schedule Trigger
- Limit
- Google Sheets - Get Target
- Summarize
- combine data
- If
- Wait
- slack drink webhook
- Slack send drink notification
- Send to Slack with confirm
- Edit Fields-Set progress
16 steps in total.
Similar automations
RAG & Knowledge BasesRecord Patient Intake in a CRM with Claude RAG11 stepsRAG & Knowledge BasesSend Drink Water Reminders with OpenAI RAG11 stepsEmail AutomationTurn pool water tests into customer reports with Sheets, Gmail, Discord, and GPT-4o-mini34 stepsDocuments, PDF & OCRTurn Hiring Intake Transcripts into Briefs and Scorecards8 steps