A script that updates a spreadsheet with Github task details and Pull Requests

[CritiqalPete]

Goal:

Grants and budgets require some measurability of work completed by volunteer and contract specialists for SCORES Tech projects on Github. A process that maintains this work in a spreadsheet will provide for reporting, tracking, measurement, and predicting.

Requirements:

1. The script/service should be portable to various runtime environments such as GCP, AWS, Google Workspace, and Salesforce Data Cloud
2. It should be in a common language and format, such as .py
3. The code should have some clear structure, naming, and comments that will make it easy to hand off among volunteer developers for update and enhancement
4. The output will be consumed by an LLM as well as machine learning for summary and additional modeling
5. All the available fields in a Github ticket should be included and stored an appropriate format. (CSV? Spreadsheet?)
6. Maintainting a uinique ID if there is one, will enable lifecycle tracking
7. Date and Time should be in different fields/columns
8. Updates should append, ideally, or allow for simple uniform extension of the data store. If new fields are added, this should naturally extend the record and still provide for historical comparison

Considerations:

• there may be graphics. The link should be handled/formed in a way that provides for access
• probably will run in a controlled process and called only periodically, like nightly
• if appending to a file is an issue, such as a size limit, then a new file should be created and named usefully