Create a provider to consume data from Google Sheets inside Insights for ArcGIS
git clone https://github.com/ArcGIS/google-sheets-provider.git
npm start you should see something like this:
> node server.jsinfo: registered output: Geoservices 1.1.1No root directory was specified, defaulting to: /Users/foobar/koop/providers/google-sheetsinfo: registered filesystem: localfs 1.1.1info: registered provider: googlesheets 1.0.0Koop Trimet Provider listening on 3000For more docs visit: https://koopjs.github.io/docs/specs/provider/To find providers visit: https://www.npmjs.com/search?q=koop+providerTry it out in your browswer: http://localhost:3000/googlesheets/1JlPaiuIHXmkfpLBaQdoRixPSasjX5NlDte70pyFT9yI/Park%20Cleanup!A1:H/FeatureServer/0/queryOr on the command line: curl --silent http://localhost:3000/googlesheets/1JlPaiuIHXmkfpLBaQdoRixPSasjX5NlDte70pyFT9yI/Park%20Cleanup!A1:H/FeatureServer/0/query?returnCountOnly=truePress control + c to exit
You have 3 deployment options.
Option 1 - This is a good option if you do not have Portal for ArcGIS staged in a place for development.
nowin your terminal
Option 2 - Arrage to have NodeJS installed on your 10.5+ Portal for ArcGIS machine
Option 3 - Access a web access machine and deploy the project files
Once the Google Sheets provider is running, read below on how to bring this content into portal.
My Content -> Add Item -> From the web
ArcGIS Server Web Service
Park Cleanup, Insights, Provider
Google Sheetsand select
If you do not have the flexibility to deploy the project to a development environment, feel free to try out the sample below.