search

move-coop / parsons

A python library of connectors for the progressive community.
https://www.parsonsproject.org/
Other
260 stars 131 forks source link

[Bug] Google Sheets initiation instructions insufficient #781

Closed elyse-weiss closed 1 year ago

elyse-weiss commented 1 year ago

Detailed Description

The Google Sheets section includes direction on creating a service account. There is a key piece of information missing! The service account created -- [text]@[project].iam.gserviceaccount.com -- needs to be shared on any Google Sheets or Google Drive Folders being interacted with.

Priority

High! I couldn't figure this out without asking others.

ethyoo commented 1 year ago

Does changing the code to automatically share a newly created file with the service account make sense?

We can get the service account's address with credentials_dict['client_email']

elyse-weiss commented 1 year ago

Sure! I think that would work.

jburchard commented 1 year ago

While that would be cool solution, in my experience, the sheet/file might already before the script is written. I would suggest also or only updating the documentation.