Hi, I have remixed a Leaflet map and extended the app with a dropdown that will eventually contain categories of markers for the map. Now I want to read data from a live Google Spreadsheet by passing values from the sheet into an array in a JS file in Glitch.
To get the data into the app on Glitch, I am attempting to use this sample script .
To get PHP working with Glitch, I set up Composer using the console and that has worked. However, I am unsure where to take it from there. Is there a way to create and run a php script, and then read from that into the JS file? Or is this not something that is possible?
I also tried SpreadsheetGlitchMe but I get an error
“Site didn’t respond
Something in the code caused it to close the connection before providing a response.”
Although this might have something to do with current issues affecting Glitch’s API!