Best Google Sheets Add-ons for Landlords (2026)

I've been managing 12 units with Google Sheets for over 3 years. Along the way I've tested a bunch of add-ons. Some are genuinely useful. Most are bloated junk that slows your sheet to a crawl.

Here are the ones that actually earned a permanent spot in my workflow. Plus a few I've tested so you don't have to.

1. Yet Another Mail Merge (YAMM): Best for Tenant Notices

YAMM lets you send personalized bulk emails straight from Google Sheets using Gmail. You write one template, add merge fields like tenant name and unit number, and blast it out.

I use it for late payment reminders, lease renewal notices, and the occasional "we're doing inspections next week" email. You can track opens and clicks right in your sheet.

Price: Free for up to 50 emails/day. Paid plans start at $25/year.

Pros: Dead simple. Works right inside Sheets. Tracks who opened what.

Cons: Free tier has a daily limit. Not great for sending attachments.

If you're sending the same email to 10 tenants with different details, this is the tool. I still use it monthly.

2. Autocrat: Best for Generating Rent Receipts

Autocrat takes data from your spreadsheet and merges it into a Google Docs template. Then it can export the result as a PDF and even email it automatically.

For landlords, the killer use case is rent receipts. You set up a receipt template once. Every time you mark rent as paid, Autocrat generates a personalized PDF receipt for that tenant.

Price: Free.

Pros: Completely free. Creates PDFs automatically. Can email them on a trigger.

Cons: Setup takes 20-30 minutes the first time. The interface is a little clunky. But once it's running, you never touch it again.

I used Autocrat for about a year before I got lazy and just started emailing receipts manually. But if you need something official and automated, it's solid.

3. Formfacade: Best for Tenant Applications

Google Forms is fine for collecting info, but it looks ugly. Formfacade lets you customize the appearance of your Google Forms so they actually look professional when you embed them on a website.

I set up a tenant application form that feeds directly into a Google Sheet. Applicant fills it out, the data lands in my sheet, and I review it there. No extra software needed.

Price: Free for basic customization. Paid plans start at $12/month.

Pros: Makes Google Forms look like they belong on a real website. Responses still go to Sheets. Conditional logic for multi-step forms.

Cons: The free tier is limited on styling. You need the paid plan for file uploads, which is annoying since tenants need to upload IDs and pay stubs.

If you're still collecting tenant applications via email, this is a huge upgrade for zero technical effort.

4. Form Publisher: Best for Lease Documents

Form Publisher is similar to Autocrat but works from Google Forms submissions. A tenant fills out a form, and it auto-generates a document from a template.

Some landlords use this for move-in checklists or simple lease addendums. Tenant fills out the form, Form Publisher merges the answers into a Google Doc template, and exports a PDF. The tenant even gets a copy emailed to them.

Price: Free for 20 merges/month. Paid plans from $63/year.

Pros: Great for anything where a tenant fills out info and you need a document generated. Supports Google Docs, Slides, and Sheets templates.

Cons: 20 free merges per month might not be enough if you're doing a lot of turnover. More expensive than Autocrat for similar results.

5. Easy Mail Merge: Best for Sending PDFs to Tenants

Easy Mail Merge is like YAMM but with better attachment handling. The standout feature for landlords is the ability to convert your spreadsheet into personalized PDFs and send them as email attachments.

Think rent statements, annual summaries, or end-of-year tax documents. You write the template, it merges tenant data, converts to PDF, and sends.

Price: Free for up to 50 emails/day. Premium at $30/year.

Pros: Handles attachments better than YAMM. Can send entire sheets as personalized PDFs. Test mode before you blast everyone.

Cons: Slightly less intuitive than YAMM for basic mail merge. Overkill if you're just sending text emails.

6. RentGuard: Best for Rent Monitoring & Overdue Alerts

Full disclosure: I built this one. But I built it because nothing else on the market did what I needed.

RentGuard connects to your existing Google Sheets rent roll and monitors it automatically. When rent is overdue past your grace period, it sends you an email alert. No code. No migration. Your sheet stays exactly the same — RentGuard just watches it.

There are two ways to use it:

The Google Sheets add-on — Install it directly from the Google Workspace Marketplace. Open your rent spreadsheet, launch the add-on from the sidebar, sign in with Google, and you're connected in under 60 seconds. It works right inside Sheets where you already are. No separate app to learn.

The web app — Sign up at getrentguard.com, connect your Google Sheet through the onboarding wizard, and configure your alert preferences. Same monitoring engine, just a different door. The web dashboard gives you a fuller view of all your properties, overdue history, and activity logs.

Either way, you get the same thing: RentGuard scans your sheet daily and alerts you the moment rent goes past due. The other add-ons on this list help you create documents, send emails, and collect data. RentGuard fills the gap none of them cover — actually watching your spreadsheet and telling you when something needs attention.

Price: Free forever (1 property, up to 5 units). Pro at $15/month for unlimited properties and units.

Pros: Purpose-built for landlords. Installs directly into Google Sheets as an add-on. Email alerts for overdue rent. Connects to your existing sheet in under a minute. No formulas, no Apps Script, no code.

Cons: Focused on rent monitoring — not a general-purpose add-on. If you only have 1-2 units, the free tier covers you but you might not need automated alerts yet.

If you're managing 5+ units in Google Sheets, this is the one I'd install first. Biased? Sure. But I built it because I needed it myself, and the add-on means you never have to leave your spreadsheet to set it up.

7. Doc Variables: Best for Template-Heavy Workflows

Doc Variables lets you create document templates with fillable variables, then merge data from Sheets or a custom form. It supports images, lists, and even AI-generated content.

Landlords with lots of standardized documents (lease addendums, inspection reports, notice letters) will get the most value here. It's like Autocrat on steroids.

Price: Free tier available. Premium from $48/year.

Pros: Extremely flexible templating. Handles images and complex formatting. Works with Salesforce and HubSpot if you're fancy.

Cons: More complexity than most landlords need. Setup time is real. Better for property managers with 50+ units and standardized processes.

Which Ones Should You Install?

If I had to pick just three for a landlord running 5-20 units on Google Sheets, I'd go with:

YAMM for sending tenant notices. Autocrat for generating rent receipts. RentGuard (the add-on) for making sure you never miss a late payment.

That combo covers communication, documentation, and monitoring — the three things that actually matter. And all three install directly into Google Sheets, so you never have to leave your spreadsheet.

Want to get more out of your rent spreadsheet? Read my guide on how to automate your landlord spreadsheet in Google Sheets. And if your formulas need work, here are the Google Sheets formulas every landlord should know.