A lot of small businesses use spreadsheets as an effective DB + CRUD app, where the content of the sheet represent the current "state" of the data. An example could be a sheet full of orders, or customer queries, or current products for sale.
While running analysis on the "current" data of the sheet is easy, its very hard to see how your data changes over time as rows are added/removed and cells altered. For example, in a sheet full of customer support issues, maybe you want to see how the number of "open" tickets changes over time, to see how your queue grows / shrinks.
So I built this tool that allows you to simply select a google sheet you have access to and create trackers to monitor the columns you want to. It uses the google sheets api to poll the sheets daily, storing aggregated data in a time-series DB.
Unfortunately it requires sign-in via google for obvious reasons, but it has a free trial if you want to test it out.
Any feedback appreciated!
0 comments
—
Show HN: SheetMonitor – Track changes to Google Sheets over time · HackerTrans
While running analysis on the "current" data of the sheet is easy, its very hard to see how your data changes over time as rows are added/removed and cells altered. For example, in a sheet full of customer support issues, maybe you want to see how the number of "open" tickets changes over time, to see how your queue grows / shrinks.
So I built this tool that allows you to simply select a google sheet you have access to and create trackers to monitor the columns you want to. It uses the google sheets api to poll the sheets daily, storing aggregated data in a time-series DB.
Unfortunately it requires sign-in via google for obvious reasons, but it has a free trial if you want to test it out.
Any feedback appreciated!