mixed analytics
mixed analytics
  • 14
  • 331 853

Відео

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...

КОМЕНТАРІ

  • @chrisder1814
    @chrisder1814 4 дні тому

    hello what is the difference between this module and appscript?

  • @chrisder1814
    @chrisder1814 Місяць тому

    hello what is the difference between this method and the abscript method and also the import functions? is data synchronization done in real time?

  • @chrisder1814
    @chrisder1814 Місяць тому

    hello is there a difference between this method and appscript and the import functions? is data synchronization done in real time?

  • @cgc2300
    @cgc2300 3 місяці тому

    hello

  • @johnb2271
    @johnb2271 4 місяці тому

    fantastic video, but CoinGecko no longer has free API. Coinmarketcap still does

  • @TheEmolano
    @TheEmolano 4 місяці тому

    Ty I was trying to do it via Sheet Scripts but they're don't seem to like it very much lol

  • @LayalMeselmani
    @LayalMeselmani 5 місяців тому

    These are not automatically updated every period of time? So I'd have to do this everytime I need to update the info?

  • @princedeniega3685
    @princedeniega3685 5 місяців тому

    cant get it for free now sadddddddddddd

  • @ruud.de.groot.
    @ruud.de.groot. 6 місяців тому

    Sir, you're a wizard. Thank you for this.

  • @zarishkhan5583
    @zarishkhan5583 6 місяців тому

    hello i followed a step by step guide but still got an error :( . Can somebody help?

  • @Valnurat
    @Valnurat 7 місяців тому

    Can you do a video on how to have authentication converted to base64?

  • @dannyredcdsdunn6634
    @dannyredcdsdunn6634 8 місяців тому

    the message was 451

  • @dannyredcdsdunn6634
    @dannyredcdsdunn6634 8 місяців тому

    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?

  • @nicodesiderato1676
    @nicodesiderato1676 8 місяців тому

    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?

  • @azizabdal3786
    @azizabdal3786 8 місяців тому

    Not working anymore Binance blocked you guys

  • @LumaBendini
    @LumaBendini 8 місяців тому

    I don’t think this is a free connector anymore, right?

  • @ibm.kostya
    @ibm.kostya 8 місяців тому

    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?

  • @jacquestroussard9857
    @jacquestroussard9857 9 місяців тому

    This is a really well made video, well done. Side note, you've got the most epic eyebrows! =D

  • @Jonnyrockin71
    @Jonnyrockin71 9 місяців тому

    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?

  • @user-xj5le1gf5d
    @user-xj5le1gf5d 9 місяців тому

    How yo do use for keepa?

  • @zfrdmnn
    @zfrdmnn 10 місяців тому

    adamsın

  • @247earnings2
    @247earnings2 10 місяців тому

    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

  • @carolinehodge5943
    @carolinehodge5943 11 місяців тому

    Hi I'm looking how to pull birthdates from Shopify into Google Sheets. Could I use your program to do this?

  • @Thomas-op8of
    @Thomas-op8of 11 місяців тому

    Big dislike, bye, UNSCRIEBED! BAD AND STUPID ACTING ON ADVERTISING...

  • @raaverathee6938
    @raaverathee6938 11 місяців тому

    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!

  • @raaverathee6938
    @raaverathee6938 11 місяців тому

    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?

  • @sherifabdulla
    @sherifabdulla Рік тому

    This is awesome - thank you! Is there a way to automatically add a new row everytime a new order kicks in?

    • @mixedanalytics
      @mixedanalytics Рік тому

      No, but you can add a time-based trigger that refreshes and adds rows on a regular basis.

  • @alecthecatholic3380
    @alecthecatholic3380 Рік тому

    Holy crap. Coding is awesome

  • @samwolf7445
    @samwolf7445 Рік тому

    the problem is, prices dont update at all. its like a photo. what did i do wrong?

  • @gufranmirza7760
    @gufranmirza7760 Рік тому

    This not working

  • @hancemdemir1346
    @hancemdemir1346 Рік тому

    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?

  • @RashmiPandey-rf7ht
    @RashmiPandey-rf7ht Рік тому

    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?

  • @rohitpanjabi1256
    @rohitpanjabi1256 Рік тому

    Getting a 403 Error in google sheets, how should I resolve that?

  • @bit_Jon_Trader
    @bit_Jon_Trader Рік тому

    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

  • @DavidRodriguez7
    @DavidRodriguez7 Рік тому

    Incredible! Thank you so much for the detailed walkthrough 🙌 Little finicky with the process and data formatting but works great!

  • @delcampoalcrypto
    @delcampoalcrypto Рік тому

    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?

  • @jorwegs
    @jorwegs Рік тому

    Is there a way to request more than the top 5000 coins?

  • @interestinginvestments1805

    Is there a way to get listed all APIs in a given website ?

  • @wandavazquez3201
    @wandavazquez3201 Рік тому

    amazing. thank you.

  • @Upbeat_Impact
    @Upbeat_Impact Рік тому

    Loving your videos, Can you also make a video on How to Pull Data from Retail ERP software, into Google Sheets

  • @bscfx1
    @bscfx1 Рік тому

    Now my search is end good explanation with simple language

  • @synai9156
    @synai9156 Рік тому

    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?

  • @ricardorivero9334
    @ricardorivero9334 Рік тому

    Can I automate with scheduled updating?

  • @sdy1473
    @sdy1473 Рік тому

    Great content. If I connect a weather API, does it update data every x minutes or hours?

  • @adamqa1
    @adamqa1 Рік тому

    A great way to retrieve competition store data and see their best selling products and ads too ! nice try

  • @MrMayankpasi
    @MrMayankpasi Рік тому

    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

  • @emilioperez5164
    @emilioperez5164 Рік тому

    dude you are teaching!!!. you talk and move too fast...

  • @icaroaraujo2250
    @icaroaraujo2250 Рік тому

    FUCKING GENIUS MANNNN GONNA USE THIS ONE! Tyty

  • @herrguru4264
    @herrguru4264 Рік тому

    how do we get API data for "watchlist" within Coinmarketcap? For example Bitcoin: "On 3,6Million watchlist"?

  • @herrguru4264
    @herrguru4264 Рік тому

    how do we get API data for "watchlist" within Coingecko? For example Bitcoin: "On 1,2Million watchlist"?