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
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Create base
Creates a new airtable base with specified tables and fields within a workspace; ensure field options are valid for their type.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Create Comment
Creates a new comment on a specific record within an airtable base and table.
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 Field
Creates a new field within a specified table in an airtable base.
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 multiple records
Creates multiple new records in a specified airtable 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 a record
Creates a new record in a specified airtable table; field values must conform to the table's column types.
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 table
Creates a new table within a specified existing airtable base, allowing definition of its name, description, and field structure.
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.
Delete Comment
Deletes an existing comment from a specified record in an airtable table.
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.
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.
Google Sheets and Airtable, 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 Airtable.