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

Support syncing from remote CSV (Google Sheets) #4

Open
patcon opened this issue Nov 15, 2024 · 2 comments
Open

Support syncing from remote CSV (Google Sheets) #4

patcon opened this issue Nov 15, 2024 · 2 comments

Comments

@patcon
Copy link
Contributor

patcon commented Nov 15, 2024

Builds on #3 :)

If building from CSV is doable, then we can add code to download the CSV from a public Google Sheet, and cofigure the starter pack / feed from that :)

This would simply involve downloading a CSV from a URL when provided, instead of looking locally in the repo.

Pros:

  • allow anyone who knows how to use Google Sheets to edit the starter pack
  • access control via google collaboration tools (very established)

Cons:

  • can't auto-detect changes, so would need to run CI on schedule, but not immediately updated (there are interesting mitigations by poking the the "workflow dispatch" endpoint in the GitHub API, but more on that in another PR ;) )
@patcon patcon changed the title Allow configuration of accounts from Google Sheet Allow configuration of accounts from remote CSV (Google Sheets) Nov 15, 2024
@patcon patcon changed the title Allow configuration of accounts from remote CSV (Google Sheets) Allow configuration from remote CSV (Google Sheets) Nov 15, 2024
@patcon patcon changed the title Allow configuration from remote CSV (Google Sheets) Support syncing from remote CSV (Google Sheets) Nov 15, 2024
@jaseemabid
Copy link
Owner

I actually started writing this code yesterday with a Google sheets backend in mind, but their auth is complicated enough that I gave up and picked a dead simple text file instead. This would be a good addition unless the code and auth setup gets a lot more complicated.

@patcon
Copy link
Contributor Author

patcon commented Nov 15, 2024

Yay! public/published sheets (there might be a difference) just allow fetching a CSV from the export url fwiw. So shouldn't need complicated google auth.

Happy to scope later

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants