API Connector for Google Sheets

Powerful, flexible data grabber to connect any API to Google Sheets

Install for Free

✨ 3000+ 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).

UNIVERSAL

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.

SHEETS FIRST

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.

PRICING

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.