1
of 6— Open Your Revenue Spreadsheet
What you'll need
- Google account (free) with Google Sheets access
- Your revenue data in a Google Sheet (exported from PMS, STR, or RMS)
- Google Workspace account with Gemini features enabled (or use the free Gemini sidebar)
Use Google Sheets AI to Build Revenue Formulas Without Coding
Step 1: Open Your Revenue Spreadsheet
Open the Google Sheet containing your data. For formula help, your data should have labeled column headers in row 1 (e.g., "My RevPAR," "Comp Set RevPAR," "Occupancy %," "ADR").
Tools:Google Sheets