Usually, we use Google Forms to check the responses or to analyze the basic statistics of them. Did you know that we can use Google Forms for customer satisfaction, improve customer experience, and win prospects? We are sharing how we can use data from Google Forms to send personalized emails to the respondents.
Send personalized emails
Communicating with users who responded to the survey is a great way to improve marketing and help grow your company. Thus, we often want to send personalized emails using survey information. In that case, you can simply use Google Sheets (where your Google Forms data are saved) and SendGrid to send emails tailored to each respondent.
By linking these two applications, you can send an email through SendGrid, an email sending service, with the responder email in Google Sheets.
Tip! You can use other email solutions such as Amazon SES, Stibee, or Mailchimp instead of SendGrid.
1. Bring all information from Google Forms
Survey information in Google Forms is stored in Google Sheets. Therefore, you can check and utilize the respondent information through Google Sheets. We will bring all the information from the sheet as shown below.
2. Send individual emails to the respondents
You can send personalized emails using the data we brought from the previous step. You can use the desired information through {{ }} on Outcode.
You can see {{a.ColumnA}} written in the 'To' section below. ‘a’ refers to the previous task (Google Sheets) and ‘ColumnA’ refers to the column with emails on Google Sheets. Applying the same logic, {{a.ColumnB}} would be name of the respondents stored in the previous task. You can use all the Google Sheets data following the rule of {{task + Column}}.
Unlike regular newsletters or marketing emails, sending personalized email containing survey answers or other information shared by respondents can increase your marketing effectiveness.
& more!
If you want to send personalized emails or automate tasks using information from Google Forms or Google Sheets, get started here!