Custom Authentication Using Google Sheets Data

I need help in creating a login page that will read data from google sheet and after authentication load that view which his/her user role supports. please can anyone help me out?? :worried:

Hi Abhi,

Why are you using Google sheets as your user table? I’d suggest using Appsmith’s login system instead.
If you’d still like to do custom authentication, we’ve written a doc on custom authentication here: How to implement custom authentication on Appsmith - Appsmith