Google Forms to PDF & Email while storing data in Google Sheets
HTML-код
- Опубликовано: 22 июл 2024
- Learn how to
1.) take a Google Forms submission
2.) store it in Google Sheets spreadsheet
3.) convert the data submitted to a PDF using Google Doc template
4.) store the PDF in Google Drive and add a link to the spreadsheet
5.) email the PDF as attachment to the person that submitted the Google Form
We'll be of course using App Script.
#googleform #pdf #email
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.
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 :)
hi, do you have the code? could you please share?
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.
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
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.
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
Cool!
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!
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? 🙂
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");
You have unlocked Pandora's box of creativity for me. Thank for teaching us🙏
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.
Fantastic!
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.
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.👍🏻🙏🏻🙏🏻
Great teaching skills. Awesome tutorials!
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!
Addicted to your video. Just like daily routine. Thanks 😊
Thank you for step by step explanation
This tutorial is a new art form. Amazing
Excellent like always!!!
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?
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 !
You are an amazing teacher
Thank you, this is great! I learnt lot of things watching your video!
this is actually life changing for cheap marketers like me, thanks for the tutorial, much appreciated!
huh.. super long and fun journey. Nicely delivered!
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
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
ur channel it is going to be big in no time!! congratulations 4 the good work n sharing!!
Thank you so much Chi! say I want to get an image uploaded in the form, should I use the mime type 'image'?
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.
Great tutorial! Very useful! What changes would you do at the script if instead of Google Docs, the template was Google Slides?
thank you so much for this Video. Please keep up the good work. Much love from Vietnam!!
Thank you so much. Just an incredible tutorial.
Thank you for these videos. I appreciate you!
On Line 18 you have get file by ID. Is there any way that could be get active file instead? I have multiple documents that the user selects to use (which they select 1st) then fill in the form that i hope to get the ws to populate the pdf data
you're real life saver. Please continue making videos about these.
It’s very impressive! Thank you!
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?
Great info..thank you
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?
This is very useful video for me, Now I have one requirement that on the basis of data entered by this form I am bringing some values in additional column form restored data but I am not able to pick values of those columns using info object.
Can we do this?
Eg. I have added a dropdown of Form submitter Jhon, Mike, Cali, getting there emails id from form, but while sending emails then I want to keep their superior into copy and that I am bringing using look-up function.
But I am able to get only data submitted by the form.
that's awesome! well i do have a question , how do i replaceText in the createPDF method when i have added a column with lets say a SUM ? when the form is submitted , it inserts a row in the sheet , so i made another sheet2 with the main columns and some extras , how do I use these extra column content with the replaceText?
This is brilliant! Thank you!
Really great video here. Thanks !
I really appreciate your channel!
PRICELESS WORK ,,,,,FREE,,, THANKS A LOT
This is awesome, congrats... I have a question, do u have a tutorial to do the same, but instead a doc template using a sheet? nos using text, just the range of the sheet. Thank U!
Hello, i want to ask, how to add html body on the send email function, because i got result in email, by "object Object" in body email... Can you help ?
Awesome tutorial ♥♥♥♥♥
Eres brillante!☆☆☆☆☆ El mejor canal de GAS☆☆☆☆☆
You are incredible! Thank you so much for helping me
I enjoyed this tutorial, thank you
Great Job!!!
Awesome! Plese don't get tired of doing more videos like this! Maybe you can share the script as well? Heh. :)
Oh, i would love it too!
It much better to learn if u share script. Thanks
Great job ! Very clear . Thank you !
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
Just awesome! That's was exactly what I needed. Thanks a lot buddy!
We're you able to make it work?
Hi there, how could I create a filter by a specific date on this code? I need it weekly
i have 2 questions, how can i insert the email subject from sheet. as well as, how to make sure it is send with plain text mode?
thanks a lot
i would like to know to incorporate arrayformulas i made to the body.replaceText
it only replaceText the data coming from the Forms Answer questions..
the arrayformula i made is always left out please help me
Is there way to move the link from one tab to the other in the same spreadsheet using script 🤔? So i would not have to keep re-linking data
Great Video, thank's David
Hi eveyone, I'm George, and Im newbie in this field. I need some little help for my first script I'm trying to get working.
The problem witch I got into is that once data is collected trough the google form, the spreadsheet is building up normaly,
but for some fields I had to run an arrayformula in order to calculate some values for the entire column.
Eveything works just fine, the spreadsheet looks good, but once function (onFormsubmit) is trigered, the pdf is not
collectig data from the columns where array formula is running. So PDF is creating witch just the values witch are entered
trough the form, but not witch the ones are calculated.
Tks!!
Great video. Do you have a video on creating a pdf from the sheet you are working on and emailing that multiple people?
Thank you for your sharing. It is very helpful for set up the Google form to pdf. Is it possible to use a spreadsheet instead of a document as template? 🤔 Does this replace text functions still work on the spreadsheet?
You are amazing! You know your stuff. I like how you basically say "I'm going to do this and let's see how we do that". I noticed your permissions was causing drama to send the email. Would it be that the user of the form would have those permissions come up on their end and have to give permission too? I imagine it should be. Cheers
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 ?
Hello, did you find a way to fix that ? I will be very grateful to you !
Help please, can you enter images that the respondent captures in pdf?
Hi,
I just used this video, and I have created a proper notification system, add as many emails to notify (through google forms), and create the log with google sheets. Great stuff. Thank you, I just want to create a customized subject for my emails using the google docs {} in my template. Can that be done?
can we as well have images upload from G form and then populate onto the PDF layout?
A huuuuuuuuuuuge thumbs up!!! Thank you very much. You are a life saver.
Thanks for the Great tutorials,
can you please tell me how can I automate download the pdf file created with form data...
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 !!
Very useful, nicely done. Can you make a video of sending confirmation on form submit with results preview?
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)
Can you show how can we create a interactive RFI form (used mainly for construction sites) from a google doc so that users can interact and export to pdfs
@Learn Google Spreadsheets I got error in line 2..... TypeError: cannot read property ‘namedValues’ of undefined ( line 2, file “code”)
Need help
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.
@learn google spreadsheets one of my input from google form is image. What changes i need to do to get that image in google doc
I did this without the email part and for some reason I can’t figure out after
OpenDoc.saveAndClose();
To convert to the new copy pdf
My pdf conversion is still just a template as if the new info wasn’t populated in at all. When I check the doc in my drive after though, it is filled out properly. Any help?
This is great. How can I include more than just the e.namedValues from the form? I have other headings with calculated data in the columns to include, but namedValues does not allow me to access them.
Awesome!! I have a Question, if I have a five Photos, How do I put those images in a pdf? (in order)
Can we just fill the response sheet and generate the pdf link in People tab.
wow thaank you ... well ... the slowmo guys would be very useful here ...
I wanted the form to have uploading field of an image. How would I code this with specification to the size of the image. Is that possible ?
This was great thank you so much - it would be great if you can advise the code at the end of how we can password protect the PDF file so it can't be edited but you can print ONLY please
Excelent video as always! How about trying to switch between different document templates?
I really like this one!!!
What to do, If want to attach Temp file which is an DOC file as an second attachment?
@Learn Google Spreadsheets This was great thank you so much! - it would be great if you can advise the code at the end of how we can password protect the PDF file so it CAN'T be edited but you can ONLY print please
instead of email it , is there any way that i could automatically download the pdf ??
Thank you for the tutorial, but I'm little confused how to put image has we uploaded using google form and put to templae?
Excellent !
Amazing content! Can you please do a video with an uploading image? Exemple employers data and pic. I use gsuite files only work on my domain is that a problem to generate pdf with the pic?
Is there a script I can copy so I'm not reinventing this wheel? I'm new to this and didn't know where to look. Thanks!
Excellent
The remove(newTempFile) doesnt remove the copy folder but moves it.
Can this code modify for run without Form Submit - etc. run after click "RUN"
Thank You !!! this is really excellent, you explained it so well, could you help me to add the total value while sending the PDF responses as it's only the form info fields. (eg if the form has the MRP and quantity, can we send the total value in the PDF.
Muito bom vídeo!!!Aprendi muito com esse tutorial. Obrigado!!!!!
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!
maybe
newTempFile.setTrashed(true)