Auto-Create Airtable Bases When You Add New Spreadsheets
You create a Google Sheet to explore a new idea. Notis automatically creates a matching Airtable base with standard tables and fields, so both tools are ready to use without manual setup.
Trigger
New Spreadsheet Created
Triggers when a new Google Spreadsheet is created. This trigger monitors Google Spreadsheets and fires when new spreadsheets are detected. Uses timestamp filtering to efficiently detect newly created spreadsheets.
Action
Create table
Creates a new table within a specified existing airtable base, allowing definition of its name, description, and field structure.
Why this helps
Every new project or initiative requires duplicate setup work: building tables, adding fields, and configuring both Sheets and Airtable. This repetitive work breaks momentum.
- Skip repetitive setup work every time you start a new project
- Ensure consistent table structure across all initiatives
- Both tools ready to use immediately, no manual configuration
- Maintain a clear separation of Sheets (exploration) and Airtable (structure)
Setup
Build it in a few focused steps.
- 1Connect your Google and Airtable accounts to Notis.
- 2Ask Notis: 'When I create a new Google Spreadsheet, automatically create a matching Airtable base with standard tables for tasks, notes, and timeline.' Notis remembers your preference.
- 3Specify your standard table structure (names and field types) that should be created in Airtable each time.
- 4Choose a Telegram or email channel for confirmation when bases are created.
- 5Test by creating a new Google Spreadsheet and checking that the Airtable base appears within a minute.
Questions about this workflow
Can I customize which tables are created?
Yes, describe your standard table structure in the automation prompt. Notis creates exactly the tables and fields you define.
What if I don't want a base created for every spreadsheet?
Add a filter to your prompt: 'Only create bases for spreadsheets with a name starting with Project.' This prevents unwanted base creation.
Will the base be created in a specific Airtable workspace?
Yes, specify which workspace in your automation prompt. Notis creates all bases there.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Airtable. A trigger fires from one place; an action lands in another.
Google Sheets triggers
Airtable actions
Aggregate Metric Changed
Triggers when an aggregate metric (SUM/COUNT/AVG/MIN/MAX) changes in a Google Sheets spreadsheet. This trigger monitors an aggregate calculation on a target column (optionally filtered by a search column/value) and fires when the calculated result changes.
Create base
Creates a new airtable base with specified tables and fields within a workspace; ensure field options are valid for their type.
Cell Range Values Changed
Triggers when values in a specified A1 range change in Google Sheets. This trigger monitors a specific cell or range of cells and fires when any values change.
Create Comment
Creates a new comment on a specific record within an airtable base and table.
Conditional Format Rule Changed
Triggers when conditional formatting rules change in a Google Spreadsheet. Detects when rules are added, updated, or removed. Uses snapshot-based diffing to detect changes between polls.
Create Field
Creates a new field within a specified table in an airtable base.
Data Validation Rule Changed
Triggers when data validation rules change (added/updated/removed) in a Google Spreadsheet. Uses snapshot-based diffing to detect changes between polls.
Create multiple records
Creates multiple new records in a specified airtable table.
Developer Metadata Changed
Triggers when developer metadata entries change (new/updated/removed) in a Google Spreadsheet. Uses snapshot-based diffing to detect changes between polls.
Create a record
Creates a new record in a specified airtable table; field values must conform to the table's column types.
Filtered Range Values Changed
Polling trigger that monitors Google Sheets filtered ranges for value changes. Uses snapshot-based diffing to detect when values matching a data filter change. Emits the matched values when changes are detected.
Create table
Creates a new table within a specified existing airtable base, allowing definition of its name, description, and field structure.
New Rows in Google Sheet
Simple polling trigger that monitors Google Sheets for new rows. Detects when new rows are added and returns the complete row data. Perfect for triggering any workflow based on new sheet entries.
Delete Comment
Deletes an existing comment from a specified record in an airtable table.
New Sheet Added in Google Spreadsheet
Polling trigger that detects when a new sheet is added to a Google Spreadsheet.
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 Sheets and Airtable. Any combination from 985+ 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.