Find stale Uploadcare assets on a schedule
Bring cleanup candidates forward before they clutter your work.
Trigger
Recurring schedule
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Action
Query
Query tool will run a sql query in bigquery. note: make sure the query being input in a single line format. for example, select * from sample dataset.sample table where column name = 'value'
Why this helps
Old files pile up because cleanup is easy to postpone.
- A smaller cleanup backlog
- Less mental clutter
Setup
Build it in a few focused steps.
- 1Connect Uploadcare and Google BigQuery to Notis once.
- 2Create the automation through the portal or conversationally.
- 3Ask Notis to query for stale asset records needing review.
- 4Select a monthly schedule and run-report channel.
- 5Test it against existing asset data.
Questions about this workflow
Will it delete files?
No. This workflow only identifies candidates through a query.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Uploadcare to Google BigQuery. A trigger fires from one place; an action lands in another.
Uploadcare triggers
Google BigQuery actions
Query
Query tool will run a sql query in bigquery. note: make sure the query being input in a single line format. for example, select * from sample dataset.sample table where column name = 'value'
Connect any two apps with Notis in the middle.
Not just Uploadcare and Google BigQuery. Any combination from 1,000+ integrations.
When this happens · Trigger
Do this · Action
Save your first hour today.
7 days free trial with 20$ free usage included.
No card. Works with personal or business Google BigQuery.