I’m running into an issue with the Sheets API while working on my Google Spreadsheet. When I execute my script, I receive an error message stating:
API call to sheets.spreadsheets.values.get failed with error: The request is missing a valid API key. (line 5).
The code snippet causing the error is:
let data = SpreadsheetApp.getActiveSpreadsheet().getDataRange().getValues();
It appears that I might have missed adding the API key required to access the service. I’m invoking the function using =myFunction() in a cell. Has anyone encountered this issue before? Could it be that I need to configure my API key somewhere in the account or script settings? Any advice would be appreciated!
I encountered a similar issue before, and I found that the error message is sometimes misleading. Running the script directly in the Apps Script editor allowed me to see and accept the necessary permission prompts. Once those permissions were granted, executing the function from the spreadsheet worked fine. In my experience, it is also important to verify that you are not unintentionally mixing Apps Script calls with direct API methods. Keeping your code consistent with Apps Script’s native functions usually resolves these types of errors.
sounds like ur using Apps Script, not the Sheets API directly. That error msg is weird for Apps Script. Double-check ur script’s authorization - might need to run it from the script editor first to grant permissions. Also, make sure ur using the right method for ur needs (getActiveSpreadsheet vs openById). hope this helps!