Every 2 hours, plus a daily total

Get reminders to drink water

A friendly nudge in Slack every couple of hours, and a total for the day each evening.

Runs: Every 2 hours, plus a daily total
Apps: Google Sheets, Slack
AI: Optional
Access: Slack chat:write; Sheets read+write

Send this to your assistant

Create a ClickRuntime automation: every 2 hours on weekdays, remind me in Slack to drink water. At 6pm, add up today's entries in my Water sheet and post the total.

Paste it into your assistant. It tells you what it will send or change before it runs live.

Add to ChatGPT Add to Claude

First time? Adding ClickRuntime to your assistant takes about two minutes.

Why use it

Why teams use this automation

A remote worker spends eight hours at a screen and realizes at 4 pm that she has had two coffees and no water. She has tried phone alarms, which she silences without thinking, and apps with streaks that she forgets to open. What she actually looks at all day is Slack, and what she lacks is a simple record, so she cannot tell whether she is drinking enough or just thinks so.

Every two hours during the working day, ClickRuntime posts a reminder to drink water in Slack. You log a glass by adding a row to a Google Sheet, with an amount if you like. At the end of the day, it reads the day's rows and posts your total compared with your goal.

It suits desk workers, people building a health habit, and teams who want a friendly wellness channel.

What you get out of it

Reminders where you already look
A message in Slack is harder to ignore than a phone alarm you have learned to dismiss. Seeing the reminder among your work messages makes it part of the day.
A record instead of a feeling
Rows in a sheet show how much you actually drank on each day. Patterns such as low intake on meeting-heavy days become visible and give you something concrete to change.
A daily total keeps you honest
The end-of-day post compares your total with your goal. It is a small nudge, and seeing 1.2 liters against 2 makes it easier to improve tomorrow than a vague sense of having done well.
Simple enough to keep using
Adding a row takes seconds, with no app to install. Habits stick when logging costs almost nothing, and a sheet is something most people already know how to use. Fewer steps means fewer skipped days over a month.
Easy to share with a team
Posted in a shared channel, the reminders become a light wellness routine for the whole group. People encourage each other, and nobody needs to learn a new tool to join in.

How it works

What happens, step by step

Every 2 hours during the working day, ClickRuntime posts a friendly reminder in your #me Slack channel to drink a glass of water.
You log each glass in the Water tab of your Google Sheet.
In the evening it adds up today's entries from the sheet.
You get a Slack message with the total, such as "Today you drank 2,250 ml".

Before it runs live

Connect your Google Sheets account and pick the spreadsheets it may use
Connect Slack, then invite the app to the channel (type /invite @ClickRuntime there)

What you get

RunsEvery 2 hours, plus a daily total

Get reminders to drink watertoday, 9:00Succeeded

Slack · #me💧 Today you drank 2,250 ml 🎉

Build your own

Need it to work differently?

This template is a starting point. Copy the prompt and change it, or describe a different automation from scratch, with your own conditions, more apps or an AI step. Your assistant writes it, tests it and runs it on ClickRuntime.

Your own rules
Conditions, thresholds, filters and exceptions, written the way you'd explain them to a colleague.
Any number of apps
One automation can read from one app and update several others. Over 248 apps are ready, and anything with an API works too.
AI where it helps
Summaries, classification, extraction and drafts use ClickRuntime's built-in AI, with no extra key.
On a schedule or on each event
Runs as often as every 5 minutes, or the moment an app sends an event, and keeps track of what it already handled.

Changes you can ask for

Run it at a different time, more or less often, or only on weekdays
Change what the AI looks for, or how it writes the result
Add another app, for example also send it to Gmail
Combine it with other Google Sheets and Slack steps into one automation

Under the hood

The code that runs this automation

This is the Python script that runs each time the automation starts. Your AI assistant writes it for you when you send the prompt, and you allow each step in your assistant. To change how the automation works, describe the change to your assistant and it updates the script for you. For every function it can use, see the script reference.

water_drinking_reminder_with_a_log_sheet.pyexample

from datetime import datetime, date
from zoneinfo import ZoneInfo
from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from clickruntime import on_trigger, credentials, notify

SHEET_ID = "your-spreadsheet-id"
TZ = ZoneInfo("Europe/London")

@on_trigger
def run(event):  # every 2 hours on weekdays, 8am-6pm
    if datetime.now(TZ).hour < 18:
        notify.slack("💧 Time for a glass of water. Log it in the Water sheet.", channel="#me")
        return {"reminded": True}
    sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False)
    rows = sheets.spreadsheets().values().get(spreadsheetId=SHEET_ID, range="Water!A2:B").execute().get("values", [])
    today = date.today().isoformat()
    total = sum(int(r[1]) for r in rows if len(r) > 1 and r[0].startswith(today) and r[1].isdigit())
    notify.slack(f"💧 Today you drank {total} ml{' 🎉' if total >= 2000 else ''}", channel="#me")
    return {"total_ml": total}

FAQ

Common questions

How do I log a glass of water?

Add a row to the sheet with the date and an amount, or just a tick for one glass. You can also type a short message in a Slack thread if you prefer, and the amount is saved to the sheet for you.

Can I change the goal or reminder times?

Yes. Pick any daily goal, such as 8 glasses or 2 liters, and set reminders to match your hours, for example 9:00 to 17:00. You can also skip weekends or pause reminders on days off.

Can AI write a friendlier message?

Optionally. The AI can vary the reminder wording, so it does not read the same every time, and add a short comment on your daily total. That keeps the nudges fresh without you having to write new ones.

What permissions does it need?

Slack chat:write; Sheets read+write. Nothing else in your accounts is used.

Does it need AI?

No, but you can ask for an AI step (for example a summary). It then uses ClickRuntime's built-in AI allowance.

How many runs does it use?

One run each time it runs (every 2 hours, plus a daily total). Checks that find nothing to do and stop right away aren't counted.

Can I change how it works?

Yes. Describe the change to your AI assistant, for example a different schedule, channel or filter. It updates the automation, tests it and tells you what changed.

Daily