Hi Hunters! API Connector lets you easily import API data into Google Sheets, without needing a complicated data warehouse or any custom scripts. I first released it 9 months ago because my freelance clients were asking for dashboards that integrate date from all different sources.
Since then I've seen API Connector grow to more than 20,000 users, with people not just making reports but building Sheets-based no-code apps for music, SEO, crypto tracking, and all kinds of things I never imagined. One guy made a "what to wear" app for his kids by hooking it up to a weather API that fed into a Fire tablet. 🌞 Another is powering a travel website. ✈️
This edition contains tons of updates to make everything smoother and more powerful:
-a custom function to trigger and edit API calls from directly in your sheet
-faster data refreshing
-full no-code support for looping through API responses (pagination handling)
-new algorithms for flattening JSON into tabular format for Google Sheets
-POST support to push as well as pull data
-request sharing with others
-a bunch of other improvements 🔨
Best,
Ana
Shred Index
API Connector for Sheets 2.0
API Connector for Sheets 2.0