Pretty neat. I'm assuming you cache the results from the google sheet and update them when the google sheet is updated?
Another idea. Would be to have a "under maintenance" flag you could mark in the google sheet and then only the updates would happen on a secondary test site. When you are satisfied with the results you can change the flag to go live.
The initial version did not cache indeed. On each request, the Google Sheet API was hit. I changed that with today's release and the sheet is cached (shared cache). To update the site, just append ?refresh=true to the URL.
I like your idea of a kind of staging system. Have to think about how to solve that.
6 comments
[ 2.3 ms ] story [ 15.7 ms ] threadAnother idea. Would be to have a "under maintenance" flag you could mark in the google sheet and then only the updates would happen on a secondary test site. When you are satisfied with the results you can change the flag to go live.
The initial version did not cache indeed. On each request, the Google Sheet API was hit. I changed that with today's release and the sheet is cached (shared cache). To update the site, just append ?refresh=true to the URL.
I like your idea of a kind of staging system. Have to think about how to solve that.