Available
Spreadsheets
Pangoni + Google Sheets
Auto-populate Google Sheets with tenant and payment data. Build custom dashboards and share them with owners, accountants, or your team.
What can you do with the Google Sheets integration?
- Live-sync Pangoni data into Google Sheets via a native add-on.
- Build custom dashboards that refresh every time the sheet opens.
- Share owner-specific sheets with view-only access — no Pangoni login needed.
- Automate monthly reports using Google Sheets + Pangoni + Apps Script.
- Mix Pangoni data with other data sources (bank feeds, marketing) in a single sheet.
Prefer to build it yourself? The Pangoni API is open today — your developer can wire Google Sheets to Pangoni directly. See the API overview for endpoints and authentication.
Why does the Google Sheets integration matter for Kenyan landlords and agencies?
Pangoni's Google Sheets integration lets Kenyan landlords auto-populate a Google Sheet with their tenant and payment data via a native add-on — refreshing as often as you want, so the dashboards you build and share with owners or your accountant stay in sync with your source of truth.
Google Sheets is the working environment for a huge slice of Kenyan property managers — shared, real-time, accessible from anywhere, and free. The challenge is keeping the spreadsheet in sync with the underlying source of truth. Pangoni's Google Sheets integration auto-populates a Sheet with your tenant and payment data, refreshing as often as you want, so the spreadsheet you share with owners or your accountant is never more than a few minutes out of date.
How the Google Sheets integration works
Setup looks like this. Your data flows in the background; you keep working in both tools.
Install the Pangoni for Sheets add-on
From the Google Workspace Marketplace. Available free, scoped permissions only.
Authorise your Pangoni account
OAuth from the add-on; pick the properties you want visible in this Sheet.
Insert the data ranges you need
Tenants, leases, payments this month, arrears, occupancy, owner statements — each as a separate range in the Sheet.
Build your dashboard around the data
Pivots, charts, conditional formatting — your spreadsheet logic stays intact; the source data just refreshes.
Share with whoever needs it
Owners, accountants, your team — Sheets handles the sharing model. Refresh is automatic on open.
Real use cases from Kenyan landlords
- A property manager building per-owner dashboards in Sheets: each owner gets their own Sheet that auto-refreshes from their property's data.
- A landlord co-managing a portfolio with a sibling abroad: shared Sheet with live rent collection visibility, no monthly email.
- An accountant who works in Sheets, not Excel: Pangoni feeds the Sheet directly, and the monthly close shrinks from a day to an hour.
Frequently asked
The Google Sheets integration is live now. Auto-populate Google Sheets with tenant and payment data via a native add-on — rent rolls, arrears, and payments refresh on demand. Build dashboards and share them with owners or accountants, or use the open Pangoni API.
The Google Sheets integration will be included on Pangoni Elite (KSh 3,500/month for landlords) and all Agent and Agency plans at no additional charge. You only need an active Google Sheets subscription on your side.
Yes. The Google Sheets integration is built around the same multi-property and multi-owner model as the rest of Pangoni — each property maps to the right account on the Google Sheets side, and reporting can be filtered per property or per owner.
Yes. The Pangoni API is fully open and your developer can wire Google Sheets to Pangoni today. See the API documentation at api.pangoni.com — webhooks for real-time events, REST endpoints for data, OAuth for authentication.
Connect Google Sheets to Pangoni today
Start your free trial and connect Google Sheets today. You also get the rest of Pangoni: M-Pesa rent collection, tenant management, and financial reporting.
Sign up free