Great for people who like to work in their free time.
Perfect for start-ups or small companies.
Best for large companies and enterprise.
Best for large companies and enterprise.
Awesome add-on that works perfectly! Couple of hours saved every month since I'm using it. Highly recommended for users who often deal with CSV exports from many platforms.
Wow, importing JSON has never been easier. It's nice to a have a little GUI when working with shared docs and such since not everybody knows APIs. Also, scheduling repeated api calls is a great feature.
FAQS ABOUT UPGRADING
How do I get paid access?
Click the Buy Monthly or Buy Annual button and enter the email address for which to activate paid access (should be a Google account), along with your payment details.
Once you complete the purchase, simply re-open the add-on in Google Sheets to activate pro status.
One purchase provides access for one Google account. If you need to switch pro status to a different email account, please send a message using the API Connector Contact Form.
Will you automatically charge my credit card?
Yes, your credit card will be automatically charged at the interval you select (monthly or annually). We'll send you a receipt after each payment, and you can cancel your subscription at any time.
Is there a free trial?
Yes, when you install the plugin you automatically enter a 7-day free trial period, during which you can access all paid features. At the end of this period, you can choose to continue using the free version, or upgrade to a paid plan.
Can I share API Connector data with non-paying users?
How do I cancel a subscription?
You can cancel your subscription at any time, just send a note through the API Connector Contact Form. We'll cancel your subscription immediately, no questions asked.
When you cancel your subscription, you won't get billed again, and your subscription will remain active to the end of your billing period.
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?
Unfortunately triggers can't run more than once an hour. This limit is set by Google (documentation).
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 account 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 generally doesn't fetch the complete set of API data, 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 without historical data. API Connector is the right choice if your primary focus is data and reporting.
Which APIs does this plugin work with?
This add-on supports any API that uses an API key for authorization (or doesn't require authorization), and that returns data in the standard JSON format. This opens up access to the thousands of services and platforms, both public and private, that provide their data in this format.
The knowledge base contains detailed guides on how to use this add-on to access numerous popular platforms like YouTube, Harvest, Mailchimp, and many more.