Smartpms API Platform
SmartPMS Reports
Sync your reservation data directly into Google Sheets — no coding required.
Analyse occupancy, revenue, and guest trends using familiar spreadsheet tools. Just open the template, connect your API key, and sync.
Request API Key to get startedAlready have an API key? Open the template spreadsheet →
How it works
Request an API key
Fill out the short request form. We'll review and send your API key within 1–3 business days.
Open the template and make a copy
Access the shared Google Sheets template and save a copy to your own Google Drive. No marketplace installation needed.
Connect and sync
Open the SmartPMS Reports sidebar, enter your API key, and click Sync. Your reservation data loads in seconds.
What you get
Reservations
One row per reservation — guest details, dates, channel, status, and revenue, ready to filter and pivot.
Daily Revenue
Aggregated daily revenue per property for quick trend analysis and occupancy charts.
Reservation Days
One row per stay-night. Ideal for calculating nightly occupancy rates across your portfolio.
Analysis
Pre-built pivot tables and charts so you can start exploring your data without any setup.
Features
- Full sync or incremental updates
- Filter by date range and property
- Works with all SmartPMS properties
- No coding or technical setup required
- Embedded directly in Google Sheets
- Data refreshes on demand