I could have sent 48 individual emails to 48 different people with 48 different pieces of information they need to know... Or I could perform a mail merge and create 48 different messages at the click of a button! And I can do this all within the G Suite environment!
Install autoCrat, the add-on available for Google Sheets here. This add-on allows you to take raw data in a spreadsheet (or collected from a Form), merge the information onto a Doc template, create personalized Docs, and email them to specific people.
The best way to learn autoCrat is to install the add-on and try it out with the sample data and letter template below. Enjoy!
- Install the autoCrat add-on
- Sample Data Spreadsheet (run and set-up autoCrat from the 'Add-ons' menu)
- Sample Letter Template (use this letter as your template)