Thank you for the incredible tutorial. It was very easy to follow and helped someone like myself, who had never coded with Apps Scripts, to get a sense of how the language works and be able to personalize my script for my intended application. I've already build off of your script to automate the filling of multiple documents at the clinic I work at, which will dramatically decrease the burden on our doctors and nurses, and allow them overall more time to focus on patient care. Thank you for helping us make that difference!

Thank you so much for this tutorial! It is so much easier to understand and adapt to different situations when you take the time to explain what every line does instead of just importing a pile of code from some website.

This script was FANTASTIC! I used it to create a hundred individual data forms from a Google Sheet with nearly 100 individual data points. Thank you!!

How come this guy only has 2.2k followers? Doing such a great job sharing this type of content so carefully so anybody just stepping in this would be able to understand? thank you So much man!! God bless you!

This tutorial really helped my company save time and mistakes on filling out paperwork. The autofill feature we created with this, and his "Adding Custom Menus" video took some tinkering, but we got it to work, and everyone's delighted at this low cost, low maintenance solution. Thank you Jeff!

@jeffeverhart

Ай бұрын

Thanks for the kind words and thanks for watching!

I just started a role at a new company and docs and sheets are a major part of the workflow. This gives me a great quick way to automate things without standing up a full Python or Node.js application to do it.

You are incredible. I was trying for so many days. I have no coding knowledge but just a determination to solve a problem we had. Thank you!!

Thanks Jeff. This will come really handy for us. 1. Data collected through google form. 2. Data dumps into spreadsheet 3. Use this script to create a letter for sending out to clients

That is actually a very good tutorial! I first watched a crappy one called "Autofill Google Doc Template from Google Sheets | Google Apps Script" from the channel Outright System... The guy just stole your code, without even giving you credit, and pasted it without any explanation! Some people have no shame and are awful educators, really. But thank YOU for the great explanation and time you took to actually teach us!

This is just what I need! Hopefully I can execute this on my own template, I don’t really understand any programming language but I’ve surviving by copying codes out of tutorials and browsing the net. Thank you so much for sharing your knowledge!

@jeffeverhart

3 жыл бұрын

Awesome! Thanks for watching

Amazing video ! Allowed me to create 10 docs for a client that usually takes me 20 minutes each to create. Thanks so much Jeff 😍

This is exactly what I was missing in my function..... grabbing the link to the created Doc and posting it back to the spreadsheet. Thanks again.

@jeffeverhart

3 жыл бұрын

Awesome, glad part of that was helpful to you! Thanks for watching

This was so helpful!! Thank you - I created a merge doc weeks ago and went back to your website to find out about formatting (currency)... and found the answer in you FAQ! Massive help - thank you!

