Keep Databox Current When Drive Metrics Change
Let a changed source file prompt a dataset refresh, keeping reported figures closer to the latest version.
Trigger
File Updated
Triggers when a file's metadata or content changes in Google Drive.
Action
Push Data to Dataset (V1)
Tool to push data points to a Databox dataset using the v1 API. Use when you need to ingest data records into a specific dataset by providing the dataset ID and an array of records matching the dataset schema.
Why this helps
When a metrics file changes, the Databox copy can lag while someone remembers to upload the revised figures.
- Respond to updates in Drive files used as reporting sources.
- Push current records into an existing Databox dataset.
- Reduce missed refreshes caused by manual follow-up.
Setup
Build it in a few focused steps.
- 1Connect Google Drive and Databox once in the Notis portal.
- 2Create an automation in Automations, New Automation, and name it.
- 3In one instruction, identify the source file and describe which current records to send to the prepared Databox dataset.
- 4Pick the Google Drive File Updated trigger and choose where run reports go.
- 5Test with one real file update and review the ingestion report.
Questions about this workflow
Does this detect which cells or fields changed?
The listed trigger detects that file metadata or content changed. Specify the records to extract; the trigger description does not promise a cell-level diff.
Does the destination dataset need to exist already?
Yes. Push Data to Dataset sends records to a specific existing dataset.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Drive to Databox. A trigger fires from one place; an action lands in another.
Google Drive triggers
Databox actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Create Dataset
Tool to create a new dataset in Databox data source. Use when you need to initialize a dataset with a title, data source ID, and primary keys for unique record identification.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Create Data Source
Tool to create a new data source in Databox. Use when you need to create a logical container for datasets within a Databox account. Requires accountId, title, and timezone parameters.
Comment Added (Docs/Sheets/Slides)
Triggers when a new comment is added to Google Docs, Sheets, or Slides.
Delete Dataset
Tool to delete a dataset by ID in Databox. Use when you need to permanently remove a dataset. This operation is irreversible.
File Created
Triggers when a new file is created in Google Drive.
Delete Data Source
Tool to delete a data source by ID in Databox. Use when you need to permanently remove a data source. This operation is irreversible and will delete all associated datasets.
File Deleted or Trashed
Triggers when a file is moved to trash or permanently deleted in Drive.
Get Dataset Ingestion Status
Tool to check the status of a specific data ingestion for a dataset. Use when you need to verify whether a data ingestion was successful by providing the dataset ID and ingestion ID returned from the initial POST request.
File Shared (Permissions Added)
Triggers when new sharing permissions are granted to a file or folder. Uses Drive's `changes.list` endpoint with inline `permissions` in the `fields` mask so each change carries the file's current permission set provider-atomically. We diff that against `seen_permission_keys` to identify newly added grants. Drive page tokens are the primary cursor; if Drive rejects a stored token, the trigger raises `PollingTriggerError` without clearing state rather than silently re-baselining and dropping events. Limitation: truly ephemeral permissions (added and revoked between two polls without any other file modification in between) are not detected. Drive Activity API would catch those but requires an additional OAuth scope and a different payload contract.
List Accounts
Tool to retrieve all Databox accounts accessible to the authenticated user. Use to identify account IDs required for subsequent API operations like data source creation.
File Updated
Triggers when a file's metadata or content changes in Google Drive.
Push Data to Dataset (V1)
Tool to push data points to a Databox dataset using the v1 API. Use when you need to ingest data records into a specific dataset by providing the dataset ID and an array of records matching the dataset schema.
Google Drive Changes
Triggers when changes are detected in a Google Drive.
Connect any two apps with Notis in the middle.
Google Drive and Databox, 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 Databox.