Find analysis files that may need attention
Surface older analysis documents for a quick review before they become confusing or get reused without context.
Trigger
Recurring schedule
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Action
Find file
Tool to list or search for files and folders in google drive. use when you need to find specific files based on query criteria or list contents of a drive/folder.
Why this helps
Old exports and notes accumulate quietly, making it unclear which analysis is still relevant.
- Surface candidate files for human review.
- Reduce clutter and uncertainty in analytics folders.
- Use consistent age and naming criteria.
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 name it for stale analysis discovery.
- 3In one instruction, ask Notis to search the specified Drive location for files matching your age and naming criteria, then report candidates without deleting them.
- 4Pick a recurring schedule and choose where run reports go.
- 5Test with one real folder and review whether the returned candidates fit your criteria.
Questions about this workflow
Will it delete stale files?
No. This workflow finds and reports candidate files for review.
How does it know what counts as stale?
State the age threshold and matching criteria in the instruction. The workflow should not assume a policy that was not provided.
Does it read ClickHouse data?
No ClickHouse query or trigger is involved in this Drive search. ClickHouse provides the context for which analysis files to look for.
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.