Spreadsheet not found using service_account_file

Asked Sep 04 '18 at 05:33

Active Nov 25 '22 at 08:26

Viewed 2,988 times

Hi I plan to deploy an app that would log to spreadsheets. I used the PyGSheets.

I get a raise.

raise SpreadsheetNotFound('Could not find a spreadsheet with title %s.' % title)
pygsheets.exceptions.SpreadsheetNotFound: Could not find a spreadsheet with title RSSI Spreadsheet.

after I used to authorize using service_account_file

gc = pygsheets.authorize(service_account_file='something.json')

But it works with

gc = pygsheets.authorize(client_secret='client_secret_something.json')

I would want to use the service_account_file so that it would pass authorization process.

asked Sep 04 '18 at 05:33

Nikko

1,410
1
22
49

6

if you are using service account make sure to share the sheet with that account. only then you can access then. – Nithin Sep 04 '18 at 06:00
1

also what do you mean by pass the authorization process? – Nithin Sep 04 '18 at 06:01
When you use the client_secret, it will generate some keys then need to copy and paste it. – Nikko Sep 04 '18 at 06:34
Hey it worked, thanks! I shared it with the client email. Thanks! – Nikko Sep 04 '18 at 06:39

Spreadsheet not found using service_account_file

0 Answers0