4 ms·
I was actually toying with the idea of replacing our custom-made, rather limited shop system with something entirely based on Google Sheets. We have rather low
by IAmEveryone 9y ago
I was actually toying with the idea of replacing our custom-made, rather limited shop system with something entirely based on Google Sheets.
We have rather low requirements, which is why I'm resisting existing shop systems. They all seem like overkill to me.
But from time to time, someone wants a some statistics, or needs to send emails to "everyone who bought in the last four weeks". These are trivial for me to compile in SQL, but a spreadsheet would allow others to quickly work with the data.
Unfortunately, the Sheets API at around one second per request was too slow for my tastes when I last checked it out.
- daveFNbuck 9y agoYou could always schedule regular exports of your data to sheets if you just want it to be easier for others to answer simple questions.
- tlarkworthy 9y agoI had a super slow sheet script but I found it had a batch-all-my-changes type of workaround in the API which brought it back into reasonable territory.