1
of 6

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