Turning a Google Sheet into a JSON API

This topic was automatically generated from Slack. You can find the original thread here.

Dylan Sather (Pipedream) : This workflow turns any Google sheet into an array of JSON objects, returning them in the HTTP response.

Copy the workflow and it’ll generate an HTTP endpoint you can hit. Connect your Google Sheets account and enter your spreadsheet’s ID, then make an HTTP request to the workflow’s endpoint. This spreadsheet:

Screen Shot 2020-11-24 at 5.13.40 PM.png

will return this response:

[ 
    {
      "name": "Luke", "title": "Jedi"
    },
    {
      "name": "Leia", "title": "General"
    },
]