Google sheet api valueRenderOption doesn't work properly

[Chathula]

1. Is this a client library issue or a product issue?

• It looks like the library issue as it works fine with product direct API

2. Did someone already solve this?

• No

3. Do you have a support contract?

• No

Environment details

• OS: Mac
• Node.js version: v18.16.0
• npm version: 9.5.1
• googleapis version: 128.0.0

Steps to reproduce

1. I tried to fetch spreadsheet values using the below method. but it returns numeric values as it is, when I use the google API Explorer, it returns all the values as strings. I want to get all the values as strings in this case.

	sheetsApi.spreadsheets.values.get({
			spreadsheetId,
			range,
			valueRenderOption: 'FORMATTED_VALUE',
		})

https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/get