3 ms·
Have you open sourced this or found a similar project? Does it make an API guy to the google sheets api client side to populate the data, if so is there a cach
by moneywoes 3y ago
Have you open sourced this or found a similar project?
Does it make an API guy to the google sheets api client side to populate the data, if so is there a caching layer or does each client get a fresh copy.
- havnagiggle 3y agoI assume it's a hook to rebuild on changes and data is statically embedded during build. Happy to also see the details of OP's work. Sounds great!
- michaelteter 3y agoI 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.