# How to verify emails passwordlessly, store them in Google Sheets and redirect users to a code-prefilled Google Form? **URL:** \ **Category:** Get Help\ **Tags:** emails, google-apps, google, magic, verify-email\ **Created:** [May 18, 2017, 8:24pm UTC](https://community.auth0.com/t/how-to-verify-emails-passwordlessly-store-them-in-google-sheets-and-redirect-users-to-a-code-prefilled-google-form/6665 "2017-05-18T20:24:55Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![kalbonyan.jobs](https://upload.wikimedia.org/wikipedia/commons/thumb/7/7c/User_font_awesome.svg/768px-User_font_awesome.svg.png) [@kalbonyan.jobs](https://community.auth0.com/u/kalbonyan.jobs)\ **Post date:** [May 18, 2017, 8:24pm UTC](https://community.auth0.com/t/how-to-verify-emails-passwordlessly-store-them-in-google-sheets-and-redirect-users-to-a-code-prefilled-google-form/6665/1 "2017-05-18T20:24:55Z")
Peace and Greetings everyone, I’m not a developer and I’ve been googling a lot to find an unlimited, free, and easy away to verify emails that we collect through Google Form for a non-profit cause. I finally found Auth0 and I hope it saves us time and money! * * * We need the scenario to be like this: - We share a link on our facebook page for people who need our help. - This link leads to a page that only asks the users for their emails. - The users enter their emails and verify with magic links. - Finally, Auth0 does two things: 1. Generates unique codes and stores them in a Google Sheet, paired with the verified emails. 2. Redirects users to a Google from, prefilled with their unique codes. * * * On our side, we will make the function or the conditional formatting required between the two Google sheets to pair the verified emails with their responses based on the unique codes. As you can see, the term “Active Users” don’t apply to us, as we don’t have logins. We only want to verify emails before filling the Google Form. I wonder if we will be affected by the 7000 users limit. * * * So, the BIG question is… How can we do that with Auth0? Please, in details. Thank you in advance. ---
**Author:** ![sherbeeny](https://sea1.discourse-cdn.com/auth0/user_avatar/community.auth0.com/sherbeeny/32/7174_2.png) [@sherbeeny](https://community.auth0.com/u/sherbeeny)\ **Post date:** [May 18, 2017, 8:40pm UTC](https://community.auth0.com/t/how-to-verify-emails-passwordlessly-store-them-in-google-sheets-and-redirect-users-to-a-code-prefilled-google-form/6665/2 "2017-05-18T20:40:13Z")
I tried to follow this question, but it keeps giving a permission error! I hope this comment will make me follow the question. ---
**Author:** ![prashantT](https://sea1.discourse-cdn.com/auth0/user_avatar/community.auth0.com/prashantt/32/6002_2.png) [@prashantT](https://community.auth0.com/u/prashantT)\ **Post date:** [May 22, 2017, 11:06am UTC](https://community.auth0.com/t/how-to-verify-emails-passwordlessly-store-them-in-google-sheets-and-redirect-users-to-a-code-prefilled-google-form/6665/3 "2017-05-22T11:06:37Z")
Auth0 Passwordless features can support your ‘verification’ process for the emails, by using the magic link: > **[Passwordless Connections](https://auth0.com/docs/authenticate/passwordless)** > > Learn about passwordless connections, Auth0-supported passwordless methods of authentication, and how to implement passwordless authentication with Auth0. In order to achieve your other requirements (Google Sheets integration) you will require a developer, or some developer knowledge. As a summary: > Finally, Auth0 does two things: > > 1 Generates unique codes and stores them in a Google Sheet, paired with > the verified emails. This can be done inside a [Rule](https://auth0.com/docs/rules). Your developer will need to setup this integration, using the [Google Sheets API](https://developers.google.com/sheets/api/). You can store the unique code in `app_metadata`. > 2 Redirects users to a Google from, prefilled with their unique codes. Auth0 will redirect back to your webpage with the user’s token. Your webpage will need to extract the unique code from the `app_metadata`, and redirect to the Google form. ---
**Author:** ![system](https://global.discourse-cdn.com/auth0/original/3X/b/5/b560f266932fcce5d57f09a6595bd50518cae3f3.jpeg) [@system](https://community.auth0.com/u/system)\ **Post date:** [March 2, 2018, 5:53am UTC](https://community.auth0.com/t/how-to-verify-emails-passwordlessly-store-them-in-google-sheets-and-redirect-users-to-a-code-prefilled-google-form/6665/4 "2018-03-02T05:53:59Z")