API Connector for Google Sheets

API Connector for Google Sheets lets you access API data from thousands of platforms directly within your worksheet. No coding required!

api_connector_demo

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.

api_connector_create

api-connector-request-screen

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.

api_connector_triggers

API DETAILS

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.

SHEETS FIRST

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.

PRICING

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.

 

QUESTIONS?

Check out the knowledge base, submit your question through the API Connector Contact Form, or email info@mixedanalytics.com. You'll receive a response shortly.