← All N8N workflows
AI & researchGoogle SheetsIfLimitMergeOpen Ai

Grab recent drink data

Configured with Google Sheets, Limit, Open Ai, Schedule Trigger, and additional nodes. Review the connections and setup before adapting this template.

Workflow preview
Transformslack_action_payloadEdit FieldsTransformslack_action_drink_dataEdit FieldsAI & modelsOpenAIOpen AiTriggerSchedule TriggerSchedule TriggerTransformLimitLimitData storeGoogle Sheets - GetTargetGoogle SheetsTransformSummarizeSummarizeTransformcombine dataMergeRoutingIfIfWaitWaitWaitTriggerslack drink webhookWebhookMessagingSlack send drinknotificationSlackMessagingSend to Slack withconfirmSlackTransformEdit Fields-SetprogressEdit FieldsData storeGoogle Sheets - logwater value to sheetGoogle SheetsData storeGoogle Sheets - GetToday Water LogGoogle Sheets

Node categories in this workflow

  • Transform
  • AI & models
  • Trigger
  • Data store
  • Routing
  • Wait
  • Messaging

Icons describe general node roles, inferred from node types. Inspect the parameters for the configured action.

Drag to pan; use + and − to zoom. Reconstructed from the exported node positions; nothing runs here. Dashed lines represent non-main connections. Full node names and notes appear below.

How it works

The exported workflow contains the following configured nodes. Their connections are shown above; inspect the JSON for the complete logic, expressions, and external actions.

Workflow node names, types, and operations
NodeCategoryTypeOperation
slack_action_payloadTransformEdit FieldsSee node parameters
slack_action_drink_dataTransformEdit FieldsSee node parameters
OpenAIAI & modelsOpen AiSee node parameters
Schedule TriggerTriggerSchedule TriggerSee node parameters
LimitTransformLimitSee node parameters
Google Sheets - Get TargetData storeGoogle SheetsSee node parameters
SummarizeTransformSummarizeSee node parameters
combine dataTransformMergeSee node parameters
IfRoutingIfSee node parameters
WaitWaitWaitSee node parameters
slack drink webhookTriggerWebhookSee node parameters
Slack send drink notificationMessagingSlackSee node parameters
Send to Slack with confirmMessagingSlackSee node parameters
Edit Fields-Set progressTransformEdit FieldsSee node parameters
Google Sheets - log water value to sheetData storeGoogle Sheetsappend
Google Sheets - Get Today Water LogData storeGoogle SheetsSee node parameters

Setup

  1. Download the JSON and import it into an isolated n8n instance. Leave the workflow inactive.
  2. Connect your own credentials through n8n’s credential store. Replace REPLACE_WITH_* values with your resource identifiers.
  3. Inspect API destinations, Code nodes, database queries, file paths, and outbound actions.
  4. Run with synthetic data and harmless destinations. Enable triggers only after checking the actual outputs.

Requirements

An n8n instance with the listed node types and compatible versions. Service-connected workflows may require accounts, credentials, or paid APIs.

Credential types declared in the source

  • googleSheetsOAuth2Api
  • openAiApi
  • slackOAuth2Api

Workflow notes

Wait

If the user log water recently. Wait for another 3x minutes

Sticky Note1

If already drink recently. Delay the notification in 3x minutes randomly

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

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

Created by darrell_tw_

Created by darrell_tw_

An engineer now focus on AI and Automation

contact me with following:

X Threads Instagram Website

Grab recent drink data

Grab recent drink data

Purpose and structure

This folder contains the Grab recent drink data workflow. Its executable nodes use googleSheets, if, limit, merge, openAi, scheduleTrigger, set, slack, summarize, wait, webhook. The table and connection map below are derived from the JSON, not an inferred guarantee of behavior.

Setup

Import inactive. Configure your own credentials and replace REPLACE_WITH_* values. Review external destinations and Code nodes before running.

Entry points

Schedule Trigger, slack drink webhook

Verification

Sanitized source candidate; not runtime-tested. This overview is generated from node metadata. Read the folder README for the connection map, credential types, and license.

Attribution

https://github.com/Zie619/n8n-workflows/blob/94007c1445d9258a7da116646b79473e7c7c3282/workflows/Wait/0766_Wait_Limit_Update_Webhook.json MIT; preserve source notices.

Canvas section labels

These name areas of the original canvas; they do not include explanatory instructions.

  • Grab recent drink data
  • Send the slack notification with AI wording. Also have the drink water action buttons

More in AI & research