Auto Fill Google Doc Template from Google Sheets Data Using Google Apps Script

[brunolanca]

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!

[alfred]

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!

[movingfast]

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.

[GreenMushroomForYou]

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!

[csrllf]

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!

[EcoAku]

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!

[afernandezp]

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.

[johnpauljonesgrouptv]

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

[buttercool]

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.

[samsillman]

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.

[jacqualinegrant]

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!!

[bumpersmith]

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

[ConcernedUser-zf]

This was my first dive into Google Scripts or any code for the matter. And it was a successful one!
This saved me a lot of hassle and put me on a way of Excel / Sheets skill development and put a lot of ideas into my mind about working with code.
You are truly a special kind of person for doing this, at least in my life! Thank you very much.

[hafthorkristjansson]

At this point, I'm honestly more used to your voice on 0.5x speed haha. Again, thanks so much for this tutorial, it has helped my business a lot to automate some of our systems. I'm officially crowning you as the dad of Google Sheets haha!

[believeinheroes]

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.

[sixtysystems]

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

[thirdinrev]

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!!

[kristenevans]

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

[allisonk]

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!

[andestransitllc]

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?