Subscribe
Sign in
API Connector — Import API data directly into Google Sheets
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.
31
Replies
Mohit
Awesome product. Integrated an API in 2 minutes with. this. Too good to be true :)
Share
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?
@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....
@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!
@colinwinhall yep, you can do that :) Check this out for instructions: https://mixedanalytics.com/knowl...
@aaronlintz The next version will have POST support, OAuth is on the list for a future future version :)
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 :)
@alistair_holmes Yeah! I hope you build something great, let me know if I can help with anything.
@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.
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.
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.)
@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.
Can you build IFTTT integration? That would probably solve some of the challenges you have come across and would greatly expand functionality.
@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?
@krishnaprasath_s Sure, you can input your API key into API Connector within the API URL path field or in the Headers section.
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?
@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.
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?
@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.
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!
@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.
@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/
