Subscribe
Sign in
API Connector for Sheets 2.0
p/api-connector-for-sheets-2-0Pull 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 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
Colin Winhall
This is a phenomenal addition to anyone No Coder / Low Coder's toolkit! After my quick check of the website and chrome extension page I do not see any mention of pricing and/or limitations. That sounds too good to be true?
Ana Kravitz
Maker
@colinwinhall Thank you for the comment, I would love to see people use it for low/no-code projects! You can see pricing here: https://mixedanalytics.com/api-c....
Colin Winhall
@a_kravitz Very fair pricing. I may become a pro sometime soon. I have some immediate feedback though from a few quick tests I just did. Is there any way to make the api url path dynamic, such as https://a.com/v1/{CellA}/johndoe Where the value from {CellA} comes from a separate sheet's cell? This would be a must have requirement for me to REALLY make use of this. Look forward to your response!
Ana Kravitz
Maker
@colinwinhall yep, you can do that :) Check this out for instructions: https://mixedanalytics.com/knowl...
Ana Kravitz
Maker
Hi Product Hunters! I'm Ana, a freelance analytics consultant. I made this add-on after receiving a lot of client requests for spreadsheets and dashboards displaying data from platforms like Shopify, Mailchimp, Harvest, VWO, etc. This usually meant searching for an existing integration, and, if none existed (this was usually the case), either manually exporting out data or writing a custom script to extract data from the platform APIs. The API Connector greatly accelerates and simplifies the process of getting API data into Sheets. There's no code required, just enter the API URL and credentials to import API data to Sheets. It's free for basic use, with paid upgrade option available for scheduling and other features. I know spreadsheet users are super creative, so I'm excited to see what people do with this. There have been 140+ installations since I released it last week, and I have a lot of ideas for future development. Looking forward to your feedback.
Alistair Holmes (AllyCat)
This is awesome! I can edit data from the api with a sheet, can also create a mashup of multiple apis thank you @a_kravitz :)
Ana Kravitz
Maker
@alistair_holmes Yeah! I hope you build something great, let me know if I can help with anything.
Rayan Smith
I was looking for this tool.Thanks
Ana Kravitz
Maker
@ryanstweeting Awesome! Let me know if I can help with anything. And if you're interested, https://mixedanalytics.com/knowl... contains my documentation and detailed guides for accessing a bunch of popular APIs.
Scott Sheldon
Could this be used to import a device's current latitude and longitude, via Google maps API for example? (Sheets doesn't have a function for this, and Google apps script can't access it.)
Ana Kravitz
Maker
@scott_sheldon That's a very good question. Unfortunately I don't think it can because the API request comes from Google rather than your own computer. So if you enter, for example, 'http://ip-api.com/json' into the URL input field and click Run, it just returns the location information for Google LLC.
Oliver McCloud
Can you build IFTTT integration? That would probably solve some of the challenges you have come across and would greatly expand functionality.
Ana Kravitz
Maker
@olivermccloud Hi Oliver, thank you for the suggestion. IFTTT is an awesome service! However, as far as I know, IFTTT doesn't provide data themselves, they provide a protocol that enables triggers and actions based off other providers' APIs. What kind of integration do you have in mind?
Mohit
Awesome product. Integrated an API in 2 minutes with. this. Too good to be true :)
Aaron Lintz
Would love to see OAuth option for APIs like meetup now that keys are not allowed.
Ana Kravitz
Maker
@aaronlintz The next version will have POST support, OAuth is on the list for a future future version :)
Krishnaprasath S
Hi, will this work with API key?
Ana Kravitz
Maker
@krishnaprasath_s Sure, you can input your API key into API Connector within the API URL path field or in the Headers section.
Agustín Leira
Hi, great job ! I get this for my api: { "last_modified": "2019-09-01T18:46:58-04:00", "user_id": 285229582, "total_amount": 12049.62, "pending_to_review": 0, "available_balance": 9604.49, "unavailable_balance": 2445.13, "currency_id": "ARS", "tags": [], "unavailable_balance_by_reason": [], "available_balance_by_transaction_type": [] } How can I save just the "total_amount" value into the cell B2 for example?
Ana Kravitz
Maker
@agustin_leira API Connector will return the entire API response. If you only need a specific value, I suggest creating another sheet that references the cell you need.
Sama Sama Co
This is such an awesome product - thank you! I've noticed in the past few days it hasn't been wokring as well as it once did - it's much slower and keeps hanging - has something changed?
Ana Kravitz
Maker
@sama_sama_co I'm glad you like it! I wasn't aware of any performance issues, thank you for bringing this to my attention. I did make some changes recently, to enable different methods of converting JSON to tabular format. I'll send you a message.
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.