API Connector for Google Sheets lets you access API data from thousands of platforms directly within your worksheet. No coding required!
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.
Wow, importing JSON has never been easier. It's nice to a 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.
Get API data from thousands of data sources
Thousands of sites provide access to their platforms via APIs. The API Connector add-on has an intuitive, easy-to-use interface that lets you pull data from these APIs directly from your account into your Google Sheets worksheet, without needing a line of code. Just enter the request URL and API key to connect and view this data in your spreadsheet.
See all your data in a single Google worksheet
API Connector enables you to view and manage data from multiple data sources in a single place, without requiring code or an expensive data warehouse. Create, save, and run multiple API requests, all in Google Sheets.
Schedule your API requests
Automate your data pulls. Set triggers to pull from APIs at hourly, daily, weekly, or monthly intervals, or click a button to refresh all your data immediately. Please note that scheduling is a paid feature.
This add-on supports any API that accepts requests via a GET or POST method and returns data in the standard JSON format, using an API key for authorization. This opens up access to the thousands of services and platforms, both public and private, that provide their data in this format.
Made specifically for reporting and spreadsheets. Includes spreadsheets-first features like automatic data refreshes, append vs. overwrite modes, and creating API requests based on the value in a cell. Choose between 3 different ‘JSON to csv’ conversion methods to flatten and convert JSON responses into a tabular format for Google Sheets.
The free version of API Connector enables up to 10 daily API requests, while the paid version allows unlimited requests, scheduling, and some additional power features. Please view the pricing page for more details.