How it works
To get okoCrm notifications in Google Sheets, you don't need a developer: a ready-made scenario watches events and sends messages for you.
- Starts when: Schedule Trigger
- Then: Google Sheets - Get Target
- Check: combine data
- Then: Edit Fields-Set progress
- Check: If
- If yes: Wait
- Then: OpenAI
- Then: Slack send drink notification
- Then: Google Sheets - Get Today Water Log
- Then: Limit
- Then: Summarize
- Then: slack_action_payload
- Then: slack_action_drink_data
- Then: Google Sheets - log water value to sheet
- Then: Send to Slack with confirm
- Starts when: slack drink webhook
You can launch this okoCrm + Google Sheets integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.