Posts

Showing posts with the label Automate Google Sheets

How To Automatically Send Email To The Respondent On Google Form Submission ?

Image
Google forms are one of the most used forms for collecting data but do you know that you can send confirmation form to the respondent on form submission and look like a professional. There are many add ons for sending the email to the respondent on form submission like  Email Notifications For Google forms but do You Know that You can  write your custom Script For sending Email to the respondent. Welcome Guys You are at Techsyapa and Today we will talk about how to write a custom script for sending emails to the respondent. As we all Know that the data entered on Google forms are stored in Google sheets, so we will automate the google sheets to send emails. So here is the step by step Procedure For Automating Google Sheets :- 1. Open the Google sheet which is linked with Google Form. 2. At the top of the Google sheet You will see a navigation bar , in navigation bar their will be a option of Tools , from Tools open script editor. Navigation bar -> Tools -> script editor...