I'm trying to read data from a Google Sheet in my Google Drive, and keep getting an email saying my service account address couldn't be found -
I tried following 2 walk-thrus - this one and that one, which are pretty similar. In both cases I followed all steps, including creating new project, enabling Google Drive API, creating credentials (a Web Server to access Application Data, granted it a Project Role of Editor), downloading the JSON, and trying to share the sheet with the client_email in the JSON. The structure of the address also checks out - [service_account_name]@[my_project].iam.gserviceaccount.com.
I also triple checked the sheet is on the same account as my API project.
Still, I keep getting this email saying the domain can't be found, and when I try accessing the sheet in my code, I'm getting a 403 - Insufficient Permission error.
Any suggestions?