Blog

Email Notifications In UniFi Controller

March 21, 2018 by Glen Ferguson

How to send email alerts from UniFi to Zapier, and then into Fieldbook to see who/what was using our network each day.

Set Up Your Mailbox

Get a Zapier Parser Account

https://parser.zapier.com It’s free. Follow the guidance on the screen.

Create a mailbox

Click the button. 🙂

You Can Skip Waiting

Choose A Better Name

or not. It’s up to you. I’m using “cowfredwifi”

Don’t worry about the template contents for now.

Configure UniFi Controller

Go To Settings

Click the gears icon to open the Settings menu.

Add A New Admin

At present, I’ve only been able to get emails sent to administrators. Hopefully this will change.

Add the email address you created for your Zapier Mailbox and make it an administrator. *** Pick a very strong password for this account ***

Go To Notifications

Here you’ll find the categories for all the different events you can use to trigger alerts.

We’re using Client Events, so expand that.

By the way, if you want to undo what we’re about to change, use that red Reset To Defaults button to reset any alerts you’ve changed.

Set The Alert and Email

Right now, it the only way to get the email to send is if you also select the Alert checkbox. It can create a lot of alerts though (see circled icon) so clear your alerts regularly.

We’re using the alert for “User connected (wireless)” so click the checkboxes for Alert and Email.

Bonus: I expanded Hotspot Events because I’m also sending myself an alert for “Guest payment processed” so I can confirm our Daypass users have connected OK, but this isn’t used in our Zapier process.

Click the Apply Changes button. Scroll the screen down if it isn’t visible.

Time Passes…

Let’s Finish That Template

Since you have a busy cowork business, a member has likely arrived and joined your WiFi. If not, make an alert happen by disconnecting your device (maybe your phone) from WiFi, then re-connecting it. As an admin, you should also get an email of the alert.

Switch back your Zapier Parser screen and you should have an email by now. Click Edit see it.

I already had a template made, so these screens refer to an extra template, but otherwise they”re the same as setting the main template.

Highlight the content you want to use and give it a name. The next steps explain in more detail.

Highlight And Name Your Variables

Again, I had to grab a different area to demonstrate, but you highlight the section of the email you want to use in Zapier and give it a name. The next step shows what I really capture.

Make Your Template For Zapier (Before)

From the alert UniFi sent, highlight the content you want to use later on. These are the two areas I chose, although we really only need the second one.

Just highlight the MAC address (the part within the brackets) and not the brackets.

The next step shows the finished template.

Make Your Template For Zapier (After)

We need the MAC address of our member’s device, so I selected that content and named it {{usermac}}. Note that the square brackets are not part of the highlighted selection.

I also selected the alarm subject and called it {{status}} in case I want to use that later on.

Leave the Body source and Parser engine at the default values.

Click Save Address and Template button when you’re done.

Go To Zapier

Make A New Zap

For Step 1, choose the Email Parser by Zapier component and select New Email as the trigger.

Sync or connect your Parser and Zapier accounts if prompted.

Choose your mailbox in the Edit Options step and test it.

(Optional) Clean The Date Format

Free Zapier accounts only allow 2-step zaps, so this step should be skipped unless you have a paid account.

I wanted to use only the date and not the date/time. The reason is the app I use in the last step has a “create record if it doesn’t exist” action, and if I have a record with the same date and MAC address, it won’t create a duplicate record.

The Formatter by Zapier enables you to manipulate dates, times, numbers, etc. to get them in the format your other app may need.

Write The Record

I’m using a service called Fieldbook, but you can probably get a prettier end result if you use AirTable.

You could also use Google Sheets, but I don’t know if you can get all database-y and link the sheets/tables.

My spreadsheet has columns for Date, Devices, Member Name and Device Name. These last two columns are linked to a sheet I set up ahead of time with our members names, device names, and device MAC addresses (all things you can get from the UniFi controller).

Test your Zap. If it works, save and make sure it’s turned on.

The End Result

The Fieldbook Entries

Here’s how the information is presented after Zapier updates the Attendance 2018 sheet in Fieldbook.

Green Devices are ones that match a MAC address in my Devices table, and the Device name and member Name is filled in automatically when there’s a match.

