Google Forms to PDF & Email while storing data in Google Sheets

[@roomforrentcuba]

Dude, you have absolutely no idea about how much easier my life has become since I found you. Of course it takes a little bit of time and brains to understand what you are explaining and adapt it to my specific needs (I'm no programmer), however... the time that this automations are earning me is countless,. My life is much easier now thanks to you. Thank you my friend, please, keep up the good work, we need you, hahaha :)

[@corbettdestination5256]

hi, do you have the code? could you please share?

[@nikluz3807]

I want to sincerely thank you for all of these tutorials. I got my degree last year and have been working with Google suite for several years now and just scored my first freelance programming job building an application in Google suite for a company

[@ExcelGoogleSheets]

Cool!

[@allisonharvill936]

I have no formal tech training but have been designated the tech person for a small non-profit and needed to do exactly what this tutorial does in a needed it done last week time frame. Thank you for making these videos. They are a lifesaver.

[@ridingwithcharley6821]

With a little work, I was able to use this basic outline, modify it a little, and create an actual working invoice I can create from my phone that is ready to email without having to be near a printer and computer. I can now create an invoice immediately and email when I have finished the work order. Thanks for the video's... so much better than other YT channels.

[@emingunduz4690]

You make me feel like I'm the best coder 😄 It worked so much for my work. I create order form. No more losting papers. Thank you

[@abdulmajeedrozan634]

Great, Lectures, Thanks and Kudos to You. Just Now Finished by creating interactive Email System for My Clinic in Dubai, Where Patient get their immediate health indicator report. Responses are Amazing. Learned from the master. Thank You.

[@BềnNguyễnThị-h3i]

Sorry, I can't create link and send mail. Can you assist me?

[@namwan.c6947]

Thank you very much for your tutorial. As of the present (2023), some methods in the code cannot be used, such as the "removeFile" function, which can be replaced by using the "setTrashed(true)" method.

[@vrm2009]

Thanks a ton for making this very useful video. This covered a lot of use cases and opened a ton of possibilities for future projects!! Quick tip for anyone who is facing the issue where google doc is getting created with values from form but the PDF doesnt reflect it, you can just add this line below before creating the PDF ie, last line of the createPDF() openDoc.saveAndClose(); const pdfFile = pdfFolder.createFile(blobPDF).setName("My PDF");

[@alekdaniels]

The best part of this, aside from all these cool stuff, is how we were able to see the thought process of it all. Plus the troubleshooting bits really gave it an approachable feel. I feel confident I can do this.

[@RoiUltraviolet]

Excellent video, very good explanations with all the necessary details to understand simply and quickly. Congratulations and thank you for the remarkable quality of your knowledge sharing.

[@gabrielcambronero4338]

It took me hours to do it, but bro.. you are something else.. really!! Thank you so much, you can't imagine how this is going to change my life!

[@cornevanzyl5880]

You have unlocked Pandora's box of creativity for me. Thank for teaching us🙏

[@ciarajanay23]

This is exactly what I needed! I am so proud of myself. I was able to follow along and using the Google App Script Reference you showed I was able to have it send as my alias and add an additional email to send the file to myself too! I will be doing more of your tutorials to learn more. And I have little to none Java Script knowledge.

[@ExcelGoogleSheets]

Fantastic!

[@davidclough6288]

This was AMAZING! It's the first time I've ever had no errors in my code. Thanks so much. I also appreciate how you didn't edit out your troubleshooting. That helped!

[@daleramirez7438]

Hi! Were you able to make it work? I tried and copied what he did in the video but I got notified with exception: invalid argument: attachments I don't how to troubleshoot it. I have no background in programming. Can you help me? 🙂

[@ericagallego7825]

you're real life saver. Please continue making videos about these.

[@cheskavillanueva5772]

Awesome! Plese don't get tired of doing more videos like this! Maybe you can share the script as well? Heh. :)

[@danisentinella]

Oh, i would love it too!

[@digitaldevinder1770]

It much better to learn if u share script. Thanks

[@revolvency]

this is actually life changing for cheap marketers like me, thanks for the tutorial, much appreciated!

[@juniorwalewangko]

I've tried and this is awesome. For me this method has create a paperless system for my work. Awesome..!!! Definetely going to learn alot from this channel. Keep up the good work.👍🏻🙏🏻🙏🏻

[@therghammotlak2755]

You are an amazing teacher

[@huseyinataseven6032]

A huuuuuuuuuuuge thumbs up!!! Thank you very much. You are a life saver.

[@bocobox]

Addicted to your video. Just like daily routine. Thanks 😊

[@MsBoolo]

Awesome tutorial ♥♥♥♥♥

[@mohnasnassr9816]

Great teaching skills. Awesome tutorials!

[@gravityelements14]

TriggerEvent step seems to have changed since you made this video. Google sheet form submit event shows a caution message “make sure you use this form submit trigger with SpreadsheetTriggerBuilder”. I am unable to pass googlesheet info data - that comes from google form - to google doc variables using event trigger. Any advise?

[@rajeshparkar5683]

Thank you for step by step explanation

[@ekeretteekanem]

huh.. super long and fun journey. Nicely delivered!

[@bobykumar3960]

MAY BE ONE DAY I HAVE THE HONOUR OF MEETING YOU..

[@guitarman7575]

Excellent

[@luiscorado2868]

Excellent like always!!!

[@aldoalbar3516]

wow thaank you ... well ... the slowmo guys would be very useful here ...

[@NamNguyen-hn5os]

thank you so much for this Video. Please keep up the good work. Much love from Vietnam!!

[@baljka17]

Man this is crazy and saved my life!

[@victormenna]

This tutorial is a new art form. Amazing

[@ubaidshakri7987]

Great info..thank you

[@taufikismail4704]

Thank you for this awesome tutorial. I have a question. What if the respondent have to upload an image to the form which will be appear as gdrive link in spreadsheet. Then I want to show the image submitted in the PDF.

[@narendranathansk5918]

Dear Sir kindly the solution for this question. Also resize of image that need to be fit in the template.

[@julianasasantos]

Did you learn how to do that?? I need it too

[@JustinAquino]

This was awesome! Learned so much!

[@ExcelGoogleSheets]

:)

