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

API Connector - Import API data directly into Google Sheets

by
API Connector for Sheets 2.0
•
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
Alex Conway
This is super cool and useful @a_kravitz, 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!
Ana Kravitz
Maker
@alxcnwy 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.
Alex Conway
@a_kravitz 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 :) https://excel-dna.net/
Mark Palmer
Does this addon work for SOAP Calls?
Ana Kravitz
Maker
@mark_palmer hey Mark! No, it only works with JSON.
First
Previous
12