4 ms·
I have not open sourced it. I probably wouldn't go to that trouble, but I might write a good blog post illustrating it. The Google Sheet has a script associat
by michaelteter 3y ago
I have not open sourced it. I probably wouldn't go to that trouble, but I might write a good blog post illustrating it.
The Google Sheet has a script associated with a button which the sheet editor uses to "publish" the changes. That triggers a rebuild on Netlify, and the build does the sheet data fetch. This was better than automatically triggering the build on sheet save, since the save happens within a second or two of every change.
Netlify has an unpublished URL trigger to force a rebuild, and that URL requires no authentication. Thus, one must be careful about making that URL public. But worst case scenario, the free tier Netlify build credits get used up for a period.