ZLOOKUP
IMPORTJSONAPI
Our great sponsors
| ZLOOKUP | IMPORTJSONAPI | |
|---|---|---|
| 1 | 28 | |
| 25 | 235 | |
| - | - | |
| 0.0 | 0.0 | |
| over 2 years ago | almost 3 years ago | |
| JavaScript | JavaScript | |
| GNU General Public License v3.0 only | MIT License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
ZLOOKUP
IMPORTJSONAPI
-
Hello, I am trying to implement a live tracker from a website on some prices, does anyone know how?
You can access the API with IMPORTJSONAPI or a custom script.
-
Good job lil bro
I used https://github.com/qeet/IMPORTJSONAPI to bring it in to Google Sheets -- but there are a lot of ways to get it.
-
Alternative to Cloud community for function information with different ussage examples ?
IMPORTJSONAPI or just a direct API call with Apps Script would probably be easier.
-
help with importxml. trying to parse prices from websites
IMPORTJSONAPI has graphQL support.
-
importHTML only prints table colum names
Try IMPORTJSONAPI() and this url:
-
show auto update status
Well you can check out https://github.com/qeet/IMPORTJSONAPI as a script solution. Or just grab the data yourself with UrlFetchApp.
-
IMPORTXML "Could Not Fetch URL" Error
You can use tcgplayers api (https://docs.tcgplayer.com/docs/getting-started) and IMPORTJSONAPI (https://github.com/qeet/IMPORTJSONAPI)
-
Scraping data using JSON files
Use https://github.com/qeet/importjsonapi. However, that url seems to require a url key or some form of authentication so you'll have to pass those parameters.
-
IMPORTXML problem
I usually use this script for interacting with APIs: https://github.com/qeet/IMPORTJSONAPI/
-
Scraping Data from a Grafana website
I also tried using the IMPORTJSONAPI from https://github.com/qeet/importjsonapi but I am not sure if I can find the correct path and parameters.
What are some alternatives?
form-to-google-sheets - Store HTML form submissions in Google Sheets.
ImportJSON - Import JSON into Google Sheets, this library adds various ImportJSON functions to your spreadsheet
Luckysheet - Luckysheet is an online spreadsheet like excel that is powerful, simple to configure, and completely open source.
OpenBBTerminal - Investment Research for Everyone, Everywhere.
fuzzball.js - Easy to use and powerful fuzzy string matching, port of fuzzywuzzy.
meraki-to-google-sheets - Imports Meraki devices into Google Sheet
quotable - Random Quotes API
unsubscribe-gmail - Gmail Unsubscriber is a Google Apps Script for unsubscribing from unwanted newsletters and other bulk emails.
metabase-google-sheets-add-on - Import a Metabase question directly to a Google Sheet.
deckbrew - Magic: The Gathering API
google-sheets - Custom =SCRYFALL() function for Google Sheets
libre_crm - Open source customer relationship management based on LibreOffice