Airtable + Google Sheets
Copy new or updated Airtable records to a range in Google Sheets
Streamline your workflow by instantly duplicating new or updated records from Airtable into Google Sheets. This automation takes care of the manual data entry, ensuring that any changes in your Airtable database are immediately reflected in your Google Sheets document. It's an efficient solution for multiple team collaboration, keeping everyone updated in real time.
Streamline your workflow by instantly duplicating new or updated records from Airtable into Google Sheets. This automation takes care of the manual data entry, ensuring that any changes in your Airtable database are immediately reflected in your Google Sheets document. It's an efficient solution for multiple team collaboration, keeping everyone updated in real time.
- When this happens...
New or Updated RecordTriggers when a record is created or updated.
TriggerPollingZapier checks for new data every 15 min on the Free plan - automatically do this!
Copy RangeCopy data from one range to another within a Google Sheets spreadsheet, with options for what to paste (values, formatting, etc.).
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
BaseRequired
TableRequired
Limit to View
Include attachment content
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planBaseRequired
TableRequired
RecordRequired
CommentRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Cache Copy
BaseRequired
TableRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.BaseRequired
TableRequired
Help Text
Primary lookup fieldRequired
Secondary lookup field
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.BaseRequired
TableRequired
RecordRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.BaseRequired
TableRequired
Number of RecordsRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.BaseRequired
TableRequired
Search by Field
Search Value
Search type
Search Formula
Limit to View
ActionThis is an event a Zap performs.SearchFind existing data in your appBaseRequired
Search KeywordRequired
Search In
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch KeywordRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appBaseRequired
TableRequired
Search by Field
Search Value
Search type
Search Formula
Limit to View
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundDont Change Sheet Structure
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Dont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
Use Timezone set up on the spreadsheet to format date values?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Condition TypeRequired
Background Color
Text Color
Bold Text
Italic Text
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
Spreadsheet Containing the Worksheet to CopyRequired
Worksheet to CopyRequired
Copy Worksheet Destination
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Confirm DeletionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Format TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SpreadsheetRequired
WorksheetRequired
New Sheet NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Sort by ColumnRequired
Sort OrderRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Row IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
Help Text
BaseRequired
TableRequired
Last modified time columnRequired
Limit to view
Include file contents?
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planBaseRequired
TableRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
Workspace IDRequired
Number of TablesRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.BaseRequired
Table NameRequired
Table Description
Primary Field Name
Primary Field Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.BaseRequired
TableRequired
RecordRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
Additional request headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.BaseRequired
TableRequired
Record IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appBaseRequired
Table IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appBaseRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDont Change Sheet Structure
No Team Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Frozen Rows Count
Frozen Columns Count
Sheet Position
Hide Sheet
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Source RangeRequired
Destination RangeRequired
Paste Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Validation TypeRequired
Input Message
Strict Validation
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
Additional request headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
ColumnsRequired
Row countRequired
Output format
First row
ActionThis is an event a Zap performs.SearchFind existing data in your appSpreadsheet IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
About Airtable
Related categories
About Google Sheets
Related categories
Related Zap Templates
- Add new Airtable records in views to Google Sheets
- Save new Google Sheets rows to Airtable
- Update Airtable records with newly-updated rows in Google Sheets spreadsheets
- Update Google Sheets rows with new or updated Airtable records.
- Track new Airtable records in Google Sheets rows
- Update Airtable records with new or updated Google Sheets rows
- Track new survey responses and alert a team via email
- Create Airtable records for new Google Sheets rows
- Create Google Sheet row(s) for new Airtable records
- Create Airtable records from new or updated Google Sheets rows.
- Create rows in Google Sheets with new or updated Airtable records
- Create Airtable records from new or updated Google Sheets spreadsheet rows
- Create Airtable records for new or updated rows in a Google Sheet (Team Drive)
- Create Google Sheet rows for new Airtable records in a view
- Create Google Sheets rows for new updates to Airtable records
- Create Airtable records for new Google Sheets rows.
- Create Airtable records with line items from new or updated Google Sheets rows
- Update Google Sheets rows with new or updated Airtable records
- Create Airtable records from new Google Sheets rows with line items
- Update Airtable records when new or updated Google Sheets team drive spreadsheet rows are detected
- Create Airtable records with line item support from new or updated Google Sheets rows in team drive
- Create new Google Sheets worksheets for each new Airtable record
- Create or update Google Sheets worksheets when new or updated Airtable records appear
- Copy new or updated Airtable records to Google Sheets worksheets
- Create new Google Sheets worksheets for every record added to Airtable
- Add new Airtable records to Google Sheets as rows
- Update Google Sheets rows with new Airtable records
- Create multiple Google Sheets rows from new Airtable records in view
- Create Google Sheets rows for new or updated Airtable records
- Add new Airtable records to Google Sheets as multiple rows
- Update Google Sheets rows with new or updated Airtable records
- Add new Airtable records to Google Sheets as rows
- Create spreadsheets in Google Sheets for new Airtable records
- How to Connect Apps to Webhooks Demo #1
- Create new records in Airtable from new worksheets in Google Sheets
- Create or update Airtable records with new or updated Google Sheets rows on team drive
- Create or update Airtable records from new Google Sheets rows
- Create or update Airtable records from new or updated rows in Google Sheets
- Update Google Sheets rows with new Airtable records
- Maintain and update Airtable extensions with every new or updated row in Google Sheets
- Create or update Airtable records from new rows in Google Sheets team drive
- Create and update Google Sheets spreadsheets with new or updated Airtable records
- Create new actions in Google Sheets when new records appear in Airtable
- Create records in Airtable from new spreadsheets in Google Sheets
- Update Airtable records when new rows are added to Google Sheets in team drive
- Create Google Sheets columns for new Airtable records
- Find specific Airtable records and update them from a Google Sheet
- Create new Airtable records with line items for each new row in Google Sheets
- Create or update Airtable records when new spreadsheets are added in Google Sheets
- Update Airtable records with new or updated rows from Google Sheets team drive
- Create records in Airtable from new rows in Google Sheets
- Update Airtable records when new rows are added in Google Sheets
- Update or create Airtable records from new or updated rows in Google Sheets team drive
- Track new or updated Airtable records by creating rows in Google Sheets
- Manage new or updated Google Sheets rows by creating or updating records in Airtable
- Create or update Airtable records from new or updated rows in your Google Sheets team drive
- Create Airtable records from new Google Sheets rows in team drive
- Create top rows in Google Sheets for new Airtable records
- Create Google Sheets rows at top for new or updated Airtable records
- Update Google Sheets properties when new or updated records are detected in Airtable
- Create new Airtable bases from new or updated Google Sheets rows
- Clear Google Sheets rows for new or updated Airtable records
- Create new Airtable tables from new Google Sheets rows
- Update Google Sheets with new or updated records from Airtable
Related Zap Templates
- Add new Airtable records in views to Google Sheets
- Update Google Sheets rows with new or updated Airtable records.
- Track new survey responses and alert a team via email
- Create Airtable records from new or updated Google Sheets rows.
- Create Airtable records for new or updated rows in a Google Sheet (Team Drive)
- Create Airtable records for new Google Sheets rows.
- Create Airtable records from new Google Sheets rows with line items
- Create new Google Sheets worksheets for each new Airtable record
- Create new Google Sheets worksheets for every record added to Airtable
- Create multiple Google Sheets rows from new Airtable records in view
- Update Google Sheets rows with new or updated Airtable records
- How to Connect Apps to Webhooks Demo #1
- Create or update Airtable records from new Google Sheets rows
- Maintain and update Airtable extensions with every new or updated row in Google Sheets
- Create new actions in Google Sheets when new records appear in Airtable
- Create Google Sheets columns for new Airtable records
- Create or update Airtable records when new spreadsheets are added in Google Sheets
- Update Airtable records when new rows are added in Google Sheets
- Manage new or updated Google Sheets rows by creating or updating records in Airtable
- Create top rows in Google Sheets for new Airtable records
- Create new Airtable bases from new or updated Google Sheets rows
- Update Google Sheets with new or updated records from Airtable
- Save new Google Sheets rows to Airtable
- Track new Airtable records in Google Sheets rows
- Create Airtable records for new Google Sheets rows
- Create rows in Google Sheets with new or updated Airtable records
- Create Google Sheet rows for new Airtable records in a view
- Create Airtable records with line items from new or updated Google Sheets rows
- Update Airtable records when new or updated Google Sheets team drive spreadsheet rows are detected
- Create or update Google Sheets worksheets when new or updated Airtable records appear
- Add new Airtable records to Google Sheets as rows
- Create Google Sheets rows for new or updated Airtable records
- Add new Airtable records to Google Sheets as rows
- Create new records in Airtable from new worksheets in Google Sheets
- Create or update Airtable records from new or updated rows in Google Sheets
- Create or update Airtable records from new rows in Google Sheets team drive
- Create records in Airtable from new spreadsheets in Google Sheets
- Find specific Airtable records and update them from a Google Sheet
- Update Airtable records with new or updated rows from Google Sheets team drive
- Update or create Airtable records from new or updated rows in Google Sheets team drive
- Create or update Airtable records from new or updated rows in your Google Sheets team drive
- Create Google Sheets rows at top for new or updated Airtable records
- Clear Google Sheets rows for new or updated Airtable records
- Update Airtable records with newly-updated rows in Google Sheets spreadsheets
- Update Airtable records with new or updated Google Sheets rows
- Create Google Sheet row(s) for new Airtable records
- Create Airtable records from new or updated Google Sheets spreadsheet rows
- Create Google Sheets rows for new updates to Airtable records
- Update Google Sheets rows with new or updated Airtable records
- Create Airtable records with line item support from new or updated Google Sheets rows in team drive
- Copy new or updated Airtable records to Google Sheets worksheets
- Update Google Sheets rows with new Airtable records
- Add new Airtable records to Google Sheets as multiple rows
- Create spreadsheets in Google Sheets for new Airtable records
- Create or update Airtable records with new or updated Google Sheets rows on team drive
- Update Google Sheets rows with new Airtable records
- Create and update Google Sheets spreadsheets with new or updated Airtable records
- Update Airtable records when new rows are added to Google Sheets in team drive
- Create new Airtable records with line items for each new row in Google Sheets
- Create records in Airtable from new rows in Google Sheets
- Track new or updated Airtable records by creating rows in Google Sheets
- Create Airtable records from new Google Sheets rows in team drive
- Update Google Sheets properties when new or updated records are detected in Airtable
- Create new Airtable tables from new Google Sheets rows