I am working on a simple internal react native application for my company. I am trying to update an excel sheet using google’s apis via axios requests. I have used Google’s oAuth (via Firebase) and am authenticated properly.
Here is the code (be advised that some of the variables are not used yet. I will update that when this code works):
const doWriteToGoogleSheets = async (sheetId, sheetName, range, majorDimension) => {
await axios.put(`https://sheets.google.com/v4/spreadsheets/${sheetId}/values/${sheetName}!${range}?valueInputOption=${VALUE_INPUT_OPTION.USER_ENTERED}&key=${AUTH_SHEETS_API_KEY}`, {
range: `${sheetName}!${range}`,
majorDimension: "ROWS",
values: [
["NAMESS"] // test value, try with only 1 cell as the range
],
})
}
I have also tested using:
await axios.put(`https://sheets.google.com/v4/spreadsheets/${sheetId}/values/'TimeFullYear (Input Here)'!A1?valueInputOption=${VALUE_INPUT_OPTION.USER_ENTERED}&key=${AUTH_SHEETS_API_KEY}`, {
"range": "'TimeFullYear (Input Here)'!A1",
"majorDimension": "ROWS",
"values": [
[
"NAMESS"
]
]
})
and
await axios.put(`https://sheets.google.com/v4/spreadsheets/${sheetId}/values/'TimeFullYear (Input Here)'!A1?valueInputOption=${VALUE_INPUT_OPTION.USER_ENTERED}&key=${AUTH_SHEETS_API_KEY}`, {
range: "TimeFullYear (Input Here)!A1",
majorDimension: "ROWS",
values: [
[
"NAMESS"
]
]
})
THE PROBLEM
My logger is saying that the code completed successfully (no error was thrown) but then I get “undefined” as a response (after the “:” is where the response should be):
SUCCESS - write to timecards: undefined
And when I check in the google sheet nothing is updated.
WHAT I KNOW
- I am authenticated properly. I know this as my Google Sheets get request does work
- I have enabled the required scopes (https://www.googleapis.com/auth/spreadsheets)
HELP
can someone help me out?
EDIT
- VALUE_INPUT_OPTION.USER_ENTERED is equal to the string “USER_ENTERED”
- I am following these docs: https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/update