[@gamingfunforall]

very useful, as i was searching this from since many time but it seems i wasn't having option other than an add-on, but you have done a grate job brother, thanks for this video !!

[@academyonnet]

Awesome

[@pvamshikrishna3169]

Finally, script is working fine.

[@jayasri-ft8040]

I spend whole day. But failed, can you share your sources code sir

[@lasaventurasdevitoelgatoma3405]

ur channel it is going to be big in no time!! congratulations 4 the good work n sharing!!

[@hemantshinde4857]

Thank you ver much Sir. I was looking for this for a long time. I don't know the coding, but i still managed to follow the tutorial and create the mail merge as given in the tutorial. One request to you Sir, please also show how to merge the images uploaded through the forms in the doc and finally in pdf. I collect the information of my newly admitted students via google forms in which, I also collect there photos(images). So please provide next part of this tutorial in which there will be solution for merging the images in pdf. With regards.

[@PavanKumar-gg8jq]

will it be possible to create pdfLink directly from google sheets without using trigger or after form submission function? Directly to generate pdflink in the google sheet and store the generated link in the pdfLink cell.

[@elricho72]

Great Video, thank's David

[@ezzyhann]

Excellent !

[@bobykumar3960]

PRICELESS WORK ,,,,,FREE,,, THANKS A LOT

[@mohamedfazlan4074]

Thanks A lot. i Had a Small Issue ... How to Print Multiple Pages in 1 Pdf file? ( Mean Daily Entry as one PDF File or one Company invoices as one Pdf file)

[@missnorazila1742]

VERY BRILIANT !!!

[@ExcelGoogleSheets]

Thanks!

[@pedrotomasdominguezcardena9206]

Eres brillante!☆☆☆☆☆ El mejor canal de GAS☆☆☆☆☆

[@FaccinEnrico]

Wowwwww, just amazing! Thanks a lot!

[@Akash-ef4vx]

Many Many thanks.its working..

[@AndeanFace]

Hi @ExcelGoogleSheets, I hope that you are doing very well! I made the script as you presented it, and was working very well, but at the momment it seems to have two problems, and maybe you have some information about them. 1) It seems that the "Class File" from Apps Script, the method "removeFile" used at the end of the script "tempFolder.removeFile(newTempFile); " isn't anymore supported, it appears crossed over in .gs . Could you recomend other method to do the same part of the script? And my second question, I receive this message of error: "TypeError: Cannot read properties of undefined (reading 'namedValues')" on the constant declaration, line 3: "const info = e.namedValues;" in the function declaration. Do you have the seame error message? Many thanks for your help!

[@ExcelGoogleSheets]

