Best for large companies and enterprise.
- One userOne user
- 8 daily API requests8 daily API requests40GB Cloud Data
- 3 saved requests3 saved requestsFree Support
- ImportAPI() custom functionImportAPI() custom function
- JSON to Sheets converterJSON to Sheets converter
Perfect for start-ups or small companies.
- One userOne user
- 150 daily API requests150 daily API requests30GB Cloud Data
- 15 saved requests15 saved requests15 Databases
- ImportAPI() custom functionImportAPI() custom function
- JSON to Sheets converterJSON to Sheets converter
- Stack multiple queries togetherStack multiple queries together
- Standard scheduling (daily, weekly, monthly)Standard scheduling (daily, weekly, monthly)
Best for large companies and enterprise.
- One userOne user
- 1000 daily API requests1000 daily API requests40GB Cloud Data
- 100 saved requests100 saved requests25 Databases
- ImportAPI() custom functionImportAPI() custom function
- JSON to Sheets converterJSON to Sheets converter
- Stack multiple queries togetherStack multiple queries together
- Standard scheduling (daily, weekly, monthly)Standard scheduling (daily, weekly, monthly)
- Hourly schedulingHourly scheduling
- Share request configurationShare request configuration
- Priority email supportPriority email support
Best for large companies and enterprise.
- Five to ten usersFive to ten users
- Unlimited API requestsUnlimited API requests40GB Cloud Data
- Unlimited saved requestsUnlimited saved requestsFree Support
- ImportAPI() custom functionImportAPI() custom function
- JSON to Sheets converterJSON to Sheets converter
- Stack multiple queries togetherStack multiple queries together
- Standard scheduling (daily, weekly, monthly)Standard scheduling (daily, weekly, monthly)
- Hourly schedulingHourly scheduling
- Share request configurationShare request configuration
- Multi-channel supportMulti-channel support
This tool is a lifesaver for our sales reporting — it saves us hours and hours. I automate our weekly reporting by connecting Google Sheets to this and then running a Tableau workbook off the automation.
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 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 the email address you use with Google Sheets), 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 email or 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 email or 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.
Is payment secure?
Yes, this site holds a valid SSL certificate, and your payments are securely processed by Stripe. We never see or store your credit card details.
OTHER FAQS
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 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.
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.
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 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.
STILL HAVE QUESTIONS?
Please send a message using the API Connector Contact Form, check out the knowledge base, or email support@mixedanalytics.com. You'll receive a response shortly!