Your tutorials are excellent, you do a great job of explaining as you go along. I originally used your prior video, "Auto Fill Google Doc from Google Form Using Google Apps Script," but found on occasion it would fail to generate the doc, without explanation (i.e. someone submits a form, it goes to the spreadsheet, but the doc just doesn't happen.) The method you demo here allowed me to set up a manual workaround for those occurrences.

Amazing tutorial! You made this so simple to follow and understand. This will save me an unbelievable amount of time creating ICAs. Thank you so much.

Thank you so much for taking the time with these tutorials. Very straight to the point and an easy steps. It's really helping me a lot with my business automations! THANK YOU!

@jeffeverhart

3 жыл бұрын

Thanks for watching!!!

Thank you for a great tutorial. This is going to save me and my husband so much time with filling out legal documents for our real estate business. I am a complete novice when it comes to coding, but this was very easy to follow and understand. The only thing I had a problem with was an error saying that the document was inaccessible. But, I realized that I had been using a .docx (Microsoft Word) document and that google docs didn’t recognize it within the code, even though it could open the file and edit it. Just thought I’d mention that in case anyone else had the same problem.

@user-ce5jq2qi3l

2 жыл бұрын

is it just me or the 'real estate business' part is tmi

@gradinitaamicusjunior

2 жыл бұрын

Thank you for the hint about docx, we have tried days to solve this.

Excellent class, we added an extra menu item and function for that item on the menu. Thank you so much, it was such a pleasure to learning with you.

You just saved myself and a handful of my colleagues hours of work. THANK YOU for this tutorial!!!

@jeffeverhart

Жыл бұрын

Glad I could help!

Thanks so, so much for this. I'm just dipping my toes into coding and wouldn't have been able to do this sort of thing without your helpful, clear instructions and provision of the template! I made some mistakes in my version of it, but because I was able to rewatch your tutorial, I learned not only what I did wrong, but how to identify where in the code the mistake was made.

@jeffeverhart

2 жыл бұрын

Awesome, glad this was a helpful resource. Best of luck -JE

You, Are, The, Best! Couple adjustments and it works FLAWLESSLY for my use case!

Thank you so much for the video! I have never coded anything before, and I was able to follow your steps and create a huge time-saver for our school's secretary. I appreciated how you explained everything so clearly - it really helped me understand what I was doing and also helped me find mistakes when the errors popped up. :)

@jeffeverhart

2 жыл бұрын

Thanks for the kind words! Glad it helped you out and got you started.

You just saved a whole lot of time to lots of people including me, brilliant tutorial!

They've shuffled some of the buttons around, but this still works like a charm. Well done, and good show!

The UI in Google Sheets is slightly updated from when this was recorded, but even with my rudimentary coding knowledge I was able to modify this to work. THANK YOU, this is amazing.

@moving2fast2

Жыл бұрын

​ @Jeff Everhart out of curiosity, is there a way to use template literals to have the scrip generate a new folder, and store the document in that folder?

@moving2fast2

Жыл бұрын

Update: Yes, there is! I fed the script to ChatGPT and asked if it could modify to generate a new folder. I can share if anyone wants

@jeffeverhart

Жыл бұрын

Oh wow, that's pretty cool

@karinalsaravia-butler4227

3 ай бұрын

@@moving2fast2 Please do share!

This video is the best! you explained it so well. I needed to add a few more pieces to my code. Having gone into this with no idea how to use AppScript did not matter! This video pointed out to me in the right way to ask my questions online and I was able to get everything to work! Thank you Jeff!

@jeffeverhart

Жыл бұрын

Awesome, that is great to hear. Cheers -Jeff

Thank you SO MUCH!!! It's so hard to find good tutorials on Google App Script.

Thank you so much for sharing this, and for the accurate explanation. It was super usefull to me 3 years after you originally posted it. Thanks! :)

This is AMAZING. not only do i understand the what, but I also understand the why. You are a great instructor.

Best code I found to perform this function! Elegant, to the point and handles spreadsheets with hundreds of rows (the known google bug issue notwithstanding). Thank you so much :D

@jeffeverhart

2 жыл бұрын

Thanks for the kind words and thanks for watching _ JE

Wonderful tutorial. Thank you. So helpful. Worked first time without an issue (miraculously!)

thank you! you really put in the effort to explain everything so that beginners like me can understand the reasoning behind each line and therefore customize the script later on.

@jeffeverhart

Ай бұрын

Thanks for the kind words

Thank you so much. Concise, clear and competent instructions! A great contrast to a lot of other help out here. It's helped me sort out a formatting issue for an online form. What I would really love is to email the resulting doc (form submission output file) as a PDF to myself/my colleague. I have not been able to resolve the variable for the output filename... thanks for any help you are able to give.

@jeffeverhart

3 жыл бұрын

You can find an example of that here: jeffreyeverhart.com/2015/01/30/tech-tip-google-forms-confirmation-email-with-attachments/

this is awesome and very easy to follow. what a gap in googles suite of products that you've solved without any external apps to add in. thanks again!!

Thank you for your instructions. They are very well done. Do you have any options for how to output just the date from a cell in the month/day/year format?

Jeff, thanks so much for the tutorial. Each step is explained extremely well. I just used it to automate creating invoices for my freelance work.

@jeffeverhart

2 жыл бұрын

Great use of the script, best of luck - JE

Great tutorial and really easy to follow. Helps solve a problem I've been having 🙂 Is there coding that could be used to also automatically share (view only) the resulting doc with someone in domain if their email address was also a field in the sheet?

