Google Sheets + Zapier Tables
Manage new, updated, or deleted records in Zapier Tables by creating worksheets in Google Sheets
Stay organized and up-to-date with this workflow. Whenever there's a new, updated, or deleted record in Zapier Tables, a corresponding worksheet is instantly created in Google Sheets. This automation helps ensure your data is always mirrored and up-to-date, saving you time and maintaining consistency across your tools.
Stay organized and up-to-date with this workflow. Whenever there's a new, updated, or deleted record in Zapier Tables, a corresponding worksheet is instantly created in Google Sheets. This automation helps ensure your data is always mirrored and up-to-date, saving you time and maintaining consistency across your tools.
- When this happens...
New or Updated or Deleted RecordTriggers when a record is added, updated, or deleted in a table.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Create WorksheetCreate a blank worksheet with a title. Optionally, provide headers.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Table IDRequired
Zap Id
Zap Step Id
Zap Path Run Id
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Table IDRequired
Zap Id
Zap Step Id
Zap Path Run Id
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Table IDRequired
Zap Id
Zap Step Id
Zap Path Run Id
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Table IDRequired
Zap Id
Zap Step Id
Zap Path Run Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Table IDRequired
Name
Description
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Table IDRequired
Record IDRequired
Zap Id
Zap Step Id
Zap Path Run Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Table IDRequired
Zap Id
Zap Step Id
Zap Path Run Id
ActionThis is an event a Zap performs.SearchFind existing data in your appTable NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNo 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.TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
HTTP MethodRequired
URLRequired
Query String Parameters
Headers
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
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Search from last row
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
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
Table IDRequired
Zap Id
Zap Step Id
Zap Path Run Id
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Table IDRequired
Zap Id
Zap Step Id
Zap Path Run Id
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Table IDRequired
Record IDRequired
Zap Id
Zap Step Id
Zap Path Run Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Table IDRequired
Zap Id
Zap Step Id
Zap Path Run Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Table IDRequired
Record IDRequired
Zap Id
Zap Step Id
Zap Path Run Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Table IDRequired
Zap Id
Zap Step Id
Zap Path Run Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Table IDRequired
Zap Id
Zap Step Id
Zap Path Run Id
ActionThis is an event a Zap performs.SearchFind existing data in your appTable IDRequired
Zap Id
Zap Step Id
Zap Path Run Id
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNo Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Trigger Column
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
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
Headers
Overwrite existing worksheets
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
Text Bold
Text Italic
Text Strikethrough
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
ColumnsRequired
Row CountRequired
First Row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Headers
Overwrite existing worksheets
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 Google Sheets
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Related categories
Related categories
Related Zap Templates
- Add new Zapier table records to Google Sheets
- Create Google Sheets rows from new or updated Zapier table records
- Update Google sheets rows with new Zapier tables records
- Create records in Zapier Tables from new rows in Google Sheets
- Create records in Zapier Tables for new or updated Google Sheets rows
- Create new Zapier Tables records from updated Google Sheets spreadsheet rows in team drive
- Format and update Google Sheets rows with new or updated records from Zapier Tables
- Update Google Sheets Rows with Zapier Tables Record Updates
- Create records in Zapier Tables from new spreadsheets in Google Sheets
- Add New or Updated Zapier Tables Records to Google Sheets Rows
- Update Google Sheets rows with new or updated Zapier Tables records
- Create Google Sheets rows for new Zapier Tables records
- Update Google Sheets rows with new Zapier Tables records
- Update Google Sheets rows with new or updated Zapier Tables records
- Update Google sheets rows with Zapier tables records
- Update Google sheets with new Zapier tables records
- Create Google Sheets rows for new Zapier Tables records
- Create multiple spreadsheet rows in Google Sheets for new or updated records in Zapier Tables
- Update Zapier Tables records with new or updated Google Sheets rows
- Create new Zapier Tables records from new rows in Google Sheets team drive
- Create new Zapier Tables records from new or updated Google Sheets rows
- Create new Zapier Tables records from new Google Sheets rows
- Create spreadsheet rows in Google Sheets for new records in Zapier Tables
- Update Zapier Tables records with new or updated Google Sheets rows from team drive
- Create new Zapier Tables records from new or updated Google Sheets rows in team drive
- Update records in Zapier Tables when new rows are added in Google Sheets
- Click zap buttons in Zapier Tables to copy worksheets in Google Sheets
- Create Google Sheets extensions for every new record in Zapier Tables
- Create multiple spreadsheet rows in Google Sheets for new records in Zapier Tables
- Create spreadsheet rows in Google Sheets from new trigger zap buttons clicked in Zapier Tables
- Create new rows in Google Sheets and continue with clicked buttons in Zapier Tables when new spreadsheet rows appear in team drive
- Create multiple Google Sheets rows with each new Zapier Tables button clicked
- Create spreadsheets in Google Sheets when zap buttons in Zapier Tables are clicked
- Create records in Zapier Tables from new worksheets in Google Sheets
- Update Google Sheets rows with new records from Zapier Tables
- Create duplicates in Google Sheets worksheets when new records are added in Zapier Tables
- Duplicate tables in Zapier Tables when new or updated rows are recorded in Google Sheets
- Manage new or updated records in Zapier Tables with custom actions in Google Sheets
- Update multiple spreadsheet rows in Google Sheets when records are updated in Zapier Tables
- Create Google Sheets spreadsheets for new or updated records in Zapier Tables
- Update Google Sheets spreadsheets with every record change in Zapier Tables
- "manage new or updated spreadsheet rows in Google Sheets with custom actions in Zapier Tables"
- Clone worksheet in Google Sheets for new or updated records in Zapier Tables
- Manage new or updated Google Sheets rows with custom actions in Zapier Tables
- Create actions in Zapier Tables for each new row in Google Sheets
- "increment Zapier Tables values when a new or updated row occurs in Google Sheets"
- Create spreadsheets in Google Sheets for new records in Zapier Tables
- Initiate custom actions in Google Sheets when new buttons are clicked in Zapier Tables
- Update Google Sheets rows when new Zapier Tables buttons are clicked
- Update Google Sheets rows when new Zapier Tables buttons are clicked
- Duplicate tables in Zapier Tables every time new worksheets are created in Google Sheets
- Create spreadsheet rows in Google Sheets for new, updated or deleted records in Zapier Tables
- Update Google Sheets rows with new, updated or deleted records from Zapier Tables
- Manage new or updated rows in Google Sheets by clicking continue button in Zapier Tables
- Create worksheets in Google Sheets from new buttons clicked in Zapier Tables
- Manage new, updated, or deleted records in Zapier Tables by creating multiple rows in Google Sheets
- Create spreadsheet columns in Google Sheets when new buttons are clicked in Zapier Tables
- Update trigger buttons in Zapier Tables when new or updated spreadsheet rows occur in Google Sheets
- Update Zapier Tables buttons when new or updated rows happen in Google Sheets team drive
- "increment values in Zapier Tables each time new rows are added in Google Sheets"
- Manage new, updated or deleted Zapier Tables records by deleting corresponding rows in Google Sheets
- Track and copy new, updated, or deleted records in Zapier Tables to Google Sheets worksheets
- Update Google Sheets rows when new, updated, or deleted records occur in Zapier Tables
- Duplicate tables in Zapier Tables when new rows are added in Google Sheets
- Update Zapier Tables records when new rows are added to Google Sheets (team drive)
- Create worksheets in Google Sheets for new records in Zapier Tables
- "clear Google Sheets rows when records in Zapier Tables are updated"
Related Zap Templates
- Add new Zapier table records to Google Sheets
- Create records in Zapier Tables from new rows in Google Sheets
- Format and update Google Sheets rows with new or updated records from Zapier Tables
- Add New or Updated Zapier Tables Records to Google Sheets Rows
- Update Google Sheets rows with new Zapier Tables records
- Update Google sheets with new Zapier tables records
- Update Zapier Tables records with new or updated Google Sheets rows
- Create new Zapier Tables records from new Google Sheets rows
- Create new Zapier Tables records from new or updated Google Sheets rows in team drive
- Create Google Sheets extensions for every new record in Zapier Tables
- Create new rows in Google Sheets and continue with clicked buttons in Zapier Tables when new spreadsheet rows appear in team drive
- Create records in Zapier Tables from new worksheets in Google Sheets
- Duplicate tables in Zapier Tables when new or updated rows are recorded in Google Sheets
- Create Google Sheets spreadsheets for new or updated records in Zapier Tables
- Clone worksheet in Google Sheets for new or updated records in Zapier Tables
- "increment Zapier Tables values when a new or updated row occurs in Google Sheets"
- Update Google Sheets rows when new Zapier Tables buttons are clicked
- Create spreadsheet rows in Google Sheets for new, updated or deleted records in Zapier Tables
- Create worksheets in Google Sheets from new buttons clicked in Zapier Tables
- Update trigger buttons in Zapier Tables when new or updated spreadsheet rows occur in Google Sheets
- Manage new, updated or deleted Zapier Tables records by deleting corresponding rows in Google Sheets
- Duplicate tables in Zapier Tables when new rows are added in Google Sheets
- "clear Google Sheets rows when records in Zapier Tables are updated"
- Create Google Sheets rows from new or updated Zapier table records
- Create records in Zapier Tables for new or updated Google Sheets rows
- Update Google Sheets Rows with Zapier Tables Record Updates
- Update Google Sheets rows with new or updated Zapier Tables records
- Update Google Sheets rows with new or updated Zapier Tables records
- Create Google Sheets rows for new Zapier Tables records
- Create new Zapier Tables records from new rows in Google Sheets team drive
- Create spreadsheet rows in Google Sheets for new records in Zapier Tables
- Update records in Zapier Tables when new rows are added in Google Sheets
- Create multiple spreadsheet rows in Google Sheets for new records in Zapier Tables
- Create multiple Google Sheets rows with each new Zapier Tables button clicked
- Update Google Sheets rows with new records from Zapier Tables
- Manage new or updated records in Zapier Tables with custom actions in Google Sheets
- Update Google Sheets spreadsheets with every record change in Zapier Tables
- Manage new or updated Google Sheets rows with custom actions in Zapier Tables
- Create spreadsheets in Google Sheets for new records in Zapier Tables
- Update Google Sheets rows when new Zapier Tables buttons are clicked
- Update Google Sheets rows with new, updated or deleted records from Zapier Tables
- Manage new, updated, or deleted records in Zapier Tables by creating multiple rows in Google Sheets
- Update Zapier Tables buttons when new or updated rows happen in Google Sheets team drive
- Track and copy new, updated, or deleted records in Zapier Tables to Google Sheets worksheets
- Update Zapier Tables records when new rows are added to Google Sheets (team drive)
- Update Google sheets rows with new Zapier tables records
- Create new Zapier Tables records from updated Google Sheets spreadsheet rows in team drive
- Create records in Zapier Tables from new spreadsheets in Google Sheets
- Create Google Sheets rows for new Zapier Tables records
- Update Google sheets rows with Zapier tables records
- Create multiple spreadsheet rows in Google Sheets for new or updated records in Zapier Tables
- Create new Zapier Tables records from new or updated Google Sheets rows
- Update Zapier Tables records with new or updated Google Sheets rows from team drive
- Click zap buttons in Zapier Tables to copy worksheets in Google Sheets
- Create spreadsheet rows in Google Sheets from new trigger zap buttons clicked in Zapier Tables
- Create spreadsheets in Google Sheets when zap buttons in Zapier Tables are clicked
- Create duplicates in Google Sheets worksheets when new records are added in Zapier Tables
- Update multiple spreadsheet rows in Google Sheets when records are updated in Zapier Tables
- "manage new or updated spreadsheet rows in Google Sheets with custom actions in Zapier Tables"
- Create actions in Zapier Tables for each new row in Google Sheets
- Initiate custom actions in Google Sheets when new buttons are clicked in Zapier Tables
- Duplicate tables in Zapier Tables every time new worksheets are created in Google Sheets
- Manage new or updated rows in Google Sheets by clicking continue button in Zapier Tables
- Create spreadsheet columns in Google Sheets when new buttons are clicked in Zapier Tables
- "increment values in Zapier Tables each time new rows are added in Google Sheets"
- Update Google Sheets rows when new, updated, or deleted records occur in Zapier Tables
- Create worksheets in Google Sheets for new records in Zapier Tables