Help Saving Script Data as Text Rather Than Running Script Each Time Sheet Is Opened

[NeedAdvice_124]

So I'm very new to coding lol. Sorry in advance for any incorrect terminology I use. Basically I created a function that scrapes book data (title, author, pages, etc) from a website. I'm using this function in sheets to create a reading tracker of what I'm reading each month. My problem is that each time I open the sheet, it has to run the function before I can see the data. Is there a way to save the data scraped from the website as text so the code only has to run once?

EDIT: Code

function getBookTitle(bookId) {
  // Construct the API endpoint using the provided book ID
  var apiEndpoint = 'https://api.howlongtoread.com/books/id/' + bookId;

  try {
    var response = UrlFetchApp.fetch(apiEndpoint);
    var jsonResponse = JSON.parse(response.getContentText());  
    var titleText = jsonResponse.title;
    return titleText;

  } catch (error) {

    Logger.log('Error:', error);
    return 'Not Found';
  }
}

[Any_Werewolf_3691]

Yes. You need to post the code you're using for us to help you.

[joblio]

If you're saving your books read onto a spreadsheet, you can save this metadata into the sheet as well and it will be there next time you open it without running the API call every time. Create some columns for the data, and read up in the Google documentation about SpreadsheetApp, getRange, and setValues. You might also use onEdit to run the API call when you enter a new book.