Thank you for this tutorial! It was very easy to follow and it did exactly what I wanted it to do.

You explanations are super clear, thank you so much for this tutorial!

@jeffeverhart

3 жыл бұрын

You're very welcome!

This absolutely awesome. Thanks for your great tutorial and this is what needed for me.

Fantastic. This script helps me save hours creating score cards for our events!

@jeffeverhart

3 жыл бұрын

Awesome! So glad I could help out, especially someone from the CF community. Best of luck with your events!

Well done man! Very nice cadence, explanations, even the error was helpful to see.

Thank you!! This is the first time i've ever done one of these! massive help so thank you

Hi Jeff, amazing video and great teaching skills. I was wondering if instead of creating google docs we are able to create PDFs named with a field and saved them to a google shared drive?

Thank you sooooooooooooooooooooooo much! This is exactly what I needed to save me hours of sending personalized letters every day!

@jeffeverhart

3 жыл бұрын

Awesome! Thanks for the kind words. Cheers, JE

This is amazing!! Thank a million. just one question, how can i have the document URL to be a 'hyperlink' instead of the long url?

Thanks a lot myannn.... It works really great... Words cant describe how happy I am. You have made my work a lot easier... Thank you so much...

This was incredibly easy to follow! Thank you so much! I have several cells that have formulas that rely on other cells. If the target cells are blank, it returns a "" or blank. This script creates documents for all of these rows. Using your tutorial, I was able to add a line of script that if the first name was blank it moves on!

@deepali8939

Жыл бұрын

Hello, Can you let me know if you've found a solution to your problem?

@allisonk1848

Жыл бұрын

I did!

@umbrellatec4646

Жыл бұрын

