This week on our Tuesday Q&A call, we talked about another Zapier integration: DonorDock & QuickBooks.
As a refresher, Zapier is a middleware integration tool that allows DonorDock to connect to cloud based apps by way of series of triggers, creating new contacts, new gifts, campaigns, funds, appeals or activities in DonorDock from that app or vice versa.
With over 2,000 possible apps to integrate with, Zapier gives our users the ability to connect with whatever makes sense for their organization.
One of the most frequently asked questions is about our integration with QuickBooks Online.
Zapier uses zaps from a trigger (what initiates an action) in one system to create an action (what you want to do) in another system, moving data from point A to Point B. In this case, we are moving data from DonorDock to QuickBooks Online (QBO) in 3 steps.
When a new gift is created in DonorDock (whether it’s manual, online, or from another Zapier integration) we want to create an action in QBO. After the trigger is created, click Continue and connect Zapier to your DonorDock account. You can do this by creating an API and Secret Key, as long as you have an administrative role. Instructions on how to create an API Key and Secret Key can be found in the Knowledge Base article API Keys.
Pro-tip: Make sure you just put in your organization URL; Zapier already includes the https:// in the beginning and the .donordock.com at the end.
Once you’ve connected Zapier to DonorDock, click Continue.
Connect to your QBO account by signing in and allowing Zapier to connect.
Begin mapping the data you want from DonorDock to fill in on the QBO side.
We have filled in the search field, which gives you the option to find a match from name or email. Because we don’t keep a lot of email information in QBO, we have decided to go with the customer name.
If a match is found, we short circuit the next step. If a match is not found, the checked box will tell the system to create a new customer and map all the fields in DonorDock that we have in QBO. Click Test and Continue and Continue.
Map your data from DonorDock into the sales receipt we want to create. You can use the step in Step 2 to populate the customer fields by using the customer ID. Map other necessary fields.
It’s worth noting that DonorDock has created the above discussed templates and submitted them to Zapier for approval. Once it’s published, you will be able to use the templates and manipulate them however you need so you create your custom zaps for DonorDock and QBO.