The salmon colored Devices are MAC addresses I don’t have paired with a member (yet). We had a meeting that night, and the alerts aren’t differentiating between our member network and our event network. That may be my next project when this is polished a bit more.

Created with StepShot Guides

Protected: Why You Need Online Donations

July 19, 2017 by Glen Ferguson

Don’t Be A Digital Sharecropper

June 24, 2014 by Glen Ferguson

After writing my earlier post about branding mistakes, I was listening to a Copyblogger* podcast and I was reminded how important it is to have your own domain name. More to the point, I was reminded WHY you want to have your content show up under YOUR domain name.

How many times have you heard about someone’s Facebook, Twitter, Pinterest or other social media account being suspended? Just yesterday I read about a mommyblogger whose Instagram account was shut down over a minor terms of service violation regarding a photo. Right or wrong, all her content is no longer available. All her effort creating a page, getting likes, followers or whatever, and now it’s a big blank page.

Digital Sharecropping

The term is “digital sharecropping” and it applies when you put your content on any platform you don’t control. If someone else owns it, you’re beholden to them and subject to their whims. Without your own website – and your own domain name, you’re creating traffic for someone else. All that fuss you hear about SEO and Google page rank? You’re helping to build someone else’s reputation and traffic. Wouldn’t you rather have all of your effort benefit your own business instead of theirs?

Your Domain Name = Your Brand

Now don’t get me wrong, I’m not saying you should abandon social media. Not at all.

First, sharecropping extends to free websites and blogs too. Anyone remember Geocities.com? They had tens of thousands of websites hosted for free. They all vanished when Geocities closed their doors. Today, sites like blogger.com, web.com, weebly.com offer ways to get a free website. [Read more…] about Don’t Be A Digital Sharecropper

The One Big Branding Mistake Businesses Make

June 6, 2014 by Glen Ferguson

misspelled photo — Photo by victoriapeckham

We all know how important branding is to your business. That’s why you worked endless hours on a name, a tag line, and a logo design. And don’t forget the effort you put in to make sure you could secure a domain name that matched! But, there’s a major piece in the branding puzzle that is often overlooked, and it defeats all the work you put in to create a consistent image. Fortunately, it’s easy – and cheap – to fix this huge branding mistake. I’ll tell you what it is in a minute. [Read more…] about The One Big Branding Mistake Businesses Make

Setting Up Google Apps on an iPhone

February 19, 2014 by Glen Ferguson

[The following information comes from Google Apps for Business setup wizard]

Google Apps works great on iPhones and other iOS products, where you can access your email, contacts, and calendar using the device’s built-in apps. This is easy to set up, using Google Sync.

Want quick access to your apps? Skip all this and access your apps in a moblie browser by visiting http://mail.google.com/a/<your domain name> on mobile Safari.

Step 1: Sync an iPhone with Google Apps

After you enable Google Sync for your domain, have each user follow these instructions on their iPhone.

Open the Settings application on the iPhone’s home screen.
Open Accounts & Passwords.
Tap Add Account….
Select Microsoft Exchange. [NOTE: screens may be different depending on your version of iOS]
In the Email field, enter your full Google Apps email address.
Leave the Domain field blank.
Enter your full Google Apps email address as the Username.
Enter your Google Apps password as the Password.
Tap Next at the top of your screen. (Choose Cancel if the Unable to Verify Certificate dialog appears.)
When the new Server field appears, enter m.google.com.
Press Next at the top of your screen again.
Select the Google Apps services (Mail, Calendar, and Contacts) you want to sync.
Unless you want to delete all the existing Contacts and Calendars on your phone, select the Keep on my iPhone option when prompted. This will also allow you to keep syncing with your computer via iTunes. To sync only the My Contacts group, you must choose to Delete Existing Contacts during the Google Sync install when prompted. If you choose to keep existing contacts, it will sync the contents of the “All Contacts” group instead. If there are no contacts on your phone, the latter will happen — the contents of your All Contacts group will be synced.

That’s it! You can now access Google Apps from your iPhone. If you have Push enabled on the phone, synchronization starts automatically. You can also just open the Mail, Calendar or Contacts app and wait a few seconds to start a sync.

Setting Up Google Apps On Your Android Phone