[FR] Draw from an external CSV source

[instantiator]

Feature request

Google Sheets can be published as CSV files, and this is a much nicer interface than asking people to edit CSV directly. Let's find a way to incorporate data from a Google Sheet or alternative external source into ListSky.

Proposed process

To do this, we'll need to:

• Add an external sources CSV URL collection to list metadata
• Add support for an additive submission form URL to list metadata
• Add a column to the local CSV files to indicate the external source a record comes from
• Periodically run an actions workflow (see: schedule)
  • Compares data from the repository CSV to external sources
  • Generate a new PR with modifications to the local CSV (add or remove)

After that, the tool can return to the existing processes to update the lists on BlueSky and publish lists.

[instantiator]

Octokit.net can probably do all this - and Github Actions provides a GITHUB_TOKEN environment variable that can be used to authorise activity.

var client = new GitHubClient(new ProductHeaderValue("ListSky"));
var tokenAuth = new Credentials(token);
client.Credentials = tokenAuth;