API Connector for Google Sheets
Powerful, flexible data grabber to connect any API to Google Sheets
✨ 6000+ data enthusiasts started using API Connector within the past 30 days
⭐️ Free, with paid upgrade available for advanced features
🔥 Designed for spreadsheet users, no coding required
Serving 100,000+ professionals at these great organizations & many more:
Wow, importing JSON has never been easier. It’s nice to have a little GUI when working with shared docs and such since not everybody knows APIs. Also, scheduling repeated API calls is a great feature.
MATT B Information Security Officer
Awesome add-on that works perfectly! Couple of hours saved every month since I’m using it. Highly recommended for users who often deal with CSV exports from many platforms.
DIMITRI L Digital CFO
This tool is a lifesaver for our sales reporting — it saves us hours and hours. I automate our weekly reporting by connecting Google Sheets to this and then running a Tableau workbook off the automation.
LAUREN R Director of Digital Marketing
Pull API data to Google Sheets
Thousands of sites provide access to their platforms via APIs. API Connector lets you pull data from these APIs directly into your Google Sheets worksheet, without code.
Combine all your metrics
Easily view and manage data from multiple data sources in a single place. No manual exports, custom scripts, or expensive data warehouse required.
Schedule your API requests
Automate your data pulls. Set triggers to pull from APIs at hourly, daily, weekly, or monthly intervals, or use API Connector’s custom
IMPORTAPI function to refresh data even faster (every few minutes).
Reference cells in requests
Turn spreadsheet cells into variables. Achieve dynamic, code-like capabilities by basing request URLs on the cells in your sheet.
This universal API connector pulls data into Google Sheets from any platform that uses API keys for authorization and returns data in JSON, XML, or CSV format. This opens up access to nearly any platform, e.g. CoinMarketCap, Facebook, Shopify, Asana, YouTube, OpenWeatherMap, etc.
Made specifically for reporting and spreadsheets. Includes spreadsheets-first features like append vs. overwrite modes and building API requests based on the value in a cell. Choose between 4 different conversion methods to flatten and convert JSON responses into a tabular format for Google Sheets.
The free version of API Connector enables up to eight daily API requests, while the paid versions allow more requests, scheduling, pagination handling, filtering, OAuth2 connections, and additional power features. Please view the pricing page for more details.