![mixed analytics](/img/default-banner.jpg)
- 14
- 331 853
mixed analytics
United States
Приєднався 16 жов 2020
A channel for learning how to connect API data to Google Sheets
Відео
Mixed Analytics API Connector Demo
Переглядів 9 тис.2 роки тому
⭐🧑💼⭐With all new features, API Connector is packed with both ease of usability AND technical customizability. This quick video shows how to quickly pull in data via our new interface! 📩Get API Connector: mixedanalytics.com/api-connector/ 🔗Come meet our community! www.reddit.com/r/api_connector/
LinkedIn Ads API to Google Sheets via API Connector
Переглядів 1,5 тис.2 роки тому
⭐🧑💼⭐With all new features, API Connector is packed with both ease of usability AND technical customizability. In this video, I'll show you how to quickly pull in data via our new interface! Quickly get LinkedIn Ad API data into Google Sheets FREE using our user-friendly and easily customizable interface. Chapters: 0:00 Intro 0:12 Download API Connector 0:26 Pull Ids 1:07 Pull Ads 2:22 Edit Out...
Shopify API to Google Sheets via API Connector
Переглядів 2,6 тис.2 роки тому
⭐🛒⭐With all new features, API Connector is packed with both ease of usability AND technical customizability. In this video, I'll show you how to quickly pull in data via our new interface! Quickly get Shopify API data into Google Sheets FREE using our user-friendly and easily customizable interface. Chapters: 0:00 Intro 0:18 Download API Connector 0:43 Creating an API Key 1:49 Setup All Orders ...
CoinMarketCap API to Google Sheets via API Connector
Переглядів 3,2 тис.2 роки тому
⭐🤩⭐With all new features, API Connector is packed with both ease of usability AND technical customizability. In this video, I'll show you how to quickly pull in data via our new interface! Quickly get CoinMarketCap API data into Google Sheets FREE using our easily customizable interface. 📩Get API Connector: mixedanalytics.com/api-connector/ 👀Check out our blog post for more details: mixedanalyt...
How to Connect to Free APIs via API Connector (and Other Tools 🔎⚒️)
Переглядів 3,3 тис.2 роки тому
Tired of pulling the same old weather data for your projects? Wanting to learn more about what an API is? Curious about the tools developers use to access this data? Tune in and I'll show you some ways to get started with accessing free APIs! Chapters: 0:00 Introduction 0:25 Free API List 1:36 JSON Viewer 2:20 Swagger Inspector 2:55 Postman 3:55 API Connector 5:15 Brewery Database API 6:41 Name...
Create a Basic Instagram Dashboard in Google Sheets
Переглядів 11 тис.3 роки тому
In this video, I'll show you how to get started pulling publicly available Instagram data into Google Sheets via API Connector, an awesome no-code Add-On for Google Sheets! Chapters: 0:00 Introduction to API Connector 0:54 RapidAPI Introduction 1:51 Using instagram40 API 3:06 GET Account Feed 5:29 Piping Raw Data to Dashboard 10:30 Cleaning Up the Dashboard 🚀Get the Add-On API Connector: gsuite...
Import Shopify Data to Google Sheets
Переглядів 15 тис.3 роки тому
In this tutorial, I will walk you though how to pull data from Shopify into Google Sheets! No coding required :) Feel free to also check out the KB article on our website for more details on pagination and other useful tips (linked below). Chapters: 0:00 Intro to API Connector 0:50 Shopify API Key Setup 3:26 GET Orders 5:30 Side-Note: limit Parameter 6:07 GET Customers 8:00 GET Products 9:43 Si...
Pull API Data Into Google Sheets With API Connector [2021]
Переглядів 54 тис.3 роки тому
This API to Sheets tutorial shows a very easy way to import data from any API into Google Sheets, using the free API Connector add-on for Sheets. No custom scripts required, simply paste in your request URL to connect APIs with Google Sheets. In this tutorial, we'll run a demo API request from the REST Countries API here: restcountries.eu/ For more advanced usage, check out our other videos in ...
Beginners Intro to Pulling API Data into Google Sheets [BONUS: Secret APIs]
Переглядів 31 тис.3 роки тому
Have you heard the term API before and wondered what it means and what you can do with it? Look no further! This is an introduction to what API data is and how to pull it into Google Sheets via our No Code, beginner friendly API Connector Sheets Add-On. We'll dive into both crypto and hashtag-generator endpoints to give you a brief overview of the vast data accessible from just a few clicks! Fi...
Import CoinBase Data to Google Sheets
Переглядів 12 тис.3 роки тому
In this tutorial, I will walk you though how to pull data from CoinBase into Google Sheets! No coding required :) Feel free to also check out the KB article on our website. Chapters: 0:00 API Connector intro 1:05 Navigating the Coinbase API 3:12 GET Currencies (fiat) 4:05 GET Currencies (blockchain) 7:04 GET Spot Pair Coinbase: www.coinbase.com/ API Connector: workspace.google.com/marketplace/a...
Import Binance Data to Google Sheets
Переглядів 87 тис.3 роки тому
In this tutorial, I will walk you though how to pull data from Binance into Google Sheets! No coding required :) Feel free to also check out the KB article on our website. Chapters: 0:00 Intro to API Connector 1:16 Binance API 2:15 GET symbols 3:12 GET candlestick 5:41 No Headers? No Problem! Binance Docs: binance-docs.github.io/apidocs/spot/en/ API Connector: gsuite.google.com/marketplace/app/...
Import CoinMarketCap Data to Google Sheets
Переглядів 52 тис.3 роки тому
In this tutorial, I will walk you through how to pull data from CoinMarketCap data into Google Sheets! No coding required :) Feel free to also check out the KB article on our website. Chapters: 0:00 API Connector intro 1:14 CoinMarketCap API 3:01 GET coin ids 5:43 Using your API key 6:37 GET latest quotes 8:56 Report styles CoinMarketCap: coinmarketcap.com/ API Connector: gsuite.google.com/mark...
Import CoinGecko Data to Google Sheets
Переглядів 50 тис.3 роки тому
In this tutorial, I will walk you though how to pull data from CoinGecko into Google Sheets! No coding required :) Feel free to also check out the KB article on our website. Chapters: 0:00 API Connector intro 1:21 What is an API? 2:37 CoinGecko API 3:56 GET coin ids 6:45 GET simple prices CoinGecko: www.coingecko.com API Connector: gsuite.google.com/marketplace/app/api_connector/95804724197 Doc...
hello what is the difference between this module and appscript?
hello what is the difference between this method and the abscript method and also the import functions? is data synchronization done in real time?
hello is there a difference between this method and appscript and the import functions? is data synchronization done in real time?
hello
fantastic video, but CoinGecko no longer has free API. Coinmarketcap still does
Ty I was trying to do it via Sheet Scripts but they're don't seem to like it very much lol
These are not automatically updated every period of time? So I'd have to do this everytime I need to update the info?
cant get it for free now sadddddddddddd
Sir, you're a wizard. Thank you for this.
hello i followed a step by step guide but still got an error :( . Can somebody help?
Can you do a video on how to have authentication converted to base64?
the message was 451
i received a message 403 blocked due to excessive traffic on google and it said to switch to a websocket. How do I do that?
Hey! this is great and easy! thanks for the awesome content :D. Do you know if is it possible to also export Dispute/Chargebacks information from shopify > google sheet via this API too?
Not working anymore Binance blocked you guys
I don’t think this is a free connector anymore, right?
Hello, can you help me set up an API for a Facebook page, I have a page with 1.5k groups, I need to track the count of participants in each group separately, and these statistics are needed about once a week, it’s not realistic to do this manually, you can create an IP request to collect statistics about groups linked to this page? Would the information be updated every day or once a week?
This is a really well made video, well done. Side note, you've got the most epic eyebrows! =D
This was an excellent intro duction to API, I figured it out. However.....the data is not live? What needs to be set so the price on the quotes is updating in near realtime?
How yo do use for keepa?
adamsın
What would be the "formula" be to get all of the crypto names and prices in one go? Is this information updated in Google Sheets as prices change
Hi I'm looking how to pull birthdates from Shopify into Google Sheets. Could I use your program to do this?
Big dislike, bye, UNSCRIEBED! BAD AND STUPID ACTING ON ADVERTISING...
I am quite disappointed! Why have you not made more videos!!! I checked out this channel and ugh! this one was massively amazing content, helpful!
Hey, this was really really amazing! But I had just one tinnie tiny doubt, how to find the right API, At 01:40 you mentioned a trick to verify "instagram40" since this video was made in 2021, does the same trick apply in 2023? Is there any other way to verify?
This is awesome - thank you! Is there a way to automatically add a new row everytime a new order kicks in?
No, but you can add a time-based trigger that refreshes and adds rows on a regular basis.
Holy crap. Coding is awesome
the problem is, prices dont update at all. its like a photo. what did i do wrong?
This not working
How to list the data from /api/v3/ticker/24hr in excel as 1 or 5 minutes; that is, how can I keep the old data sequentially, while the data is refreshed every 1 or 5 minutes?
Hi sir, A genunien feedback, please guide and teach in a way that actully help to those who are doing this for the first time. You are making any efforts in explaining which data is going to feacth in what condition? I tried to follow your steps but it way more hard as you explained. What are way if want to fatch a data which has breakdown of campains, ads with date wise?
Getting a 403 Error in google sheets, how should I resolve that?
Thanks for sharing, it's very helpful. Can I filter the list of coins before import? For instance, if I want a list of only coins that pairs with USDT? Thanks
Incredible! Thank you so much for the detailed walkthrough 🙌 Little finicky with the process and data formatting but works great!
Great video! I really appreciate the simplicity of it! I know nothing about coding or python but I got the API from coingecko and I am using it for some charts on google sheet. Does the data update automatically or do I have to pull the data every time I want to use it?
Is there a way to request more than the top 5000 coins?
Is there a way to get listed all APIs in a given website ?
amazing. thank you.
Loving your videos, Can you also make a video on How to Pull Data from Retail ERP software, into Google Sheets
Now my search is end good explanation with simple language
What about if you need to log in into a page to get access, can you scrape the data from there somehow with auto log in as well or it's not possible?
Can I automate with scheduled updating?
Great content. If I connect a weather API, does it update data every x minutes or hours?
A great way to retrieve competition store data and see their best selling products and ads too ! nice try
Hi i need some answers 1. I have an automatically calculations sheet and i need to sand it it answered values on my api link........ Plz halp
dude you are teaching!!!. you talk and move too fast...
FUCKING GENIUS MANNNN GONNA USE THIS ONE! Tyty
how do we get API data for "watchlist" within Coinmarketcap? For example Bitcoin: "On 3,6Million watchlist"?
how do we get API data for "watchlist" within Coingecko? For example Bitcoin: "On 1,2Million watchlist"?