Import Live Cryptocurrency Price (And More) In Google Sheets & Schedule Auto Refresh @jiejenn
Import Live Cryptocurrency Price (And More) In Google Sheets & Schedule Auto Refresh  @jiejenn
Uploaded March 2024 | Updated November 2026, 1 day ago
So my old method to import live cryptocurrency data doesn't work anymore, so I decided to come up with a more stable solution, which is to create a custom function called getCoinInfo() to fetch live crypto data. By using a custom function, we have the flexibility to pick and choose what information we want to display. And by using an actual API instead of web scraping, we no longer need to worry about if the source page's HTML code is updated. This tutorial is ideal for anyone who is looking for a free solution to import live cryptocurrency data.

In this tutorial I will cover two things:
1) Create getCoinInfo function.
2) How to schedule data refresh.

πŸ“‘ Source Code: wp.me/payCAw-1mQ

πŸ’» Live Coin Watch website: livecoinwatch.com/tools/api

πŸ’– Show Support
β˜• Paypal: paypal.me/jiejenn/5
β˜• Venmo: @Jie-Jenn
🌳 Patreon: patreon.com/JieJenn (early access to tutorial source code)
βœ‰οΈ Business Inquiring: YouTube@LearnDataAnalysis.org

0:00:00 - Introduction to the tutorial on retrieving live crypto data.
0:00:09 - Announcement of a new robust solution for crypto pricing information.
0:00:20 - Quick demo of the proposed solution.
0:00:26 - Introduction of the GetCoinInfo function.
0:00:38 - Requirement to register for LiveCoinWatch for API access.
0:01:15 - Detailed explanation of using the coins/single endpoint.
0:02:08 - Overview of the GetCoinInfo function parameters.
0:03:28 - Google Sheets setup for implementing the function.
0:04:18 - Scripting in Google Sheets to enhance functionality.
0:09:38 - How to refresh formulas using Apps Script triggers.
0:12:25 - Confirmation and testing of the trigger functionality.

#googlesheets #cryptodata #crypto #cryptocurrency #googleappscript
Import Live Cryptocurrency Price (And More) In Google Sheets & Schedule Auto RefreshPython Automation: Send Emails In Outlook Using Python (Source Code In Description)Getting Started With Google Search API For Beginners In Python | Full TutorialVisualize JSON Data In VS CodeConnect YouTube In Claude Desktop With This YouTube MCP Server | Step-By-Step WalkthroughCreate A Markdown Editor With Python | PyQt6 TutorialLoad CSV Files To Database With dbt seed | dbt TutorialCreate An AI Assistant Chatbot With RAG Capability With OpenAI Assistants API & PythonSet Up AWS User Authentication For Python Development | Step-By-Step TutorialHow To Use Ollama (Or Other LLM Providers) In OpenAI Agents SDK.Building A Travel Planning AI Agent With Web Search And Research Capabilities | Agno TutorialCreate a GPT Action to Send Emails In ChatGPT | Step-By-Step Tutorial
Jie Jenn |

Import Live Cryptocurrency Price (And More) In Google Sheets & Schedule Auto Refresh

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER