Skip to main content

Send attachments based on form answers using Google Email Form Notifications

· 2 min read

Introduction​

There are time when you want to send an attachment depending upon the response in the google form .Lets look at some of those use cases.

Use Cases for Sending Different Attachments Based on Google Form Responses​

Course Enrollment with Different Study Materials​

Scenario: A Google Form collects enrollments for different courses.Logic:

  • If a user selects "Python Programming", send Python study material (PDF).

  • If a user selects "Web Development", send HTML, CSS, and JavaScript guides (ZIP file).

  • If a user selects "Data Science", send Data Science eBook (PDF).

Customer Support with Product Manuals​

Scenario: A form collects customer issues for different products.Logic:

  • If a customer selects "Laptop Model A", send Laptop A User Manual (PDF).

  • If a customer selects "Smartphone Model X", send Smartphone X Quick Start Guide (PDF).

  • If a customer selects "Smartwatch Y", send Smartwatch Y Setup Guide (PDF).

Job Application with Position-Specific Documents​

Scenario: A company collects applications for different job roles.Logic:

  • If an applicant selects "Software Engineer", send Coding Challenge (PDF).

  • If an applicant selects "Marketing Manager", send Marketing Case Study Assignment (DOCX).

  • If an applicant selects "Graphic Designer", send Design Portfolio Guidelines (PDF).

How to send attachments in Email Notifications based on Form Answers​

You can achieve this by using the Form Notify -Email Notifications on Google Forms add-on.

  • After installing the add-on Create a New Processor
  • Opt for "HTML Editor" for Email body customization while setting up the Processor.
  • Different Attachments can be sent using the logical constructs Form Notify supports.
  • Here is a sample Logical construct to attach a Google Drive file based on Form Answers
{%codeblock%} 
{%condition%} 
var x = '{{Topic}}'; 
if(x == 'Python Programming') return true ;else return false;
{%endcondition%} 
{%result%}
<p><i><b>You have opted for Python Study Material .</b></i></p>
https://drive.google.com/file/d/1q9e00TiahpUrwxqGfVRwFncFCAAhdoNp/view?usp=drive_link
{%endresult%} 
{%endcodeblock%}

note

Please note that the Google drive files have to be shared publicly for the files to be attached successfully.