API Connector is a powerful, easy-to-use extension 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 *Visual field editor to filter and re-arrange fields *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 *JMESPath query language support for filtering API results *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 *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, LinkedIn Pages, Mailchimp, Pipedrive, Pinterest Ads, Procore, QuickBooks, Quora Ads, Spotify, Strava, Stripe, TD Ameritrade, Vimeo, Xero, YouTube Analytics, YouTube Public Data, 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.