Performing Mail Merge with the Google Docs API

Performing Mail Merge with the Google Docs API

Channel:
United States Google Workspace
Subscribers:
1,010,000
Published on ● Video Link: https://www.youtube.com/watch?v=536IF8lJch4


Duration: 3:47
49,706 views
313

Mail merge, having long been a feature of word processors with the help of spreadsheets or databases, is now possible with the Google Docs API. In this video, Google Developer Advocate Wesley Chun describes the flow of a mail merge system and how to use the Google Docs, Sheets, Drive, and Gmail APIs to implement one.

For the minimal mail merge sample app (mentioned in the video) → https://goo.gle/2HYkaHO

Additional resources:

Mail merge sample repo → https://goo.gle/2WKKY6R
Google Docs API overview → https://goo.gle/2X6egtp
Docs API documentation → https://goo.gle/2X6egtp
Drive API documentation → https://goo.gle/2MuU9UU
Sheets API documentation → https://goo.gle/2HZ7Qar
Spreadsheet A1 Notation → https://goo.gle/2K24cic
Gmail API documentation → https://goo.gle/2MtJdqy
Build on G Suite → https://goo.gle/2Xukq6I
Mail Merge with the Google Docs API Blog→ https://goo.gle/2KrPNeG
G Suite Dev Show → goo.gle/JpBQ40


For the latest updates, subscribe to the G Suite Channel →
https://goo.gle/GSuite


Product: Google Docs API, Apps, G Suite, GSuite, Cloud, Docs, Drive, Sheets, Gmail, API, APIs; Fullname: Wesley Chun;

#CustomizingGoogleWorkspace #DocsAPI



Other Videos By Google Workspace


2019-07-16Change default settings in Google Forms
2019-07-16Add alternative calendars in Google Calendar
2019-07-16Get notified about files in Google Drive
2019-07-16How To: Set expiration dates on files in Google Drive
2019-07-16How To: Permanently delete files from Google Drive
2019-07-16Recover a file in Google Drive
2019-07-1630 Ways Google Sheets Can Help Your Company Uncover and Share Data Insights (Next '19 Rewind)
2019-07-08How to Grow a Spreadsheet into an Application (Next '19 Rewind)
2019-07-02Make it work: Exploring the future of productivity and collaboration with Maribel Lopez
2019-06-18Manage Chrome Browser From the Cloud (Next ‘19 Rewind)
2019-06-04Performing Mail Merge with the Google Docs API
2019-05-23Bring Your Favorite Enterprise Apps to G Suite with the New G Suite Add-ons (Next ‘19 Rewind)
2019-05-22ATB Financial: Reimagining Banking with G Suite
2019-05-17Almost Anonymous: Changing the Status of our Animals
2019-05-15What's New for G Suite Admins? - Special Edition - G Suite Directories
2019-05-14What's New for G Suite Admins? - March 2019 Edition
2019-05-09A Use-Case Base, Demo-Led Approach to G Suite Security (Cloud Next '19)
2019-05-07Humpty Dumpty 2.0 30s
2019-05-07Humpty Dumpty 2.0 15s
2019-05-07Make scheduling simple with Google Calendar in G Suite
2019-05-03Upgrading your domain to the new Hangouts Chat


Tags:
variable names
mail merge
variable placeholders
form letters
generate batch of customer invoices
data source
template
placeholders
master template
copy original form letter
sheet file ID
Google Drive
Google Drive API
merge form letter
placeholder variable
replace text
email PDF
create multiple email drafts
Wesley Chun
word processors
Google Docs
drive API
G suite
Google
google developers
developers
GDS: Yes;