How to get google sheets API to work Go to google APIs IN A NON SCHOOL GOOGLE ACCOUNT Create a new project enable google sheets api enable google drive api create a service account add the service account email to the google sheet Create a json key download and put key in folder