I just wrote my first Apps Script! Thank you for you video. I'm encouraged to explore further and I'd like to extend this script to skip the recipients who received an email the first time the script was sent (as indicated in the "SENT" column). Additionally, I'm interested in learning about scheduling a script to run automatically, maybe at a certain time each day or trigger when a new line is added to the spreadsheet (from a form submission). Do you have a videos (or advice) that would point me in the right direction for these topics. Thank you again for you very easy to understand video and inspiration to finally learn more about Google Apps Scripts.
Yes you can automate the scripts to run as needed, on events, time based or calendar based. I do have some videos, my latest shows how to setup a trigger in the dashboard there are also code setup of triggers in other videos.
Thanks for such an easy tutorial. May I know if you have another video explaining how to skip the rows with “sent” status, so next time when run the script it doesn’t duplicated the result. Thanks
I do have several on that, unfortunately Im not very organized on here and not sure what they are called. This channel does not have many subscribers so hard to get time for better organization, if it grows I'll improve it.
Hi sir, this content is very helpful. Is it possible to link this in google form? And everytime a response is made it will automatically sends pdf and have an approval.
Great video Sir! Thank you very much!!
I just wrote my first Apps Script! Thank you for you video. I'm encouraged to explore further and I'd like to extend this script to skip the recipients who received an email the first time the script was sent (as indicated in the "SENT" column). Additionally, I'm interested in learning about scheduling a script to run automatically, maybe at a certain time each day or trigger when a new line is added to the spreadsheet (from a form submission). Do you have a videos (or advice) that would point me in the right direction for these topics. Thank you again for you very easy to understand video and inspiration to finally learn more about Google Apps Scripts.
Yes you can automate the scripts to run as needed, on events, time based or calendar based. I do have some videos, my latest shows how to setup a trigger in the dashboard there are also code setup of triggers in other videos.
Thank you sir! This is very helpful
Glad it was helpful!
Brilliant!
Thanks
Thanks for such an easy tutorial. May I know if you have another video explaining how to skip the rows with “sent” status, so next time when run the script it doesn’t duplicated the result. Thanks
I do have several on that, unfortunately Im not very organized on here and not sure what they are called. This channel does not have many subscribers so hard to get time for better organization, if it grows I'll improve it.
thank you for your work!
Thank you for your support please subscribe and share this channel
I already did it)))
hi, why my html content return error? my ${row[0]} all turned red color not black. please help.thanks
Hi sir, this content is very helpful. Is it possible to link this in google form? And everytime a response is made it will automatically sends pdf and have an approval.
Hello sir, why file pdf isblank from sheet template ,the template fill data from sheet
if i have multiple sheet in one sheet then what to do
you can loop through all the sheets within the spreadsheet
*data.forEach IS not a function*
Error is showing after running the function.
data would need to be an array of data to use forEach
Bisakah mengirim file pdf ke email tanpa batas atau unlimited menggunakan apps script
Hi, Sheet not pick the value it is showing like this 'New PDF ${row[0]} ${row[1]}' kindly resolve this.
You need to use backticks not quotes
Fvck! 😂😂
I love what you did here Bro...
You just solved my problem🥲
thanks for viewing