API Connector for Google Sheets lets you access API data from thousands of platforms directly within your worksheet. No coding required!
Get 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 sheet
API Connector enables you to view and manage data from multiple APIs in a single place, without requiring code or a 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.