Send out Pre-filled Google Forms using YAMM

In one of my previous blogs, I had shown you how to create Pre-filled Google Forms using a simple Google Sheet formula. In this blog, I am going to show you how to send out pre-filled Google Forms using YAMM. If you haven't read the previous click here.

What is YAMM?

YAMM(Yet Another Mail Merge) is an easy to use Mail merge where you select a draft created in Gmail and replace all the variables from a Google Sheet. It will send automatic personalized emails to the contacts specified in the spreadsheet.

You can even do this using Google Apps Script, to know more check out the blog below.

Step1: Sample Google Sheet

The sheet that we will be using in this blog contains the following details:

  1. Roll number of the student
  2. Name of the student
  3. Division of the student
  4. Students choice on whether they want to opt for Offline school
  5. Suggestions for the school
  6. Pre-filled Google Form link created using the Google Sheet Formula
  7. Email Address of the student

Step 2: Install the Yet Another Mail Merge Add-on

Before we get into creating the draft for the email, we have to install the YAMM add-on to our Google Sheet. To install the Add-on follow these steps:

  1. Click on Add-ons and click on Get Add-ons.

2. The Google Workspace Marketplace will come upon clicking Get add-ons.

3. Search YAMM and click on the first option and then click on install

4. On clicking install, accept all the requirements and the Add-on will get added to your Google Sheet

Step3: Create your Email Draft

To create the draft, you have to follow the same steps that you follow to write an email. To create your draft, follow these steps:

  1. Go to gmail.com
  2. Click on Compose and start writing your email draft.
  3. We have to replace the variables in the draft with the data in the Google Sheet. To do that you need to specify the column names that you want to replace in the draft like this.

4. Here I have done the following:

  • Here I wanted to put the name of the student in the beginning of the email, so I put in the column name where the names are stored.
  • The same is for all the other variables that I have called in the email draft.

5. After you are done creating the draft, save and close the draft.

Step4: Send the Emails

Now that we have installed the YAMM Add-on, created the email draft, its time to send out the emails. To send out the emails, follow these steps:

  1. Go to Add-ons and click on Yet Another Mail Merge and start the mail merge.

2. On clicking Start Mail Merge, it will bring up a box where you need to put in some details.

Here you need to specify the sender name, followed by the email template that you want to use.

Now that we have added all the features that we need lets send out the emails. You can do that following:

  1. Send all the emails
  2. Schedule the emails
  3. Send a test email to check whether everything works fine.

For now we are going to go ahead and send the emails by clicking on Send 10 Emails.

Step5: Check the Emails

Here you can see on successful execution the email has been sent successfully and all the details have come in properly.

Here you can see all the details that we had specified have successfully come into the email.

Summary

In this blog we saw how to send out pre-filled Google Form links in email using the YAMM. We started out by taking a look at Google sheet, installing YAMM Add-on, creating the Email draft and in the end adding some settings and then send the emails. I hope you have understood how to send bulk emails using YAMM. You can send your feedback to aryanirani123@gmail.com.

--

--

--

Currently pursuing B Tech at MPSTME. Technical Blogger, interested in Google Workspace. Hope to remain a life long student.

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

New Ford GT: American Supercar

car upholstery cleaning

Best Budget Phablets in Singapore

Browsers Reimagined

Why platforms need fewer controls not more

The Mega-Merger

Event Recap: 8 Ignites on Tech & Society

Ted Schaer was Set to Speak at the CLM Conference on the Internet of Things in Mid-March

5 MUST Have iPhone Apps for Any Occasion

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Aryan Irani

Aryan Irani

Currently pursuing B Tech at MPSTME. Technical Blogger, interested in Google Workspace. Hope to remain a life long student.

More from Medium

Increase Website Conversion with Motion Design

Build an awesome website for free

Tic Tac Toe game using basic python tools

Bulk Create Certificates from Google Slide using FormPublisher