ministryofjustice / operations-engineering

This repository is home to the Operations Engineering's tools and utilities for managing, monitoring, and optimising software development processes at the Ministry of Justice. • This repository is defined and managed in Terraform
https://user-guide.operations-engineering.service.justice.gov.uk/
MIT License
12 stars 5 forks source link

Create Python script to pull data from Google Sheets #4137

Open andyrogers1973 opened 7 months ago

andyrogers1973 commented 7 months ago

Using the Google Sheets API it is possible to use Python to pull data out of the Support Requests spreadsheet and report the findings into the operations-engineering-team Slack channel.

This issue is to:

This will provide a convenient, clean and automated process for reporting Support Request stats. For this process to work we will require a Google Sheets API authentication token, which is being investigated first.

andyrogers1973 commented 2 weeks ago

Currently we cannot secure a license to use the API. This may change with the move to MS365, so will investigate further at a later date.