Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Update VZ_google_sheets readme for adding a new year #1067

Open
gabrielwol opened this issue Sep 9, 2024 · 0 comments · May be fixed by #1069
Open

Update VZ_google_sheets readme for adding a new year #1067

gabrielwol opened this issue Sep 9, 2024 · 0 comments · May be fixed by #1069
Assignees
Labels
Documentation Vision Zero Data sources supporting VisionZero

Comments

@gabrielwol
Copy link
Collaborator

## 4. Google Credentials
Initially, a credential file (named `key.json` in the script) was required to connect to the Google Sheets to pull data. The google account used to read the Sheets is `bdittoronto@gmail.com`. First, Google Sheets API was enabled on the google account. Then, a service account was created so that we are not prompted to sign in every single time we run the script. Instructions on how to do that can be found at [Creating a service account](https://github.com/googleapis/google-api-python-client/blob/master/docs/oauth-server.md#creating-a-service-account). Go to the `Service accounts` page from there, select the `Quickstart` project and click on the `Search for APIs and Services` bar to generate credentials. Copy the credentials and paste it on a `key.json` file located in the same directory as the script. The `key.json` file should look something like this:

  • what permissions need to be granted on sheet?
  • correct email / service account?
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Documentation Vision Zero Data sources supporting VisionZero
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants