Optimiza La Facturación Con La Plantilla De Factura De Google Sheet Para Comunicaciones Y Medios

Google sheet invoice template for Communications & Media

in this video we are going to explain to you how to automatically autofill spreadsheet data to google docs we have added all the essential details to the spreadsheet the details are all about full name address contact number and so on the document link column is still pending but it will be updated here automatically so we will open the google docs file now to show you all the variables including the template content to send to those leads let's go back to spreadsheet now and open the extensions option we will now click on apps script write the name of your project as per your choice [Music] now the next step is to write a code to create a menu item check this code that we are writing save this project after completing the code go to the run option and click on review permissions after this it will ask you to sign in from your google account accept the privacy policy and terms by going to the allow option execution is done successfully go to your spreadsheet again and refresh the page you will see the autofill docs option appear by clicking on it you will see the script function as not found open the extensions option again and click on apps script this is the whole script you can copy all code from youtube description this is google doc id copy the google docs template url and replace it here in the app script the second one is google doc folder id the second is to copy the google drive folder link and replace it the third is the spreadsheet name here you can see our sheet name you can write ing to your choice all the fields in the app script are matched save the project now tap on run and then review permissions sign in to your google account again and you can see execution has started and to spreadsheet again and tap on the autofill docs option the script function will work now and you can see the document link of every led is added automatically open the docs one by one and check all the right details added with the template information docs file of every led is added in google drive too we have deleted the docs file from the drive and also removed links from spreadsheets it is just to show you that even if you delete it you can get back those links and files once again go to autofill docs to run the script again links are appearing again and docs are back on the drive thank you for watching this video make sure to like share and subscribe [Music]