search

dbvideostriketeam / wubloader

MIT License
14 stars 6 forks source link

sheetsync: Reverse sync full events to Sheets #346

Closed ekimekim closed 2 weeks ago

ekimekim commented 11 months ago

If we use Streamlog as our source of truth, we want a way to keep Google Sheets updated with the results. This is for two reasons:

  1. So we can immediately pick it up and start working if Streamlog has critical issues
  2. So that the transfer sheet -> public sheet -> website pipeline can continue to work without changes

This should mostly just be a matter of making more columns output columns instead of inputs. However id assignment will need some work as we'll be in the unique position of having events in the DB that have no matching id on the sheet.

ekimekim commented 11 months ago

Good progress was made but back-burnering for this year's run since we're not going to use streamlog.

ekimekim commented 6 months ago

Note for future: make sure that streamlog entries with a parent have a ^ prepended in sheet to approximate the old-style caret usage