For villas and other small accommodation properties, the Caona Property Finder supports simple Google Sheets rate sheets.
This allows you to easily create a rate sheet that will be periodically checked by our system and used to display pricing for your property.
One Google Sheets document can support up to 100 individual rate sheets, with up to 32 rows of rate information per sheet.
You'll need to have a Google account and create a new Sheets (spreadsheet) document.
The sheet must be publicly viewable (read-only access). You can get a link by clicking the Share button in the top right of the screen. Under ‘Get Link’, ensure that ‘Anyone with the link’ is selected. The mode should be ‘Viewer’. Copy the link.
You can easily test this link to make sure it’s accessible by opening a new incognito or private web browsing window, and checking if you can view the document without signing into your Google Account.
You can view a sample document here: https://docs.google.com/spreadsheets/d/10FmXIep79Vya54Y3oKRvGoZ1tRfIGPcOzpgpqzY2k3U/edit
The first row of the document should be the column headers. The order does not matter. Do not add brackets, periods or spaces around the column headers. You can use the following headers:
The dates must be in ISO format, which is yyyy-mm-dd. Prices can contain the currency symbol $ and , which will be ignored when parsed.
You can have an extra person charge by using the columns Included Occupancy and Extra Person Charge. Add a rate row as normal, and then set the Included Occupancy to be the point after which the Extra Person Charge applies. Both columns must be present if you want extra person charges.
We have an online tool where you can check that your file is parsed correctly.
Verify Caona Google Sheets Rate Sheet
Adding via the account is currently not available. Please email your rate sheets to email@example.com and a representative will assist you.
To add a rate sheet, login to your account and select the Caona Property Finder option. Navigate to your proprety and click on Manage Rates to add a rate sheet.