Google Sheets + Sonderplan
Create rows in Google Sheets for new Sonderplan contacts
Effortlessly manage your new Sonderplan contacts by connecting your CRM with Google Sheets using this workflow. When a new contact is added in Sonderplan, a new row is created in your chosen Google Sheets spreadsheet, ensuring your contact list stays organized and up-to-date. This seamless process simplifies contact management and guarantees that you never miss crucial client information.
Effortlessly manage your new Sonderplan contacts by connecting your CRM with Google Sheets using this workflow. When a new contact is added in Sonderplan, a new row is created in your chosen Google Sheets spreadsheet, ensuring your contact list stays organized and up-to-date. This seamless process simplifies contact management and guarantees that you never miss crucial client information.
- When this happens...
New ContactTriggers when a new contact is created.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Create Spreadsheet RowCreate a new row in a specific spreadsheet.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
New Booking
Triggers when a booking is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Invoice
Triggers when an invoice is created
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Quote
Triggers when a quote is created
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Contact
Triggers when a contact is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Project
Triggers 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 appBooking Status NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appContact NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appResource NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appWorkspaceRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appBooking 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 foundProject 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 foundService 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 foundDrive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier 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.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.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
New Contact
Triggers when a new contact is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Project
Triggers when a new project is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Booking
Triggers when a booking is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Invoice
Triggers when an invoice is updated
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Quote
Triggers 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 appContact NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appProject Name
Project ID
ActionThis is an event a Zap performs.SearchFind existing data in your appServiceRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appItem 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 foundContact 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 foundResource 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 foundWorkspace 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 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 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
About Google Sheets
Related categories
