API Connector - Import API data directly into Google Sheets

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.

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 :)

Great work @a_kravitz

I was looking for this tool.Thanks

Can you build IFTTT integration? That would probably solve some of the challenges you have come across and would greatly expand functionality.

Awesome product. Integrated an API in 2 minutes with. this. Too good to be true :)

Would love to see OAuth option for APIs like meetup now that keys are not allowed.

Hi, will this work with API key?

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?

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?