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?
- How does API Connector compare to Supermetrics?
- Does API Connector work with platform ‘X’?
- Does API Connector support OAuth 2.0?
- Does API Connector support GraphQL?
- Are API Connector requests secure?
- Is there an affiliate program?
What is the purpose of this add-on?
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.
How does scheduling work?
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.
Can I run triggers more than once an hour?
Scheduled triggers can’t run more than once an hour. This limit is set by Google (documentation) and applies to all add-ons, not just API Connector.
If you need faster data updates, you can consider using API Connector’s custom IMPORTAPI() function to force more frequent refreshes (check the section on Fast cell-based refresh).
Do I need coding skills to use API Connector?
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.
How does API Connector compare to Zapier?
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.
How does API Connector compare to Supermetrics?
Supermetrics is a tool for pulling data from different platforms into Google Sheets. It provides access to about 50 of the most popular platforms, and provides a nice user interface so you don’t need to interact with APIs directly. However, it is very limited in its ability to connect to services outside of its 50 integrated sources, and, as an enterprise-focused tool, it has pricing to match (currently starting at $99/month).
If you are looking for a simple interface and need access only to big popular platforms (e.g. Facebook and Google Ads), Supermetrics comes highly recommended. However, if you are interested in an alternative to Supermetrics, don’t mind a little data wrangling, and want complete access to all data from all 20,000+ APIs, including niche and custom data sources, you will appreciate the flexibility of API Connector.
Does API Connector work with platform ‘X’?
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 should 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. All requests run through Google’s servers only, and API Connector does not have its own databases. Requests and triggers are saved to Google’s Document Properties, and subscription data is stored to Google’s User Properties. The only data logged is some limited metadata (e.g. timestamps, hostnames, error messages) to help with debugging, and logs are provided by Google Cloud Logging.
In addition, API Connector has been through Google’s verification process to prove that the add-on isn’t malicious and doesn’t access or share sensitive information.
Soon! Please see this link for pre-registration to the API Connector affiliate program.