Very good video helped a lot. I would like to save an image as well, I saw that google drawings allows saving, publishing and getting an html code that can be used in HTML projects. Could you help me create a script that also saves images? Thanks
Dear Aryan , Thank you for the Nice Video, I have a Question , How do i Generate a PDF everytime Data is received by in Google sheet via WEBAPP or when Data is Corrected in Google Sheet
Firstly, glad the video helped. Secondly you can use triggers to run your Google Apps Script Code. Check out this blog that I have written : medium.com/swlh/create-pdf-using-googleapps-script-6d974f3f06c4 . Hope this helps.
@@AryanIrani123 Dear Aryan , If i send the Data to Googlesheet using google form all works fine, My issue is when the same data is submitted through WEBAPP , then the pdf is not getting created , can you help
Perfect! This is what I need but I'm wondering what if the template is in Google Sheet format, not Google Docs? I have some variables that need dynamic formula calculations Google Sheets addresses computations. Do you have a sample video or script for that?
I want to add some pictures that are stored in drive. In the generated pdf files pictures are not showing instead drive url is displaying. Please guide how to display the pictures.
Hi! Just what I was looking for.. But, is there a way I can create bulk PDF from spreadsheet? My report template is in sheet (I use drop-down list to select students name). Is there a way for me to bulk print all reports as PDF? Really hope you can help me
Hi ty for the shared knowledge. Is there any way to turn that header PDF image into a variable? Image x for input x at a certain sheet column, Image y for impute y at the same column... I would appreciate any repply! ty!
Hi, thanks for a such a wonderful tutorial, but I face a problem in creating copy of the file exactly in the same way as you did, var temp_file = doc_File.makeCopy(Temp_Folder); It generates error and didn't execute it. Please do help me, if there is some change in command or little modification required.
is it possible to have the data in the rows output as a just separate page within only 1 PDF file instead of every student having their own PDF? I'm trying to use this tutorial to generate car tags from data in a google sheet and would like them to be put into one file instead of individual files to make them easier to print.
Instead of using Google doc as a template for creating pdf, can we use Google sheet and it's data for creating PDFs..? I have my data in google sheet, which is a template 2nd sheet and it gets data from another 1st sheet within tha same google sheet file through a drop down list from source sheet. If you don't mind can I get your e mail address to share this sheet to find out solution.?
Hello Aryan thank you for this tutorial. I really managed for the first time to create pdf files from google sheet and send them by email. So to plot the url on sheet. But I have a problem when I created a column using the (ARRAYFORMULA) function, the url is created in duplicate. I'm really sorry my English is bad I hope you understood me. plus i'm new to programming. Thank you
Thank you, can we make all data in one phone address book Name Photo Phone number Address in a page multiple persons in a page & so on Please make a video
If you have a normal Google Account, you can only send 500 emails in a day and if you have a Google Workspace Account you can send up to 2000 emails. Check out this link to know more : support.google.com/a/answer/166852?hl=en Also if you want to make the process faster you can check out this Add-on called Form-Publisher : form-publisher.com/
@@AryanIrani123 Thanks for giving answer. Because I just have made a google form for salesman recruitment and I am getting daily 3000+ response and as you said even I have google workspace account I can only send only 2000 pdf. What if I have to send 3000+ pdf in a day? Thanks in advance Eagerly waiting.
Hi Aryan, this was very helpful, thank you! A couple of things I noticed as I watched your video and copied your script for my own project: - removeFile function doesn't work anymore (the temp-files will just end up in the root of your google drive). You can use File.setTrashed(true) instead. - The line with var body = temp_Doc_File.getBody() doesn't seem to be doing anything. I removed it from my script without consequences. - Almost at the end of the video, a typo (MimeTpe.PDF) was corrected (to MimeType.PDF) off-camera. If you follow along the video and type everything over this could be easy to miss.
Can you please help me out in in creating copy of the file, var temp_file = doc_File.makeCopy(Temp_Folder); It generates error for me the way it explained in the video
@@Tutorials-by-MuhammadUsman I'll try to help you if I can contact you by email. Could you customize your RU-vid channel so it shows your email address in your contact info?
@@AryanIrani123 The problem occurs when I run the function "createPDF". I rewrote the code three times following your instructions, but when I run the "createPDF" function the error message bellow appears: function createPDF(docFile,tempFolder,pdfFolder) { const tempFile = docFile.makeCopy(tempFolder); const tempDocFile = DocumentApp.openById(tempFile.getId()); const body = tempDocFile.getBody(); ....
@@juliobispo Check the Document that you are using, the error is telling you that it cannot make a copy of undefined. This means that the you have not declared or got the correct Doc.