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
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.
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
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.
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
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.
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
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 UA-cam channel so it shows your email address in your contact info?
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.?
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.
@@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.
This is great work. Keep it up, Aryan Irani.
Thank you so much !
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
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?
Not that I know of
Nice Tutorial.
But how can one get the pdfs generated downloadable link on every individual student on a new column
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.
You can directly copy/paste the images in the Google Doc Template.
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
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!
Hello Aryan, can You also print the pdf automatically after it has been created ? Thank You for advice.
this is word template to pdf bt i have to do excel template to pdf plz help me. means i have to bring qr code in each pdf
Thanks a lot for making so many nice helpful videos. How to add image link to document as image in google sheet data. Please help. Thank you.
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.
I also face this error and how to resolve it.
var temp_file = doc_File.makeCopy(Temp_Folder);
how can we add photos of students in marksheet in this method.? please reply.
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 Aryan, thank so much for yours videos, I have a questions, what will be a solution when I want to put a image into the PDF?
Have you found any solution?
And one thing more, How to generate data from script on same page like MCQs or question paper in ordered list
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.
I need the same type for school Mark list class wise in one PDF. To take print easily class wise
nice tutorial. thanks
Glad it helped you.
Thanks for sharing this wonderful.
I just face this error.
var temp_file = doc_File.makeCopy(Temp_Folder);
Bro how to marksheet prepare with google form scrips
Tq Aryan your video helping me. I got 1 question, How to make all data student mark in single pdf file not separate each student? Can you help me.
If you want only one final document, then I think you should eliminate the for loop that creates a new doc for each student. Hope this helps you :)
@@AryanIrani123 Can you make tutorial or script for that because i don know much about script. TQ for help.
Thank you dear Arian,
Is it possible to open a PDF file right after its creation with Apps Script in Google Sheets?
Unfortunately not !
@@AryanIrani123 thanks
Your are amazing...
Thank you :)
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
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 UA-cam channel so it shows your email address in your contact info?
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.?
I will have to check .
DEAR ARYAN, CAN YOU CREAT VIDEO FOR SEND THIS PDF TO WHATSAPP AUTOMATIC BY TRIGER...
I am sorry. In my knowledge I don't think it is possible.
@@AryanIrani123 oh thanks for replay...
Nice Video.. How to get Print & Print preview option in selected student like some button click event in html page .
If you want to preview your PDF before you send out all of them, you can use the FormPublisher Add-on that does the same, but in a more easier way.
Do you have any example.
Yes I have uploaded a Video on how to create documents using FormPublisher.
Could you do like this by using Google sheet as template. Thanks
Do you mean you want send data back to a sheet ?
Thanks for Nice Video.
How to paste those PDF links in same google sheet Column G for each student's PDF URL.
I will be making a short video on your problem in a few days. Stay tuned.......
@@AryanIrani123 Thanks for your reply...
Awaiting for the video..
I need to put the totals etc also in my doc template, how can I?
Use the sum Formula, to get the sum of all the marks, and create a variable in the doc and add it to the Script.
Thanks, please do more appscript toturial.
More to come!
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
Suppose if i made a google form for recruitment and i am getting daily 10000 response for next 15 days . Then this will work or not ?
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.
Nope. There is a quota that you cannot exceed, so I think you can only send 2000 pdf's a day.
hello Aryan, i am very interested. i want to study about that.. can i get acces to the doc file. i have send message request acces,..thanks before.
Done!
Very informative thank you !
Glad it was helpful!
Thanks for the video. I followed the instructions step by step , however I got the "TypeError: Cannot read property 'makeCopy' of undefined".
Check again, see the function that you are running. You might be running the wrong function.
@@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.
bich me kisi row me agar email id nahi ho to pdf generation block ho jata hai.. iska koi solution ho to bataye.
Script for all pdf in single pdf for teacher