Data Sources
Connect your reports, review your data, and keep your dashboard up to date.
Your business
Data is connected only to the business you select.
Choose the property that owns this data. You can also add a new operational unit here.
Choose your data source
Advanced source details
Upload one operational report. SUMS scans every populated tab, understands the business facts, maps what it can use, derives safe metrics, and asks you only about uncertain data.
Choose how you want to connect. SUMS reads the spreadsheet, understands the business facts, validates every update, and keeps the last trusted dashboard active if something needs review.
Connect your Google account
Read-only access. SUMS never edits your spreadsheet.
Your selected operational unit is shown above under Your business. Check it before granting access.
Select the data source
Choose one spreadsheet. SUMS will scan every populated tab automatically.
Connect with the private script
Paste the spreadsheet link, choose its operational unit, then install the connector once.
The destination operational unit is selected above under Your business.
One-time setup
- Open the spreadsheet → Extensions → Apps Script.
- Copy the SUMS connector below into a new script file and save it.
- Select setupSumsConnection and click Run. Review Google's permissions, then allow the connection.
- Return to SUMS and click Review data on the connected source.
Keep this private connector inside the spreadsheet's Apps Script project.
Connected spreadsheets
Review data or manage automatic updates.Setup guidelines & connection policy
What SUMS accesses
Direct Google connection requests read-only spreadsheet access and never edits cells. Apps Script fallback also sends only the populated tabs of the connected spreadsheet. SUMS does not request Gmail access.
Prepare the data
Use one header row and one record per row inside each tab. Monthly tabs may use the same columns; SUMS combines compatible tabs automatically. Use numeric cells for amounts and Google date cells or YYYY-MM-DD text. SUMS automatically excludes blank, summary, subtotal and total rows before dashboard calculations; keeping operational rows clean still improves review speed. Daily revenue requires Gross Revenue; inventory requires Rooms Available and Rooms Sold. Keep Booking IDs and Property Codes as plain text when leading zeros matter. Maximum per tab: 5,000 data rows, 100 columns and 100,000 cells. Maximum whole-workbook snapshot: 8 MB.
Review once, validate every update
Confirm the suggested mapping before the first sync. Updates are validated on the server and committed together. Ambiguous values, changed headers, duplicate keys or conflicting sources are quarantined for confirmation; the last valid dashboard remains available while you fix or ignore only the affected rows. Matching dates or Booking IDs in the selected unit may replace previous file/demo records only after your approval.
Freshness
Edits trigger a sync; a one-minute trigger checks formula, external and other changes. Google scheduling, quotas and connectivity can delay delivery. The open dashboard checks for changes every 15 seconds and displays the last successful sync. This is automatic near-real-time synchronization, not an instantaneous streaming guarantee.
Privacy & control
Exclude guest names, contacts, payment card data, sensitive notes and other unnecessary personal information before connecting. Raw snapshots and confirmed fields are stored privately for validation and recovery. Disconnect stops new updates and clears the connector snapshot; previously saved review files and validated business records remain subject to the privacy policy. Remove the SUMS triggers in Apps Script to stop scheduled attempts. Revoke script authorization in your Google account to withdraw Google access. Privacy Policy