PDFs from Spreadsheet Data and Google Docs Template - Google Sheets 

I feel like I should pay for watching this. Outstanding quality.

This is SO SO SO helpful! It's exactly what I needed to get things done for my new business, thanks so much--as a non-software language person, this broke everything down the way I needed to "get" it. I've subscribed and will be working my way through your videos, and hopefully will find a way to thank you that's remunerative, soon. Thanks so much again!

What an incredibly lucid tutorial. When it comes to the best at explaining tech on RU-vid, there is this guy and Bob Traversy, then everyone else.

you are a saviour.. automated 70% of my department work from your channel

God bless you man. I think sometimes you read people's mind, this was a life savior video as it came out the right time we needed it to generate acceptance letters to email to students. Keep up the good work.

You are the best Teacher for Google Apps Script with Spreadsheets

This is Wagner, speaking from Brasil. Simply amazing your videos! Thank you for taking your time teaching us!

really love this channel now. feels like watching drama thriller series.

My mind has just been blown. Thank you so much for the in-depth explanations. You have probably saved me months worth of work.

Would love to see a tutorial on printing out or exporting ranges to PDF or maybe image files, too. :) This would really be useful since there's currently no easy way to do this with code. Thank you so much for your great videos!

Thank you so much! You've just freed me from third-party extensions, and made me more independent in creating certificates. Ps.: I'm #Brazilian and I used the automatic translator, sorry for the mistakes.

Absolutely amazing. Content, presentation, depth, to the point, spot on! Well done man!

I love You, I love the way you explain things, I love the amount of useful things you teach using Google Apps, I love How you release a video teaching exactly what I need to implement over here. I've been waiting so long for this video in particular. If, possible, you could make some videos about integrating Google Forms with Google Contacts.

This was exactly what I needed! You are a very good teacher. Thank you so much for this video. I have subscribed to your channel. :-)

Thank you so much for these tutorials. Absolutely amazing!!!

Just what I needed! And excellently presented! Thank you!

You know that this is useful and needed so, I am just gonna say thank you. It saved me days and it will save days to a lot of people.

Awesome! I've been looking for a video like this one, I am very grateful to you. Keep the good work!

Thanks for the informative video,it really helped me to get the automation i wanted to do from very long,i have no idea about java and any sort of scripting,but your explanation made it very easy to understand.big thanks

Thank you so much. This is one of the best ever exist tutorials.

A magnificent class. Great!!

Very valuable content and clear explanations. Good job!

This was an AWESOME tutorial, just what I was looking for. I subscribed for the next tutorial.

Really useful lesson here. Once again, thanks for the class!!!!!!!!!!!!!!!!

Great stuff! Everyone who uses Google Sheet/Excel should be on your channel!

Awesome tutorial, also a great explanation of variables, loops, and error catching thanks a bunch

thanks for the valuable tutorials , a really loved this channel and the why you explain the things , very simple . I support to start learning JS separatly but here I found my self learning lot of things about JS and GS at the same time , really thank you very much I hope also that you make some videos about organizing many forms (custom form not google forms with bootstrap ) on google sites and link every thing with GD and GS thanks again

🤯 just what I needed, thank you very much !!

Awesome! Thanks for posting the video. Informative and educative. You explained very well.

You’re a beast my guy.

This is a great demostration to do mail merge in Google Sheets without add-on. I learned from here and try to merge but hit the 6 mins execution time limit with maybe 60 recipients. Hopefully could see your solutions or ideas someday. Thanks!

If you have trouble with "MimeType.PDF" - replaced "tempFile.getAs(MimeType.PDF)" with "tempFile.getAs('application/pdf')" and it will work like a charm. Thanks for the great content!

Saved the day! Thank you so much!

Hi, many thanks for your teachings, very educative and over all step by step!

This is such an amazing video. Thank you!!!

Could you take this a step further and show how to automatically send PDF file to a given email after it was submitted through google form?

Gracias, @Learn Google Spreadsheets. Muy bueno el tutorial.

World's No 1 Channel World's Best Teacher World's Best Quality Learn Easy and Understand I Love And Like All Video All Video Is Heart 💓 Touching

Gracias por este maravilloso tutorial!

Explained everything very well. Nice work👍🏻👍🏻

Extremely helpful, thank you!

Excellent video and its exactly what I need to do for my project!!!

Thank you so much!!! Just what I was looking for

I used this tutorial and in 2h I made it to work without any problems, interface from google has changed a little bit here and there but it all works and its not hard to do and follow, THANK YOU!!!

You are a awesome teacher sir.

This is the most useful channel for me Love it very much Thank you for creating this channel

Man, you is the best. Congrats.

Friking awesome! Thank you.

nice, very nice, big very nice!!! thank you!

Amazing tool. you made my task a lot more easier. Thanks a ton.

thanks for your support!, great info very well presented!

Wow,,, super video,,, I going to practice. Thanks a Lot.

Hello, all your videos are easy to understand, they give me a lot of solutions and help me to rethink my processes. In this case I wonder, how to group data in a pdf report having more than one item (lines of the spreadsheet ) referred to the same customer, like I 'm used to do with pivot, but to be dinamically generated, and saved in a folder. Thank you for all your videos and for the passion you put in spreading this knowledge!

very clear and informative. Thank you so much!

