I have 9000 lines with URL's in my Google Sheet.
Example: https://steamcommunity.com/auction/ajaxgetgoovalueforitemtype/?appid=233860&item_type=10).
Every URL returns JSON like this:

"success": 1,
"goo_value": "80"

I want to put goo_value in another cell in the same spreadsheet.

IMPORTDATA doesn't work: "Too many requests".

Is there a way how to get these text values? Some script or something?


1 Answer 1



Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.