I am trying to import JSON data into Google Sheets essentially like IMPORTHTML("URL"&A1&"URL"). Basically trying to adjust the URL by the contents of Cell A1. It seems to work fine with IMPORTHTML function but not IMPORTJSON function URL. Is there another way to code the URL to allow the cell content to adjust it?


I found the answer! =IMPORTJSON(CONCATENATE("https://financialmodelingprep.com/api/v3/income-statement/";AAPL;"?limit=120&apikey=demo"))

  • The IMPORTJSON formulas apparently is not using the correct syntax. Is AAPL the value of A1 ? – Rubén Feb 13 at 3:45
  • Yes. It would be a stock ticker symbol. – Wayne Feb 13 at 18:40
  • Answers should not be included in the question, they should be posted as an answer. – Rubén Feb 15 at 23:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.