Hi! Yo can try next code
1. Make a copy https://colab.research.google.com/drive/1kRX7dcCbLzebz5piSzV-DBHp5-tzpMjH 2. Upload the credits.json to files 3. Fill form 4. Run the script 5. Send us the error Best, Alex. On Tuesday, February 18, 2020 at 8:37:39 PM UTC+3, Lucas Pereira wrote: > > Hi there! > I have a given Spreadsheet, which is shared with anyone within my company. > I have created a service account, marked it to behave as an account from my > company, even granted access to the service account email directly, and, > still, I cannot read the data in my Spreadsheet. > > May I read data from a spreadsheet in that given condition without using > OAuth? > > My use case is that I want to read data from a Spreadsheet and display it > on my site - the default embedding doesn't work for me, because I need to > user to be able to filter the data, so I'm trying to build that myself. It > the OAuth access is the only option, how would that work on a site? Each > new user would have to trigger the OAuth popup to authorize access? And, > how so, if the users would not have access to that given SpreadSheet > directly? > -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to google-spreadsheets-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/google-spreadsheets-api/3f3dcfae-ad44-4334-8a21-64a59fe300ab%40googlegroups.com.