maybe newTempFile.setTrashed(true)

[@anupriyamishra2037]

Thanks for the tutorial. Please help me knowing that if a respondent is uploading any file that appears in spreadsheet as gdrive link then I want to show that image in the pdf also. What should I do for that. Please reply.

[@iatulsinha]

I have the same question too.... Were you able to find a solution.. Thanks!

[@mustaphasaadi6093]

thanks for the video i followed all your steps but i have a probleme the PDF FILE does not get ceated only the temp file

[@camposricardo86]

Thank you so much Chi! say I want to get an image uploaded in the form, should I use the mime type 'image'?

[@MuamarRahmanto-yt7er]

we need you to remake this video with current google script and app

[@danielch8186]

Perfect bro. You helped me a lot

[@thanakornsairat8711]

i've been having an error saying Cannot read property 'namedValues' of undefined can anyone help?

[@brianashline268]

I am having the same problem.

[@jayasri-ft8040]

Did you fixed

[@calidadsed4713]

Excelente muchas gracias por su ayuda, que mi Dios lo bendiga por siempre. 🙏

[@valentinpereira810]

Thank you so much ! I have a question : When a form es edited and resubmitted. The namedvalues code only returns the modified values, there is a way to get all the values of the current row and execute the pdf creation? I Will be very grateful for your response ! Thank you !

[@VFXMonkey1]

I would really appreciate it if you could show how to add an uploaded image from the form and add it to the PDF. Can't find the solution anywhere. Thank you

[@lucasflorentinovarella7817]

Man, you are THE guy. Yhank you so much. That will change my life. hahaha. Brilliant!

[@SVBP]

its not working for my now. showing error ['First Name'] and etc., plz help me

[@mowlawn2882]

Hi! I have no training and new at this so this was perfect! Thank You! I am just having trouble with an addition. I added a column to the sheet to calculate two columns and just want to show the total on the google doc. It looks like it won't extract since it's a calculated value. Can you please tell me what script I need to accomplish this? THANKS AGAIN :)

[@richardpowell4667]

I would try to pass the dependent cells values in your sheet into the script and use the script to calculate instead, then store that in a variable. I'd have thought it could pass calculated values....?

[@ilhan_idriss]

Oh man, this makes my life easy

[@fdphy]

Thank you for this Tutorial, I had trouble deleting the temp Document. But on looking through the references the removeFile() method in tempFolder.removeFile(newTempFile); is depreciated. So all temp Documents end up on the root folder. A new way delete is rather simple, just use newTempFile.setTrashed(true);

[@ExcelGoogleSheets]

Thanks for the update!

[@Mikarevival]

Great Job!!!

[@dbclmy]

Thanks Mate! You have been a very big help.

[@eugenepaulus9946]

Thank you for these videos. I appreciate you!

[@Franklin-n4z]

How about if you have a multiple choice and checkboxes from google forms? how could I implement it in template document and generate in pdf file?

[@markestillero688]

