Create rows in Google Sheets for new Sonderplan bookings
Effortlessly manage your bookings data with this Sonderplan and Google Sheets integration. Whenever a new booking is made in Sonderplan, this workflow will add a row to your Google Sheets spreadsheet with the relevant information. Stay organized and save time by seamlessly transferring your booking information between apps!
- When this happens...

New BookingTriggers when a booking is created.TriggerInstant - automatically do this!

Create Spreadsheet RowCreate a new row in a specific spreadsheet.ActionWrite
- Free forever for core features
- 14 day trial for premium features & apps
More things you can do with Sonderplan and Google Sheets
Discover other triggers and actions you can use with Sonderplan and Google Sheets
New BookingTriggers when a booking is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New InvoiceTriggers when an invoice is created
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New QuoteTriggers when a quote is created
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Updated ContactTriggers when a contact is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Updated ProjectTriggers when a project is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.- Item NameRequired
- Description
- Unit Name
- Buy Cost
- Sell Cost
- Currency
- Taxes
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Contact NameRequired
- TypeRequired
- Client
- Email 1
- Email 2
- Email 3
- Phone 1
- Phone 2
- Phone 3
- Address Line 1
- Address Line 2
- Address Line 3
- Address City
- Address State
- Address Postcode
- Address Country
- Website
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Resource NameRequired
- Description
- Type
- Type Person ID
- Resource Group Parent
- Color Background
- Color Text
- Hour Buy Cost
- Hour Sell Cost
- Day Buy Cost
- Day Sell Cost
- Week Buy Cost
- Week Sell Cost
- CurrencyRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Workspace NameRequired
- Description
- Working Week / Weekend
- Resources
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- BookingRequired
- Booking Name
- Booking Start Date / Time
- Booking End Date / Time
- All Day Booking
- Notes
- Resources
- Project
- Booking Client
- Booking Status
- Check for Booking ClashesRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- ProjectRequired
- Project Name
- Project Code
- Notes
- Project Status
- Private Project
- Project Client
- Project Color
- Project Parent Folder
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Service IDRequired
- Service Name
- Description
- Booking Description Template
- Resources
- Hour Buy Cost
- Hour Sell Cost
- Day Buy Cost
- Say Sell Cost
- Week Buy Cost
- Week Sell Cost
- CurrencyRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Billable ItemRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Booking Status NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Contact NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Resource NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- WorkspaceRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Booking NameRequired
- Booking Start Date / TimeRequired
- Booking End Date / TimeRequired
- All Day Booking
- Notes
- Resources
- Project
- Booking Client
- Booking Status
- Check for Booking ClashesRequired
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- Project NameRequired
- Project ID
- Project Code
- Notes
- Project Status
- Private ProjectRequired
- Project Client
- Project Color
- Project Parent Folder
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- Service NameRequired
- Description
- Booking Description Template
- Resources
- Hour Buy Cost
- Hour Sell Cost
- Day Buy Cost
- Day Sell Cost
- Week Buy Cost
- Week Sell Cost
- CurrencyRequired
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- Dont_change_sheet_structure
- Drive
- SpreadsheetRequired
- WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan- Dont_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
- 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
- First row
- Row count
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row countRequired
- Output format
- First row
ActionThis is an event a Zap performs.SearchFind existing data in your app- Spreadsheet IDRequired
- Include Grid Data
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- Spreadsheet NameRequired
- Search Type
- Spreadsheet to Copy
- 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- 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.Search or writeFind existing data in your app, or create a new record if no data is found
New ContactTriggers when a new contact is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New ProjectTriggers when a new project is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Updated BookingTriggers when a booking is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Updated InvoiceTriggers when an invoice is updated
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Updated QuoteTriggers when a quote is updated
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.- Booking NameRequired
- Booking Start Date / TimeRequired
- Booking End Date / TimeRequired
- All Day Booking
- Notes
- Resources
- Project
- Booking Client
- Booking Status
- Check for Booking ClashesRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Project NameRequired
- Project Code
- Notes
- Project Status
- Private ProjectRequired
- Project Client
- Project Color
- Project Parent Folder
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Service NameRequired
- Description
- Booking Description Template
- Resources
- Hour Buy Cost
- Hour Sell Cost
- Day Buy Cost
- Day Sell Cost
- Week Buy Cost
- Week Sell Cost
- CurrencyRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Billable Item IDRequired
- Item Name
- Description
- Unit Name
- Buy Cost
- Sell Cost
- Currency
- Taxes
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- ContactRequired
- Contact Name
- Type
- Client
- Email 1
- Email 2
- Email 3
- Phone 1
- Phone 2
- Phone 3
- Address Line 1
- Address Line 2
- Address Line 3
- Address City
- Address State
- Address Postcode
- Address Country
- Website
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Resource IDRequired
- Resource Name
- Description
- Resource Group Parent
- Color Background
- Color Text
- Rate ID
- Hour Buy Cost
- Hour Sell Cost
- Day Buy Cost
- Day Sell Cost
- Week Buy Cost
- Week Sell Cost
- CurrencyRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Workspace IDRequired
- Workspace Name
- Description
- Working Week / Weekend
- Resources
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Booking NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Contact NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Project Name
- Project ID
ActionThis is an event a Zap performs.SearchFind existing data in your app- ServiceRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Item NameRequired
- Description
- Unit Name
- Buy Cost
- Sell Cost
- Currency
- Taxes
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- Contact NameRequired
- TypeRequired
- Client
- Email 1
- Email 2
- Email 3
- Phone 1
- Phone 2
- Phone 3
- Address Line 1
- Address Line 2
- Address Line 3
- Address City
- Address State
- Address Postcode
- Address Country
- Website
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- Resource NameRequired
- Description
- Type
- Type Person ID
- Resource Group Parent
- Color Background
- Color Text
- Hour Buy Cost
- Hour Sell Cost
- Day Buy Cost
- Day Sell Cost
- Week Buy Cost
- Week Sell Cost
- CurrencyRequired
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- Workspace NameRequired
- Description
- Working Week / Weekend
- Resources
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- Dont_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 plan- Dont_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
- Overwrite All Columns
- 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.- Api_docs_info
- 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
- Spreadsheet NameRequired
- Search Type
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- WorksheetRequired
- A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row IDRequired
ActionThis is an event a Zap performs.SearchFind existing data 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 app- Drive
- 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




