Automated UniFi Guest Wi-Fi Voucher Generator (via Google Sheets/Google App Script)

Дата публикации: 09-10-2026 13:35:38

Hey everyone,

I manage multiple sites, and easily one of the most annoying little admin tasks on my plate was constantly dealing with guest Wi-Fi vouchers.



You know the drill: receptionists lose the printed sheets, visitors show up unannounced, nobody else in the office can be bothered (or knows how) to log into the UniFi portal to generate fresh ones, and old printed voucher sheets end up lying around desks like confetti.



So, to save my own sanity, I built a lazy-proof script that runs completely free inside Google Sheets to handle the whole circus automatically.

What it actually does:


Automated Weekly Top-Ups: Fires off every Monday morning and automatically tops up your site inventory (e.g. keeps a steady supply of 20x 8-hour passes and 5x 3-day extended passes for inspectors/VIPs).


Stops Voucher Hoarding: Tired of staff leaving months-old voucher slips lying around? You can enable a "purge" option that wipes all unused codes from the UniFi controller every week before issuing the new batch—meaning old paper slips instantly become useless trash.


Hands-Off Emailing: Automatically emails your office managers or receptionists their site's fresh codes every week so they stop bugging IT.


Foolproof Print Dashboard: The email includes a live link to a clean web page where staff can just click "Print Tickets" if needed. As visitors use codes, they vanish off the screen in real-time. so they dont get handed out multiple times


Handles multiple controllers: Built specifically to handle multi-site UniFi setups from a single master sheet.


Zero Hosting Costs: Runs 100% on free Google Apps Script—no virtual machines, Docker containers, or servers required.

I've made the script and setup guide open-source on GitHub. Feel free to grab it, fork it, or use it to automate yourself out of the guest Wi-Fi business:



https://github.com/DG-WISE/Unifi-Hotspot-Voucher-Generator



Hope this saves a few of you from the endless "Can you send over some Wi-Fi codes?" let me know if ive missed anything

And yes the sheet is probably defunct, but it started as a i want an easy list myself and turned into hey it can do all the work for me instead...

Основное содержимое страницы с новостью.

Схожие новости

#	Наименование новости	Тональность	Информативность	Дата публикации
1	Unshorten: resolve shortlinks and strip tracking parameters	0	7.13	30-09-2026
2	Mail notification for Governor school email addresses	0	5.47	09-10-2026
3	How do you stop the same person from signing up again and again on a free plan?	0	7.37	16-09-2026
4	How to segment a small office LAN with VLANs on a Catalyst 9300?	0	7.84	05-10-2026
5	Markdific - A better tool to open, read, edit and export Markdown files	0	7.23	05-10-2026
6	Ditch iCloud: Get 1TB of Koofr cloud storage — $129.99 with this code	0	14.38	05-10-2026
7	Access more visitor data with the Kinsta API	0	7.35	14-08-2026
8	[IOS-XE] AES password encryption setting is not reflected from GUI	0	12.35	07-10-2026
9	Learn Claude Code and Cowork — Just $15 during Deal Days	0	15.48	04-10-2026
10	Microsoft Rewards	0	9.51	08-10-2026

Классификация: Пресс-релизы. Схожих патентов: 0. Схожих новостей: 10. Тональность: 0. Информативность: 9.18. Источник: www.edugeek.net.