Comment on an Airtable record when its Drive file is shared
When someone new gets access to a file, the people tracking it in Airtable should know. Notis posts a comment on the linked record the moment a share happens, so access changes are visible without anyone digging through Drive settings.
Trigger
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.
Action
Create Comment
Creates a new comment on a specific record within an airtable base and table.
Why this helps
Sharing changes happen silently in Drive, and the team tracking the file in Airtable has no idea who was just added.
- Access changes are announced right on the Airtable record
- No one has to open Drive sharing settings to stay informed
- A visible trail of who was added, in context
Setup
Build it in a few focused steps.
- 1Connect Google Drive and Airtable to Notis once from the portal.
- 2In the portal, open Automations and click New Automation.
- 3Write the prompt: when a Google Drive file gets a new share, comment on the linked Airtable record with who was added.
- 4Pick the File Shared trigger and set your run-report channel.
- 5Share a test file and confirm a comment appears on the record.
Questions about this workflow
Where does the comment go?
Onto the Airtable record that matches the shared file, based on the rule you describe in the prompt.
Can I include who was granted access?
Yes. The share event carries the new permission, so Notis can include that detail in the comment.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Drive to Airtable. A trigger fires from one place; an action lands in another.
Google Drive triggers
Airtable actions
Comment Added (Docs/Sheets/Slides)
Triggers when a new comment is added to Google Docs, Sheets, or Slides.
Create base
Creates a new airtable base with specified tables and fields within a workspace; ensure field options are valid for their type.
File Created
Triggers when a new file is created in Google Drive.
Create Comment
Creates a new comment on a specific record within an airtable base and table.
File Deleted or Trashed
Triggers when a file is moved to trash or permanently deleted in Drive.
Create Field
Creates a new field within a specified table in an airtable base.
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.
Create multiple records
Creates multiple new records in a specified airtable table.
File Updated
Triggers when a file's metadata or content changes in Google Drive.
Create a record
Creates a new record in a specified airtable table; field values must conform to the table's column types.
Google Drive Changes
Triggers when changes are detected in a Google Drive.
Create table
Creates a new table within a specified existing airtable base, allowing definition of its name, description, and field structure.
New File Matching Query
Triggers when a new Google Drive file matches a provided query. This is the legacy query-centric trigger: it preserves Drive API query config such as ``corpora`` / ``driveId`` aliases and emits the historical ``file_matching_query`` event type. ``FileCreatedTrigger`` covers the broader "new file" case and emits ``file_created``.
Delete Comment
Deletes an existing comment from a specified record in an airtable table.
Delete multiple records
Deletes up to 10 specified records from a table within an airtable base.
Connect any two apps with Notis in the middle.
Not just Google Drive and Airtable. 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 Airtable.