Microsoft Excel + Planyo Online Booking

Add new Planyo Online Booking reservations to Microsoft Excel as rows

Boost streamlining with this workflow! Each time a new reservation is made in Planyo Online Booking, a corresponding entry is created instantly in Microsoft Excel. This positions all your booking details at one accessible location for effortless reservation management, saving you time and improving productivity.

When this happens...
New Reservation
Triggers when a new reservation is made.
TriggerInstant
automatically do this!
Add Row
Adds a new row to the end of a worksheet.
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?

Before or After Event #1
Triggers a given number of hours/days before or after the rental begins or ends.
Trigger
Instant
Try It
Before or After Event #3
Triggers a given number of hours/days before or after the rental begins or ends (#3 event defined in Notifications in the Planyo backend).
Trigger
Instant
Try It
Before or After Event #5
Triggers a given number of hours/days before or after the rental begins or ends (#5 event defined in Notifications in the Planyo backend).
Trigger
Instant
Try It
Update of Reservation Status to Checked-In
Triggers when the customer checks in.
Trigger
Instant
Try It
New Reservation
Triggers when a new reservation is made.
Trigger
Instant
Try It

Update of Reservation by Admin
Triggers when a reservation is modified by an admin.
Trigger
Instant
Try It
New Reservation Is Confirmed
Triggers when a reservation gets confirmed.
Trigger
Instant
Try It

Update of Reservation Status to Cancelled by Customer
Triggers when a reservation is cancelled by the customer.
Trigger
Instant
Try It
New or Updated Customer
Triggers when a new customer has been added or when customer data has been updated.
Trigger
Instant
Try It
- Resource ID
- Start Date/TimeRequired
- End Date/TimeRequired
- Quantity
- Comment
Action
Write
- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
Trigger
Scheduled
Try It
- Storage Source
- Folder
- SpreadsheetRequired
Trigger
Scheduled
Try It
- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Storage Source
- Folder
- TitleRequired
- Column Headers
- Zap Step Id
Action
Write
- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search

Before or After Event #2
Triggers a given number of hours/days before or after the rental begins or ends (#2 event defined in Notifications in the Planyo backend).
Trigger
Instant
Try It
Before or After Event #4
Triggers a given number of hours/days before or after the rental begins or ends (#4 event defined in Notifications in the Planyo backend).
Trigger
Instant
Try It
Before or After Event #6
Triggers a given number of hours/days before or after the rental begins or ends (#6 event defined in Notifications in the Planyo backend).
Trigger
Instant
Try It
Update of Reservation Status to Checked-Out
Triggers when the customer checks out.
Trigger
Instant
Try It
Update of Reservation Status to Cancelled by Admin
Triggers when a reservation is cancelled by an admin.
Trigger
Instant
Try It
Automatic Update of Reservation Status to Cancelled
Triggers when a reservation is automatically cancelled according to the cancellation rules set for the resource.
Trigger
Instant
Try It
New Payment
Triggers when a new payment is made.
Trigger
Instant
Try It
Update of Reservation by Customer
Triggers when a reservation is modified by the customer.
Trigger
Instant
Try It
- First NameRequired
- Last NameRequired
- Email AddressRequired
- Address
- City
- Zip
- State
- Country
- Phone
- Phone Country Code
Action
Write
- Resource IDRequired
- Start Date/TimeRequired
- End Date/TimeRequired
- QuantityRequired
- Email AddressRequired
- First NameRequired
- Last NameRequired
- Address
- City
- Zip
- State
- Country
Action
Write
- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
- TableRequired
Trigger
Scheduled
Try It
- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Scheduled
Try It
- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
- TableRequired
Action
Write
- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write
- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search or write

About Microsoft Excel

Microsoft's Excel is a spreadsheet application used by millions of users across the world. It is part of the Office ecosystem and is considered the industry standard for spreadsheets. Only files on OneDrive for Business (available with Office 365 and Sharepoint server) are supported at this time with Zapier.

Help

Related categories

Similar apps

OneDrive

File Management & Storage, Microsoft

Smartsheet

Spreadsheets

Quip

Documents

About Planyo Online Booking

Planyo is an online reservation system which can be used by any business taking bookings. It's used, amongst others, by businesses offering vacation properties, car rentals, hotels, driving schools, yacht charters, doctors and therapists, conference rooms, tennis courts, car parks, event tickets or any other bookings you could imagine.

Learn more

Related categories

Scheduling & Booking

PRODUCTS

CAPABILITIES

By team

Microsoft Excel + Planyo Online Booking

Add new Planyo Online Booking reservations to Microsoft Excel as rows

Before or After Event #1

Before or After Event #3

Before or After Event #5

Update of Reservation Status to Checked-In

New Reservation

Update of Reservation by Admin

New Reservation Is Confirmed

Update of Reservation Status to Cancelled by Customer

New or Updated Customer

Create Vacation

Resource ID

End Date/TimeRequired

Quantity

Comment

New Row

Storage Source

FolderRequired

SpreadsheetRequired

WorksheetRequired

New Worksheet

Storage Source

Folder

SpreadsheetRequired

Add Row

Storage Source

FolderRequired

SpreadsheetRequired

WorksheetRequired

Create Spreadsheet

Storage Source

Folder

TitleRequired

Column Headers

Zap Step Id

Find Row

Storage Source

FolderRequired

SpreadsheetRequired

WorksheetRequired

Lookup ColumnRequired

Lookup ValueRequired

Before or After Event #2

Before or After Event #4

Before or After Event #6

Update of Reservation Status to Checked-Out

Update of Reservation Status to Cancelled by Admin

Automatic Update of Reservation Status to Cancelled

New Payment

Update of Reservation by Customer

New Customer

First NameRequired

Last NameRequired

Email AddressRequired

Address

City

Zip

State

Country

Phone

Phone Country Code

Create Reservation

Resource IDRequired

Start Date/TimeRequired

End Date/TimeRequired

QuantityRequired

Email AddressRequired

First NameRequired

Last NameRequired

Address

City

Zip

State

Country

New Row in Table

Storage Source