Autofill Google Doc template from Google Sheets, nocode with Make/Integromat.

Try a free Make(Integromat) account now: https://www.make.com/en?pc=from3mintech
Get the templates and ready made blueprint: https://businessautomated.gumroad.com...

Automate creation of business letters to your customers using Google Docs templates, Google Sheets data and Integromat.

Integromat Free plan allows you to create fully functioning automation scenarios and provides monthly renewable 1000 operations credit.

Subscribe to Business Automated for more video automation tutorials 🚀:

https://www.youtube.com/c/BusinessAut...

Are you looking for a tool to send out automated letter templates to your customers? Tired of filling out letter envelopes? With this simple Google Docs template automation you will be able to create instantly dynamic letter and envelopes for your customers.

Just place the tags with relevant information inside the Google Docs template and gather the corresponding data inside the Google Sheet documents. Finally connect both with help of Integromat ( you might also follow similar logic using Zapier, but Integromat scenarios end up being faster to build and test).

With this Google Docs template automation you can substitute some of the basic functionalities of expensive software like Formstack Documents or Panda Doc. This tutorial will help you get started with automation. This way you can see if Integromat and Google Sheets, Google Docs combination is able to cover all your business needs or if you need more complicated tools.


Details of the video:
0:00 Setting up templates in Google Docs
4:10 Starting Integromat scenario to look up rows in Google Sheets
6:30 Set up Google Docs Template module in Integromat
8:40 Formatting date in Integromat
10:27 Updating Google Sheets with feedback information
13:10 Sending Gmail notifications when new document is created

Business Automated is an independent automation consultancy. If you would like to request custom automation for your business, visit us at https://www.business-automated.com

If you like our tutorials - buy us a coffee☕: https://www.buymeacoffee.com/business
Follow us on Twitter🐦:   / bautomated  
Read more on Medium 💆‍♂️:   / business-automated  
Check out Blueprints and digital products on Gumroad 🍬🛣 : https://businessautomated.gumroad.com/

#GoogleSheets #GoogleDocs #Integromat