October Thu, 2018
Zapier…what’s all the buzz about?
You may have noticed that everyone has been talking A LOT about Zapier lately, and you’re probably wondering, what is all the buzz about?
Imagine this: you send a new client a Google Form to gather their information. They complete and submit the form and the following tasks occur automatically:
- The client is added as a new Client in Practice Ignition
- A new channel is created in Slack
- A new folder is created in Sharefile, Google Drive or DropBox
- A new card is created in Trello
- A notification is sent to someone in your organization to let them know that the client has completed the form and the tasks above have been completed
Sounds incredible, doesn’t it? I have saved countless hours each month using Zapier to automate many of my recurring tasks. In November 2017, I shared 5 of my favorite Zaps at QuickBooks Connect in San Jose, CA and in December, I launched a 5-week Zapier Workshop course to help busy accounting professionals and consultants learn how to use Zapier to supercharge their efficiency both in their own practice and with the clients. We’re just finishing up our 4th Zapier workshop cohort and the Zapier revolution has certainly gained momentum. Accounting firms are now offering Zapier consulting as part of their firm service offerings and bring the power of self-serve automation to their clients and community.
My students are doing some pretty clever things with their new found knowledge. One student has automated the entry of Invoices from Freshbooks into QuickBooks and another has created a Zap that scrapes data from an email and automatically creates a Sales Receipt in QuickBooks. They created these new automations in no time and are saving tons of time! Another student, Neal Coogler of All About Services created a one-hit wonder zap to set up dozens of files in Sharefile and has published her handiwork on Insightful Accountant!
So, what is Zapier?
Zapier is a web-based application designed for non-techies that allows you to create automated workflows between other web-based apps that you probably already use, like Gmail, Trello, QuickBooks, Xero and over 1,000 other supported apps. Some exciting recent additions to their platform include awesome accountant-specific apps like Practice Ignition and Aero Workflow (still in beta as of publication of this article).
So how does Zapier work?
A Zap starts with a Trigger, which means that something happens in an app that you’re using, this could be that you receive a new email in Gmail, or create a new invoice in QuickBooks, or an event is added to your Google Calendar. When that Trigger occurs, Zapier sends an Action instruction to another app to do something in another app.
Let’s look at an example:
I created a Zap that I use in my own firm that automatically sends a blank Form W-9 to my service vendors via an email when I add the vendor to my QuickBooks Online company. I call this my W-9 collection Zap! Here’s the way the workflow in Zapier works:
Step 1 – Define the Trigger: The first step is to define the Trigger for the Zap. The Trigger in this workflow is that a new Vendor is created in my QuickBooks Online Company. But not all of my vendors should receive a 1099, only the vendors that provide a service to me. This brings me to Step 2.
Step 2 – Add a Filter: Zapier has built-in apps to help you supercharge your Zaps by filtering for specific data, transforming data from one app to a format that can be read by another app, or completing more complex functions like parsing data from an email. This all sounds very technical but it really isn’t that complicated once you learn the rules and best practices for building Zaps. In my W-9 collection Zap, the filter will be to look to see if the “Track payments for 1099” box is checked when the Vendor is created and only run the Zap if that condition is true. Now that we’ve set up our Trigger and told Zapier exactly what to look for, our next step is to tell Zapier what to do by creating an Action.
Step 3 – Add an Action: In this workflow, the Action is to create an email that will be sent to the vendor with a blank W-9 attached to it, along with a link to upload the completed W-9 to a folder in my Sharefile account.
Now that I’ve completed building the Zap, I just turn it on and let Zapier do the work for me. The email above is sent to my service vendors automatically when I check the 1099 box in QuickBooks. This has saved me tons of time because I don’t have to remember to reach out the vendor or manually request a form W-9 from them! Pretty cool stuff.
To learn how to create this Zap for yourself, watch this video! You can learn more about the different types of Zapier accounts and how to build more amazing Zapier workflows by signing up for my 5-week Zapier Workshop! Here’s what you’ll learn:
- Session 1: Introduction to Zapier and Build Your First Zap
- Session 2: Built-in Zapier Apps to help you build your workflows: Part 1
- Session 3: Built-in Zapier Apps to help you build your workflows: Part 2
- Session 4: Exploring Zaps to automate your Marketing and Communications
- Session 5: Exploring Zaps that work with QuickBooks
As a member of the class, you will be invited to a closed Slack Channel where you’ll be able to ask questions, view the recordings of the class sessions and network with your peers. You’ll also be invited to my closed Facebook group where you can continue your learning and journey with Zapier beyond the duration of the course. If you have any questions, please feel free to reach out to me at firstname.lastname@example.org!