IMPORTJSONAPI
metabase-google-sheets-add-on
IMPORTJSONAPI | metabase-google-sheets-add-on | |
---|---|---|
28 | 1 | |
235 | 103 | |
- | - | |
0.0 | 10.0 | |
almost 3 years ago | over 1 year ago | |
JavaScript | JavaScript | |
MIT License | 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.
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.
metabase-google-sheets-add-on
-
Know any BI software that functions like Excel (for the user)?
Another option would be to run Metabase as a BI, and then setup the metabase-google-sheets-add-on. I’ve done this before and it’s worked pretty well.
What are some alternatives?
ImportJSON - Import JSON into Google Sheets, this library adds various ImportJSON functions to your spreadsheet
vocabulary-to-google-sheet - Save examples from dictionaries to Google Sheet in one click.
OpenBBTerminal - Investment Research for Everyone, Everywhere.
apps-script-samples - Apps Script samples for Google Workspace products.
meraki-to-google-sheets - Imports Meraki devices into Google Sheet
wazirx-google-sheet-dashboard - Use Google Sheet to Visualise Your WazirX Portfolio
quotable - Random Quotes API
unsubscribe-gmail - Gmail Unsubscriber is a Google Apps Script for unsubscribing from unwanted newsletters and other bulk emails.
ZLOOKUP - Google Sheet Fuzzy String Matching Function
deckbrew - Magic: The Gathering API
google-sheets - Custom =SCRYFALL() function for Google Sheets
libre_crm - Open source customer relationship management based on LibreOffice