Quick demo of data sharing
There are many ways to accomplish this of course, but using Caching across multiple Apps Script and Node projects using a selection of back end platforms is pretty fast to set up. To test this, here’s a challenge that shares the data in a spreadsheet with node, set up end to end in less than 5 minutes. This example is almost exactly the same as Sharing data with Upstash between Node and Apps Script – end to example in 5 minutes except this time, instead of using Upstash (redis) – we’re going to use a Github Repo.
- Github as the back end crusher platform and get credentials
- bmPreFiddler to deal with the data in the spreadsheet
- bmcrusher-node as the node client
- scrviz to quickly find the apps script library credentials
Assume you’ve set up a github personal token for Node and either an oauth dance or the same personal token for the Apps Script side. If you want to use Oauth for Apps Script, then you’ll need an extra 5 minutes for that. For Oauth2, see Github as an Apps Script cache platform if you haven’t done that before. If you prefer you can use a Github personal access token for both Node and Apps Script, here’s how to set one up in your Github settings. You’ll need repo scope.
Create an apps script project, and find and add the necessary libraries
We can use scrviz to quickly find the library keys, which are normally a pain to find
- find and add bmCrusher
- find and add bmPreFiddler
We’re going to get a sheet from this spreadsheet that contains a bunch of stuff about the main airports worldwide.
so all we need is the spreadsheetId and the name of the sheet, get the data, and write to the upstash store.
Code for getting spreadsheet data and writing to cache
Note that the only difference between backends is how they are initialized. And that’s all there is on the Apps Script side.
I’m using a specific repo dedicated to all my crusher keys. It’s not essential, but probably best. Here’s what the repo looks like. The airports key us the one we’ve just written
The node client is even briefer, but first install the bmcrusher-node module from npm using either npm or yarn
Here’s the code
I’m picking up my github personal access code from a file, but you do whatever here to get yours.
And we’re done – in less than 5 minutes –
Of course you could process the data in some way if you want, and write it back for Apps Script to pick up, clean up the store etc.
scrviz Apps Script bmCrusher: https://scrviz.web.app?repo=brucemcpherson%2FbmCrusher
scrviz Apps Script bmPreFiddler: https://scrviz.web.app?repo=brucemcpherson%2FbmPreFiddler
github bmcrusher-node: https://github.com/brucemcpherson/bmcrusher-node