Follow the steps below to create a template that can be duplicated and used throughout your LENND event cycle to subscribe data feeds.
Step 1: Create a New Google Sheet
Step 2: Open Apps Script
In the Google Sheet menu, select:
Extensions → Apps Script
This will open the Apps Script editor in a new browser tab.
Step 3: Add the Script Code
Delete any existing text in the editor and paste in the Code.gs Code found HERE, then select the “Save” icon.
Step 5: Open Project Settings
In the left-hand menu, select Project Settings and toggle on the “Show "appsscript.json" manifest file in editor” option.
Step 7: Return to the Editor
Navigate back to the Editor tab.
Step 8: Add the appsscript.json code
Select the appsscript.json tab.Delete any pre-populated code and replace it with the appsscript.json code found HERE and then select “save”
Step 11: Refresh the Google Sheet
Return to your Google Sheet and refresh the browser page.
Your Google Sheet is now configured as a reusable JSON/XML feed template that can be duplicated for any LENND dashboard view.
Connecting a LENND Feed
In your duplicated sheet:
Paste the desired LENND XML or JSON feed URL into cell A1
Use the Feed Connector dropdown menu to:
Run a manual sync, or
Enable 1-minute auto-sync to keep data live and continuously updated