I recently had a need for this and didn't find a solution that worked[1] for me. This is a very simple proxy service that translates JSON data into responses th

I recently had a need for this and didn't find a solution that worked[1] for me. This is a very simple proxy service that translates JSON data into responses that can be used in Google Sheets using ImportXML or ImportData functions. I've tried to make it as simple as possible to spin up your own on Heroku for free, or to try some examples in the example Sheet. [1]: The main alternative I found was using Google App Scripts to add custom functions, but the problem was the recently updated, complicated, strict, and under-documented process to allow permissions for external requests from those scripts. So I preferred to have the logic outside, and use only basic Sheets functions.