Replace Text in Google Docs Easily from Google Sheets Using Apps Script - Mail Merge
This tutorial walks you through how to use Google Apps Script to take text from Google Sheets, replace template tags (like name, address, etc.) in a Google Doc, and email the final result as HTML, save or email as a PDF, or save as a new Google Docs.
Make a copy of the files used here:
https://bit.ly/4d20Q7U (link to Google Doc on Google Sheet)
0:00 Introduction
0:42 Download Templates
0:58 Google Doc Setup
1:38 Google Sheets Setup
2:10 Apps Script Intro
10:30 Script Authorization
13:11 Save As Google Doc
22:09 Send as PDF
28:07 Send as HTML in Email
![Easy Automatic Last Updated Timestamp in Google Sheets [No Authorization Required]](https://images.videosashka.com/watch/i-qd8vXUoEA)
