Keep tabs on who has access to your Airtable
Base gets renamed or permissions change. Notis logs it immediately to your audit sheet, so you know exactly what changed and when.
Trigger
Base Metadata Changed
Triggers when an existing Airtable base changes its name or permission level.
Action
Update Sheet Properties
Tool to update properties of a sheet (worksheet) within a google spreadsheet, such as its title, index, visibility, tab color, or grid properties. use this when you need to modify the metadata or appearance of a specific sheet.
Why this helps
Airtable permissions and base names shift, but you don't have a record of who can access what or when access was granted.
- Maintain transparent record of base access changes
- Quickly spot unauthorized permission changes
- Improve security audits and compliance reporting
- Preserve history of structural changes over time
Setup
Build it in a few focused steps.
- 1Connect Airtable and Google Sheets to Notis
- 2Create automation: 'When my Airtable base metadata changes (name or sharing), log the base name, change type, and timestamp to my Base Audit sheet'
- 3Set trigger to 'Base Metadata Changed' and action to 'Append Values to Spreadsheet'
- 4Set up notification to alert you when permissions change
- 5Test by renaming a base or adjusting sharing and verify the log entry in Google Sheets
Questions about this workflow
Does it track which user made the change?
Airtable logs the user. Notis captures this if available in the metadata.
Can it alert on specific permission changes (e.g., making base public)?
Yes. Tell Notis to highlight or alert on certain permission types.
How far back does the history go?
Your Google Sheets log preserves all changes from setup forward. Airtable's API usually provides recent changes.
Can it prevent unauthorized sharing?
No, but logging allows quick detection and rollback of unwanted changes.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Airtable to Google Sheets. A trigger fires from one place; an action lands in another.
Airtable triggers
Google Sheets actions
Base Metadata Changed
Triggers when an existing Airtable base changes its name or permission level.
Add Sheet to Spreadsheet
Adds a new sheet (worksheet) to a spreadsheet. use this tool to create a new tab within an existing google sheet, optionally specifying its title, index, size, and other properties.
Base Schema Changed
Triggers when tables, fields, or views change in an Airtable base.
Aggregate Column Data
Searches for rows where a specific column matches a value and performs mathematical operations on data from another column.
User Profile Changed
Triggers when the connected Airtable user's profile information changes.
Append Dimension
Tool to append new rows or columns to a sheet, increasing its size. use when you need to add empty rows or columns to an existing sheet.
View Created
Triggers when a new view is created in an Airtable base.
Batch get spreadsheet
Retrieves data from specified cell ranges in a google spreadsheet; ensure the spreadsheet has at least one worksheet and any explicitly referenced sheet names in ranges exist.
View Deleted
Triggers when a previously known Airtable view is deleted.
Batch update spreadsheet
Updates a specified range in a google sheet with given values, or appends them as new rows if `first cell location` is omitted; ensure the target sheet exists and the spreadsheet contains at least one worksheet.
View Metadata Changed
Triggers when an Airtable view changes its name or type.
Batch Update Values by Data Filter
Tool to update values in ranges matching data filters. use when you need to update specific data in a google sheet based on criteria rather than fixed cell ranges.
Clear Basic Filter
Tool to clear the basic filter from a sheet. use when you need to remove an existing basic filter from a specific sheet within a google spreadsheet.
Clear spreadsheet values
Clears cell content (preserving formatting and notes) from a specified a1 notation range in a google spreadsheet; the range must correspond to an existing sheet and cells.
Connect any two apps with Notis in the middle.
Not just Airtable and Google Sheets. 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 Sheets.