Our great sponsors
-
IMPORTJSONAPI
Use JSONPath to selectively extract data from any JSON or GraphQL API directly into Google Sheets.
-
SurveyJS
Open-Source JSON Form Builder to Create Dynamic Forms Right in Your App. With SurveyJS form UI libraries, you can build and style forms in a fully-integrated drag & drop form builder, render them in your JS app, and store form submission data in any backend, inc. PHP, ASP.NET Core, and Node.js.
The Scryfall API (e.g. https://api.scryfall.com/cards/random?q=usd%3C.4 ) is designed to be used for automated tasks like this, although I don't have any experience really working with google sheets. Trying to have a spreadsheet cell backed by a random value is conceptually kind of weird, so not sure exactly what the outcome would be, but theoretically, you can use something like IMPORTJSONAPI to put the results of an API request into the spreadsheet. (There is also an official Scryfall implementation for Google Sheets, but not sure that it handles the random API endpoint.)
The Scryfall API (e.g. https://api.scryfall.com/cards/random?q=usd%3C.4 ) is designed to be used for automated tasks like this, although I don't have any experience really working with google sheets. Trying to have a spreadsheet cell backed by a random value is conceptually kind of weird, so not sure exactly what the outcome would be, but theoretically, you can use something like IMPORTJSONAPI to put the results of an API request into the spreadsheet. (There is also an official Scryfall implementation for Google Sheets, but not sure that it handles the random API endpoint.)
Related posts
- Hello, I am trying to implement a live tracker from a website on some prices, does anyone know how?
- Good job lil bro
- Alternative to Cloud community for function information with different ussage examples ?
- help with importxml. trying to parse prices from websites
- importHTML only prints table colum names