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.