Google Sheets + Zenoti

Create multiple rows in Google Sheets for every new invoice closure in Zenoti

Keep your financial records in order with this efficient workflow. When an invoice is closed in Zenoti, multiple rows are immediately added to your chosen Google Sheets spreadsheet. This saves considerable time and reduces the risk of manual errors in recording. Perfect for tracking sales and balancing the books, this process provides a clear and simple way to maintain accurate financial records.

When this happens...
Invoice Closure
Triggers when an Invoice is Closed.
TriggerInstant
automatically do this!
Create Multiple Spreadsheet Rows
Create one or more new rows in a specific spreadsheet (with line item support).
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

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
Polling
Try It
- Drive
- SpreadsheetRequired
Trigger
Polling
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Use Timezone set up on the spreadsheet to format date values?
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Condition TypeRequired
- Background Color
- Text Color
- Bold Text
- Italic Text
Action
Write
- Drive
- Spreadsheet Containing the Worksheet to CopyRequired
- Worksheet to CopyRequired
- Copy Worksheet Destination
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
- Overwrite existing worksheet with the same title
- Headers
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Confirm DeletionRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Format TypeRequired
Action
Write
- SpreadsheetRequired
- WorksheetRequired
- New Sheet NameRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Sort by ColumnRequired
- Sort OrderRequired
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
- A1 RangeRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row IDRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
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
Polling
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
Polling
Try It
- Drive
Trigger
Polling
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
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Frozen Rows Count
- Frozen Columns Count
- Sheet Position
- Hide Sheet
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Source RangeRequired
- Destination RangeRequired
- Paste Type
Action
Write
- TitleRequired
- Spreadsheet to Copy
- Headers
Action
Write
- Info
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row(s)Required
Action
Write
- Info
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row(s)Required
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Validation TypeRequired
- Input Message
- Strict Validation
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row countRequired
- Output format
- First row
Action
Search
- Spreadsheet IDRequired
Action
Search
- Drive
- SpreadsheetRequired
- TitleRequired
- Overwrite existing worksheet with the same title
- Headers
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

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

Related categories

Marketing Automation

Similar apps

Zapier Interfaces

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

Google Sheets + Zenoti

Create multiple rows in Google Sheets for every new 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

Create Opportunity

Search Guest by ID

Find Guest by ID or Create Guest

New Spreadsheet Row

New or Updated Spreadsheet Row (Team Drive)

New Worksheet

Create Spreadsheet Row

Create Spreadsheet Row at Top

Create Conditional Formatting Rule

Copy Worksheet

Create Worksheet

Delete Sheet

Format Cell Range

Rename Sheet

Sort Range

Update Spreadsheet Row(s)

Lookup Spreadsheet Rows (Advanced)

Get Data Range

Get Row by ID

Lookup Spreadsheet Row

Find or Create 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

Search for a Guest

Find or Create Guests

New Spreadsheet Row (Team Drive)

New Spreadsheet

New or Updated Spreadsheet Row

Create Spreadsheet Column

Create Multiple Spreadsheet Rows

Change Sheet Properties

Copy Range

Create Spreadsheet

Clear Spreadsheet Row(s)

Delete Spreadsheet Row(s)

Format Spreadsheet Row

Set Data Validation

Update Spreadsheet Row

API Request (Beta)

Find Worksheet

Get Many Spreadsheet Rows (Advanced)

Get Spreadsheet by ID

Find or Create Worksheet

About Google Sheets

Related categories

Similar apps

Zapier Tables

Zoho Creator

Smartsheet

About Zenoti