Autofill Google Doc Template from Google Sheets | Google Apps Script
Вставка
- Опубліковано 27 лис 2024
- In this video, we have demonstrated the automated way of converting Google Sheets into Google Docs and Word documents. We have done this with the help of Google Apps Script. The information of the Google Sheets will be properly formatted in the Docs.
✅ Use Updated Version of Autofill data from sheet to doc, you need to replace only your doc id and sheet name in this.
☛ Video Link: ✅ • Autofill Document & In...
🚀 Download Script: DOWNLOAD LINK IS AT BOTTOM OF THIS PAGE - AT BLOG
☛www.outrightcr...
To watch all the interesting Google Sheet videos in a playlist: • Free Google Apps Scrip...
✉: Sharma.mohit@outrightcrm.com
Send free message from google sheet to WhatsApp.
Video URL: • Send WhatsApp Message ...
👉 𝐅𝐨𝐫 𝐋𝐚𝐭𝐞𝐬𝐭 𝐔𝐩𝐝𝐚𝐭𝐞𝐬 𝐅𝐨𝐥𝐥𝐨𝐰 𝐔𝐬:
𝐕𝐢𝐬𝐢𝐭 𝐨𝐮𝐫 𝐬𝐭𝐨𝐫𝐞: store.outright...
𝐅𝐚𝐜𝐞𝐛𝐨𝐨𝐤: / outrightstore
𝐋𝐢𝐧𝐤𝐞𝐝𝐈𝐧: / outright-store
𝐓𝐰𝐢𝐭𝐭𝐞𝐫: / outrightstore
𝐏𝐢𝐧𝐭𝐞𝐫𝐞𝐬𝐭: / outrightstore
𝐈𝐧𝐬𝐭𝐚𝐠𝐫𝐚𝐦: / outrightstore
𝐓𝐡𝐚𝐧𝐤𝐬 𝐅𝐨𝐫 𝐖𝐚𝐭𝐜𝐡𝐢𝐧𝐠. Don't Forget To "𝐒𝐔𝐁𝐒𝐂𝐑𝐈𝐁𝐄" 🔔 @outrightsystems
#googledocs #googleappsscript #javascript #appsscript #googlesheets . For More Videos Stay Tune
Is it possible to add custom formatting for the google docs? Example, if the field in excel is 'TRUE', then TRUE will be merged on docs with green font. But if it 'FALSE', then it will be merged with red font. I have been finding for such functions in app script, but I cannot find the function for google docs
This is exactly what I was looking for. This will be very helpful for automating a lot of communications we have with our clients. Thank you!
• "Thank you for your wonderful comment! 😊 Your support keeps us going. If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
• store.outrightcrm.com.
• Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
• Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
Just requested for the script, this is a great solution guys. Well done at Outright!!
Thanks for watching! Please like and subscribe to our UA-cam channel.
Thank you for posting this. I am waiting for approval to access the script.
Thanks for Watching!
Approved.
This is exactly what I needed! Can't wait to get my access request approved!
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!""""
@@OutrightSystems may i request for the script?
Great! It is really helpful and practical.
I am trying to use a template document that has two images in the background, but when I put that file ID, a message appears saying that the file is inaccessible. Can it be due to the images? Thanks in advance
"If you send me the template and a screenshot of the error to promotion@outrightcrm.com, then I can help you.
@@OutrightSystems great, thanks for the quick reply. I will
:D
Very easy to follow instructions. Loved it. Can't wait to get the access request approved.
Thanks for watching! Please like and subscribe to our UA-cam channel
@@OutrightSystems Of course, subscribed. Can you please approve our request for access to your app script?
"Your request has been approved.
@@OutrightSystems Thank you so much for approving and it is working. Loving it. I have one request though. Your Google app script works for one column and several rows but can you help us with a Google app script that can be used for multiple columns and multiple rows to auto fill the Google doc from Google sheets data?
Thank you so much for this video, This is what I have been looking for, now I'm waiting for my approval.
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!""""
this is exactly what I was looking for! Thank you so much! Waiting for the access approval. Thank you again!
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
Can you share me the code
finally! this is exactly what I was looking for! Thank you so much! Waiting for the access approval. Thank you again!
Thanks for watching.
Approved!
@@JessMyers-b4q what do you mean "waiting for the access approval"? Is this code sending personal information to their system? Can you please explain?
Happy to find this video. Hope I'll be given access to your script.
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
Its Cool Tutorials, it solve my Problem, Loved it. Subscribed and Liked , Can't wait to get the access request approved.
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!""""
Thank you, what I want to start by the 3rd row not the 2nd? & What if I want to retrieve a specific row only? Each time I click on createNewDoc, it recreates the docs all over.
would be nice if there was a way to retrive data from the selected row... i am also searching for a solution
@@AramArsenyan35 so for i generate the document, copy the rows to another sheet & go on.
Thank God I found this video on UA-cam! really help my job easier and quicker. Waiting for you access approval. Thank you!
Thanks for watching.
Approved!
Hi, thanks for this helpful tutorial. Just wondering if you can help with multiple document autofill? I have 4 template google docs and like to autofill them according to google sheet data. Please help. thank you!
"Thank you for your wonderful comment! 😊 Your support keeps us going. If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
Thank you. Will make life much easier!
Thanks for watching.
Bahut achcha hai bhai
Thank you for the script... Is there a way to call images within a cell with the curly braces? I am trying to create a quote template with our product images.
Amazing info! thank you so much! Access request sent
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!""""
was amazing by the way! goog job!
Thanks for watching.
So growing fast
Nice sharing..
This is very useful and helpful. Thank you so much. I will share your content..❤
Thanks for watching!
"Thank you for your wonderful comment! 😊 Your support keeps us going. If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
Thanks for the video! I downloaded the script but it is in "var" and not in "const", I got the error "TypeError: Cannot read properties of null (reading 'getDataRange')"
same issue
same
This is the code used in the video:
function onOpen() {
const ui= SpreadsheetApp.getUi();
const menu = ui.createMenu('AutoFill Docs');
menu.addItem('Create New Docs', 'createNewGoogleDocs')
menu.addToUi();
}
function createNewGoogleDocs(){
const googleDocTemplate = DriveApp.getFileById('your doc file id');
const destinationFolder = DriveApp.getFolderById('your drive folder id');
const sheet = SpreadsheetApp
.getActiveSpreadsheet()
.getSheetByName('your sheet name')
const rows = sheet.getDataRange().getValues();
rows.forEach(function(row, index) {
if (index === 0) return;
if (row[5]) return;
const copy = googleDocTemplate.makeCopy(`${row[1]}, ${row[0]}) `, destinationFolder);
const doc = DocumentApp.openById(copy.getId())
const body = doc.getBody();
body.replaceText('{{Field 1}}', row[0]);
body.replaceText('{{Field 2}}', row[1]);
doc.saveAndClose();
const url = doc.getUrl();
sheet.getRange (index + 1, 2).setValue(url)
})}
Very good informative video
My "scripts" is failing and said "bad request"... this is frustrating...
Hi,
If you encountered a "bad request" error, it could be due to various reasons, such as incorrect IDs for the template file or destination folder, insufficient permissions, or issues with the spreadsheet data.
For real 😢
Hi i just got it to work here for me, if you still need help i can try to help you
Thanks . Save many time for me . Waiting Google Doc Access . thanks
Hi,
Thanks for watching!
Approved!
Hi
Great video!
How do you do it with multiple tables in the same sheet, some of them with the same headers name?
Awesome vid, just requested access now!
Thanks for watching!
Approved!
Really helpful, good job!👍
Thanks for watching.
thank you for this helpful tutorial, waiting for approval :)
Thanks for watching.
Approved!
This is very helpful! Please share the whole script if possible. Thank you!
The script is provided in the video description. Please visit the blog link and copy it.
Awesome 👍
Thanks for the script, it works great only few things to highlight, I am not able to get the document link back in spreadsheet and the document created by the script you have shared is a PDF document and not a word document.
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
Good information
Very informative
Thank you but it first function say after Run - "Exception: Cannot call SpreadsheetApp.getUi() from this context." What is wrong with it?
I had the same issue
Keep it up 🔥💚
Great 👍
Excellent 👍
Nice work!! I have just ask for the script, amazing.
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
Bro can you share the script with me please
ask them, the took 2 days but they send me@@groovyyvibe6440
Can't access download script link from your bio
Hi Jesse, Thanks for reaching out we mentioned the script access on UA-cam Description, also you can click here and get script.
docs.google.com/document/d/1JFtSBbmna0D_ehYHPTDyiS5pWDA7m2xjPF7dXlMfBUc/edit?usp=sharing
It's Very useful!
Thanks for watching!
Amazing! been looking for something like this for so long!
waiting for the access approval
Thanks for watching!
Approved
Hey can you give me the code
So if you are generating 200 reports, it will be in 200 different Google documents?
yes
Thanks for watching! Please like and subscribe to our UA-cam channel
Very good video
Amazing
i dont have the extensions options and cant find app script, is this option gone now?
Hi Griffin, Thanks for reaching out we mentioned the script access on UA-cam Description, also you can click here and get script.
docs.google.com/document/d/1JFtSBbmna0D_ehYHPTDyiS5pWDA7m2xjPF7dXlMfBUc/edit?usp=sharing
Hi! Looking forward to trying this. May I get access to the script? Thanks!
"
""Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!""""
"""
Excellent ☺️
Hi there, thank you for the great video and all your supports! I need your help to create all info into one google docs in different pages. How do we do it?
"Hi, thanks for watching! Please like and subscribe to our UA-cam channel." "If you want the solution, please DM me at promotion@outrightcrm.com.
I have an urgent question. Hope u could answer this for me soon.
I have several different templates for the google document to be filled so how do I select a specific document out of it rather than a common document?
Hi, do one function by document :)
Nice
Thanks for the script.. I have requested on it too
It's awesome to have you as a viewer of my content!
Approved!
how to get data spreadsheet with formating currency to google Doc? ?
i try
Sting,(row[ ]) not change
Can u pls tell me how to set autocorrect option in Excel same I want in Google sheet for example I set the whole Google sheet the word cnc that means call not ans, so when I type cnc and hit enter it convert in call not ans as prescribed by me. Pls help me it possible in Ms Excel. I don't know how to do in Google sheet. I know by apps script it's possible
"Thanks for watching! Please like and subscribe to our UA-cam channel. For your related queries, feel free to DM us at promotion@outrightcrm.com.
Keep it up
I requested access as well! I need to merge spreadsheet data with a template I created to print individual forms for a youth camp. Thanks!
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!""""
Good sir
Zbrdst
Thank you a thousand times. please approve my request so I might get benified. Thanks a million times you saved a lot
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!""""
This was great! I requested access :)
Thanks for watching!
Approved
very helpful
Thanks for watching! Please like and subscribe to our UA-cam channel
Полезное видео, спасибо!
Thanks for watching!
Approved
thank you for sharing this
Thanks for watching!
I am getting Reference Error: "SpreadsheetApp is not defined" why would that be? I am in incognito window inputting the code from the video. I have also requested access. Thank you!
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!""""
If you need any help, please contact us at promotion@outrightcrm.com."
Hi, thank you for this! I've also sent a request access to the document. I hope it gets approved. Thank you!
It's awesome to have you as a viewer of my content!
Approved!
I love this! Requested access, waiting approval
Extremely beneficial! Perfect timing as I'm currently working on a task that aligns with this. I've submitted a request to access the document, and if you could grant approval when time allows, it would be greatly appreciated. Thank you!
"We're thrilled you're enjoying our content! 😄 Your support keeps us motivated. Have you explored our store yet? 🛍️ We've got a fantastic range of free and paid products/services: store.outrightcrm.com.
If you find something you love, give our videos a 'Like' and subscribe for more updates. We'd also love your feedback on our Google My Business profile: [g.page/r/CR8HImMos1HTEB0/review]. Thanks for being a valued part of our community!"
great help
Execution was completed successfully but when I tried to create new docs, it did not generate a new document or a link
Please watch the video step by step. You need to create a Google Doc, fill in the folder ID and template ID, and ensure the fields in the Doc are correct. Then run the script. If you face any issues, I have an updated version of the script available to fill the Google Doc. Watch this video: ua-cam.com/video/9lPpjOu0XC8/v-deo.htmlsi=BxqS_oJiL3E3q8GR.
Amazing - waiting for the access
Thanks for watching.
Approved!
Hi!, thanks for the excelent tutorial.
Is it possible to paste a picture in the template?
I have a report where I get data from a google forms, including pictures, and I want to get the report automaticaly.
Hi @matheus,
Thanks for reaching out!
We will update latest script soon & send on your email.
very usefull.. pls grant thanks
Thanks for Watching!
Approved
Great Video~ Now I have fount what I have been waiting for. Would you mind if I ask your approval of script access?
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
I would be very grateful if you would allow me to open access to download the document script.
This will really help me in making my work easier using Google Documents and Google Spreadsheets
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
Thanks for the video. Just waiting for access to the document.
Thanks for watching.
Approved!
Hey, Can you share how to insert an image in placeholder in google doc?
If you need a custom script to insert an image in a placeholder, please send an email to promotion@outrightcrm.com with your requirements.
As per my desire. Thanks a lot. waiting for access.
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!""""
I requested access and I have liked and subscribed to your UA-cam page already. How do I go about getting access to this information?
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!""""
This looks great! and very useful! Can I have the approval? 😃😄😃😄
Thanks for watching.
Approved!
Tried this script and it doesn't work. Totally sure the values and Doc ID are correct.
The script returns this error when I run it: Exception: Invalid argument: replacement
Even worse, it generates an undefined number of copies of my doc template without replacing the placeholders. Moreover, I have only two rows in my sheet, but it generated 4 copies!
Please send video of issue at promotion@outrightcrm.com
Amazing! waiting for the access approval, thanks
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
Bro can you share that with me please
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
Hey there,
I don't know if you are still looking at the comments as the video is 1 year old, but I'd love to get access to the script! :)
Thanks for watching! Please like and subscribe to our UA-cam channel.
If you want to access the script, please go to the video description, open the link, click on the "Access Script" button, then wait a few minutes to automatically receive the document in your email.
Waoo imazing
Hi! Could you please approve access to the script? Thanks!
Done!
Can't access download script link from bio
Hi, Thanks for reaching out to us!
Please use this link: docs.google.com/document/d/1JFtSBbmna0D_ehYHPTDyiS5pWDA7m2xjPF7dXlMfBUc/edit?usp=sharing
I'm trying to autofill Google doc from a Excel sheet. Luckily, I found this video. Could you please approve the access request.
I do not see the "extensions" tab in Google Sheets. Any alternate solution/step would be highly appreciated.
Try opening in PC. 👍
Fine
Is there a way to make the script run without saving the doc to google drive?
Yes You can create and run a Google Apps Script directly from the Apps Script editor by visiting script.google.com and clicking "Start Scripting."
It's Very useful!
helped a lot. ive requested to access the full code. it would be great if you allow us to use this. thank you!
Hi, Thanks for your request, Your request has been approved. If you feel that script helps you and If you haven't already, please 'Like' our video and subscribe for more exciting content. Your subscription means a lot! Explore our store for a variety of free and paid products/services:
store.outrightcrm.com.
Lastly, share your thoughts on our Google My Business profile: g.page/r/CR8HImMos1HTEB0/review.
Your review helps us improve and serve you better. Thanks for being an essential part of our journey!"
Outright Systems
Awesome video. Waiting for approval on the script
Thanks for watching.
Approved!
Thank you! I have requested access!
Thanks for watching.
Approved!
Very Useful Video, kindly approve the access :)
Thanks for watching!
Approved
line 3 const menu = ui.createAddonmenu. Dont work for me at all.. There is no such function it says..
Please send a screenshot or video to promotion@outrightcrm.com.
Please replace line 3 with
const menu = ui.createMenu('AutoFill Docs');
thanks
Thanks for watching! Please like and subscribe to our UA-cam channel
oh my, this is awesome! can i have the script too? i'm waiting for approval!
Thanks for watching.
Approved!
This is really cool please approve my access!
Thanks for watching.
Approved!