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?
- Does API Connector support GraphQL?
- Are API Connector requests secure?
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 any of the three main data formats (JSON, XML, and CSV). It also supports access to selected platforms via OAuth 2.0. 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.
API Connector supports OAuth 2.0 for selected platforms (paid feature). Please see this article for details. If you’re interested in managing the OAuth 2.0 process manually, you can also see an example here.
Yes, you can use API Connector with GraphQL APIs. Generally, you will enter your GraphQL query into either the “query” parameter or the POST body, depending on the specifics of your API. The following examples demonstrate these methods of using API Connector with GraphQL APIs:
- Import Product Hunt Data to Google Sheets
- Import CJ Affiliate (Commission Junction) Data to Google Sheets
Yes. API Connector does not view or store API credentials or any of the data that gets retrieved. Everything runs through Google’s servers only, and the only data logged is some limited metadata (e.g. timestamps, hostnames, error messages) to help with debugging. In addition, all add-ons on Google’s G Suite Marketplace go through an extensive verification process (documentation) to prove that the add-on isn’t malicious and doesn’t access or share sensitive information, and API Connector has been verified by Google.