wonderful! especially liked the way the whole video went in a stepwise fashion, and often retrograde!!!

Fantastic !!! Thanks a lot !

Hey man, you're awesome! Thank for All!

Helped a lot! Thanks

Amazing. Exactly what I wanted to learn how to do. The last step that would be helpful is entering the url to the pdf in a column in the spreadsheet.

Awesome, awesome...and, once again, awesome!!

Nice one👍

Absolutely amazing!

Omg i just found it, sorry for asking at ur newest video about this 😁👍🏻 thank you so much

*Awesome Tutorial Bro. 💖💖💖💖*

Hello @learn Google Spreadsheets, I would suggest renaming this video to show it is different video from the other PDF video you created. So, this is more a 'Bulk' email AppScript, rather than 'onSubmit' form video. This will be better for users to find the correct information. Your videos are great. I implemented your solution without problems. The Google Permissions approval process has changed.

thank you!

Actually, you CAN chain .replace(). I've been using that a lot to generate bunches of customized "diplomas" for students, and it worked liket a treat. The only painful thing is to have to declare each and everyone of the placeholders. I'd rather do some sort of automatic find of the {} occurences and map them to the "fields" in the spreadsheet, but I'm not good enough to do that… Anyway, your video was the greatest I've ever found about that specific need. Thanks a ton !!

Very wonderful ❤️

very amazing and use full

Remarkably fabulously amazing - and every other positive adjective I can think of! Thank you. Now I need to determine how to do a mailmerge that attaches the newly created pdfs......and send it to those individual emails.....anyone?

ThankU so much badly needed this.. been searching for awhile without addons.. big big help, how about after submitted the form, auto generates PDF ?

This was a great video! I've never used scripts before and was able to accomplish it. Do you have a video on how to make bulk Google Docs? I thought the PDF was the best option for my needs, but I think it would be great to know how to make Google Docs in Word format as well

This is absolutely amazing instruction! I am a novice at coding, but was able to follow along step-by-step. I typed each line along with you and created the docs and folders right along with you. I actually made it through without errors (other than the ones you showed us) the first time through! The one issue I had has been mentioned in the other comments. How would you recommend duplication prevention when adding names to the spreadsheet and running the script again?

Amazing comunicator Man!! Thanks a lot.

Thanks such a helpful video! I feel like this would be more complete if you could show how to use the generated bulk PDFs to send individually to the people listed in the sheet. Would you have a video of this somehow in your channel?

Amezing sir thankyou soo much for this

Thank you !!!

Finally, I found what I was looking for. Great teacher. However, I am still stumped. That's only because I am not into all this data stuff. Do you do this as a gig work too?

Very useful script thank you.

Hi, thank for your tutorial. That's it helpfully.

Parabéns pela aula! Didática incrível! Excelente fala e exemplos durante o aprendizado! Nota 10000000000!

Awesome!!

Your explanations are awesome man. Is there any way to add an image to the PDFs before we email them?

Amazing. Thank you⭐⭐⭐⭐⭐

Thanks for all the content so far ! Im using extension to doing the same thing , which is whenever a google form submitted it will generate a pdf email. Wonder is this works by writing scripts from a newbie like me ? As the chrome app is not supported anymore end of this year...

Great. I used a longer way to achieve the same. Get as mimetype.pdf is new i learned here.. thank you

Thank you for putting this together; it's been super helpful! I had a question about getting the formatting to match what's currently the sheet range I'm pulling from. The getDisplayValues() helped, but it didn't bring over bold, underline, and other formatting from the cells. I've also got a column with a linked website. Any guidance on how to get all of these into my final PDF would be most welcome. I really appreciate your channel, I've been using it a lot!

And you've earned a sub from as well. Hope you reach 1 million subs soon man I'm glad I could add to that number. Hope you're

OMG, thank you!!!!

May I ask a quick question. I am trying to export individual rows from a product catalog. The catalog has images stored in a cell. Is it possible to load that image into the template as well? I saw you using a different function to get the dollar symbol, so similarly does loading an image require a new function?

work! Cheers

nice class :)

this is gold

Thanks .. You saved my Day..

this is so great. ❤❤❤

That was an amazing tutorial. Straight to the point and perfectly explained. I implemented a version on my data which at the moment is 50 rows and 9 columns, trying to create invoices for my clients. Is it normal that the 6 minutes of allowed runtime only gets me up to about 30 pdfs created? Is there any way to optimize the script so it could potentially deal with 100 clients in less than 6 minutes? thanks for your help :)

Hi! This has been such a huge help for me. Thank you for your amazing tutorials. We receive applications at my organisation using Google Forms. From there the data gets saved into a sheet and I want to then save PDF summaries of those applications. Your tutorial has allowed me to achieve this. The one thing I would love to be able to do in addition to this would be to now allow for duplicate files. The way the code works now, it creates PDFs for all rows each time the script is run. I'd love to be able to run the script and only create new PDFs for new application responses without creating more and more of the same. Do you have any advice on how I can find out how to do that?

Oh my God, I needed this so bad :)I know I sound like some country girl but hey, thank you a lot! LOL

You are a life saver!!! One quick question. How do I get it to look at the PDF folder and remove the old files automatically? My spreadsheet used to update information so when the spreadsheet updates I need new PDF's preferably without having to go into the folder and delete the old files manually.

Thank You.