Google Tools

We are going to design a Google form. For one of the fields we are going to create a select list which shall pull content from an existing Google Spreadsheet. When the user submits data through this form, the response is first stored in another Google spreadsheet and response details are also sent to a Gmail account.

Mail merge is a process of sending emails to multiple users with personalized content. This way, we can send emails to multiple users with separate content based on their email address.