Mar 13, 2024 | Google App Scripts
I have updated the source code to address nested fields like links.website, delta.year. function getCoinInfo(coin, field_name = ‘rate’, currency = ‘USD’, trigger) { // Replace with your actual API key const apiKey =...
Apr 3, 2023 | Uncategorized
function getCryptoData() { var url = “https://pro-api.coinmarketcap.com/v1/cryptocurrency/listings/latest”; var apiKey = “<YOUR API KEY>”; // Replace with your own API key var params = { start: 1, limit: 500, // maximum is 5000, but may...
Jan 19, 2022 | Uncategorized
Crypto Scraper Template Download Download Link: https://docs.google.com/spreadsheets/d/1lgLZtA75LDKvei3aztPq4Hb955kxDglwaXPPh3jj8wQ/edit?usp=sharing For Full Tutorial On How To Build A Crypto Web Scraper With Google Sheets App Script Code
Nov 29, 2021 | Google Sheets API, Python
Buy Me a Coffee? Your support is much appreciated! Source Code:
May 17, 2021 | Google Sheets API, Python
In this tutorial, I am going to show you how to automate Pivot Table in Google Sheets with Google Sheets API in Python. Since there are many things you can do with a Pivot Table, I will divide the tutorial into multiple parts. What is a Pivot Table? A Pivot Table is a...
