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 you'll be able to do
- 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.
Building something sooner? The Pangoni API is open today — your developer can wire Google Sheets to Pangoni directly. See the API overview for endpoints and authentication.
Why this matters for Kenyan landlords
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
Once shipped, 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 on the Pangoni roadmap and being built. Sign up for a Pangoni account today and we will email every account the moment it ships. In the meantime, you can use the Pangoni API to wire Google Sheets directly if your team has developer capacity.
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.
Be first to know when it's live
Sign up for Pangoni today — we'll email every account when the Google Sheets integration ships. In the meantime you'll get the rest of Pangoni: M-Pesa rent collection, tenant management, and financial reporting.
Sign up free