CODEWITHSUNDEEP
google-apps-scriptgoogle-sheetsgoogle-forms
rahulserver
rahulserver

Reputation: 11205

Email verification using google app script and google forms

I have a google form app which has, among others, an email id field.I want to verify that the email entered by user is the email which belongs to him. Pls note: I DO NOT WANT TO VERIFY THE DOMAIN/SYNTAX OF EMAIL. All emails would be gmail ids, so if that helps, is there a way to send a mail validation link to their gmail accounts and on clicking the link, the entry is made to spreadsheet. Else its cancelled. Also the link must be valid for limited time only.

Upvotes: 3

Views: 3046

Answers (1)

Amit Agarwal
Amit Agarwal

Reputation: 11278

Yes this is possible. You can publish a Google script as a web app and add the email address of the recipient as a query parameter to this app. When the user clicks the link, the app is called, the email is verified and the app itself can log an entry into the spreadsheet.

Upvotes: 2

Related Questions