Remove stale Coda rows after OneDrive deletions
When the source disappears, its tracking record can be cleaned up too.
Trigger
OneDrive Item Deleted Trigger
Triggers when a file or folder is deleted in OneDrive. Uses Gmail-style state management for reliable duplicate prevention.
Action
Delete row
Deletes the specified row from the table or view. this endpoint will always return a 202, so long as the row exists and is accessible (and the update is structurally valid). row deletions are generally processed within several seconds. when deleting using a name as opposed to an id, an arbitrary row will be removed.
Why this helps
Stale rows make project tables noisy and hide current work.
- Keep tracking tables current
- Reduce manual cleanup
- Avoid acting on deleted assets
Setup
Build it in a few focused steps.
- 1Connect OneDrive and Coda in Notis once.
- 2Create an automation describing the matching row and deletion rule.
- 3Pick the OneDrive Item Deleted trigger.
- 4Choose where run reports should go.
- 5Test with a disposable row and item.
Questions about this workflow
Can it delete the wrong row?
Define a precise matching rule and require a confident match before deletion.
Can it archive instead?
Yes. Adjust the instruction to use a supported archive or review action if permanent deletion is not desired.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link One drive to Coda. A trigger fires from one place; an action lands in another.
One drive triggers
Coda actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Add a category for pack
Add a publishing category for a given pack.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Add a maker for pack
Set a maker for a given pack. used to display makers for a pack in the corresponding packs page.
Onedrivebasetrigger
Base trigger for OneDrive changes using Gmail-style state management. Subclasses override `filter_changes(...)` to extract only the relevant items.
Add a permission for pack
Create or modify user, workspace, or global permissions for a given pack.
OneDrive File Created Trigger
Triggers when a new file is created in OneDrive. Uses Gmail-style state management for reliable duplicate prevention.
Add custom domain
Add a custom domain to a published doc.
File Updated
Trigger that fires when a OneDrive file's content or metadata changes. Returns file ID, last modified time, and modifier info.
Add permission
Adds a new permission to the doc.
OneDrive Folder Created Trigger
Triggers when a new folder is created in OneDrive. Uses Gmail-style state management for reliable duplicate prevention.
Begin content export
Initiate an export of content for the given page.
OneDrive Item Deleted Trigger
Triggers when a file or folder is deleted in OneDrive. Uses Gmail-style state management for reliable duplicate prevention.
Content export status
Check the status of a page content export
Item Moved or Renamed
Triggers when a file or folder is moved to a different path or renamed in OneDrive. Includes both old and new path/name data in the payload.
Copy Document
Creates a copy of an existing coda document. this action allows you to duplicate a document while optionally specifying a new title and location for the copied document.
Connect any two apps with Notis in the middle.
One drive and Coda, 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 Coda.