Google Sheets + Zenoti

Create new Zenoti guests from new or updated rows in Google Sheets

Keep your Zenoti guest list updated with every new or changed entry in Google Sheets by using this efficient workflow. It instantly mirrors any updates made in your Google Spreadsheet into Zenoti, removing the need for constant spreadsheet checks. Ideal for user-friendly, time-saving management of changing guest details in Zenoti. Explore the convenience of this streamlined approach to managing your guests.

When this happens...
New or Updated Spreadsheet Row
Triggered when a new row is added or modified in a spreadsheet.
TriggerInstant
automatically do this!
Create Guest
Creates a Guest
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

Supported triggers and actions

What does this mean?

- Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Scheduled
Try It
- Drive
Trigger
Scheduled
Try It
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Column NameRequired
- Index
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write

- TitleRequired
- Spreadsheet to Copy
- Headers
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write

- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write
- Api Docs Info
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Search from last row
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Search from last row
Action
Search or write
Appointment Group Create
Triggers when a appointment is completed.
Trigger
Instant
Try It
Appointment Start
Triggers when a Appointment is Started.
Trigger
Instant
Try It
Class Booking Cancel
Triggers when a Class Booking is Cancelled.
Trigger
Instant
Try It
Class Booking Delete
Triggers when a Class Booking is Deleted.
Trigger
Instant
Try It
Class Booking Reject
Triggers when a Class Booking is Rejected.
Trigger
Instant
Try It
Class Schedule Create
Triggers when a Class Schedule is Created.
Trigger
Instant
Try It
Class Schedule Update
Triggers when a Class Schedule is Updated.
Trigger
Instant
Try It
Employee Delete
Triggers when an Employee is Deleted.
Trigger
Instant
Try It
Guest Create
Triggers when a new guest is created.
Trigger
Instant
Try It
Guest Membership Cancel
Triggers when a Guest Membership is cancelled.
Trigger
Instant
Try It
Guest Membership Freeze
Triggers when a Guest Membership is Freezed.
Trigger
Instant
Try It
Guest Membership Unfreeze
Triggers when a Guest Membership Unfreezes.
Trigger
Instant
Try It
Guest Update
Triggers when an existing guest is updated.
Trigger
Instant
Try It
List All Employee Jobs
Api to list the jobs setup at organization.
Trigger
Scheduled
Try It
- 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
Action
Write
- First Name
- Last Name
- phone
- username
- email
- Guest Center ID
Action
Search
- First 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
Action
Search or write

- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Scheduled
Try It
- Drive
- SpreadsheetRequired
Trigger
Scheduled
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- Spreadsheet Containing the Worksheet to CopyRequired
- Worksheet to CopyRequired
- Copy Worksheet Destination
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
- Headers
- Overwrite existing worksheets
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Text Bold
- Text Italic
- Text Strikethrough
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Search from last row
- Row Count
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row CountRequired
- First Row
Action
Search
- Drive
- SpreadsheetRequired
- TitleRequired
- Headers
- Overwrite existing worksheets
Action
Search or write
Appointment Complete
Triggers when a appointment is completed.
Trigger
Instant
Try It
Appointment Group Status
Triggers when an appointment group status is changed.
Trigger
Instant
Try It
Class Booking Approve
Triggers when a Class Booking is Approved.
Trigger
Instant
Try It
Class Booking Create
Triggers when a Class Booking is Created.
Trigger
Instant
Try It
Class Booking No Show
Triggers when a Class Booking is marked NoShow.
Trigger
Instant
Try It
Class Schedule Cancel
Triggers when a Class Schedule is Cancelled.
Trigger
Instant
Try It
Class Schedule Delete
Triggers when a Class Schedule is Deleted.
Trigger
Instant
Try It
Employee Create
Triggers when an Employee is created.
Trigger
Instant
Try It
Employee Update
Triggers when an Employee is Updated.
Trigger
Instant
Try It
Guest Delete
Triggers when a Guest is Deleted.
Trigger
Instant
Try It
Guest Membership Create
Triggers when a Guest Membership is Created.
Trigger
Instant
Try It
Guest Membership Reinstate
Triggers when a Guest Membership is Reinstated.
Trigger
Instant
Try It
Guest Merge
Triggers when multiple Guests are merged.
Trigger
Instant
Try It
Invoice Closure
Triggers when an Invoice is Closed.
Trigger
Instant
Try It
- 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
Action
Write
- Center IDRequired
- Opportunity TitleRequired
- Opportunity Description
- Opportunity Owner ID
- Guest IDRequired
- Employee IDRequired
- Priority
- Follow-Up dateRequired
- expected close date
- listed amount
- offered amount
Action
Write
- Guest IDRequired
Action
Search
- Guest 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
Action
Search or write

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Learn more Help

Related categories

Similar apps

About Zenoti

Zenoti provides an all-in-one, cloud-based software solution for the spa, salon and med spa industry.

Learn more Help

Related categories

Marketing Automation

Similar apps

Zapier Interfaces

App Builder, CRM (Customer Relationship Management), Forms & Surveys, Zapier

Google Sheets + Zenoti

Create new Zenoti guests from new or updated rows in Google Sheets

New Spreadsheet Row (Team Drive)

Drive

New Spreadsheet

Drive

New or Updated Spreadsheet Row

No Team Drive

Trigger Column

Create Spreadsheet Column

Drive

Index

Create Multiple Spreadsheet Rows

Drive

Create Spreadsheet

Spreadsheet to Copy

Headers

Clear Spreadsheet Row

Drive

Update Spreadsheet Row

Drive

API Request (Beta)

Api Docs Info

Query String Parameters

Headers

Additional Request Headers

Body

Find Worksheet

Drive

Lookup Spreadsheet Row

Drive

Supporting Lookup Column

Supporting Lookup Value

Search from last row

Find or Create Row

Drive

Supporting Lookup Column

Supporting Lookup Value

Search from last row

Appointment Group Create

Appointment Start

Class Booking Cancel

Class Booking Delete

Class Booking Reject

Class Schedule Create

Class Schedule Update

Employee Delete

Guest Create

Guest Membership Cancel

Guest Membership Freeze

Guest Membership Unfreeze

Guest Update

List All Employee Jobs

Create Guest

User code

Username

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

Search for a Guest

First Name

Last Name

phone

username

email