Frequently Asked Questions
- What is the purpose of this add-on?
- How does scheduling work?
- Can I run triggers more than once an hour?
- Do I need coding skills to use API Connector?
- How does API Connector compare to Zapier?
- Does API Connector work with platform 'X'?
- Does API Connector support OAuth 2.0?
Thousands of finance, marketing, analytics, and other platforms provide their data through APIs. You can see one listing of these APIs here.
This API Connector add-on has an intuitive, easy-to-use interface that lets you pull data from these APIs directly into your Google Sheets worksheet, without needing a data warehouse or a line of code. You can report on and analyze the data directly in Google Sheets, or connect it to Data Studio to create data visualizations and dashboards.
Scheduling allows you to automate your data pulls. The paid version of this add-on allows you to set triggers that fire requests from APIs at hourly, daily, weekly, or monthly intervals.
You can set individual triggers for each request, or set a trigger to run all your requests at once.
Unfortunately scheduled triggers can't run more than once an hour. This limit is set by Google (documentation). However, you can use API Connector's custom IMPORTAPI() function to force more frequent refreshes.
No, you don't need any code to use API Connector, though you may need to read some documentation to determine your API URL and API key (usually available in the developer section of your platform).
API Connector was designed specifically with spreadsheet users in mind, so you can achieve dynamic, code-like capabilities by setting triggers and referencing cells in your requests.
Zapier connects different platforms to each other. One of these platforms is Google Sheets, so there is some overlapping functionality with API Connector. However, data created before your Zap was turned on won't be imported, Zapier limits you to certain pre-selected metrics, and Zapier only works with platforms that have a built-in integration.
Essentially Zapier is a great choice if you need if-this, then-that functionality for common metrics and platforms, without historical data. API Connector is the right choice if you a) want to connect to platforms that don't have existing integrations, and b) need access to the full set of API data.
This add-on supports any API that uses an API key for authentication, and that returns data in JSON or CSV format. This enables access to most API platforms, but you will need to check your platform's documentation and run your request in API Connector to confirm. You can also consult the knowledgebase for detailed guides on getting started with numerous popular APIs.
Technically, API Connector will allow you to connect to APIs utilizing OAuth 2.0 authentication. However, this is not recommended, due to the complexity of exchanging and refreshing access tokens (you can see one example of this process here). API Connector is designed to be used with API keys only.