https://linen.dev logo
Googlesheets - GET SHEET NAMES not working
# 🖥│support-forum
e
When I call the GOOGLESHEETS_GET_SHEET_NAMES with an id of my google sheets I get the following error in the response, I do have permission to the sheets - also used to work fine just a few days ago. "message\": \"Error executing `GET_SHEET_NAMES`: Traceback (most recent call last):\\n File \\\"/var/lang/lib/python3.10/site-packages/gspread/client.py\\\", line 168, in open_by_key\\n spreadsheet = Spreadsheet(self.http_client, {\\\"id\\\": key})\\n File \\\"/var/lang/lib/python3.10/site-packages/gspread/spreadsheet.py\\\", line 29, in __init__\\n metadata = self.fetch_sheet_metadata()\\n File \\\"/var/lang/lib/python3.10/site-packages/gspread/spreadsheet.py\\\", line 230, in fetch_sheet_metadata\\n return self.client.fetch_sheet_metadata(self.id, params=params)\\n File \\\"/var/lang/lib/python3.10/site-packages/gspread/http_client.py\\\", line 305, in fetch_sheet_metadata\\n r = self.request(\\\"get\\\", url, params=params)\\n File \\\"/var/lang/lib/python3.10/site-packages/gspread/http_client.py\\\", line 128, in request\\n raise APIError(response)\\ngspread.exceptions.APIError: APIError: [403]: The caller does not have permission\\n\\nThe above exception was the direct cause of the following exception:\\n\\nTraceback (most recent call last):\\n File \\\"/var/task/mercury/tools/api/tool.py\\\", line 267, in execute\\n response = instance.execute(request=request, metadata=metadata)\\n File \\\"/mnt/efs/default/googlesheets/20250915_00/actions/get_sheet_names.py\\\", line 71, in execute\\n spreadsheet = self._get_spreadsheet(\\n File \\\"/mnt/efs/default/googlesheets/20250915_00/actions/get_sheet_names.py\\\", line 58, in _get_spreadsheet\\n sheet = client.open_by_key(spreadsheet_id)\\n File \\\"/var/lang/lib/python3.10/site-packages/gspread/client.py\\\", line 173, in open_by_key\\n raise PermissionError from ex\\nPermissionError\\n\",\n \"requestId\": \"032979dc-64df-4e3b-b197-465eaf8f48c3\",\n