Google Sheets + Zenoti

Create spreadsheet rows in Google Sheets for each invoice closure in Zenoti

Streamline your billing process with this convenient workflow. When an invoice is closed in Zenoti, a new row will be created in your Google Sheets, ensuring all your key invoice details are systematically recorded and easily accessible. Save time, eliminate added manual data entry chores, and keep your invoicing records up-to-date and organized.

When this happens...
Invoice Closure
Triggers when an Invoice is Closed.
TriggerInstant
automatically do this!
Create Spreadsheet Row
Create a new row in a specific spreadsheet.
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?

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
- 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 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
- 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

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 spreadsheet rows in Google Sheets for each invoice closure in Zenoti

Appointment Complete

Appointment Group Status

Class Booking Approve

Class Booking Create

Class Booking No Show

Class Schedule Cancel

Class Schedule Delete

Employee Create

Employee Update

Guest Delete

Guest Membership Create

Guest Membership Reinstate

Guest Merge

Invoice Closure

Create Employee

Is Consultant?

Gender

Date Of Birth

Mobile Country Code

Address1

Address 2

City

Country ID

State ID

Zip Code

Job ID

Create Opportunity

Opportunity Description

Opportunity Owner ID

Priority

expected close date

listed amount

offered amount

Search Guest by ID

Find Guest by ID or 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

New Spreadsheet Row

No Team Drive

New or Updated Spreadsheet Row (Team Drive)

Drive

Trigger Column

New Worksheet

Drive

Create Spreadsheet Row

Drive

Copy Worksheet

Drive

Copy Worksheet Destination

Create Worksheet

Drive

Headers

Overwrite existing worksheets

Format Spreadsheet Row

Drive

Background Color

Text Color

Text Bold

Text Italic

Text Strikethrough