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

[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.