API Connector has a powerful, easy-to-use interface that lets you pull data from nearly any API into your Google Sheets worksheet. No code needed, just enter your API key or OAuth2 credentials to connect. 
👇 More info

✨ Standard (free) features:
*Free, unlimited requests through the IMPORTAPI() custom function 
*Save your API requests for future access
*Choose whether new data should overwrite or append to existing data
*Reference cells in API requests for dynamic queries
*Four built-in JSON-to-Sheets converter algorithms for handling nested JSON data
*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
*8 daily 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 through the sidebar
*Preset OAuth 2.0 integrations for the following APIs: 
➜Facebook Ads
➜Github
➜Google Ads
➜Google Analytics
➜Google Search Console
➜Harvest
➜Instagram Insights
➜LinkedIn Ads
➜QuickBooks
➜Quora Ads
➜Spotify
➜Strava
➜Vimeo
➜Xero
➜YouTube
➜Zoho CRM 
➜Your own custom OAuth2 API connections.

_______________________________________________________________________________________

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

_______________________________________________________________________________________

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

💬 Fast, friendly support
https://mixedanalytics.com/api-connector-contact-form/

🧑‍🤝‍🧑 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 Jira / 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.