Create Seamless Airtable Invoices for Communications & Media

Airtable invoice for Communications & Media

all right testing one two three let me know in the chat if you can hear me we're gonna be starting in about two minutes just now's a good time to get a glass of water whatever it is need to do to be comfortable just gonna get to start in about two minutes testing one two three all right we're good to go i would appreciate someone just letting me know that y'all can see the chat i'm just doing last little checks here before we kick this off in just about a moment here [Music] all right let me know in the chat if you're on periscope would love to get a quick thumbs up that the chat is working that you can hear me you're gonna have to x out if you're full screen to chat i think on youtube and we're gonna kick this off in about 10 seconds jokes doing some last checks here seems like everyone can hear me just fine hey connor how are you good to see you all right let's chat in just a moment and i'm going to kick this off what all right welcome connor uh welcome everybody really excited to uh i think the 17th live stream hey dan good to see you uh uh really yeah really excited to kick you off for folks who aren't familiar with this my name is aaron cormblett this is automate all the things where i kind of just show off things that i've learned in air table uh you know for you at 6 00 pm yeah that intro is pretty cool right connor pretty excited about as well okay so today um you know we're going to be talking about invoicing from air table uh just going to shred itself huge thing for max max joel's who who um kind of is the the catalyzer if you will of this workflow and really kind of helping me work through stripe uh and you know being able to invoice directly from airtable using a mix of button field web hooks and stripe api so i will kind of start this off with more simple uh payment options which you can't actually pay you have to get manual payment but you know just kind of talking through the base some manual options and then we're going to get into web hooks which i'm sure is the exciting part so our agenda for today just quick base structure going to keep it very very simple um then manual payment methods mainly going to focus on page designer maybe we'll do email automations let me know in the chat if you are here for the zap web hooks or if you're also interested in the kind of simple ways that you can let folks know that they owe you money without allowing them to pay and then kind of talking about uh payment with stripe using web hooks okay so let me know in the chat with what you're here for and i will try to make it as useful for you as i can while still you know obviously having fun myself so note that there will be errors at the end still quite new to the straight ppi but hopefully we'll all learn something by the end okay so just starting off with base structure we have a very simple base here uh clients which is just name email and then we tie that to invoices you can imagine having more information here i frankly just wanted something very simple name email but you can have address whatever whatever you have for your client a set of projects very very simple i have three projects done in progress backlog some sense of how many hours i worked primarily so i can get a total cost for the project which is just simply cost per hour times hours worked and then i tied that back right to the client so very simple stuff you can imagine having a task table where you roll up all of the hours worked you know i'm gonna try to keep it as simple as possible because the odds of me making a mistake on stream increase proportionally to how complex the bases so at least have control of one of those variables which is how simple the base is but this should feel quite similar to whatever it is that you're trying to invoice and then we have the most important here kind of uh are invoicing so invoices are kind of i see it as a junction table between client and project and then for that what we want to send is a total cost right so the reason i have a specific invoice table and don't invoice from the project table is just so that i can potentially merge multiple projects in one client and then roll up the cost of all of those projects frankly not necessary as well but you know for scalability thought that that was useful and really our goal at the end is just to create the send invoice button that will send an invoice via stripe to that client's email letting them know that this project is payable cool so let me know in the chat you know give me a thumbs up if the base structure makes sense uh that was a quick overview of the base if you're just joining like rohan should be relatively simple but let me know in the chat if there are any questions and i'm just going to quickly talk about kind of native options to show folks uh invoices within airtable no payment option the first is page designer now i am absolutely terrible at designing things in page designer so i apologize in advance for what this looks like but page designer essentially takes any information from a record and puts it onto a page so you can do things like slides invoices sales review pipelines meeting notes in our case what we want is we want to take this information this invoice write the cost what client the project information and put it onto a page to create an invoice you know what is an invoice but a page with some information on it right so this is my absolutely terrible invoice where what i've taken if i look at the layout is i take the project information and this is why i wanted potentially multiple projects you can imagine you know one two three projects and this is the invoice that i'm sending out i have some static information which is you know who the invoice is from and this is dynamic in that we're taking the information from the client and putting it onto a page now i only have one invoice so we can only see one example but if i had multiple right so let's actually add an invoice here let's say the client is myself again and we're going to take project two that's four thousand dollars and if i go into our page designer here i now have both of those invoices uh what i can do as well uh let's actually edit let's let's make this another client which is jeff smith right i can kind of print this download i'm going to download this as a pdf let's save that yes there we go and let's go to the second record and we can also save that and then add those as attachments in our record and potentially use airtable automations to send an email with a view that that person could kind of see that linked that uh invoice right so let's print that out so now i'm printing the second invoice saving that as a pdf like that and then just uploading those to the respective so let's call this invoice attachment save that if i remember correctly the first one is this one like that and second one is like that so now i have the respective invoice for each project for each invoice and then what i can do is i can potentially create let's say errands invoices where i'm creating a view that is specific to a client and then potentially send out you know reminders to that client using airtable automations right so let's say filter where um client contains aaron right and that is uh those invoices that relate to this specific client so we can create a share view right and let's share kind of create let's say this is invoice view it's going to be a url save so now if anyone clicks on you know they can see that specific invoice they can look at it so then you could use this view in an email to that specific client saying hey here are your open invoices right so let's actually make this a little nicer so filtering hiding some stuff here cost that's not important look at the invoice date that all seems important so now i have this view um and then whenever i'm emailing i can use airtable automations to kind of send this this client this invoice and say hey here are all of your outstanding invoices um relatively simple so we talked about page designer i'm not going to go through the actual email automation unless someone in the chat is kind of interested in seeing that but essentially what you do is you kind of create a view that is send email with a check and then you can go and find that client get the invoice view and add it to the email relatively simple or you can even hard code it if you don't have that many clients and send those emails those clients their kind of view where they can download their page designer does that make sense hopefully a page designer and the email automation directly in airtable automations does that make sense such a weird question right because you don't really know if that makes sense because i guess the question is would you feel comfortable using page designer to send an email using email automations with that quick overview that i've just told you i will assume that the answer is yes all right and now for our main event where we're going to talk about stripe right so how do we actually instead of sending a pdf right instead of sending a pdf that says you know that has no payment button what we want is to use stripe to send an invoice that says hey here's how much you owe us and you know here's a button where you can um click and pay so rohan's here dan's here appreciate that excited um so there's a few things we have to uh kind of do here to be able to do this so um i'm going to talk about a few things so first we need to talk about web hooks and web hooks are essentially a way of sending information from one service to another and in error table primarily that's done through the button field so the button field is actually just a url and that url will contain some information namely in this case where we're going to say hey you know send to zapier the new client information so you can create a new client in stripe so we're going to actually start by the end we're going to talk about what are the items you need to create an invoice in zapier in stripe and then we're going to go ahead and kind of build out those pieces to create an invoice so i'm gonna kind of uh um talk about the stripe api so the first thing we need to check out is create a customer in stripe okay so air t you know kind of how stripe works you first need to create a new customer right and all you need to specify for that customer is their email and that will be sufficient and then from there you can add invoice items to an invoice and then associate an invoice to a customer so you could send that out now this is all information we have in our base so we kind of just have to how do we create a customer right and so this is kind of all of the fields that you can add really all we're going to add is email and just going to say here's the email of that customer so we need to ping the customer api right to create a new customer and i think if you're using web hooks you can do that i think in zapier if i'm not mistaken let me look there is a create create customer in stripe right so we're actually going to use the create customer in stripe action in zapier to create our customer in stripe and all we need to do is actually trigger that uh this zap using a hook so there's a way to do it via the api right that's what i just showed you stress customers you specify the email but zap here has a specific kind of action to do it for us so what we're going to go ahead and do is coming back here we're going to create a zap that is create customer in strip so to start this zap what we need is like a way of saying this is a new customer so we're gonna add a button that is add customer to strip it's going to be a button field it's going to be add customer and then we need to specify a url so for now it's just going to be empty save that let's make this an actual button like that and this is going to start our zap right so what we want to happen is when we click this button it starts the zap that says okay take this customer in this row and then add it to stripe so let's go ahead and do that so to be able to do that to catch to trigger a zap at the click of a button we're going to use a web hook so web hook will both start the zap and tell us who the customer is so let's go ahead and have a web hook we're gonna be working a lot with web hooks today let me know in the chat if like the concept of a web hook makes sense just the way of communicating between two services and communicating some information in this case we're gonna you know communicate that person's email and the fact that we want to trigger that zap so we want to catch a hook uh so this is our hook this is the url right so i'm just copying that and what i want sent is the email and the record id so let's add record id and this is going to kind of be our key uh i already have a record id because i was testing this to make sure that this works let's do it like this there you go so it's gonna be a formula field we want the record id save that and what i want to pass in this web hook is both the email and the record id so let's take the hook that's the url that uh you know that url that um zapier gave us uh colleen happy happy to know that this helps web hooks are a little bit of a slippery and frankly i'm still learning a lot about all of this so there might be moments where you know it's not quite there i'm gonna move the chat out of the way it feels like it's a little bit too big here so let me know that should be better there cool okay and now we as parameters we can pass information so parameters you put a little question mark and the first one is going to be email equal and then we want to close and we want to take information from our record so we're going to add a variable to do that or a field as i should say in error table is going to be email and and then the structure is you do another ampersand to say we're sending some other piece of information so zapier when it receives this hook it's going to go ahead and parse go again and find this email and say okay that's the email take all of this information until that ampersand and then take another one and the other is we want to pass record id equal and we're gonna pull in the record id like that let's save that and we should get a sense of the hook right so if i click on this it's going to go to a url that url is going to send that information to zapier so if all worked if i click here okay it says success that means it's sent let's come here continue test trigger okay so it's received it says okay i've received the email you know across it and i have the record id so now let's go ahead and use the zapier zapier zapier whatever you want to call it action which is you know create a stripe customer so stripe create customer continue stripe account there we go and then i'm going to take that email address from step one that's really the only thing i want to specify at this point there's a lot more you could do you know address but all of this should kind of come from air table or should you should be able to find it in your air table continue so let's test and review i might actually have this customer okay it seems to have worked next let's actually go back to uh air table and update that customer with the stripe id right so this is going to be important this is actually a good tip for generally whenever you have kind of an id make sure you're sending ids whenever possible so if you have an a record id from air table and you have a stripe id make sure you have your stripe id in air table so that when you are pinging the stripe api from an error table you can take that stripe customer id and just create makes it easier to send you know information from one system to another so i'm actually going to go ahead and update it's going to be with airtable i'm going to update a record uh update record and i have the record id from step one so just some configuration here base is live stream 16 17 17 we've done 17 live streams i think colleen's been to everyone so thank you colleen so table clients record we can actually insert a custom value custom value taking from that hook because we know the record id like that oops just one one is enough there we go and what we want to update is the stripe id i've called it stripe id final because i already had one i tested so this is going to be our stripe id but if not you can create one i'm going to go to step two get our stripe id uh um continue and now we should have this new stripe id if i unhide that field final like that so this is hul fujwu which comes from step two so this will be important when we're trying to create a invoice for that specific customer because this is one of the parameters that you need to say who is this invoice for when you do that um okay so that makes sense let's just make sure let's turn this on and let's go into do not want to share my zap let's go into stripe and then let's go into customers you notice that i have a few customers that are myself this is the one we just created uh and now that we have our kind of uh working yeah jeff smith which is a new customer so let's actually go ahead we don't have a stripe id because we haven't added that customer so let me let me hide this so give us a little more space here there we go let's go ahead and add that customer so what two things should happen uh one is that we should have a new customer in stripe and second we should have the stripe id updated here okay it seems to work so we have the stripe id if i come to customers refresh this i now have jeff smith as a customer woo all right i don't know i don't know if you it's kind of weird but i don't know if you're excited because i'm definitely excited that it worked and now we have kind of that first step ian being able to know which customer we're going to invoice so our next step is actually okay well now that we have that customer id in stripe let's go ahead and you know specify and create an invoice for that specific customer directly from our base right so invoices feels like a natural place right because we have the cost we have the client and now we can even pull in that stripe id so let's pull in stripe id we're gonna use a lookup field we're going to pull in from client stripe id yes same round i get also very excited partially because it's it's cool to see it work and maybe partially because i don't always have confidence that i've set it up properly so i get relieved you know when there's people watching it's always more stressful um okay so now we want to generate an invoice and there were a few folks asking about subscription you can definitely configure this to do it as a subscription as well really up to you how do you do it so um let's come back to the uh send invoice to customer this is our documentation here right so there are kind of three steps here so it says okay create the invoice items and here we have to specify a customer specify a price and then use that invoice item the output of that add it to an invoice right and then also tie to customer and then send that off so there's kind of three calls that you need to make we have kind of all of this information we're going to assume that every invoice has one invoice item but you can split those off if you want but we're going to assume that it's all the same ones so first thing we're going to create invoice items we're going to create an invoice and then we're going to send that invoice off in three kind of consecutive api calls from zapier right so what kind of take away from this is really just you create invoice items if you had 10 projects that you want to invoice three of them you can just click those add them as invoice items invoice and then send off to that customer so really that's kind of our goal and we're all going to trigger this from airtable okay so this should start kind of feeling familiar so first thing we need to say that we're sending off the invoice so we're going to create a button field that's tied to a web hook that then does those three api calls so send invoice this is going to be live because i've already tested this send invoice it's going to be another button field huge fan of the button field really i gotta say button field is great send invoice let's give it a green and then let's just specify nothing save that so that we have our save invoice and now we need to go ahead and create our zap so a news app it's going to be send invoice and we're starting with a web hook as we did before catch hook continue it's going to give us a url this should start feeling familiar and so what we want um is the hook obviously hi vincent good to see you welcome um and we want to pass the record id which will allow us to kind of retrieve information you know additional information a little easier uh or you can just pass it in the the hook as well right but what we're going to do is just pass record id that way we can retrieve information so let's add record id record id like that that's just a field i already had in this one as well and what we want is the stripe id as well that will allow us to call stripe so and stripe id equal ampersand no not ampersand here is where i want an ampersand and stripe id let's save that and you know what just to save us a step let's just send the cost as well that way we we can kind of cost is really the only variable we need so cost is equal to i'm like in a risky place here where i have a lot of ampersands and uh there we go and i want cost save that there was a problem okay let's do this again really risky doing this live so does this work okay that seems to work so our record id is not at fault here and let's just okay let's just do what i wanted to do initially ampersand and we want uh stripe id ampersand like that no and stripe equal close the parentheses and stripe id there's like a 50 chance this doesn't work okay good okay now let's make sure that this works correctly we send the invoice let's conceive the web hook let's see what's here let's test this okay so it's got the stripe id and it's got the record so coming back here okay so our first uh um uh we got it we got i'll send you the base you can just look at the base don't worry about this so the first thing is a price right and then we have a customer okay so let's kind of do our web hook here with customer and price and that's going to be creating invoice items so continue uh let's actually first kind of go and get the cost because the cost is not in our uh um in that web hook because i am you know not very good at writing formulas we just want to find a record continue we have the record id that's what the whole point of this was appreciate all of your patience so base live stream 17 table is in our invoices and search by fields we want a custom field now we have um let me check here search by field record id right right search by field we can just search by that record id that we pulled in there we go and the value is from step one continue and now we have all of the information around that record simplifying the need to kind of you know send everything in the web hook but really both work it's not a problem okay now we have both the customer id we have the amount so now we want to send an api call if we look that this is a post call right so we want to send a post this is just saying okay when when you hit this action do this api call the url is this right here just copy pasting that form our data is going to be the customer so we'll just copy paste this customer and copy pasting that and this is coming from the hook right so this is coming from the stripe id but frankly you could also get it from the record i didn't need to pass it through the hook but you know that worked in the formula so stripe id this is telling us you know build this customer um and then i had practice using the price but because price has kind of breaks down into other things when i was testing this it's actually easy to use amount and just generally what i'm showing you here is not going to be kind of one-to-one mapping to your use case because you've got tax you've got you know a bunch of other things that you need to include do kind of encourage you to check out the actual api to understand every single element that you can send out and then just play around within zapier to kind of configure the different data um that you need to send i'm just gonna send the minimum amount to be able to create this invoice so amount is just like that's the total amount i don't need to break down vat or anything like that so it makes it easier for me i want to show options and so i want cost here there should be a little cost there we go cost like that and then currency is in cad so these are the minimal amount of elements i need to specify to be able to create this invoice item yours will be different but our goal here today is just to show you how it works a tested review so this oh i forgot the authentication very important okay let's add so here i'm just gonna copy paste my authentication here so authorization authorization and then let's go and get my api key this is a test api key so i'm not too worried about it continue fingers crossed did not get my authentication i forgot to put the word bearer in front you don't know how much time i spent to figure that out yesterday it's kind of embarrassing to do that same mistake there we go and then it returns a invoice item where it's returning that information so now we need to use this invoice item that's associated uh um to uh create the invoice so the reason i do the the web hook is really i don't think there's a way to create an invoice you can create subscriptions with the zap and this kind of gives you more configurability you know specific invoice items and i think kind of learning these web hooks are fun so let me know if there is a way to kind of create one-off invoices using zapier i always assume that web hooks was the way to do it unless you are creating a subscription which i think can be done within zapier if i'm not mistaken but i may be wrong odds are i might be wrong cool okay so next coming coming back here the next step here is to you know create an invoice based off of that so we have an invoice item another kind of web hook here and so another post call very similar structure to before url like that and after we do this step we should have our invoice in zapier let me i'm actually curious is there a uh you know stripe create one-off invoice uh actually i can check that later that would really make this webinar or this live stream you know stupider i guess but still useful i hope i hope um okay so url is invoices our data is going to be um let's see what if there were any other i'd flagged as potential right so customer that's the first one so who are we wanting to invoice you know and get all those invoices items that's from step one stripe id then a few that i found useful is auto advance so this is just kind of going through the steps again going to be different on your end these were just the minimal amount of settings i needed to provide to be able to collection so this collection method is going to be send invoice and finally days until collection is 10. so these are just the minimal amount of things i needed to specify uh um to be able to send this invoice so vincent mentions quickbooks has it though uh um that's great i mean the web hooks make it possible and really the specification level that you can do is quite you know interesting if you go into uh invoice items you can really uh expand a lot right so here we have um subscription options so really everything that is in stripe because of web hooks and zapier you know opens it up to you uh so very very useful i've never used quickbooks cool okay days and so we've specified this is just me testing you might need more information or less and then we need to authenticate as one does just copy paste that authorization bearer okay so if this works properly we should at this point have days until due and what's great about the stripe api is that if you make a mistake it'll try to guess what your mistake is and it'll give you the error code so this is great for people like me who make mistakes especially on a live stream very useful so it's not days until collections days until due thank you stripe for saving me so so many heartaches and stress okay so theoretically we should now have an invoice in stripe all right so let's go into our stripe where are we here customers and then if we go into invoices we now have this invoice that we've just created now you'll notice a few things here oh let me just confirm my password here okay nice so you notice that two things here the first is the invoice is for 25 instead of 2500 that's because it accepts you know cents instead of dollars so you actually have to multiply by 100 you can do that on your time in zapier but we need to manually send the invoice right and that's because you know the way invoices work is you can review them and then click send but it's associated to the right customer it theoretically has the right amount tax and coupon and memo and all of this information can be configured and it's just a note i won't have time to go into this but if you have valid payment so if someone's giving you a credit card for one of your invoices you can actually automatically charge that in the future for invoices so if max is ever kind enough to show us the whole setup i know he was able to do it where you save the kind of payment information and in the future it's auto paid uh you know directly from the api so things to keep in mind but really we have our invoice and now the only goal is to can we automatically send it without reviewing it that's also possible so this this this is pretty cool so um let's actually just do that last step of auto sending the uh invoice with the api as well so here we have our kind of send right so this is the send api and you notice here in the api itself it specifies which invoice item right so this is coming from step two in the url itself we have to add the invoice to it so that we can send it off automatically so let's go ahead and do that so next step another post call it's gonna be a web hook post oh hey max the king himself there he is uh if you have questions max is the the inspiration for today's stream um right so we want to i'm copy pasting here oops seems like i did not copy paste that so let me copy paste this and then here what we want is you know that invoice id from step four so whenever you send a post it actually sends you a response with some information in this case it's sending us the id so we want to put that into the url and now we're telling it to send this specific invoice right when we do that call and really i think if i'm not mistaken there's nothing to specify in this call nope just authorization is the only thing to do so just hitting this end point is saying okay send that invoice don't worry about me sending it manually so continue test and review parameter unknown what happened there oh i put a slash i think i put too many slashes okay id send it's a form this should be raw authorization seems to be good continue okay so it was just i didn't send any parameters so i needed to do a raw payload type a lot of things that you learn when trying to do this on a monday evening and thank you max for being really nice to debug with me so if we go back to that invoice if everything worked if i come back here i refresh uh you'll notice that it's now open so open means that the client has received that invoice now note that when you're using test data in stripe it's not actually going to send out that invoice to the email you've specified so this is all we have to trust that this would be sent out once in production but open means that it's no longer a draft and it's been sent to the customer so now we have that kind of really cool um step where we can kind of just put all of this together right so let's say i come back here i have a new client his name is max joel's max gmail.com and i don't need an invoice i don't need any of that let's add that customer so this is our first let's actually oh no i want to turn this on i always forget to do this there we go turning it on no i don't want to share my zap i am sure i am technically sharing my zap with you all uh uh so let me turn this off this is the one i was doing from before okay so now we have both of our web hooks so what happens is that when i add this customer if all goes well it opens up this page this is just saying okay i've received the web hook because it passes it through the url and now we have that stripe id so if i go into my stripe dashboard here let's just go back to stripe to our dashboard and then customers i should have max right okay that was step one so we've created a new customer a little tip here if in the future you don't want to create new customers you can actually change the formula to not make the button clickable if you have a stripe id which tells you that you have that customer and stripe pro tip doesn't matter okay next let's create a project let's go back into all invoices this is going to be max and max is project 2 let me delete this one so max is gonna be charged uh uh i mean theoretically forty dollars but uh uh let's just you actually i don't wanna i don't wanna mess with that i don't wanna multiply let's keep it at 40 you can change it to times 100 just food for thought and then let's send that invoice so this should do two things you should create an invoice item create an invoice and send it off if all goes well let's go back into stripe and then in invoices that did not work let's go into stripe see what happened and here task history that's weird let's check that again mike doing the right web hook here let's do that again status success oh did i turn on the wrong zap hmm that's weird let's try this one more time let's make sure we have the right hook load more we couldn't get any others so let's try that one more time oh i i the wrong send invoice that explains it there we go i created the press the wrong button this one is the live one okay let's do that one more time this is live let's turn the other one off let's go back turn this one off it's supposed to be my crowning moment there we go now this one's on we're using the right button let's hide that send invoice the wrong one there we go send invoice catch that hook and if we refresh here if all went well there we go we have our new kind of oh i pressed on the wrong one i didn't price on max's there we go let's do this one more time invoices we refresh that max has a 40 open invoice um so two things happen there one i was pressing the wrong button which was a dis this activated zap from monday when i was testing this but now it works and we've sent max in invoice for the right amount so a few things when you're doing this multiply by 100 you can do that in zapier or you can do that in airtable and so colleen to answer your question if is the right way so if there is a stripe id don't uh you know just make the the button blank otherwise you know create the right url um and zap history said nothing because i pressed the wrong button it was supposed to be a crescendo but i guess we we got to the end right so uh um hopefully this was useful a little longer than my usual streams but i felt like wanted to show you every single step now a few things you can do here as well is potentially a map the invoice status right open to your uh to your um invoices right so rohan asked a great question you know does the bun stop it click change no the button is always clickable unless you put an if statement in it to make it unclickable when something happens for instance you know you could after uh having sent the invoice update the record you know status that says you know invoice sent and then an if statement here in the formula that says you know if open don't you know just make the button url empty and that way you could um just not send the same invoice twice so that's something i do recommend just like we sent back the stripe id i do recommend you update existing record with um how to um with the fact that it's been sent so you don't need to make that button clickable now a few things to make this easier um i will happy to share out this base so i will make a read-only link under the video with this base um i'm trying to make zaps public so i can add them at the bottom of videos as well so you can reuse the skeleton of them um and would love love to see what um it is that you build with this so i know that this is just a starting point you all are much smarter and more innovative than i am so hopefully you'll take this and build subscriptions or build more complex invoicing and if you hit a hurdle or build something really cool i would love to see it there you go happy to stay here for any questions as we wrap up here and thank you thank you for coming this girl is great great to see folks i hope you enjoyed this hope this was valuable um and yeah thanks for coming awesome really appreciate that rohan glad this gave you some ideas all right thanks everyone for joining uh you can you know you know where to find me if you have any questions after this was a joy and pleasure of doing this and i think i'll be back next week probably the following couple weeks and then i'll take a couple weeks off um so rohan yeah the question is can we create invoices on air table and have them auto added to a field the answer is no uh the little attachment coming from blocks uh uh um uh um you know you have to manually download it and add it to the attachment so that's why it was kind of like a first step if you're not sending hundreds of invoices that's totally fine uh max you'll be happy to know that uh stripe on testing does not send out an email so max didn't receive anything uh um but if you do want to tip anyone you know max joel's is the person you should be tipping uh for this tutorial uh um he was the one who um inspired and frankly you know troubleshot if you will a lot of what we did today so really appreciate that max thanks so much cool all right i'll see you next week uh all the best i'm gonna go grab some dinner bye everyone have a good one