tutorial yang anda buat sangat membantu sekali, mudah dipahami dan mudah diikuti, terlebih bagian skript yang anda zoo in mudah dicoba. harapannya yang akan datang juga menyertakan qr code yang dapat disertakan dalam templatenya. terimakasih. 😍😍
This was awesome! Thank you! One question: I have URLs to images on my google sheet as well. Is there a way to embed the image into the Google Doc template with this method?
This is a Life saver! One question, if I remove the email function will the if(row[0] == ‘’){ function still work, to check if the date column is empty? As i need the ability do select certain rows to generate the pdf, I have 120 rows, I don’t need all of them to be generated…
Beautifully done! I'm working with some dates and times. When I get the dates or times, they come in the format like Sat Apr 29 2023 02:00:00 GMT-0400 (Eastern Daylight Time). How can I do in order to get (and show in the pdf generated) just 4/29/23 format for dates and 11:30 PM format for time? tks.
Great Video! Quick Question, how do you take the value of the spreadsheet classified as dollars/currency/accounting and apply it to the word document to transfer over as same $ format? This video has been beneficial and got everything working except the formatting of the numbers. Example: In excel sheet $240,000.00 but generated in word document --> 240000 and transferred into the PDF same as the word. Do you have any suggestions on that? Thank you again for your time!
@@LaurenceSvekisCourses Yes, I have tested all types in google sheets to see if it's impacted and it is not. The numbers do not generate over as same format as currency or finance. I have also tried to set the word template as well with the incorrect results. Any other suggestions? I have looked online and it seems no one has tried using $ numbers to transfer only whole numbers.
Thank you very much. It it a realy great video and code. Is it posible, to replace an old pdf file with a new one in app script. I have link to pdf file in Google Drive, posted on internet, I just want to create a new pdf file and update the old one to remaine the same link.
I have a sheet with a table already on it that is updated from info from other sheets all inside one sheet. Hopefully you follow. I want google sheets to automatically just make that one sheet a pdf and save it to my google drive. So probably half of what this script is doing. How can I accomplish that?
![what is Google Apps Script? [Tutorial]](/img/n.gif)
That was awesome! Didn’t even know this was possible. Thanks!
Is it really works with free online version
tutorial yang anda buat sangat membantu sekali, mudah dipahami dan mudah diikuti, terlebih bagian skript yang anda zoo in mudah dicoba. harapannya yang akan datang juga menyertakan qr code yang dapat disertakan dalam templatenya. terimakasih. 😍😍
Highly resourceful. Many thanks for this
Thank you for watching
Great Video! How do we speed up this script to complete this process way faster (if my google sheet had many rows)
You can mail out more canned messages, how many rows do you have?
This was awesome! Thank you! One question: I have URLs to images on my google sheet as well. Is there a way to embed the image into the Google Doc template with this method?
Thank you so much!
Is it possible to get the pdf opened right after it is created? or even get it printed by local printer?
Yes but not in the apps script, you need to run frontend code for this JavaScript can handle that.
You would need a web page to trigger the download or open to printer
This is a Life saver! One question, if I remove the email function will the if(row[0] == ‘’){ function still work, to check if the date column is empty? As i need the ability do select certain rows to generate the pdf, I have 120 rows, I don’t need all of them to be generated…
Beautifully done! I'm working with some dates and times. When I get the dates or times, they come in the format like Sat Apr 29
2023
02:00:00
GMT-0400
(Eastern
Daylight
Time). How can I do in order to get (and show in the pdf generated) just 4/29/23 format for dates and 11:30 PM format for time? tks.
Great Video!
Quick Question, how do you take the value of the spreadsheet classified as dollars/currency/accounting and apply it to the word document to transfer over as same $ format? This video has been beneficial and got everything working except the formatting of the numbers.
Example: In excel sheet $240,000.00 but generated in word document --> 240000 and transferred into the PDF same as the word.
Do you have any suggestions on that?
Thank you again for your time!
have you tried setting the type in Google sheets before export.
@@LaurenceSvekisCourses Yes, I have tested all types in google sheets to see if it's impacted and it is not. The numbers do not generate over as same format as currency or finance. I have also tried to set the word template as well with the incorrect results. Any other suggestions? I have looked online and it seems no one has tried using $ numbers to transfer only whole numbers.
Try typing the replacers in doc this way ${price}
Thank you very much. It it a realy great video and code. Is it posible, to replace an old pdf file with a new one in app script. I have link to pdf file in Google Drive, posted on internet, I just want to create a new pdf file and update the old one to remaine the same link.
You can create a new PDF with the same name, while deleting the old file if you need the same path.
I have a sheet with a table already on it that is updated from info from other sheets all inside one sheet. Hopefully you follow. I want google sheets to automatically just make that one sheet a pdf and save it to my google drive. So probably half of what this script is doing. How can I accomplish that?
Great video, Lawrence, thank you very much! Would you be able to make a copy of the code available to us, please?
Any updates?
Link plz?
Hi can, you make a content that encrypts the pdf with a password. Thank you
How if I want sent automation email contains pdf tables with different emails every 12 hours
I wish you would show the code fully to help us debug easily.
I pasted my code above in a comment. It does not include the email function, but it will save you a bit of time, if you've not already typed it out ;)
where is the pdf file, i try your code. No found error but pdf not create on folder. please other tutorial create pdf only from sheet data.
Trying to implement, but not yet a success
is it possible if we sent the file to whatsapp ?
Yes you can use a web hook with whatapp
how to preview a pdf file for the user to choose whether to print or save to the computer? I'm trying but without success!