Organize monthly close follow-up in Gmail
Give close-related follow-up a consistent label when the scheduled data check says it is needed.
Trigger
Recurring schedule
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Action
Create label
Creates a new label with a unique name in the specified user's gmail account.
Why this helps
Close tasks can be hard to track when data review and email follow-up happen in separate places.
- Create a label when your defined check signals follow-up.
- Keep close-related email organization consistent.
- Avoid relying on memory to create the label each cycle.
Setup
Build it in a few focused steps.
- 1Connect ClickHouse and Gmail once in the Notis portal.
- 2Create an automation in Automations, New Automation, and name it.
- 3Tell Notis which close query and condition should lead to creation of a uniquely named Gmail label.
- 4Pick a recurring schedule and choose where run reports should go.
- 5Test with one real close result and confirm the label in Gmail.
Questions about this workflow
Does the workflow apply the label to emails?
No. It creates a Gmail label. Applying it to messages is a separate action that needs message identifiers.
What defines when close follow-up is needed?
Specify the query and condition in your instruction.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link ClickHouse to Gmail. A trigger fires from one place; an action lands in another.
ClickHouse triggers
Gmail actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Modify email labels
Adds and/or removes specified gmail labels for a message; ensure `message id` and all `label ids` are valid (use 'listlabels' for custom label ids).
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Create email draft
Creates a gmail email draft, supporting to/cc/bcc, subject, plain/html body (ensure `is html=true` for html), attachments, and threading.
Create label
Creates a new label with a unique name in the specified user's gmail account.
Delete Draft
Permanently deletes a specific gmail draft using its id; ensure the draft exists and the user has necessary permissions for the given `user id`.
Delete message
Permanently deletes a specific email message by its id from a gmail mailbox; for `user id`, use 'me' for the authenticated user or an email address to which the authenticated user has delegated access.
Fetch emails
Fetches a list of email messages from a gmail account, supporting filtering, pagination, and optional full content retrieval.
Fetch message by message ID
Fetches a specific email message by its id, provided the `message id` exists and is accessible to the authenticated `user id`.
Fetch Message by Thread ID
Retrieves messages from a gmail thread using its `thread id`, where the thread must be accessible by the specified `user id`.
Connect any two apps with Notis in the middle.
ClickHouse and Gmail, or any other combination from 1,000+ integrations.
When this happens · Trigger
Do this · Action
Save your first hour today.
7-day trial of any paid plan, with 20$ of usage included.
No card. Works with personal or business Gmail.