how to export data from google sheets to a document so that I can email - similar to a mail merge

Question

Hello - This is my first time using Google sheets and forms.  Please bear with me as I describe the best I can.
I have set up 3 google form surveys on behalf of our local high school group to order student hoodies, sweatpants and parent hoodies. I can view the responses in google sheets.
I want to send an email to verify the order based on the selections in google sheets,  There are about 50+ emails to send out.  I want to make a form type of letter saying thank you insert name, for ordering a insert colour, size, options etc. that they chose and populate the blanks with the data from google sheets.
Can someone please help this volunteer band parent mom??? Would be forever grateful

--Hyde · Accepted Answer

Hi Roxanne,
 
What you are describing is a mail merge. You may want to take a look at the many mail merge add-ons. AutoCrat is a pretty decent one, and it is free. For other options, choose Add-ons > Get add-ons and search for "mail merge".
 
Cheers --Hyde