Google Sheets + Zenoti
Create Zenoti guests from new Google Sheets rows (Team Drive)
When new guests are added to Google Sheets rows (Team Drive), they will be added to Zenoti automatically.
When new guests are added to Google Sheets rows (Team Drive), they will be added to Zenoti automatically.
- When this happens...
New Spreadsheet Row (Team Drive)Triggers when a new row is added to the bottom of a Google Team Drive spreadsheet.
TriggerScheduledZapier checks for new data every 15 min on the Free plan - automatically do this!
Create GuestCreates a Guest
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Drive
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
Appointment Group Create
Triggers when a appointment is completed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Appointment Start
Triggers when a Appointment is Started.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Class Booking Cancel
Triggers when a Class Booking is Cancelled.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Class Booking Delete
Triggers when a Class Booking is Deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Class Booking Reject
Triggers when a Class Booking is Rejected.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Class Schedule Create
Triggers when a Class Schedule is Created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Class Schedule Update
Triggers when a Class Schedule is Updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Employee Delete
Triggers when an Employee is Deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Guest Create
Triggers when a new guest is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Guest Membership Cancel
Triggers when a Guest Membership is cancelled.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Guest Membership Freeze
Triggers when a Guest Membership is Freezed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Guest Membership Unfreeze
Triggers when a Guest Membership Unfreezes.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Guest Update
Triggers when an existing guest is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.List All Employee Jobs
Api to list the jobs setup at organization.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planCenter IDRequired
User code
Username
First NameRequired
Last Name
Email ID
Nationality
Gender
Date Of Birth
Country ID
Number
Address 1
City
Country ID
State ID
Zip Code
Primary Employee
Referral Source
Receive Transactional Email
Receive Transactional Sms
Receive Marketing Email
Receive Marketing Sms
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.First Name
Last Name
phone
username
email
Guest Center ID
ActionThis is an event a Zap performs.SearchFind existing data in your appFirst NameRequired
Last Name
phone
Username
Email ID
Guest Center ID
Center IDRequired
User code
Nationality
Gender
Date Of Birth
Country ID
Number
Address 1
City
Country ID
State ID
Zip Code
Primary Employee
Referral Source
Receive Transactional Email
Receive Transactional Sms
Receive Marketing Email
Receive Marketing Sms
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
No 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 foundAppointment Complete
Triggers when a appointment is completed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Appointment Group Status
Triggers when an appointment group status is changed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Class Booking Approve
Triggers when a Class Booking is Approved.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Class Booking Create
Triggers when a Class Booking is Created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Class Booking No Show
Triggers when a Class Booking is marked NoShow.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Class Schedule Cancel
Triggers when a Class Schedule is Cancelled.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Class Schedule Delete
Triggers when a Class Schedule is Deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Employee Create
Triggers when an Employee is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Employee Update
Triggers when an Employee is Updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Guest Delete
Triggers when a Guest is Deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Guest Membership Create
Triggers when a Guest Membership is Created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Guest Membership Reinstate
Triggers when a Guest Membership is Reinstated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Guest Merge
Triggers when multiple Guests are merged.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Invoice Closure
Triggers when an Invoice is Closed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.CodeRequired
CenterRequired
Is Consultant?
First NameRequired
Last NameRequired
Email IDRequired
Gender
Date Of Birth
Mobile NumberRequired
Mobile Country Code
Address1
Address 2
City
Country ID
State ID
Zip Code
User NameRequired
Job ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Center IDRequired
Opportunity TitleRequired
Opportunity Description
Opportunity Owner ID
Guest IDRequired
Employee IDRequired
Priority
Follow-Up dateRequired
expected close date
listed amount
offered amount
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Guest IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appGuest IDRequired
Center IDRequired
User code
Username
First NameRequired
Last Name
Email ID
Nationality
Gender
Date Of Birth
Country ID
Number
Address 1
City
Country ID
State ID
Zip Code
Primary Employee
Referral Source
Receive Transactional Email
Receive Transactional Sms
Receive Marketing Email
Receive Marketing Sms
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
About Zenoti
Zenoti provides an all-in-one, cloud-based software solution for the spa, salon and med spa industry.
Related categories
Related Zap Templates
- Create spreadsheet rows in Google Sheets for each invoice closure in Zenoti
- Add new Google Sheets rows to create Zenoti guests
- Create spreadsheet rows in Google Sheets for new guests in Zenoti
- Create new Google Sheets spreadsheets for every closed Zenoti invoice
- Start new Zenoti appointments and create corresponding rows in Google Sheets