API Connector for Sheets 2.0
Pull API data directly into Google Sheets. No code required.
Start new thread

API Connector - Import API data directly into Google Sheets

by•
API Connector is a Google Sheets add-on that extracts data from APIs directly into Google Sheets. No coding required! Just enter the request URL and API key to connect and view API responses in a spreadsheet.

Add a comment

Replies

Best
This is super cool and useful , well done! I just tried it out with the Bitmex public API and it worked perfectly. I built a custom Excel Add-in to do something similar a few years ago and it was such a headache. I think this is such a common problem and as another commenter said, an invaluable addition to the nocode toolset. I was also looking for how to do a query based on cell contents and saw your reply linking to a page from your docs. I think you should definitely put that in your FAQ because that opens up the universe of things you can build without code even more. All the best for your launch!
Maker
Wow, I never knew there was an Excel Add-in for this function. Do you have a link? And thank you for the suggestion to improve the FAQ.
the Excel add-in I wrote was custom to pull data from a specific financial data API back when I was working as a quant in asset management. I'm not sure if there's a generic API Connector style add-in for Excel (but if there isn't, there should be!). I used a a great free framework called Excel-DNA to create my add-in using C# and it was surprisingly easy :)
Does this addon work for SOAP Calls?
Maker
hey Mark! No, it only works with JSON.
First
Previous
12