In this tutorial we would learn: 1. How to Create Invoices using Google Sheets. 2. How to Create PDF files using Google Sheets 3. How to automatically send PDF invoices
Hi, it worked fine till make copy.. next line i.e. documentApp.openById is showing error (document is Missing ( perhaps it was deleted, or you don't have read access?)... Any idea what could be the reason though it created copy successfully? Thank you so much!!
Thank you sir, the tutorial video is very clear and extraordinary, what I want to ask is how the script code is to be able to do carbon copy (cc) and blind carbon copy (bcc). Thanks.
Very great precise and useful video, thanks. Just a question as beginner : I don't see the required ";" ending character in line 102 and 105 and no error raised during execution. Did I miss something?
Thank you for providing this very good automation, after adding onformsubmit trigger. i was unable to get last row with data. Please sir, how can i change this to get the last row with data. " for(var rowNo=2;rowNo
Thank you for this video. It was very helpful. :) Apart from generating invoice and sending invoices, i would like to if we have a tool where we can automate the billing schedule. For example :- lets say we have a five year deal and customer had opted for annual billing. I would like to know if there is any way you can create a billing schedule and system can pick the current date and generate invoice.
Hello! Thank you so much for the great tutorial. I'm having trouble getting my Customer Name and Invoice Numbers to show up on the final PDF invoice. Anything I may have missed?
Hello! Thanks for the tutorial. I have a question, is it possible to use data from not just one row ofthe document, but from all the rows on the spreadsheet?
Hi sir, thanks for the great video. One question, how to add the button and link to the google script? The only issue I have now is an empty invoice without any data in it. Your answer would be highly appreciated
If i had to use Google spreadsheet instead of google doc for invoice template, can you let me know if i have to change anything in the coding other than the Url?
Hi. Thanks a lot for this tutorial. Files removing didn't work for me. Files was moved to drive. I try another way and it's worked: var files = DriveApp.getFilesByName(rawInvoiceFile); while (files.hasNext()) { var file = files.next(); file.setTrashed(true);
Thank you. If you have template in google sheet, refer below tutorial as to how it can be converted into a pdf ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-dknSPPg7LR0.html
It only sends the last row as an invoice? I dont need prices only order info and not even sending the email.only saving the invoice in drive folder and will fill the price manually..can i change the pdf to doc also? Thanks a lot
if your code is sending only the last invoice it means you must have put the code of sending email outside the for loop. All other customizations are very much possible
Can you help making a simple project In Google Sheet I add value in sheet1 8-9 cells +mail, cc, bcc and mail get sent in pdf form then all value get stored in sheet2 for my views
Good sir, Please help me i canot run the function because this: >ReferenceError: rowNO is not defined< keeps poping up. So please help me beacuse its urgent that i complete this as soon as posible. Thank you!
One quick Question - i have updated more than 10 invoices in the google sheet but when i run the Apps script only the last invoice from the google sheet is getting created.
very good video, but i missed how to delete the empty item rows .... you have filled till item4, but how to get rid of the other empty rows ? in real production state this is not practicable. ❤
@@AutomationMadeEasy at the end of the video you open the pdf file ... 5 rows are filled .... the rest is empty and then the summary. the summary should begin at the end of the last item. what do you do, if you have e.g. 15 items ... ( as real invoices could have ) . i asked ... if there is a way to make the summary ... at the end of the last filled row ... and the rest of the empty rows ist not displayed.