Put recurring ClickHouse metrics in Drive
Get a consistent metrics note ready for your review without rebuilding the summary each time.
Trigger
Recurring schedule
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Action
Create a File from Text
Creates a new file in google drive from provided text content (up to 10mb), supporting various formats including automatic conversion to google workspace types.
Why this helps
Regular metrics reviews lose momentum when someone has to gather and rewrite the same numbers by hand.
- Create a repeatable review artifact.
- Make metric changes easier to scan over time.
- Keep recurring summaries in a shared Drive location.
Setup
Build it in a few focused steps.
- 1Connect ClickHouse and Google Drive once in the Notis portal.
- 2Create an automation in Automations, New Automation, and give it a clear name.
- 3In one instruction, ask Notis to summarize the supplied metrics with the reporting date and save a new Drive document.
- 4Pick a recurring schedule and choose where run reports go.
- 5Test with one real set of metrics and confirm the dated document appears in Drive.
Questions about this workflow
Does this schedule automatically query ClickHouse?
Only if the required data is available to the automation. The listed ClickHouse context provides no event trigger or query action, so supply the metrics or provide another supported way for Notis to access them.
Can the digest compare against last period?
Yes, when the current and prior-period metrics are available. The workflow should not assume a baseline that was not supplied.
How does the run begin?
A recurring Notis cron schedule starts the automation.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link ClickHouse to Google Drive. A trigger fires from one place; an action lands in another.
ClickHouse triggers
Google Drive actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Add file sharing preference
Modifies sharing permissions for an existing google drive file, granting a specified role to a user, group, domain, or 'anyone'.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Copy file
Duplicates an existing file in google drive, identified by its `file id`.
Create Comment
Tool to create a comment on a file. use when you need to add a new comment to a specific file in google drive.
Create Shared Drive
Tool to create a new shared drive. use when you need to programmatically create a new shared drive for collaboration or storage.
Create File or Folder
Creates a new file or folder with metadata. use to create empty files or folders, or files with content by providing it in the request body (though this action primarily focuses on metadata creation).
Create a File from Text
Creates a new file in google drive from provided text content (up to 10mb), supporting various formats including automatic conversion to google workspace types.
Create a folder
Creates a new folder in google drive, optionally within a parent folder specified by its id or name; if a parent name is provided but not found, the action will fail.
Create Reply
Tool to create a reply to a comment in google drive. use when you need to respond to an existing comment on a file.
Connect any two apps with Notis in the middle.
ClickHouse and Google Drive, 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 Google Drive.