Google Sheets Rates

Documentation Advertising Policies Ad Guidelines Billing and Payments Listing your Business Pricing How Ads Work Caona: A New Way to Stay Tarifa XML Rate Sheets Google Sheets Rates

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.

Requirements

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.

Setting up the document

You can view a sample document here: https://docs.google.com/spreadsheets/d/10FmXIep79Vya54Y3oKRvGoZ1tRfIGPcOzpgpqzY2k3U/edit

Key points:

  1. The title of the document doesn’t matter.
  2. The sheet name (bottom left) should be in the following format: Villa Name (VillaId)
  3. The system only looks for the Villa Id in parenthesis, so the Villa Name is not important and more for your convenience.
  4. You don’t need to use all available columns. The only required columns are Date From, Date To, and either Rate Night or Rate Week.

Columns

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.

Checking your Rate Sheet

We have an online tool where you can check that your file is parsed correctly.

Verify Caona Google Sheets Rate Sheet

Sending Your Rate Sheet

Adding via the account is currently not available. Please email your rate sheets to business@visittci.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.