Create Effortless Invoices with the Google Sheets Invoice Generator for Logistics

Google sheets invoice generator for Logistics

in this video I will show you how you can automatically create invoices using Google dogs Google forms and Google Sheets application and the best part of using these application is your invoice will be created for free because all these applications are absolutely free so firstly you will have to create an invoice template in Google dogs where you will have to add these variables yes the values packed with the pair of curly braces are called as variables and whatever the details you want to keep on changing automatically you can add those values in the form of variable and the idea here is whenever the new form submission is received those form submission data will replace these variables automatically with the submission data and in this way a new invoice will be generated automatically based on the form submission data okay so assume that I'm running some Bakery and to collect the orders I have created this form that is order your cake here I have mentioned all the pricing ing to the flavors and here I'm also collecting the basic details like the name email phone number the cake weight the cake flavor what are you celebrating for and what will be the message on the cake okay now how I am going to automate this invoice creation process using this Google forms and Google dogs application so basically I'm going to build a connection build an integration in these three applications so that whenever the form submission is there and invoice will be generated automatically for that I will use another software called as P connect which is an amazing integration and automation software I'm an existing user of public connect so I'm already logged in here you can create your free account in public connect in just a two minutes from this sign up free button and in the free account you will also get free task to test these kind of amazing automation now once you will log in and reach out to the dashboard of family connect click on this blue button that is create workflow and then provide a random name to your workflow to your automation so I have directly pasted the name as generate invoice with Google dogs Google Sheets and Google forms now it will ask you to select the folder in which you want to create your automation workflow so I'll go with this main workflow folder now clicking on Create and after that you will find two boxes so these boxes are called as trigger and action and here the trigger means when this happens an action means do this so whenever some something happen in your first application then automatically do this in your next application so in this way you need to always choose your applications in the trigger and the action window in which you are building an automation okay so ing to our use case I want that whenever any new person submit my Google forms then the details would be captured via P connect instantly so that is why I'm selecting the same application here why it is not searching I will have to search for the same once again all right here we have the same application that is Google form so whenever the form submission is received an invoice should be generated automatically using Google Docs application so yes I'm searching for the same that is Google Docs okay so in this way you can connect different applications by selecting those application in the trigger and the action window okay and now I am going to connect these two applications one by one with the p connect so let's first connect Google forms with the PA connect so I cannot connect Google forms with P connect directly I will have to use the spreadsheet which is associated with the same form okay so clicking on this responses section and clicking on this spreadsheet and in this way a spreadsheet will be opened here okay so here you can notice I have already generated one dummy response so how about I remove this existing data and I hope everything is clear to you let me maximize the zoom percentage okay coming back here selecting the trigger event that is new response received and you will notice a webbook URL and few set of instructions so simply copy this webbook URL and now you will have to follow these instructions carefully so go back to the spreadsheet which is associated with your Google forms then click on extension click on add-ons then click on get addons and here you will have to search for the P connect webbook add-on and you will notice that this add-on is already installed in my account because I have already created several automations okay so I'm going to close this box directly but you will have to this add-on firstly because after that you will have to open the same add-on from here then you will have to click on this initial setup and here exactly we will be pasting the same webook URL which we have got via PA connect okay so let me paste the same all right so I have pasted the URL and now it will ask you to provide the trigger column so trigger column will be your final data column on which if the data is added the whole of that row data will be sent to the webook URL okay so basically it is asking to provide a column name on filling of which this automation should Trigger or we can say the data of this spreadsheets should be sent to P connect okay so whenever any new form submission will be received from here the data will be added to this spreadsheet and currently we have all the columns up to Edge okay okay so that is why my trigger column will be Edge okay final data entry column is Edge okay so let me add the same all right so I have added the trigger column now if I will click on the send test button you will notice that it will say no data found in row two because currently our spreadsheet is blank so how about I firstly open this form in a new tab and then I'm going to submit this form so that one data will be there at least okay give me a second all right so I I have opened that form give me a second let me fill all the details so I have filled that form using some dummy details so the name I have to ped as demo user the email address is demo.com the phone number is again a dummy phone number here I have selected the cake weade as 2 kg here I am selecting I have selected the cake flavor as pineapple what are you celebrating manage anniversary and the message or the name of the cake is Happy 2 years of marriage now finally I'm submitting this form and firstly the data will be added here now I will open this extension once again but before that let me correct the formatting opening the same clicking on initial setup how about I copy this webbook URL once again and now when I will click on that send test button you will notice that this spreadsheet data will be received here as our response and the response is received let me even show you the details one by one here we have the same option that is mar anniversary the same trigger column the same timestamp basically the form submission date and time here we have the same spreadsheet name that is Kake order form and we have other details okay so the presence of this data clearly shows that the connection in between our Google Sheets and P connect is working absolutely fine okay so now onwards what will happen every time someone will submit this specific Google form the details will be captured via P connect instantly because this trigger will instantly capture new incoming data and the workflow execution will start in real time okay so in this way the first step of our automation is done but to make this happen you will have to enable one more very important setting that is this send on event as soon as you select that option you will notice that a tick Mark will be added this will ensure that every time a new data is added here that data will be sent to public connect immediately and automatically so the first step is done moving further now I'll show you you how using the same form submission data you can create an invoice automatically in Google Docs application okay so searching for the action event that is create a document from our template so yes I am going to create a new invoice using that existing template which I have already created okay so let me select the same clicking on connect and just like I have connected Google forms with P connect now I will be connecting Google Docs with the p connect and if you are connecting it with P connect for the first time simply click on the sign in with Google and provide the access of your account in which you are about to create your templates all right I have provided this access multiple times so I'm going with the existing connection clicking on Save and in this way my Google Docs account will be immediately connected with the p connect now because we are connected whatever the documents are already available in my Google Docs account have started visible here and as soon as I select the document from here you will notice whatever the variables I have added inside my template all these variables will start visible here as the field let me even show you the same so searching for the same template that is final invoice template give me a second all right here we have the very same template and you will notice all the variable names will be visible here as the field so basically we are going to provide the data from here and in this way the details will be updated here this is going to happen Okay so now it is asking for that document name whatever the document whatever the invoice you are going to generate what should be the name of that document so I would like to provide the name something like invoice for and after that I would like to add the name of the customer name of the user so from where I'm going to provide this name remember I have already capture the form submitter name as a response of my trigger step but the interesting thing is I'm not going to manually copy this name and paste below again and again for every new form submission I am going to map that name here so that it can be replaced automatically when our automation will work in real time or we can say on every new form submission okay so mapping is very simple you just need to click on this field and you will find the above dat here in the dropdown now select that data and in this way it will be mapped okay so let me tell you the difference whatever the details you will map here will be replaced automatically when our automation will work in real time but whatever the details you will provide here manually will remain same so what will happen a new form submission will be received from here and the name of that new form submitter will be added here but this invoice for will remain same asking for the location so whatever the folders are already available in my Google Drive account have started visible here and I have already created one folder with the name all invoices of cakes order so I will be selecting the same all right here we have the same folder so moving further now I'm going to provide all the details okay firstly it is asking for the customer name so I'm going to map these details one by one from my submission data from this drop on all right it is mapped asking for the email address I have mapped the same asking for the phone number how about I directly search for the number and here we have the number let me map other details also in the same way asking for the invoice date so I think I do not have any date which I can map no we have a date but that date also consist of that time so what you can do is either you can map this date as well as time both the thing here or you can separate you can split these values now how you can split the values within the dashboard of public connect or within this dashboard okay so you just need to click on this plus icon and add one more action step before your Google Docs action step and then you will have to search for the text format using which you can provide various options you can perform various options within your text this time I would like to perform this particular operation that is this split text then click on connect and it will be connected immediately and firstly it will ask you to provide the text which you would like to split so again I would like to map the same date and time from the form submission data and now it is asking for the separator so I would like to separate these values with this space so let me add the same then further it is going to ask you what segment of this particular text you want so I want the first index before this space so how about I go with first only clicking on the save Sent test request button and you will notice a response will be received and that response will consist of the first segment which I can easily map in the invoice date section okay so opening the same taking you to the invoice date field and here we have the field that is invoice date opening the save and here we have the date further it is asking for the product name so I will have to check that what exactly I can map okay so remember I have collected few things that is the pineapple cake basically the flavors so how about I map the same and after that I will manually add this cake term okay so what will happen the product name will be pineapple cake quantity so I think yes I have also captured this quantity thing using Google forms so yes I have mapped the same asking for the amount well I have not captured this amount in my form submission data so I will have to calculate this amount now how I am going to calculate this remember I have already provided all the details but all these details the pricing details are present in the description so I cannot actually pick these pricing from the description I will have to Define these pricings within my automation only okay so before my Google Docs step I will click on this plus icon and will add one more action step and here I will be searching for the lookup table okay so basically in this table only I'm going to Define all the pricing of the gig and based on the form submission data based on the selection that pricing will be picked from here automatically and when I will have that pricing as a response I can easily map the same pricing in the amount field okay don't worry about that I'll show you everything step by step okay so what you will have to add in this lookup key skip this for now firstly I'll show you this label and value thing and then I will come back to this particular field okay so this is the pair of label and value or we can say key and value pairer okay you will have to add this label and value pairer for more number of times okay basically we have to define the pricing of how many items 1 2 3 4 5 so I'm going to add this label and value thing for five times okay so I think four is already done and now I have also added it for five times okay and in this label section I am going to provide the exact name of the cake whatever the name I have added in my form okay here I have added these flavors I am going to define the the name of the flavor and in front of these flavors I'm going to add the pricing of these flavor okay so the pricing for butterscotch cake is actually 550 okay so let me add the same and in the same way I will be adding all the flavors name give me a second firstly is already done the first one is already done let me copy and paste this pineapple one further we have another flavor that is black forest give me a second let me paste all these cake name all these flavors name very quickly okay the last one we have is the red wet okay and in front of these flavors name now I am going to provide the pricing okay for the pineapple cake I'm going to charge 550 rupees for the black forest cake I am going to charge 620 rupees okay so let me quickly add the same asking for the chocolate one which is going to be of 560 rupees and the red velvet is for 660 okay so I have defined all the pricing okay now we will have to map the selection of the form submitter again from the Google forms response responses remember this particular person has provided the flavor name as pineapple so what will happen as soon as I click on that button ing to this data the pricing of that particular flavor will be received as a response let me even show you that save and sent test request and you will notice in the response we have received the pineapple flavor as well as its pricing let me even show you some other thing how about out I copy this butterscotch thing here and now for a second I'm replacing this thing and adding this butterscotch value and now you tell me what value we will get in return well I'm expecting this 550 price in this response okay give me a second fingers cross waiting for the response and you can notice a response is received and that response is actually consisting of the same pricing okay so in this way based on this lookup key basically based on the selection of the form submitter we will receive the pricing in the result let me again map the flavor the same flavor all right it is done I will have to click on that button once again okay and now I can easily use this pricing in my invoice but there is one more problem I cannot actually directly map this pricing because remember the customer has selected the weight of cake as 2 kg and these pricing were of a single kg okay so I will also have to do the calculation I will also have to multiply this 520 with two and then only I will get the actual pricing of the cake okay so now how I am going to do the same process within this automation because if I will calculate this pricing manually what is the use of this automation so give me a second I'll show you how we can do the same thing within this automation only and I have the pricing of the pineapple cake which I will have to multiply with the quantity of the cake now how I am going to do that simply click on this plus icon before your Google doc step and search for the number formatter which is an amazing feature of P connect via which you can perform various kind of operations within your workflow related to numbers okay currently I would like to perform this math operation so selecting the same action event clicking on connect and it will be connected immediately and in the first field you will have to provide the number in which you would like to perform the operation perform the math operation or perform the calculation so I would like to perform the calculation in between this flavor price basically the cake price as well as in between the quantity so searching for the same dtis quantity and I have mapped both the numbers after that I will have to select the operation basically what operation you would like to perform in these two numbers so I would like to perform this multipli location so clicking on this button save and sent test request and did you notice we have actually get the calculated amount basically 1,40 rupees of that particular Ki okay which I can map easily in this Google Talks step so opening the same taking you to the price field basically the amount field clicking on this particular field and here you can find the number format step response which I have mapped successfully and in the total amount also I am going to map the same all right it is done as soon as I click on this button you will notice that a new invoice will be generated in the same folder because we have already selected this folder only as the location give me a second let me do the same fingers crossed waiting for the response and if that response is positive that means our automation is working and in this way the invoices will be generated all right so the response is received going back to my my Google Docs and did you notice that the invoice has been created automatically with the same name that is invoice for and here we have the name of the customer here we also have the date of invoice here we also have the name again the email address the phone number we also have the name of the cake the quantity the total pricing as well as the final amount okay so in this way with the help of Google forms Google Sheets and Google dogs you can automate the process of invoice creation you just need to build this automation inside P connect once and after that sit back and relax because P connect will take care of all the task in the back end you do not have to do anything manually okay so let me even show you that let me open this form once again and now in front of you I'm going to submit this form with some dummy details and you will see one more invoice will be generated here okay so give me a second all right so this time this dummy customer is filling out this form and in the cake weight I have selected .5 basically half kg cake I'm ordering and the as the flavor I'm selecting butterscotch okay and here we have the pricing of butterscotch as 5.50 per kg okay so I'm expecting the amount of 225 okay so clicking on this button basically submit going back to my Google Drive folder and waiting for that invoice to be generated okay fingers crossed well one invoice has been generated with the same name that is invoice for dummy customer now I am going to cross check the amount and did you notice that the same amount has been added here automatically with the same quantity with the same name okay so in this way with the help of P connect you can automate this process and just in case if you want to access this fstep automation inside your P connect account I will also attach the link of my workflow into the description box click on this link sign up for free into the public connect and then you will be able to access the same fstep workflow inside your own public connect account that to for free not just these applications you can integrate multiple applications and automate your business with P connect you can ask your queries at forum. p.com my team will surely answer to your questions this is the website of P connect and for the latest updates of P connect and unique automation ideas you can join our Facebook group that is form get door deals if you have found this video helpful in any way share it with your friends and colleagues and also help them to automate their business like share and subscribe thank you for watching this video