PDFs from Spreadsheet Data and Google Docs Template - Google Sheets
ฝัง
- เผยแพร่เมื่อ 16 มิ.ย. 2024
- Learn how to create bulk PDFs using Google Docs template and spreadsheet data in Google Sheets. We'll be of course using Apps Script and JavaScript programming language to automate Google Drive, Google Docs & Google Sheets. Of course you could import an Excel file and do the same.
#pdf #Spreadsheet #googledocs #googlesheets
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!
I feel like I should pay for watching this. Outstanding quality.
Agreed. I bought a book on this stuff and I always seem to get errors I can't fix. I love your authenticity, honesty, making mistakes. It's very human and incredibly good learning, from one teacher to another!
then donate on Patreon.
Shhh! He might hear.
just do it.. buy a thanks ..
What an incredibly lucid tutorial. When it comes to the best at explaining tech on TH-cam, there is this guy and Bob Traversy, then everyone else.
you are a saviour.. automated 70% of my department work from your channel
This is Wagner, speaking from Brasil. Simply amazing your videos! Thank you for taking your time teaching us!
You are the best Teacher for Google Apps Script with Spreadsheets
really love this channel now. feels like watching drama thriller series.
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.
Awesome!
My mind has just been blown. Thank you so much for the in-depth explanations. You have probably saved me months worth of work.
Great to hear!
@@ExcelGoogleSheets
Did you have Courses Online about app Script google sheet
@@ExcelGoogleSheets hi, can i still use the removeFile method? cos it now says that this method is deprecated. thanks
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!
Absolutely amazing. Content, presentation, depth, to the point, spot on! Well done man!
Much appreciated!
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.
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.
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 might be a stupid question, but what does Google Contacts do?
@@ExcelGoogleSheets Create and update contacts on google platform. Like, What I want to do is to gather costumers info through a google forms, save this info in a spreadsheet and create a contact. If this contact has already been registered update it.
@@fernandobrito5316 @Learn Google Spreadsheets
Yes! I was thinking the same thing watching this video. For me, as a self-employed guy, writing bills is a really tedious and I am implementing the technique in this video to automate bills via spreadsheets. It would be really awesome to learn about interconnectivity between google contacts and google spreadsheets. Like how to import in and export from sheets to contacts and vice versa. Why? The "autofill" function in gmail, or to give customers access to specifics sheets for example, only works, if you have the email adress saved in google contacts (afaik).
PS: Thanks for your work - really appreciate it!!
This is the video about integrating Google Forms with Google Contacts.
th-cam.com/video/ISHALBY-w54/w-d-xo.html
Thank you so much @Learn Google Spreadsheets for creating the video, and thanks for @
Fernando Brito for the idea.
So gay .. 🤣
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
A magnificent class.
Great!!
Great stuff! Everyone who uses Google Sheet/Excel should be on your channel!
Thanks!
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
This was an AWESOME tutorial, just what I was looking for. I subscribed for the next tutorial.
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. :-)
Really useful lesson here. Once again, thanks for the class!!!!!!!!!!!!!!!!
Awesome! I've been looking for a video like this one, I am very grateful to you. Keep the good work!
Glad you liked it!
Thank you so much. This is one of the best ever exist tutorials.
🤯 just what I needed, thank you very much !!
Hi, many thanks for your teachings, very educative and over all step by step!
Very valuable content and clear explanations. Good job!
You’re a beast my guy.
Gracias, @Learn Google Spreadsheets. Muy bueno el tutorial.
Explained everything very well. Nice work👍🏻👍🏻
Awesome! Thanks for posting the video. Informative and educative. You explained very well.
Glad you enjoyed it!
Saved the day! Thank you so much!
Awesome tutorial, also a great explanation of variables, loops, and error catching thanks a bunch
Extremely helpful, thank you!
Wow,,, super video,,, I going to practice. Thanks a Lot.
Excellent video and its exactly what I need to do for my project!!!
You are a awesome teacher sir.
Man, you is the best. Congrats.
This is such an amazing video. Thank you!!!
Thank you so much!!! Just what I was looking for
Amazing tool. you made my task a lot more easier. Thanks a ton.
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!
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!!!
Unfortunately Google changes their interface so frequently that it's impossible to keep up.
Friking awesome! Thank you.
nice, very nice, big very nice!!! thank you!
This is the most useful channel for me
Love it very much
Thank you for creating this channel
Glad you enjoy it!
Gracias por este maravilloso tutorial!
very clear and informative. Thank you so much!
Glad you enjoyed it!
thanks for your support!, great info very well presented!
Awesome, awesome...and, once again, awesome!!
Thank you! Cheers!
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
Absolutely amazing!
Fantastic !!! Thanks a lot !
Helped a lot! Thanks
Hey man, you're awesome!
Thank for All!
very amazing and use full
Nice one👍
Amezing sir thankyou soo much for this
Very wonderful ❤️
Amazing comunicator Man!! Thanks a lot.
🙂
Very useful script thank you.
*Awesome Tutorial Bro. 💖💖💖💖*
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?
Awesome!!
wonderful! especially liked the way the whole video went in a stepwise fashion, and often retrograde!!!
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!
thank you!
Hi, thank for your tutorial. That's it helpfully.
Thank you!
Omg i just found it, sorry for asking at ur newest video about this 😁👍🏻 thank you so much
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!
for me it creates PDF from initial template doc file, not from copy with replaced data. any ideas?
@@user-fq5vo9zs1q Sounds like you have a bug somewhere around binding data. follow the tutorial correctly step by step and you will succeed
@@itamarnakar6698 thanks for reply. i see that another user here have the same problem. may be something in google script was changed?
@@user-fq5vo9zs1q it s working like a charm in the new script
this is so great. ❤❤❤
Amazing. Thank you⭐⭐⭐⭐⭐
Thanks .. You saved my Day..
Glad to hear that
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.
Hi. Did you manage to find the solution?
@@elmodvz No, but I have tried this yet either. Let me know if you figure it out though!
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.
have you had trouble on line 10
const = tempfile = docFile.makeCopy(tempFolder);
keeps returning docFile.maleCopy is not a function
Thank you !!!
Parabéns pela aula! Didática incrível! Excelente fala e exemplos durante o aprendizado! Nota 10000000000!
work! Cheers
this is gold
Oh my God, I needed this so bad :)I know I sound like some country girl but hey, thank you a lot! LOL
OMG, 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?
Thanks for this
Great
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 !!
Great!
Your explanations are awesome man. Is there any way to add an image to the PDFs before we email them?
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...
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?
ThankU so much badly needed this.. been searching for awhile without addons.. big big help, how about after submitted the form, auto generates PDF ?
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?
Thank You.
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?
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.
That thing is a life saver. Thank you.... One question.. Is there a way we can automate the process around the scripts time limit?
nice class :)
Thanks!
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
thanks!!!!!
I love you so so much.
Thank you sm