Hi, i have encountered an error during e.namedValues. It has an error which states: TypeError: Cannot read properties of undefined (reading 'namedValues'_

[@transcendenceuniverse4816]

Me too x.x

[@traingappscript3624]

Really great video here. Thanks !

[@dr.mohammedmohammed7633]

Could you please update this vedio by new vedio... because i think the script need update or something... i try many times... please could 🙏 you update by new one

[@DerioMehra-Dr]

@Learn Google Spreadsheets I got error in line 2..... TypeError: cannot read property ‘namedValues’ of undefined ( line 2, file “code”) Need help

[@nataliariabina3227]

Thank you , its wonderful !!! Question- when I make the same form "edit response " and submit , it will fill in PDF only edited fields, not edited- will insert as blank , how do I deal with that to make them to pick up old values and fill in new PDF ?

[@valentinpereira810]

Hello, did you find a way to fix that ? I will be very grateful to you !

[@Ttnit2012]

Can this code modify for run without Form Submit - etc. run after click "RUN"

[@giancarloschafloqueguzman9918]

Awesome!!

[@19boss16]

I need help . Do you have a function that triggers a new row in the Sheet. Iam working with Wordpress and Metforms. My Workflow is Form Submit => Zapier => Data in Google Sheets. So i cant set the trigger from the Google Form, I need a trigger for a new row.

[@TinaFasulo]

Thank you, this is great! I learnt lot of things watching your video!

[@photoclerk]

Well this gives me some ideas, but it has to be SMS, and depending on the project, different messages need to be sent. Humm, looks like I'll be able to trigger those events. Film, Ship 2 Store, and Sameday....... the possibilitys are beginning to form... Could I send both a email and SMS at the same time..... or skip if I don't have a input value. I didn't know sheets was so powerful.

[@pichit.raetai]

Love this channel

[@jerisantillan]

Hi! Can you also teach how to include in the PDF an image uploaded in the form? I hope you could help me. Thank you so much for this by the way

[@VFXMonkey1]

Yes please show this, I can find it anywhere

[@obeidalotibi8420]

if you want one image for you company or logo just add it to template if you want to add it to every one for employees just upload it to folder the read it and put the seam filed i hope this helpfull

[@jonhollandWales]

can you share the script?

[@ciarajanay23]

I really appreciate your channel!

[@sadeeshanatomy4094]

Nice video, am trying step by by step it was fine. but while trying from Response sheet to PDF ; "can not read namedValues" was the error msg. hw to rectify it.

[@diagnosticoporimageneshosp970]

The best channel to learn about google sheet Question: When a form is edited and resubmitted. The namedvalues ​​code only returns the modified values, there is a way to get all the values ​​of the current row and execute the PDF creation ? thx

[@valentinpereira810]

Hi, did you find a way to fix that ? I will be very grateful to you !

[@diagnosticoporimageneshosp970]

@@valentinpereira810 Yes, const ActiveSS = SpreadsheetApp.getActiveSpreadsheet(); const ActiveSheet = ActiveSS.getActiveSheet(); const ActiveRow = e.range.getRow(); const Name = ActiveSheet.getRange('B'+ ActiveRow).getValue(); const ContactEmail = ActiveSheet.getRange('C'+ActiveRow).getValue();

[@sudamalaresorts7783]

Thank you for the tutorial, but I'm little confused how to put image has we uploaded using google form and put to templae?

[@ali5t4ir]

Thanks again - I was also wondering if send email trigger can be put in place when a cell is populated manually in google sheets - i.e. when you manually enter a test result in the cell it will trigger to populate the PDF & then it will send an email with attached PDF to the person in the row...much appreciated

[@daleramirez7438]

Thank you for this video. I learned a lot! I'm just wondering how about the google form requires to submit an image and the image will be used in google docs. I'm currently working with an Application Form that needs photo. Thank you

[@kogilan2042]

Thank you so much sir

[@fabriciosouza408]

Just awesome! That's was exactly what I needed. Thanks a lot buddy!

[@marvincubias7900]

We're you able to make it work?

[@mohamed.montaser]

i have couple of questions: 1) the " e.namedValues " will get all the data from the form? 2) can i change the variable "e" to anything else or does it have to be "e"?

[@ExcelGoogleSheets]

I think it's event, not element, but it doesn't matter.

[@longt3776]

can we as well have images upload from G form and then populate onto the PDF layout?

[@jonathanabrams5256]

Nice video, but the removeFile() method is now deprecated. Is there another way to delete the tempFile? Also, it would be great if you can create a video just like this but using Google sheet as the template instead of a Google Doc file.

[@porkypie1231]

Hi! What should I change in the code if I want to attach two pdfs. The first one being the customized one in the sheets and the other one is a uniform pdf for all?

[@jaleahmad3248]

Thanks. Couldn't be easier than this...

[@anirudhvktakkar]

Fantastic! Thanks a lot for this! I already followed along with the create bulk PDF docs tutorial, and it worked like a charm! Then came here looking for triggers to make the script run automatically. This looks very very close to what I am looking for. However, I have one question. The Google Sheet from where I am pulling data into the Google Doc and converting to PDF is not connected to a Google Form. It is actually connected to Piotnet Forms on my WordPress website. Will this script run with a formSubmit trigger if it is not connected specifically to a Google Form? If not, can you please suggest a workaround if possible?

[@sunnygumber6221]

wonderful tutorial, but I need to get an image from google form and want in PDF but not getting possible way, please suggest.

[@edwardjohn7304]

seems like the url link,pdf name for the response sheet as well as sending email is not working with Shared Drive. or did i missed out something? because once i move all the files into "MY Drive" it works flawlessly

[@MichaelDeLeon-kg7ht]

Hi, I created a script same as yours. I works and output the PDF. Im missing a code how to attach the image that I uploaded on the form and will be on the PDF. Can you help me please? Im not a coder. I just followed your instructions.

[@bokkenknuser]

This is brilliant! Thank you!