API Connector is a powerful, easy-to-use add-on that pulls data from any API into Google Sheets. Start quickly with a library of connectors, or create your own custom connections to the data sources you choose.

👇 More info

✨ Standard (free) features:
*Free, unlimited requests through the IMPORTAPI() custom function 
*Access thousands of preset requests through a built-in API library
*Save your API requests for future access
*Choose whether new data should overwrite or append to existing data
*Use cell values in API requests for dynamic queries
*Four built-in JSON-to-Sheets converter algorithms
*GET / POST / PUT / PATCH /  DELETE support
*Works with all major data formats (JSON, XML, and CSV)
*Log timestamps and request URLs to your output sheet
*Import Curl commands and preset request files
*Preview JSON output
*250 monthly sidebar requests, 3 saved requests

_______________________________________________________________________________________

🔥 Pro features:
*Schedule API pulls to refresh automatically
*Set trigger execution order
*Cycle through a list of stacked requests
*Automatically handle pagination
*JMESPath query language support for filtering API results
*Higher save/run limits
*Add custom OAuth2 API connections
*Preset OAuth2 integrations for the following APIs: 
➜AdRoll
➜Ahrefs
➜Asana
➜Facebook Ads
➜Facebook Pages
➜Github
➜Google Ads
➜Google Analytics
➜Google Calendar
➜Google Classroom
➜Google PageSpeed Insights
➜Google Search Console
➜Harvest
➜Hubspot
➜Instagram Insights
➜Jira
➜LinkedIn Ads
➜Mailchimp
➜Pinterest Ads
➜QuickBooks
➜Quora Ads
➜Spotify
➜Strava
➜Stripe
➜Vimeo
➜Xero
➜YouTube
➜Zoho CRM 

_______________________________________________________________________________________

⭐️ Trial
When you install this add-on, you automatically enter a 14-day free trial that activates all premium features. After 14 days, you will be switched to the free plan. 

_______________________________________________________________________________________

📓 Beginner-friendly templates & tutorials:
https://mixedanalytics.com/knowledge-base/

💬 Fast, friendly support
https://mixedanalytics.com/contact/

🧑‍🤝‍🧑 User forum
https://www.reddit.com/r/api_connector/

_______________________________________________________________________________________

✅ Use cases
*Import Bitcoin and crypto currency price data
*Connect directly to trackers like CoinMarketCap / Binance / CoinGecko etc.
*Track your Facebook page likes and follows
*Build your own SEO analysis tool
*Analyze Mailchimp email activity
*Get time and project details from Asana / Trello etc.
*Track sales from your Shopify store
*Import weather data from OpenWeatherMap
*Create tons of other cross-platform reports, visualizations, and data mash-ups for marketing, analytics, and no-code projects. Recommended if you like other scraping & connection tools like Postman, Zapier, and Supermetrics.This is a totally flexible add-on that connects to almost any platform, so you can build what you want.