Latest / QB Power Hour Podcast / Bridging the Apps
Transcript
- 0:33Matthew Fulton: It's good to see everybody here again today.
- 0:36Dan DeLong: Likewise.
- 0:37Dan DeLong: Welcome everybody to another QB power hour.
- 0:39Dan DeLong: We wanted to start on time because we have a lot of stuff to do and unpack.
- 0:45Dan DeLong: Cause we're going to be talking about bridging the apps using Zapier to enhance QuickBooks online.
- 0:51Dan DeLong: Integrations.
- 0:54Dan DeLong: Without ourselves, my name is Dan DeLong, owner at Danwith and School of Bookkeeping.
- 0:59Dan DeLong: I worked at Intuit for nearly 18 years, co hosting today as well as the workshop Wednesdays over at schoolbookkeeping.
- 1:06Dan DeLong: com.
- 1:06Dan DeLong: There's a link there for the Facebook group, which is Closing in on 20, 000 members.
- 1:14Dan DeLong: And yeah, I appreciate everyone that has been reporting the posts that are, that have been spammy in the Facebook group.
- 1:23Dan DeLong: It's really hard sometimes to manage those people from not getting in.
- 1:31Dan DeLong: It's a lot of work of all sorts.
- 1:33Dan DeLong: Yeah.
- 1:34Dan DeLong: Labor of love over at the Facebook group.
- 1:36Dan DeLong: So appreciate any everyone doing that.
- 1:40Dan DeLong: If you do if you want to be a moderator to, so that you can, you do can ban spammers from the Facebook group, please let me know.
- 1:50Dan DeLong: Matthew.
- 1:51Matthew Fulton: Hello, everybody.
- 1:52Matthew Fulton: Matthew Fulton here.
- 1:53Matthew Fulton: My friends call me Spot.
- 1:54Matthew Fulton: I am the founder of Parkway Business Solutions, also known as CloudApps, Inc.
- 1:59Matthew Fulton: One of the creators of the Facebook group, Quby Community Live.
- 2:03Matthew Fulton: We are not at the 20, 000 mark.
- 2:05Matthew Fulton: We actually, it's a smaller group, but we keep it that way on purpose because like you're talking about, it's sometimes it's difficult to manage everybody's best intentions inside there.
- 2:16Matthew Fulton: Also do blueprints for business series and I am a total workflow nerd which means I like working with the API, working with app companies and trying to help them better understand how they can actually integrate their products to QuickBooks online.
- 2:31Matthew Fulton: And how did I get the nickname Spot?
- 2:35Matthew Fulton: Super fast version of it is I have a skin disease called vitiligo.
- 2:38Matthew Fulton: It changes the pigment in your skin and turns it white in places.
- 2:41Matthew Fulton: And when I was a freshman in high school, I grew up and moved a lot.
- 2:45Matthew Fulton: Every place I moved, I always had to re explain it.
- 2:47Matthew Fulton: When I was a freshman in high school, I moved to Hemet, California.
- 2:50Matthew Fulton: And they said, everybody has a nickname.
- 2:52Matthew Fulton: You have to have a nickname.
- 2:53Matthew Fulton: And I said, how about Spot?
- 2:55Matthew Fulton: So it stuck, took it with me along the way, and it turned negative into a positive.
- 2:59Matthew Fulton: So it's a positive thing for me.
- 3:01Matthew Fulton: Thank you for asking.
- 3:02Dan DeLong: And that, is what we love about you, Spot, is that you in, in, all things, not just not just with that, but like anything Intuit or QuickBooks, you always have a, nice objectively positive, view of things.
- 3:17Dan DeLong: So I really appreciate your perspective as well.
- 3:20Dan DeLong: A little bit about the QB Power Hour.
- 3:24Dan DeLong: It's every other Tuesday.
- 3:25Dan DeLong: 12 noon Eastern.
- 3:27Dan DeLong: We are eligible for CPE credits through earmark.
- 3:30Dan DeLong: So if you didn't catch the intro video there, there's a QR code to, to check that out and download the app.
- 3:39Dan DeLong: Most of our prior QB power hours, since we've started this are available for CPE credit.
- 3:45Dan DeLong: You can check out the channel on, earmark.
- 3:49Dan DeLong: Typically they're five, seven days after.
- 3:54Dan DeLong: The webinar there will be a new listing there on, on earmark to get your CPE credit.
- 4:01Dan DeLong: We're going to be talking about Zapier today, so if you have specific questions about the, about Zapier, and, how it works and, whatnot please put them in the Q& A, so it's a lot easier for us to follow up and keep track of those questions, because as I can see the, chat is going by, I don't get alerts on those things for, in in the comments please put those in there and Matthew and our helpers are, trying to make sure that we, we, get everyone everyone's perspective included so we can put them as in the, you can put that kind of stuff in the comments, like what do you eat for for Mardi Gras since it is fat Tuesday at my Mardi Gras.
- 4:46Dan DeLong: That's what Fat Tuesday is
- 4:48Matthew Fulton: about.
- 4:49Matthew Fulton: Okay, I thought it was just really, big tacos.
- 4:52Matthew Fulton: I didn't know what Fat Tuesday was, but anyway.
- 4:54Dan DeLong: Okay.
- 4:56Dan DeLong: It's Tuesday and I'm All right.
- 5:02Dan DeLong: And we also got the QB power, our story.
- 5:04Dan DeLong: You can check that out if you feel so inclined.
- 5:07Dan DeLong: So let's talk about what we're going to talk about.
- 5:10Dan DeLong: So what's on the agenda today.
- 5:11Dan DeLong: So we're going to set the stage on I guess this is a Shakespeare reference here with, to zap or not to zap.
- 5:19Dan DeLong: That's the question.
- 5:21Dan DeLong: So we'll unpack what's the need for, Zapier.
- 5:25Dan DeLong: And then we'll talk about what Zapier actually is.
- 5:28Dan DeLong: And just a brief overview of the.
- 5:32Dan DeLong: Under the hood of, Zapier, and then we'll talk about some, real world examples.
- 5:38Dan DeLong: So first off, I just wanted to talk about.
- 5:41Dan DeLong: Why I wanted to do a webinar on, Zapier because here this is the QB power hour and we're talking about a completely different application altogether.
- 5:51Dan DeLong: I went to into a connect last year and Blake, who is did a, little intro for us over here.
- 6:01Dan DeLong: He did a wonderful breakout session on how to use or how to automate.
- 6:08Dan DeLong: Advisory types of things using a couple applications.
- 6:13Dan DeLong: One was Process Street, which is a workflow automation task manager practice management type of thing and ChatGPT and Zapier.
- 6:27Dan DeLong: And it was really interesting to me that the it was probably it was one of the larger breakout sessions.
- 6:34Dan DeLong: So probably about two, 200 or so.
- 6:38Dan DeLong: Capacity that was there and a lot of the questions that were, that he was taking people could submit them and, A lot of them had to do with just what some, confusion about what Zapier actually is.
- 6:56Dan DeLong: So that's what we wanted to that's why we wanted to do this is, to make sure that people having a good understanding of what Zapier can actually do and how it can enhance some of these integrations.
- 7:09Dan DeLong: Because Matthew you, could probably attest to this pretty well.
- 7:14Dan DeLong: When a, when an app company says works with QuickBooks, I'm using air quotes there.
- 7:20Dan DeLong: The devil is always in the details and it may be not the kind of integration that you want it to have working with, QuickBooks.
- 7:31Dan DeLong: And Zapier is a way to be able to, augment some of those things when you're dealing with apps that connect to QuickBooks.
- 7:42Dan DeLong: What would you?
- 7:43Dan DeLong: What would you say?
- 7:45Dan DeLong: We're going to go into what it is and everything, but what are your thoughts on that?
- 7:50Matthew Fulton: I'd agree.
- 7:50Matthew Fulton: So I've always felt that Zapier is a great product to help app companies test out what needs to be integrated to QuickBooks Online.
- 7:59Matthew Fulton: It's a more cost effective way to connect to multiple different apps across the app sphere all at once.
- 8:07Matthew Fulton: And then.
- 8:08Matthew Fulton: Once you see that there's engagement, people are actually trying to use certain parts of it.
- 8:12Matthew Fulton: Then maybe you spend the money through development to do a direct integration.
- 8:16Matthew Fulton: And we're going to talk very briefly about the difference between a direct integration and one way versus two way, some of that stuff.
- 8:24Matthew Fulton: We can dive in and show what that is,
- 8:27Dan DeLong: let's start off with the first poll question.
- 8:30Dan DeLong: I've lost it.
- 8:32Dan DeLong: There it is.
- 8:34Dan DeLong: So the first one is just to set the stage of how familiar are you with, Zapier.
- 8:41Dan DeLong: And that's the first thing is, how do you pronounce the word?
- 8:46Matthew Fulton: Zapier.
- 8:46Matthew Fulton: I always heard Zapier makes you happier.
- 8:48Matthew Fulton: Zapier makes you crazier.
- 8:51Dan DeLong: Exactly.
- 8:53Dan DeLong: That's their slogan or byline.
- 8:55Dan DeLong: It's, Zapier makes you happier.
- 8:59Dan DeLong: So we'll talk a little bit about that.
- 9:01Dan DeLong: It looks like, looking at people answering.
- 9:04Dan DeLong: It looks like never used it is, is 71 percent of the folks that have, taken taken the
- 9:16Matthew Fulton: Interesting question.
- 9:17Dan DeLong: Wow.
- 9:17Dan DeLong: I just brain, no, I haven't started drinking yet.
- 9:25Matthew Fulton: We've had two people mentioned give butter in the comments, just already talking about nonprofit and using that.
- 9:30Matthew Fulton: So I'm going to have to take a note and check out that application as well.
- 9:33Matthew Fulton: So
- 9:36Dan DeLong: go ahead and in the poll here, it looks like most, share it.
- 9:41Dan DeLong: Yeah.
- 9:42Dan DeLong: So 68 percent never used it.
- 9:45Dan DeLong: 17, Maybe heard about it before and like a little update and enough to be dangerous.
- 9:52Dan DeLong: I think that's, the trouble area.
- 9:56Dan DeLong: I think we're, we could feasibly get ourselves into.
- 9:59Dan DeLong: So hopefully as we unpack this here today, where did the mouse go?
- 10:04Dan DeLong: There it is.
- 10:05Dan DeLong: Okay.
- 10:06Dan DeLong: So let's, talk about to zap or not to zap.
- 10:09Dan DeLong: So spot, what would you, how would you, tease this off here?
- 10:14Matthew Fulton: So the first right off the bat, when we talk about using Zapier or otherwise, the whole point is how do you get data from one place to another?
- 10:22Matthew Fulton: The ultimate, the best way of course, is a direct integration.
- 10:25Matthew Fulton: So when one app is partnering up to the other using their APIs, and you're gonna have either a one way sync or a two way sync, one way sync is where.
- 10:33Matthew Fulton: You may connect a different app to QuickBooks Online.
- 10:36Matthew Fulton: And it gets a little confusing here because they may go and suck in certain bits of information initially, like maybe your vendor list or customer list, chart of accounts.
- 10:45Matthew Fulton: They will pull that stuff over in certain transaction types.
- 10:48Matthew Fulton: But then after that initial sync, it will only write data from the external app.
- 10:53Matthew Fulton: Two QuickBooks online, only one way.
- 10:56Matthew Fulton: It never goes both directions.
- 10:58Matthew Fulton: Now a two way sync then probably becomes a little more obvious, that it's a situation where once you've done the connection, you pull information back and forth, it can actually write data both directions, and that It's a lot, it's a lot more challenging to code it that way, because you have to keep in mind, let's say both programs sent data at the exact same time, which one takes precedence?
- 11:20Matthew Fulton: Which one is going to be the most important one if they're both trying to update something at the exact same time?
- 11:25Matthew Fulton: And how do you track it with autologs, everything else?
- 11:29Matthew Fulton: If you don't have a direct integration capability, this is where we start talking about different bridge apps such as Zapier, and there's other competitors that are out there as well which if, anybody watching has other suggestions, feel free to put in the chat as well, make is one IntegraMAT, Integra, Integrately, Pably, Automate.
- 11:52Matthew Fulton: io.
- 11:52Matthew Fulton: There's probably 10 other ones as well.
- 11:55Matthew Fulton: But Zapier is the Kleenex of all these, where it came out really first, and it's got the biggest following of all of them.
- 12:03Matthew Fulton: And it's, we call it a bridge app because it, what they do is they connect points to the different APIs and allow you a very easy way, like mind map way of, Connecting these pieces and trying to understand how to put the pieces together and even cooler is recipes to make it taste good, if you will.
- 12:23Matthew Fulton: Exactly.
- 12:25Dan DeLong: So we did do we did do a webinar on Zapier back in 2021.
- 12:31Dan DeLong: So yes It deserves an updating but Heather Day Saturday she was very heavily, integrated
- 12:43Matthew Fulton: general course on it all.
- 12:45Matthew Fulton: Which we all learned from big time.
- 12:47Matthew Fulton: Yeah.
- 12:48Dan DeLong: Intro to zap your you can check that out.
- 12:51Dan DeLong: I've got it put on the QB power hour page so you can watch that as well.
- 12:57Dan DeLong: So if we're.
- 12:59Dan DeLong: Maybe talking a little bit differently about how, well it sinks in some of these topics that we're talking about here today.
- 13:07Dan DeLong: You can check that out and maybe Heather has a better way to resonate with that.
- 13:17Matthew Fulton: And we recorded the whole webinar.
- 13:19Matthew Fulton: You guys can watch the rest.
- 13:20Matthew Fulton: No, just kidding.
- 13:22Matthew Fulton: And we're done.
- 13:23Dan DeLong: Yeah.
- 13:24Dan DeLong: Easy, but really what is Zapier?
- 13:26Dan DeLong: And I think that's, what we want to first foundational wise.
- 13:31Dan DeLong: It's really just a tool that connects cloud based applications and it, offers a low code or no code way to connect one app to another.
- 13:46Dan DeLong: Would you, say that's a pretty good?
- 13:50Matthew Fulton: Yeah, I think you nailed it, basically.
- 13:53Matthew Fulton: The idea of low code, no code, it's, they use that terminology to motivate people to try it out.
- 14:01Matthew Fulton: As we get into some of the examples, you'll see, I use the term mind mapping because it's going to be graphics where you can move around and you can see the pieces, that visually you can see what you're building.
- 14:11Matthew Fulton: That's the beauty of this.
- 14:12Matthew Fulton: Because if you look at the API documentation, Have fun.
- 14:19Matthew Fulton: There's a lot more involved to that.
- 14:21Dan DeLong: Yeah.
- 14:21Dan DeLong: Yeah.
- 14:22Dan DeLong: It makes sense to someone, but it's just a question is whether or not you can actually make sense of it for yourself because, Accountants, bookkeepers, accounting professionals, peer advisors, this is probably the last thing that you wanted to get yourself into when it comes to, managing your clients.
- 14:44Dan DeLong: But it's not just as we're talking about the QB power hour and how Zapier can help with with QuickBooks online, it connects over to over 2000 different applications.
- 14:58Dan DeLong: And as we'll get.
- 14:59Dan DeLong: As we'll unpack not all applications are the same.
- 15:03Dan DeLong: James was saying in the in the Q and A, right?
- 15:07Dan DeLong: Like, how do you know if if an app is two way or one way or no way.
- 15:13Matthew Fulton: Yeah.
- 15:14Dan DeLong: Or are they just making it up?
- 15:17Dan DeLong: Each of these apps to Zapier.
- 15:19Dan DeLong: offers the same questionable options of how do they get, how do they get how do they integrate with Zapier so that you can integrate with these other apps?
- 15:33Dan DeLong: It's very powerful in that, it allows you to do more things with one action.
- 15:41Dan DeLong: Now, how much does Zapier cost?
- 15:44Dan DeLong: It depends.
- 15:45Dan DeLong: That's the answer for in most cases in our industry.
- 15:48Dan DeLong: I think there is a free option.
- 15:51Dan DeLong: You can go check it out on their, website.
- 15:54Dan DeLong: But the their pricing matrix is typically based on the type of connection whether you're using a premium app.
- 16:02Dan DeLong: Or a regular app connection.
- 16:06Dan DeLong: By the way, QuickBooks Online is a premium app, so if you wanna have anything doing with QuickBooks you're gonna at least have to go with the professional midway option.
- 16:17Dan DeLong: You can't use the free option.
- 16:19Dan DeLong: Then the other pricing consideration is the number of tasks, and we'll talk about what a task.
- 16:26Dan DeLong: Is and how do you account for the number of tasks and then the number of people on your team, you can have a team team of people and share, zaps between between you between your, between the team members.
- 16:39Dan DeLong: So there's a link there in the, slides on the, pricing but the, smallest or the lowest.
- 16:48Dan DeLong: Task option is 750 a month.
- 16:51Dan DeLong: And if you chose that with the professional, that would be like 20 bucks a month, right?
- 16:56Dan DeLong: So it's, not a lot.
- 16:58Dan DeLong: And then you figure out how many tasks you're actually needing, and then you can figure out what the pricing would actually be.
- 17:07Dan DeLong: Task accounting, I thought that was funny that on their website they have, how do you account for tasks, but what is a task?
- 17:15Dan DeLong: A task is counted when an action is successful.
- 17:20Dan DeLong: If something fails it doesn't count, right?
- 17:23Dan DeLong: If there's a problem, right?
- 17:25Dan DeLong: And that a successful action is either a read or write or a search, right?
- 17:30Dan DeLong: So if it's pushing something to the app of doing something else, that's considered a task.
- 17:37Dan DeLong: If it's reading it pulling in the information so that it can do something with it.
- 17:42Dan DeLong: Then that's a pull.
- 17:43Dan DeLong: And then searching, you're able to search within the applications that you're connected to now a trigger.
- 17:50Dan DeLong: And we'll talk about what a trigger is a little bit triggers don't count.
- 17:54Dan DeLong: So in this example, the trigger is an email coming in through Gmail.
- 18:01Dan DeLong: And then they want to do something with that email.
- 18:04Dan DeLong: They want to send it to Dropbox and Slack, right?
- 18:07Dan DeLong: So if 10 emails were received, the, okay.
- 18:12Dan DeLong: Whatever it's doing into Dropbox is 10, 10 tasks and then sending the next step or whatever that is after that DM sent to Slack is also 10.
- 18:24Dan DeLong: So one one, one zap can count for 20 different tasks, depending on how many how many steps you have in there.
- 18:34Dan DeLong: All right.
- 18:35Dan DeLong: So our next poll question is, have you ever been?
- 18:40Dan DeLong: Have you ever been disappointed by the limited integrations of apps to QuickBooks?
- 18:45Dan DeLong: Never happened, right?
- 18:47Dan DeLong: Every one Matt, right?
- 18:50Dan DeLong: Yeah.
- 18:50Dan DeLong: All the applications were exploded.
- 18:53Matthew Fulton: People are taking the poll.
- 18:54Matthew Fulton: I'm going to go over real quickly, to some of the questions we had.
- 18:58Matthew Fulton: So James was asking a question.
- 19:00Matthew Fulton: So if you send from a CRM to QBO 30 customers, that would count as 30 tasks.
- 19:06Matthew Fulton: So yes, what it would be there is because it's, in that scenario, And we'll, go a little bit deeper into it.
- 19:12Matthew Fulton: You're looking at 30 independent records, a record being a customer pushing it over.
- 19:17Matthew Fulton: So therefore it's going to complete 30 different tasks.
- 19:21Matthew Fulton: Mary asks another question, which will probably go a little bit deeper into when we.
- 19:27Matthew Fulton: Show some of the examples, but if she was asking, how does it work when you have multiple apps syncing, if all would update a client address, phone number, et cetera, which app takes precedence, or does the first one change things?
- 19:39Matthew Fulton: And then the next one changes it again, the, way I used to do something like this, one of those apps I used to do back in the days, I would take an update from my CRM, I would push it over to, Different CRMs, because different ones would collect different places.
- 19:55Matthew Fulton: But if you, can actually create a multi step action, where it acts almost as one task with lots of steps or actions within it.
- 20:05Matthew Fulton: And that's a way to not use up as many of your tasks at once, by daisy chaining them.
- 20:12Matthew Fulton: But if they're not daisy chained, then you could run into different updating issues where they're fighting over the stuff.
- 20:20Dan DeLong: Good fielding of questions here, Tomiwa, and in the poll and to share the results.
- 20:26Dan DeLong: By and large resoundingly 77 percent of you said yes, you're disappointed by some limited, limitation of integrations.
- 20:35Dan DeLong: Now, don't get too excited.
- 20:38Dan DeLong: There are plenty of limitations with Zapier as well, sorry, and we'll unpack some of those as, as, well.
- 20:44Dan DeLong: It's not going to be the magic pill, silver bullet for all things but it certainly could be a way to enhance depending on what it is that you're, looking to do.
- 20:59Dan DeLong: Spot, you want to take, these through about As we unpack, what is the overview of Zapier?
- 21:08Matthew Fulton: Yep.
- 21:08Matthew Fulton: So when we're talking about Zapier, it all comes down to triggers versus actions.
- 21:14Matthew Fulton: So after you connect your different applications together, what will happen is Zapier is going to watch for a predefined or defined activity to trigger the start of your own custom Zap.
- 21:27Matthew Fulton: Once a Zap has been triggered, it will follow a series of actions that were signed as a part of your workflow.
- 21:35Matthew Fulton: So when you organize them correctly, these apps can replace the need to manually transfer data from one program to another.
- 21:42Matthew Fulton: Trying to break it down in little nuggets to get you really to what the difference in the variance is there.
- 21:48Matthew Fulton: So a trigger leads to the action.
- 21:52Dan DeLong: Just like in that example of a a firearm, right?
- 21:57Dan DeLong: That's going to You know, if you want to have the action of firing a firearm, you got to pull the trigger.
- 22:04Dan DeLong: So you can only do it one at a time.
- 22:08Matthew Fulton: So then there's different types of triggers and they break it down into what they call pulling triggers and then instant triggers.
- 22:17Matthew Fulton: The pulling triggers, depending on the plan that you're on, it's basically going to do a periodic poll to see if there is information that needs to be.
- 22:27Matthew Fulton: If you need to activate an action, so your free plan is going to be every 15 minutes.
- 22:32Matthew Fulton: It's going to do a search professional is two minutes.
- 22:36Matthew Fulton: And team and enterprise is one minute, basically.
- 22:40Matthew Fulton: The higher up you go, the faster it would be.
- 22:42Matthew Fulton: What that really means is, the free plan, this is one of the few times where the free plan of a program, you're not the, as I say, if it's free, you are the product.
- 22:53Matthew Fulton: Zapier's done a phenomenal job, they're not using you as the product anymore.
- 22:56Matthew Fulton: It's a great gateway to get you into the product, to then get you to be willing to pay more, and do things even faster.
- 23:04Matthew Fulton: We'll go through when you're doing testing the time wise you can do a manual quick push to make sure you're testing Your zap and it's good to go Now instant triggers webhooks if you've heard of webhooks before but always wondered what they are Put a one in the comments for me, please what a webhook is with an application It's when they send out a predefined message on a url and Other applications listen and watch for that web, that, that message and they're going to hook it and pull it in and say, okay, we need this information.
- 23:40Matthew Fulton: So instead of having to always be pulling and looking for this stuff, it just listens for an RSS feed, if you will, an update from a web hook from something else and grabs it and then takes that as an action.
- 23:52Matthew Fulton: Does that make sense, Dan?
- 23:53Matthew Fulton: Do you have anything to add to that?
- 23:54Matthew Fulton: Yeah,
- 23:55Dan DeLong: When people would listen for the train on a railroad track, hopefully the point triggers the
- 24:02Matthew Fulton: penny.
- 24:02Matthew Fulton: You got it.
- 24:04Matthew Fulton: Okay.
- 24:06Dan DeLong: There's a train coming, but yeah, this is a this is a great.
- 24:11Dan DeLong: Setting the stage as far as when is that trigger going to get pulled it's going to depend, right?
- 24:18Dan DeLong: Again, another, it all depends, right?
- 24:21Dan DeLong: So what, what plan you're on and what app you're actually using, do they use the webhooks?
- 24:28Dan DeLong: But if they're using an application, if there's an API that allows for their webhooks, it doesn't matter what plan you're on.
- 24:36Dan DeLong: It's, constantly listening for something to happen.
- 24:43Dan DeLong: With anything else there's limitations.
- 24:48Matthew Fulton: Yeah.
- 24:48Matthew Fulton: So the limitation wise.
- 24:51Matthew Fulton: All of this stuff is, it's basically determined by the different applications API.
- 24:55Matthew Fulton: So in other words, if the application doesn't offer access computer language wise to do something Zapier can't make it happen at all.
- 25:04Matthew Fulton: So it's only able to do what's available there.
- 25:07Matthew Fulton: And it's only triggered by new data.
- 25:09Matthew Fulton: So what this means is if you're trying to create a zap and then you want to do your historical stuff, that's not what it's made for.
- 25:15Matthew Fulton: It's future, it's forward looking, unless you check out maybe like their Zapier transfer feature, that's something where you could try to pull historical stuff in, of course.
- 25:25Dan DeLong: Yeah.
- 25:26Dan DeLong: Or, one option is if you if, your zap is with a spreadsheet, right?
- 25:31Dan DeLong: If maybe you have a Google sheets, and, then you export whatever it is that you're doing, you have it in the exact same format as as a spreadsheet trigger, which one of that triggers could be a new row is created.
- 25:45Dan DeLong: And you then copy and paste it in bulk into that trigger, then it's going to go.
- 25:51Dan DeLong: Yeah.
- 25:52Dan DeLong: Line by line and then potentially, I wouldn't recommend that just because
- 25:57Matthew Fulton: there goes all your, you're going to use all your activities up real quick.
- 26:00Matthew Fulton: There goes all your
- 26:01Dan DeLong: tasks and then and then you're going to be paying for additional ones if you're not on plan.
- 26:09Dan DeLong: Then there are other applications that will probably do.
- 26:13Dan DeLong: Historical uploads and things like that, maybe a little better than, especially if we're talking QuickBooks here.
- 26:21Dan DeLong: Yeah, that that's a great point that it's only triggered by new data.
- 26:27Dan DeLong: So this is like the line in the sand, Hey, we're going to take care of this.
- 26:31Dan DeLong: Issue that we're having with, this integration gap.
- 26:36Dan DeLong: Let's move it forward from here and then figure out some other option for the historical stuff.
- 26:42Matthew Fulton: Now we should real quickly, before I talk about this other part, we should say again, when you're testing out, creating your difference apps, it will.
- 26:50Matthew Fulton: So in that specific scenario, try to pull the last three records of information over that you can use to try to push over the data over to a new platform.
- 27:01Matthew Fulton: Only does that during testing.
- 27:04Matthew Fulton: And that's important because you want to make sure things are working correct.
- 27:07Matthew Fulton: And it walks you step by step, shows you the information before you push it over, of course.
- 27:14Matthew Fulton: Now
- 27:16Dan DeLong: talk about these action.
- 27:18Dan DeLong: Steps.
- 27:19Matthew Fulton: Yeah, so there's this is an example as we go through some of these next sections guys There's this is where you really want to probably download these slides I'll put the link up again for everybody because there's a lot of words on here There's a lot of different types of steps that can be done within Zapier.
- 27:37Matthew Fulton: So we're talking about when you're trying to figure out what's going to first like trigger something.
- 27:44Matthew Fulton: And then if the action once it's triggered, what's the action it's going to take within the other app.
- 27:49Matthew Fulton: So there's like a search step as it says here, it's going to be.
- 27:52Matthew Fulton: Find your existing data.
- 27:53Matthew Fulton: So if you've got an existing customer, and you don't want to create a duplicate customer, it can search for it and then use that.
- 28:01Matthew Fulton: You can use filters to create conditional logic type scenarios.
- 28:06Matthew Fulton: Formatting, so you can make sure your time is formatted correct, maybe your dollars is it, currency versus percentage, different things of that nature.
- 28:16Matthew Fulton: Delay.
- 28:17Matthew Fulton: Delay is an important one because sometimes you need to, if you're doing a multi tiered step, you need to give time for something to update and finish before you go to the next piece.
- 28:29Matthew Fulton: And then paths, which is pretty cool.
- 28:31Matthew Fulton: And Dan's got a kind of an example of one of those towards the end to blow everybody's mind of conditional logic where you start to branch things off.
- 28:39Matthew Fulton: And you can make one crazy insane zap that does a lot of.
- 28:43Matthew Fulton: Moves things to a lot of different places, right?
- 28:45Dan DeLong: Yeah.
- 28:46Dan DeLong: So the these are things that you can add in between your actions to get more out of right, because maybe maybe a transaction comes over to, QuickBooks with, the, decimals in the wrong place, right?
- 29:03Dan DeLong: You can use this numbering fill format or to, make sure that's entered in the, right way.
- 29:13Matthew Fulton: And then so fields wise, there again, many different types of fields that could be used.
- 29:18Matthew Fulton: You've also got your date and time field.
- 29:22Matthew Fulton: You've got a dictionary field, which this is something I haven't used enough of and it's pretty powerful.
- 29:28Matthew Fulton: You, you can literally create.
- 29:29Matthew Fulton: Two columns where one value pops up something and you tell it instead to provide a different value.
- 29:36Matthew Fulton: So an example of that would be like for Stripe.
- 29:39Matthew Fulton: If you have a name of a certain type, a description, an invoice, it could look for that word and then switch around to something you really wanted to trigger inside of QuickBooks Online.
- 29:48Matthew Fulton: So we've got links back to all the help guide where this stuff is coming from as well for you.
- 29:56Matthew Fulton: Drop down menus.
- 29:57Matthew Fulton: That's a huge one, of course.
- 29:59Matthew Fulton: So this is where if you want to predefine select a selected list of different items, you've got your file field.
- 30:05Matthew Fulton: So this is great.
- 30:07Matthew Fulton: If you want, let's say you've got one app that creates a downloadable PDF for you, you could then take it and have that zap, grab that file and attach it and push it into maybe QuickBooks online by having it select the file field in the way you would map it out.
- 30:25Matthew Fulton: Then line item fields.
- 30:28Matthew Fulton: This is a little deceptive.
- 30:29Matthew Fulton: So line items are subsets of individual items One of the limitations I think we talked about a little bit later is in QuickBooks online, we were playing around before this, trying to see if they'd updated the ability, you can't create multiple line item invoices or sales receipts.
- 30:45Matthew Fulton: But in other type of programs, there's different line items of data.
- 30:49Matthew Fulton: You could use that in this scenario with them.
- 30:54Dan DeLong: And let's keep going.
- 30:55Matthew Fulton: I know they keep going.
- 30:56Matthew Fulton: So list fields, number, decimal.
- 30:58Matthew Fulton: We talked about those.
- 30:59Matthew Fulton: Password fields so if you need to push a password over, you could do that as well.
- 31:05Matthew Fulton: Again, download these slides and you'll be able to go through a lot of this without having to read all the words right away.
- 31:11Matthew Fulton: String text.
- 31:13Matthew Fulton: True false Boolean wise, and then custom modal fields.
- 31:18Matthew Fulton: This is where you can basically create your own mapping of different fields between different programs and different answers.
- 31:24Matthew Fulton: That's something you end up using quite a bit.
- 31:29Dan DeLong: If you're if you're, Brain's not full yet.
- 31:34Dan DeLong: There are other things in Zapier as well that can even augment this even further.
- 31:39Dan DeLong: Like they have their version of a spreadsheet where you can have Zap tables.
- 31:45Dan DeLong: Where you can store a lot of things in, a spreadsheet.
- 31:49Dan DeLong: So you don't have to necessarily, have Google sheets, for example to, be your source of truth for your spreadsheet and just keep it all in the Zapier, there's a chat bot option.
- 32:01Dan DeLong: I haven't really played around with that yet.
- 32:04Dan DeLong: I don't know.
- 32:04Dan DeLong: Have you?
- 32:05Dan DeLong: No, not yet.
- 32:06Dan DeLong: Any of the AI stuff as well.
- 32:09Matthew Fulton: And real quickly, Erickson, so what does, not have an icon mean?
- 32:13Matthew Fulton: A lot of these, they've created custom little icons so they're easier to spot and know what part of it you're using.
- 32:19Matthew Fulton: When it says it does not have an icon, that's what that means.
- 32:22Matthew Fulton: It doesn't show you like a little icon on the side.
- 32:24Matthew Fulton: It's not pronounced by that icon.
- 32:28Dan DeLong: All right, so let's now talk a little bit about how Zapier can help with QuickBooks Online.
- 32:33Dan DeLong: Here's the tie in to it, to QB, to the QB part of the PowerApp.
- 32:39Dan DeLong: So here's a listing of the QBO triggers, right?
- 32:43Dan DeLong: So anything that is an account, product, Customer project vendor.
- 32:50Dan DeLong: You can read these at your leisure, transactional information these can be triggered or triggers.
- 33:00Dan DeLong: And we'll, talk about that.
- 33:01Dan DeLong: One of the simpler ones, because there was a Facebook post on our, group that was, that could, I thought this would be, might be a good example of using how do I get alerted when my customer creates and modifies their chart of accounts, right?
- 33:20Dan DeLong: Maybe they're handling things in the bank feed and sometimes they create new accounts or QuickBooks creates the new account because they're trying to type in or find it and then they add an S or something like that to the category or the chart of accounts and then it creates a new.
- 33:36Dan DeLong: chart of accounts, which only makes work for you to go back and figure out how that got created, do it, merge it and whatnot.
- 33:44Dan DeLong: Maybe you want to get alerted when a, when an account is made or when a customer is made you can, trigger that from.
- 33:52Dan DeLong: QBO and correct me if I'm wrong, this is a, this is an active listening trigger, right?
- 33:59Dan DeLong: So it's, immediate.
- 34:01Dan DeLong: It's not going to you're not going to wait 15 minutes to alert you with that, right?
- 34:06Matthew Fulton: Yeah.
- 34:06Matthew Fulton: So QuickBooks online started using web hooks about four years ago, I think is when they really started to initiate them.
- 34:13Matthew Fulton: So they, you can use the web hook version of it.
- 34:15Matthew Fulton: You don't have to do anything.
- 34:16Matthew Fulton: Fancy to do it that way.
- 34:18Matthew Fulton: I do want to draw attention to the ones that say new and update, just in case there's a question on it, that means as a trigger, any of those, so customer bill, estimate, invoice, and credit memo, those are the only ones that if there's already something created, but they update that, would also trigger an action or
- 34:36Dan DeLong: potentially be your, trigger.
- 34:38Dan DeLong: Yeah.
- 34:39Dan DeLong: So here's all the things that you can do inside of QuickBooks.
- 34:44Dan DeLong: As far as an action, this is not.
- 34:47Dan DeLong: Trigger doesn't have to mean the action, this could be something else and then something that you want to, an action that you want to take inside of QuickBooks quite a few, right?
- 34:58Dan DeLong: There's a lot of things that you, can do here.
- 35:01Dan DeLong: I haven't played around with the API requests yet.
- 35:05Dan DeLong: Or the get attachments.
- 35:07Dan DeLong: I'm, I am intrigued by that, get attachments as well.
- 35:13Dan DeLong: Maybe you can, take that attachment and put it somewhere else.
- 35:17Dan DeLong: If they upload a receipt and maybe you have a, document storage that Is not QuickBooks, right?
- 35:25Matthew Fulton: Correct.
- 35:26Matthew Fulton: As, just again, I think everybody got this, but when we're talking about the trigger part, that is, you're using something in QuickBooks Online to trigger another action, which could be into a different application.
- 35:39Matthew Fulton: The actions are when some other program triggers something to happen, and your action will happen inside of QuickBooks Online.
- 35:48Matthew Fulton: Is the, difference there.
- 35:51Matthew Fulton: Exactly.
- 35:52Matthew Fulton: Limitations Dan?
- 35:53Matthew Fulton: Yeah.
- 35:53Dan DeLong: Yeah here's dirty Harry again, he's showing up with his man's got to know his limitations.
- 36:00Dan DeLong: Transactions, and we mentioned this earlier, transactions are created are created to either one item or category before you say, Hey why don't you use a bundle?
- 36:11Dan DeLong: Bundle items are not supported.
- 36:14Dan DeLong: We're very sad to, to find that has not been.
- 36:18Dan DeLong: included in their in their update yet.
- 36:21Dan DeLong: So if you wanted to create a bundle and then have multiple line items from that bundle sorry.
- 36:29Dan DeLong: It's not an option yet.
- 36:31Dan DeLong: So for bills, expenses all the transactions it's, really only going to allow you to do one line item on the, on that, on that transaction and for fields or for list items like customers and vendors and products and services, not all fields for lists are, going to be available.
- 36:54Dan DeLong: And then of course our.
- 36:56Dan DeLong: Custom fields, womp, when it comes to that's always on the list of things that it doesn't integrate with.
- 37:07Matthew Fulton: That's a good example of API limitations, right?
- 37:11Matthew Fulton: Because all the custom fields aren't necessarily available, you can't access all those different things.
- 37:16Matthew Fulton: Previously, tags you couldn't.
- 37:17Matthew Fulton: Now you definitely won't be able to, of course.
- 37:19Matthew Fulton: But so if you can't get to some of the, if you can't get to it through the API, if you ever have a question on that, you can reach out.
- 37:25Matthew Fulton: I can tell you.
- 37:27Matthew Fulton: You won't be able to do with any of these kind of programs.
- 37:30Matthew Fulton: And then I see your questions.
- 37:32Matthew Fulton: We'll get to those here just shortly.
- 37:35Dan DeLong: And then once you set this up, sometimes it will require some maintenance, right?
- 37:44Dan DeLong: The great thing about QuickBooks is it's constantly updated.
- 37:47Dan DeLong: The bad thing about QuickBooks is it's constantly updated, right?
- 37:52Dan DeLong: That could have an impact on on, a zap that you might have set up.
- 37:58Dan DeLong: In which case you may need to update your connection to the zap.
- 38:03Dan DeLong: It may break, an update to to, to QuickBooks may hinder the zaps inability ability to do something.
- 38:15Dan DeLong: And so if you've got this really long multi step zap created and any one of those gets updated, that could.
- 38:26Dan DeLong: Potentially cause a challenge in that, zap running, error free when there is an error you'll get an email alert, say, Hey, we can't run this.
- 38:39Dan DeLong: And, at, best the layman's terms of how they, can help you.
- 38:47Dan DeLong: I don't know if you've gotten some of those errors Matthew, you know what it is by looking at it.
- 38:55Dan DeLong: Okay.
- 38:57Dan DeLong: This is, a challenge, but it's, sometimes very developer focus of string each,
- 39:05Matthew Fulton: they do a really good job.
- 39:07Matthew Fulton: So the reason we're even able to show this image right now, Dan and I, before this, we got together and we were meeting and we're just.
- 39:13Matthew Fulton: Brainstorming different concepts of things we could try to show.
- 39:16Matthew Fulton: And we found as we were doing it on a lot of my older ones, I had to update my QuickBooks online connection.
- 39:22Matthew Fulton: And it's because the API had changed.
- 39:25Matthew Fulton: I hadn't been really using Zapier as much to push stuff in and out of QuickBooks online.
- 39:30Matthew Fulton: So I had to go in and update it and it does a good job on existing zaps of giving you like a warning.
- 39:36Matthew Fulton: And walking you through click this, to reupdate it.
- 39:39Matthew Fulton: So you're not going crazy, but the key takeaway from this is Zapier is amazing, but you do need to maintain it.
- 39:48Matthew Fulton: So you're, if you're really leaning heavily into this any platform like this, you need to put it on your counter to just do regular maintenance, make sure things are connected, correct.
- 39:58Matthew Fulton: It'll make your life a lot better by doing that for sure.
- 40:01Dan DeLong: One thing that I had noticed is that if you do get an error.
- 40:05Dan DeLong: And it stops the, zap from running.
- 40:09Dan DeLong: When you fix it, you can't rerun that zap on that that, new iteration, because it records just Just Google Sheets, there's always this version history, of, things that you're anytime that a change is made it assigns the version that was used to that ZAP run in that history.
- 40:33Dan DeLong: So even if you fix it, you can't rerun it unless You start the trigger again, right?
- 40:38Dan DeLong: So once whatever caused the zap to run in the first place, if you do it again, then it will take the new, version of your zap with your changes.
- 40:50Matthew Fulton: Which means if it broke for a month or two and you don't fix it, you don't get to go back two months and start to rerun those that, you know because again, no historical from the point you fix it, it will start to do new future stuff, but the historical toast, right?
- 41:08Dan DeLong: Yeah, And I, think I think when I was, reaching out to zap, zap your support.
- 41:15Dan DeLong: I think they were trying to investigate how to, do that.
- 41:19Dan DeLong: So I may be probably a month from now, this is already going to be outdated with that and you might be able to use a new version, but that's probably.
- 41:30Dan DeLong: Some in a future state.
- 41:33Dan DeLong: So let's talk about some examples.
- 41:35Dan DeLong: So we'll go with a simple one and then go into a little bit more immediate and then more advanced.
- 41:43Dan DeLong: A simple, simple zap would be a a trigger to a single action, right?
- 41:49Dan DeLong: So one action creates one result.
- 41:51Dan DeLong: This would be a good example used in the in the free plan that they have because you can't do anything more than just have one action, right?
- 42:01Dan DeLong: But you can't use premium apps with with the free one.
- 42:04Dan DeLong: So this will be something, where, you would be.
- 42:08Dan DeLong: The apps that do connect and we'll share some links of how do you, tell what apps do, in Zapier.
- 42:17Dan DeLong: Let me links for that on the, website as well.
- 42:21Dan DeLong: But here's an example of the pro advisor who wants to be alerted when a new account is created on the chart of accounts.
- 42:29Dan DeLong: And you have some other simple examples, Matthew.
- 42:32Dan DeLong: What so in this particular case of multi factor security tokens.
- 42:38Matthew Fulton: In my practice, we've been using Dialpad for our phone system for a very long time.
- 42:42Matthew Fulton: And we've always set up a separate phone line we call our security line.
- 42:47Matthew Fulton: And we needed a way to make sure that whoever's requesting the token could get that token including my global team In india because I don't want to answer those questions at two three o'clock in the morning So with dialpad we have the ability be that it because it would integrate to slack We could take and set up to where the text message went straight to slack But because we were more of a microsoft teams family I needed to get it from Slack over to Teams, and I was able to set up just a quick zap and be able to push it from Slack over to Microsoft Teams, sending the message right over to a certain channel, and only the person who requested it would know who needed it, basically.
- 43:29Dan DeLong: So Dial, as an example, Dialpad didn't have a direct integration with Teams.
- 43:35Dan DeLong: Correct.
- 43:36Dan DeLong: Yeah, so it, but it did have a, to slack, A direct to Slack.
- 43:40Dan DeLong: So you can send it to Slack, move it over to, teams, because that's what you Yeah.
- 43:44Dan DeLong: Were using.
- 43:44Dan DeLong: So this is great example of augmenting, limitations.
- 43:49Dan DeLong: So you don't have to, you didn't have to search for another application.
- 43:54Dan DeLong: Yep.
- 43:54Dan DeLong: To, do what Dialpad was doing, just so that you could have it in.
- 43:58Dan DeLong: Show up in teams for this.
- 44:02Matthew Fulton: And then another simple example was using for the longest time I'd use toggle for time tracking and it's more of just quick, easy reports.
- 44:12Matthew Fulton: And when I'm working on something, I can put it at beginning time, any time, tag it to a customer, that kind of stuff, because I'm not using it from my, actual.
- 44:19Matthew Fulton: Time tracking for payroll myself.
- 44:22Matthew Fulton: So what I did back in the day is I'd always have it set up that when I add a new customer and QuickBooks online, it would automatically create a new client for me and toggle.
- 44:30Matthew Fulton: So I didn't have to go and set that specifically up each time.
- 44:34Matthew Fulton: I could just go log in and choose the client and start putting my time in to create whatever reports I wanted.
- 44:41Dan DeLong: And this is this is, this is one of those things where, when you're bucketing.
- 44:49Dan DeLong: Your practice or anybody's business, right?
- 44:52Dan DeLong: There's the three P's of programs product processes and people, right?
- 44:59Dan DeLong: And if people are doing processes that can be easily done, this is a great.
- 45:07Dan DeLong: This is a great use case for something like that.
- 45:12Dan DeLong: Allowing you to automate what's, possible to automate and then humanize that relations that doesn't need, a human clicker to do that, right?
- 45:25Dan DeLong: Yeah,
- 45:26Matthew Fulton: it's really, right before you move on to this next piece, it's a good time to actually answer Lynette's as well.
- 45:32Matthew Fulton: Full disclosure, both of those examples I gave, those were examples where certain integrations didn't already exist.
- 45:39Matthew Fulton: Since creating those back in the day, Now Dialpad has integration to Teams, and that's going to be more, it's going to be a direct integration, more solid.
- 45:47Matthew Fulton: I don't have to manage it all the time.
- 45:49Matthew Fulton: And Toggle has one to QBO.
- 45:51Matthew Fulton: So this allowed me to plan and make it work to begin with.
- 45:55Matthew Fulton: But now I would move over to the direct integration most likely.
- 45:59Matthew Fulton: So I don't have to manage some of that stuff.
- 46:02Matthew Fulton: And Lynette's question was, so would Zapier be a good choice to integrate Salesforce?
- 46:07Matthew Fulton: Used as CRM for proposals invoicing center with QBO.
- 46:10Matthew Fulton: Lynette, I'm pretty certain there's, I thought there's already a direct integration to QBO.
- 46:14Matthew Fulton: I know there's third party apps that can do some of it, but you could do that.
- 46:18Matthew Fulton: I'd have to double check what's available through Salesforce.
- 46:21Matthew Fulton: Yes, you would be able to do that kind of a connection to push stuff in.
- 46:25Matthew Fulton: I've done that a long time ago in the past for the company.
- 46:27Dan DeLong: So we'll have a link for, how do you tell what triggers and what actions are available for each app?
- 46:35Dan DeLong: Zapier has a really nice page for, all of that to search that out.
- 46:41Dan DeLong: But you can find the app that you're looking at and, see what triggers are available for that app and what actions are available and then determine if this is even a good way to go.
- 46:52Dan DeLong: So here's, an example of an intermediate.
- 46:55Dan DeLong: So you have that single trigger, but you have multiple actions that are taken.
- 47:02Dan DeLong: That's global keeping.
- 47:03Dan DeLong: We use Kajabi and Kajabi is like American Express.
- 47:07Dan DeLong: It does things on its own.
- 47:10Dan DeLong: Maybe it doesn't play well with others, right?
- 47:12Dan DeLong: It wants to be a, it wants to be a QuickBooks of of the online learning, right?
- 47:18Dan DeLong: So all these things that they say they do, they want to have it all in one, place.
- 47:25Dan DeLong: But, trying to get Kajabi to integrate with QuickBooks?
- 47:30Dan DeLong: No, not gonna happen, right?
- 47:31Dan DeLong: So this is where, I can't Zapier came in to to, help me out.
- 47:38Dan DeLong: First thing was a new purchase would happen.
- 47:40Dan DeLong: Then I would add.
- 47:42Dan DeLong: A filter.
- 47:43Dan DeLong: So a filter then is, for a certain condition and you can use all sorts of, filtering, right?
- 47:50Dan DeLong: As to, so you don't want all, maybe you don't want all all sales or all actions to or all triggers to to create this, action so you can filter that out.
- 48:03Dan DeLong: I wanted a certain certain types of sales to to have this to run this app.
- 48:11Dan DeLong: Yeah.
- 48:12Dan DeLong: Just those two things the, sale and the filter doesn't cost me any tasks, right?
- 48:18Dan DeLong: So, there's no, no task usage when it's filtered, right?
- 48:21Dan DeLong: So putting those filters so best practice, put the filters up first so that you don't have a task usage.
- 48:30Dan DeLong: So what would happen if the filter was successful passed through then what it would do is it would find the customer, in my, QuickBooks.
- 48:40Dan DeLong: And then the nice part about These this app connection with Zapier is that there's really just a checkbox to say, if it's not found, create the customer.
- 48:51Dan DeLong: So rather than creating two additional steps it allows you to search for it first.
- 48:57Dan DeLong: And then if it's not found, it will find it.
- 49:01Dan DeLong: And this is where the double sided sword is here.
- 49:04Dan DeLong: There's only a few things that you can actually search on.
- 49:08Dan DeLong: And it's either going to be the display name.
- 49:10Dan DeLong: Or the display name, I think it's the display name and the email maybe those two things.
- 49:17Dan DeLong: So it's not necessarily, look for this phone number or look for this.
- 49:23Dan DeLong: This is where some of those limitations then come in, as long as you then you have your workflow laid out there.
- 49:32Dan DeLong: It will find the customer or create and create it if it's not found.
- 49:37Dan DeLong: And then after that, it will create a sales receipt in QuickBooks.
- 49:43Dan DeLong: Another thing that we use it for is also because it's an online company shipping addresses is very necessary for economic nexus.
- 49:54Dan DeLong: So we want to make sure that the address.
- 49:57Dan DeLong: Even though it's a billing address that is also copied over into the shipping address, which QuickBooks doesn't do that automatically.
- 50:04Dan DeLong: So you can have that Zapier do that, right?
- 50:08Dan DeLong: So it's make sure that your shipping address and your billing address are in alignment so that you the sales tax is going to be utilized properly.
- 50:16Dan DeLong: It's going to create that sales receipt.
- 50:18Dan DeLong: And then after that, it calculates some transaction expenses, right?
- 50:23Dan DeLong: So I'm, automatic I'm going to be charged by by Kajabi payments or Stripe or whatever the payment processor is.
- 50:31Dan DeLong: I know what that is, as long as that's consistent, based off of the sale, I can figure out what the expense would be and formatting of dates and those types of things.
- 50:42Dan DeLong: And then it creates.
- 50:44Dan DeLong: An expense for me as well.
- 50:46Dan DeLong: So one action of a sale being made on my website is then now either adding the customer, adding a sales receipt and creating an expense.
- 50:55Dan DeLong: So I've created basically three transactions in my QuickBooks where I wanted to go in, from, one action, and you can add more steps.
- 51:07Dan DeLong: There's no, I don't know if there's a limit of how many steps that you could actually have.
- 51:15Dan DeLong: Do you know Matt?
- 51:17Matthew Fulton: No, because I'm thinking of, I'm pretty sure it was Brian Clare did a 52 step zap one time.
- 51:24Matthew Fulton: And I don't even think that maxed it out, but obviously the larger you go, the more complex it's going to be, the more management that's involved to it.
- 51:32Matthew Fulton: So you can get pretty creative.
- 51:35Matthew Fulton: I think that's just where some of using the branches and such, you evolve into the advanced class for sure.
- 51:42Matthew Fulton: That's right.
- 51:44Matthew Fulton: Jan was asking, would there be a way to add an attachment to the sales transaction in QBO?
- 51:53Dan DeLong: This is, yeah we'd have to, we'd have to check it out to actually see if that gives us some, if we have time we might.
- 52:02Dan DeLong: Might go into that.
- 52:03Dan DeLong: All right.
- 52:04Dan DeLong: So here's an example of an advanced one where you have one trigger and then multiple actions with potential multiple outcomes, right?
- 52:12Dan DeLong: So this is where we talk about where Matt was talking about the, conditional logic stuff.
- 52:19Dan DeLong: Yeah.
- 52:20Dan DeLong: So this, is what.
- 52:22Dan DeLong: Zapier looks graphically in, as you're creating it, right?
- 52:27Dan DeLong: So you can see where it starts to branch out where there's one, two, two, seven, seven different potential outcomes, right?
- 52:35Dan DeLong: So it is going to result in the.
- 52:40Dan DeLong: Wherever this ends up, whatever path this, chooses, it can't choose multiple paths, right?
- 52:47Dan DeLong: That, that's one thing to, point out here is that, you, typically want to have your paths at the end of your of your zap based on that conditional logic, because then you can't.
- 53:01Dan DeLong: rerun it to have it go through the second one.
- 53:05Dan DeLong: But you can have multiple zaps with multiple paths.
- 53:11Dan DeLong: Your end result here could be trigger the next step and then we'll run through that again, that does break things up for you so that you don't have this huge monster zap that you have to man.
- 53:28Dan DeLong: But that's, one of the, one example of.
- 53:31Dan DeLong: In this case it was, filtering for a certain, field, or it was a big form on, a website that people were filtering or filling out.
- 53:42Dan DeLong: And then depending on which option they selected for certain drop downs on the, on that form, it would choose a different outcome.
- 53:54Dan DeLong: So
- 53:55Matthew Fulton: I think it goes without saying, but just to say it anyways, if you're doing complex setups like this, do it to a test company.
- 54:03Matthew Fulton: So this is where you, it's always good to have your own paid playground, because once you get it set up the way you want it you can then always turn around and change a company connects to, and this is another great piece here.
- 54:15Matthew Fulton: There's sometimes.
- 54:16Matthew Fulton: You can make zaps that fail.
- 54:17Matthew Fulton: You need to have better forward thinking of this.
- 54:20Matthew Fulton: An example being, I'm not a big fan of Twitter X or spending all much of time there, but I got this great idea Hey, I'm going to create this image.
- 54:27Matthew Fulton: And every time somebody would follow me, it would zap and post this image up on my Twitter feed.
- 54:34Matthew Fulton: If you don't go in and post anything else on there, it just became a wall of just this picture over and over and over and over again with nothing else.
- 54:42Matthew Fulton: That was a really bad example of a zap because I didn't think about.
- 54:47Matthew Fulton: Future wise, what it would look like, and was it really helping or not?
- 54:52Dan DeLong: All right.
- 54:52Dan DeLong: So let's let's launch the last poll question.
- 54:54Dan DeLong: Was this information useful?
- 54:56Dan DeLong: Did you learn something new or maybe you'd some help with with, Zapier?
- 55:01Dan DeLong: So let me go into, so here's our, here's, this is my Zapier.
- 55:08Dan DeLong: And this is a great place.
- 55:10Dan DeLong: So zapier.
- 55:11Dan DeLong: com slash apps is a great place to go to evaluate whether this is going to help you or not.
- 55:19Dan DeLong: So what was the one that went that people were asking about?
- 55:22Dan DeLong: QuickBooks
- 55:22Matthew Fulton: Online Attachments and Salesforce is the other one.
- 55:26Matthew Fulton: Salesforce.
- 55:26Dan DeLong: Wait the non profit one that,
- 55:29Matthew Fulton: Oh, give butter, I think,
- 55:30Dan DeLong: give butter.
- 55:31Dan DeLong: So those search for, yeah, there it is.
- 55:35Dan DeLong: Let's take a look at so you'd search for any app here and then you'd go down to here.
- 55:43Dan DeLong: Oh, this is one other thing that we didn't even talk about was templates, right?
- 55:47Dan DeLong: So there's already there's, tons of templates in there.
- 55:52Dan DeLong: So you can just.
- 55:55Dan DeLong: Find if a template in this state update subscribers and MailChimp for new give give butter transactions, you can just start with this template that's already there.
- 56:04Dan DeLong: And then you don't necessarily have to build it from scratch but down here,
- 56:09Matthew Fulton: right there, if they add new, give better transactions as payments and QuickBooks online.
- 56:14Dan DeLong: Yeah.
- 56:15Dan DeLong: So you can just.
- 56:17Dan DeLong: If they, if give butter doesn't automatically do it you can you can use this app to do that.
- 56:25Dan DeLong: Down at the bottom here is where you really want to go into investigating what, whether it does this or not.
- 56:32Dan DeLong: So you can filter for just the triggers, right?
- 56:35Dan DeLong: These are the things in give butter that will spawn a trigger, right?
- 56:41Dan DeLong: So a new campaign, a new transaction, a new ticket.
- 56:44Dan DeLong: And updated campaign.
- 56:46Dan DeLong: It'll tell you if this is instant or not.
- 56:49Dan DeLong: So now you know that they have probably a webhooks, here at the railroad track.
- 56:55Dan DeLong: And then you can see what the action is.
- 56:57Dan DeLong: This would be if it's some other trigger from another app, what could you do?
- 57:04Dan DeLong: Inside of get butter.
- 57:05Dan DeLong: Exactly.
- 57:06Dan DeLong: Create a contact.
- 57:09Dan DeLong: And then yeah, so I was just looking and then you just look at them same time, right?
- 57:13Dan DeLong: So that you can see it all in one place.
- 57:17Dan DeLong: So, you can create a contact.
- 57:20Dan DeLong: Notice that creating a contact is not a trigger, right?
- 57:26Dan DeLong: If you're that's like the end of the line.
- 57:29Matthew Fulton: Yeah,
- 57:29Dan DeLong: that's what's going to happen as far as an action is concerned.
- 57:33Dan DeLong: What was the other one sales
- 57:35Matthew Fulton: Salesforce, was one.
- 57:36Matthew Fulton: Yeah.
- 57:36Matthew Fulton: Let's
- 57:37Dan DeLong: take a look at the,
- 57:38Matthew Fulton: I've, so for years, I've loved going over to Zapier's site to take a look at the different apps that are coming out on the market and what they're available to do.
- 57:47Matthew Fulton: It's going to be.
- 57:49Matthew Fulton: I think it's this one.
- 57:51Matthew Fulton: Yeah.
- 57:53Matthew Fulton: See, newly new records talking about estimates and such.
- 57:57Dan DeLong: So let's just look at the triggers here.
- 57:58Dan DeLong: So it's case attachment, new fields, new lead, new record updating a record, updating a field on a record, new outbound message.
- 58:06Dan DeLong: So these are all the things that can be triggered, by Salesforce.
- 58:12Dan DeLong: And then here's all the actions that can be done.
- 58:15Dan DeLong: Into side of it.
- 58:16Dan DeLong: Quite a few,
- 58:18Matthew Fulton: right?
- 58:19Matthew Fulton: Salesforce.
- 58:20Dan DeLong: But there is there's a large number of third party apps that's all they do is build those integrations between, Salesforce and QuickBooks, for example.
- 58:33Dan DeLong: But if QuickBooks online is not your final destination or your integration between these two this can do all sorts of things elsewhere or back into Salesforce.
- 58:46Dan DeLong: It's another one that was, look at.
- 58:50Matthew Fulton: The only other question that was right off the bat was asking about trying to add attachments on in QuickBooks Online.
- 58:57Matthew Fulton: But it was get attachments, if I remember correctly, it wasn't add an attachment on.
- 59:01Matthew Fulton: QuickBooks.
- 59:02Matthew Fulton: It's not liking it today.
- 59:14Matthew Fulton: Okay.
- 59:15Dan DeLong: Where'd it go?
- 59:17Dan DeLong: And you can filter these too, right?
- 59:19Dan DeLong: So if you're just looking at the premium ones, there's QuickBooks Online here.
- 59:24Dan DeLong: There's a will, there's a workaround.
- 59:26Dan DeLong: Action.
- 59:27Dan DeLong: That was an action.
- 59:28Dan DeLong: That was an action, right?
- 59:29Dan DeLong: Yep.
- 59:30Dan DeLong: And then to get attached, there's a lot of them.
- 59:35Dan DeLong: Wait, where'd it go?
- 59:38Dan DeLong: Oh, F, there we go.
- 59:43Dan DeLong: Get attachments from a record.
- 59:45Matthew Fulton: So that's going to grab it.
- 59:46Matthew Fulton: That wouldn't be to add it though.
- 59:49Matthew Fulton: Now, if you go to create a sales receipt or update sales receipt, and maybe like two up, there you go.
- 59:58Matthew Fulton: And in here, Do,
- 1:00:05Dan DeLong: These are all, what we're looking at here is, these are all the things that can do on a sales receipt.
- 1:00:10Dan DeLong: Good point.
- 1:00:11Dan DeLong: What is not on here is.
- 1:00:14Dan DeLong: Make add an attachment, right?
- 1:00:16Dan DeLong: So this tells us that it would not allow us to attach a transaction inside of QuickBooks if the attachment is already in QuickBooks, you can get it.
- 1:00:29Dan DeLong: But you're not going to be able to do anything with it back in QuickBooks once you've got it.
- 1:00:33Matthew Fulton: Yeah.
- 1:00:36Matthew Fulton: Is that an attachment?
- 1:00:38Matthew Fulton: If let us know what you find out, you said you can play around with it, or if you get stuck on it, reach out.
- 1:00:44Matthew Fulton: Best thing you can do is if you get me excited with a very difficult challenge, you're going to get my attention big time.
- 1:00:49Matthew Fulton: Be like, Ooh, let me try to figure out how we can solve it.
- 1:00:51Matthew Fulton: So send me down a rabbit hole.
- 1:00:53Matthew Fulton: I love it.
- 1:00:53Matthew Fulton: So Dan, look at that.
- 1:00:55Matthew Fulton: We were pretty close to time this time.
- 1:00:57Dan DeLong: Yeah, we we crammed all that in into, one hour.
- 1:01:02Dan DeLong: We really appreciate you joining us here today.
- 1:01:05Dan DeLong: Next and that's what we spot and I are, looking to focus the QB power hour moving forward is.
- 1:01:18Dan DeLong: Really uncovering and unpacking the data getting into or out of QuickBooks, because that's really where the QuickBooks ecosystem, especially online is, that there is a shallow under the pool of the, all the things that you can do inside of QuickBooks but that doesn't mean there's not neighboring swimming pools that we can, steal some water from, right?
- 1:01:45Dan DeLong: And then it all boils down to how that data is, moved.
- 1:01:50Dan DeLong: So we're going to start looking into, and, unpacking some of these apps that do integrate into, QuickBooks and what they're, what they do well, what they maybe need some help with and so we wanted to start with this as more of a way of, Hey, there's another choice, even you don't have to abandon your app if it doesn't, there is there's a way to augment that closing thoughts.
- 1:02:21Matthew Fulton: Yeah.
- 1:02:21Matthew Fulton: If you guys have other topics that you are interested to learn more about, reach out to either one of us.
- 1:02:27Matthew Fulton: We would love to hear your suggestions so we can, our goal is to help however we can to the community.
- 1:02:33Matthew Fulton: So thank you for taking the time to be a part of this and joining us every other Tuesday and, appreciate it.
- 1:02:40Dan DeLong: All right.
- 1:02:40Dan DeLong: Y'all have a great Mardi Gras.
- 1:02:43Dan DeLong: Enjoy your Ash Wednesday tomorrow, but that Tuesday today, have a great day, everyone.
- 1:02:50Dan DeLong: We'll see you next time on the QB power hour.