function criarpdf () { const ui = SpreadsheetApp.getUi(); const menu = ui.createMenu('Cria um PDF'); menu.addItem('Cria um PDF, e Envia para um E-mail', 'CriarEEnviarPDFPorEmail'); menu.addToUi(); } function CriarEEnviarPDFPorEmail () { const googleDocTemplate = DriveApp.getFileById('1Z1rHTPsl0N65oSx7ILrnzDvEhGCmnoMHInAGB0s6Ffk'); const destinationFolder = DriveApp.getFolderById('1GXbtYSVR5i4LYQWnezY84Hih4liWX4nO'); const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Data'); const rows = sheet.getDataRange().getValues(); rows.forEach(function(row, index){ if (index === 0) return; if (row[3] || row[4]) return; // verifica se já há um URL na coluna 4 ou 5 const copy = googleDocTemplate.makeCopy(`${row[1]}, ${row[0]} Employee Details`, destinationFolder); const doc = DocumentApp.openById(copy.getId()); const body = doc.getBody(); const friendlyDate = new Date(row[3]).toLocaleDateString(); // Faz as substituições usando o objeto keyIndexMap Object.keys(keyIndexMap).forEach(function(key) { body.replaceText(`{{${key}}}`, row[keyIndexMap[key]]); }); doc.saveAndClose(); const email = row[2]; const url = doc.getUrl(); sheet.getRange(index + 1, 4).setValue(url); var pdf = DriveApp.getFileById(doc.getId()).getAs(MimeType.PDF); GmailApp.sendEmail(email, "New Employee Details Document", "Please find attached your Employee Details Document", {attachments: [pdf]}); }); }

Thanks mate!! I was trying this since last so many days

Absolutely fantastic video, thank you so much! I just have one question. I have hyperlinks in one column of my spreadsheet, how can I put those in the document? I tried doing it just like your tutorial, but it replaces only the text, not its formatting (i.e. hyperlinks). Is there a workaround?

I love your tutorials

Thank you for this resource! This may be a silly question - This is my first attempt at exploring apps script or coding. Can I do this for just one row of data at a time? My spreadsheet is form responses and some of them require a template checklist of next steps for the team, but not all. It's constantly collecting responses. I do have a column that records whether or not a template needs to be generated.

Thank you so much!! Your code shaved an hour off my workload! Thank you! Thank you!

@jeffeverhart

Жыл бұрын

Awesome, glad the video helped

wow thank you so much. no joke it is now so much easier and u explained it really good.

You Legend, thank you dude!

@jeffeverhart

2 жыл бұрын

You're welcome!

Thanks so much for this easy to follow vid. i did have a question as i was hopeing to add on to this. is there a way to have it create and new sub folder in the folder named one of the cells then save the doc it is creating into that? meaning every time it created a new url and doc it is also creating a folder for that doc to go into? again thanks for the video

Thank you for the tutorial, really helpful. DO you know if there is a way to create multiple of the same table but in the same doc instead of doing it in new docs? Thanks!

That REALLY helped the school I work for. Thanks man.

@jeffeverhart

Жыл бұрын

Glad to hear it! Thanks for watching

Thank you very much for your hard work, even when I don't know programming, I love this is easy to understand. I did it for some documents a friend needed and it worked!! We will just adjust some stuff, but the initial run was a total SUCCESS!! XD

Wow, I had no clue this was possible. Thank you SO MUCH

this changed my life! thanks for the great tutorial!

@jeffeverhart

Жыл бұрын

Glad it helped!

Hi, thanks for the tutorial! Very helpful and easy to follow. I have a question: instead of text or dates, I have numbers to transfer from GSheets to GDocs. With your (wonderful) script I get numbers without format. For example I have a number in GSheets formatted as 170,000 and in GDocs it comes out as 170000. Same happens for percentanges (from 25.1% to 0.251) Is there a way to respect the original formatting? Thank you!

Awesome tip! Thanks so much for making this video. This is going to save me a ton of time.

Great video! simpel and to the point. One question, what if I have a chunk of text and tables in my template, and I want to make it appear or dissappear in the output doc based on a clickbox in the sheets docs. How would I do that? I have a template with descriptions for different services, but I need that segment of text/tables only if the service is procured. So I want to have a list of services in sheets, click on the ones the customer procures.

Thank you very much, Jeff. Your video helps a lot. Is there a way to copy 'named range' from sheets to docs?

Super helpful! and a major time saver. Thank you for creating it.

Brother, i have no words to explain my joy. You just saved me a lot of time 😘😘😘 Wherever you are i wish you all the love and joy in your life 😭😭

Jeff, this has helped me out with my business so much. thank you.

@jeffeverhart

Жыл бұрын

Awesome, thanks for watching

Thankyou, first timer and it's just perfect

Hi Jeff, great Video and it has helped me a lot. I would like to hold my data items in columns (index's) rather than rows. Is this possible?

Thank you, this help me finish one of my very critical task

unbelievably well explained...to the point, no wafsofte wafsofte chat...you´re the dude ..thanks!

Jeff, This tutorial video was great! I know nothing about coding, but I followed your video and it worked! I have one big question - in my sheet at the bottom of each column, I have a SUM function. This SUM function row will be moving further down the sheet as I add more content to the sheet. How can I prevent it from reading this row?? Thank you!

Hey, thanks for the amazing Content! I got a question, i am trying to change the destination folder to 5 diffrent folders depending on the Text that is in cell 1 - so if cell 1 says "John" then i want the File to be created in the FOlder "Documents John" if the Cell says "Lisa" hen i want the File to be created in the Folder "Documents Lisa". i got 5 Names in Total - so 5 Folders in Total. I guess i need to do it with an "if" statement, but i dont get it to work..

your tutorial is very helpful to me, thanks for it. but if run twice or more it will be double/ add more files in my folder not to replace existing files. how to remove or replace the existing files without doing manually remove on my drive.

Hi Jeff Thanks for the tutorial Is there a way I can prevent regenerating all documents every time I run the generate new form Script and only generate the new document with the recent data entered or even better if I can specify the certain document I intended to have or If possible only edit the previously generated documents and generate the newly added data rows

Thank you for a great tutorial. I have little knowledge of coding and I was able to follow.

@jeffeverhart

Жыл бұрын

Glad it helped!

Thanks, Very Helpfull. How ta make the function run Automatic when adding new data in sheet?

Thank you for the great tutorial. I was wondering if it is possible to have the filled Docs merge into a single Doc, rather a separate doc for each employee. Thanks

You can't goto tools script editor anymore, but you can type script editor in help and when you search it shows apps script editor

This is brilliant! Any chance you can add the script for when there is a choice of templates to pull on depending on a criteria specified in the form????

Thank you very much for this! it was very helpful! just one question. Is it possible to add an image to the template from the google sheet? and how would that be??

Hi Jeff. Thank you for your video - I successfully used it to auto fill a doc saving so much time. I have a question for you: is it possible to add another function for the same spreadsheet? I wrote another that is similar in the hopes of making a separate doc. I checked new project, entered the coding and it saved under “my projects”. I did get an error message and I’m wondering if it’s because I’m working off the same spreadsheet? I can’t seem to figure out whether I can use it w/the same spreadsheet and if so, how?

Awesome video! So close to what I need! Two questions if you would be so kind... How can I auto populate the column without the auto fill button and how can I email the doc link automatically to the person it should go to?

Thanks for this Jeff. I want the rows of the sheet to populate sections of a single document, not create multiple documents. Which line of code to I delete or modify so that the loop sends the data of each row to the single document?

@goon4204

2 жыл бұрын

Wanted to see if anyone could respond to this awesome question, don’t need to make so many documents.

@chickenoncsgo

Жыл бұрын

instead of trying to do that i think it would be easier to just merge all the documents you create

Hi Jeff, Thanks for this video. Super helpful. I have a question. I would also like to pull data from a second sheet on the spreadsheet. I've been working on it over the weekend and still can't seem to figure it out. Would you be able to assist?

Thanks, Jeff, this is a great tutorial - with your clear explanation of something I (as a total novice) don't understand *at all* I was able to make this work for me sheet. The sheet is made automatically from responses to a form, and your method worked a treat. The only thing I've had trouble with is following the other bits of advice I've seen in the comments about images. I have image URLs submitted as part of the form, and I get stuck trying to make these URLs show as images in the generated doc. Did anybody have success with this?

@jeffeverhart

3 жыл бұрын

Yes, someone was able to figure that out in the comments. Visit this page and search for 'replaceTextToImage' to see how it was handled: jeffreyeverhart.com/2018/09/17/auto-fill-google-doc-from-google-form-submission/

Great video! I was able to grab this code and modify it to do something similar.

Hey Jeff! thanks for the nice introduction, I am having a spread sheet with numbered cases with are separated into three categories and I would like to auto fill this sheet into three docs based on the categories. Do you know by chance any source or do you have an advice? Would appreciate the help. :D

Amazing, thank you so much. Just wondering how I can get the script to read 'all sheets' and create pdf's instead of docs from the data?

@daljitsingh850

3 жыл бұрын

sir did u find solution? if yes then please let me know

Game changer for what I need to do! Thank you!

Hi! Great tutorial! I have one question is it possible to use this to fill like 3 different templates depending on conditions from sheet?

Walking through this very slowly thank you! How do you only get a range of the data, instead of the whole sheet?

Hi there, thanks for this great tutorial! Would it be possible to create 1 doc with the template copied onto multiple pages instead of creating a separate doc for each row?

Hi Jeff, I have started my own project (as a way of learning Google apps script), love the power!! I have used your example above except modified it to modify an invoice spreadsheet template instead of a google doc. I am having trouble with an error I just recently started getting - "Exception: The starting row of the range is too small." Would you mind looking through my beginner code to help me out... sure it will be a quick fix for you?!

Thanks Jeff! It's very helpful!

It would help if you linked your completed code in the description for people to use, this is a great content/instructional video, but I do think if people saw the completed code it would lend to your channel getting more attention. Either way, thanks for the instructions!

This is really useful! Is there a way to automatically link the new pages you create back to the parent spreadsheet, so that certain columns can be filled in when the sheet for a particular row is modified?

Hello! Thanks! Your video helped a lot. I have 1 question! Why decimal coma's becomes decimal dot's after running script? In my sheets i use decimal coma's.

You magnificant beast! You helped me so much, with this video. It all worked!!!