Sets values in a range of a spreadsheet in Google Sheets
A documented Google Sheets operation that changes something in your account. Describe the outcome you want in plain words — HumDay writes the program, proves it, and runs it.
What this operation does
Sets values in a range of a spreadsheet.
- PUTChanges data · spreadsheets
sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{range}
How HumDay uses it
- You describe the outcome. Not this operation by name — what you want to happen. HumDay works out which operations it needs.
- The contract names it. Before anything is built, you see exactly which Google Sheets operations the program may use, and this is one of them.
- You approve access. Because this one changes data, it cannot run until you have explicitly granted it.
Other Google Sheets operations
- Creates a spreadsheet, returning the newly created spreadsheetPOST · changes data
- Applies one or more updates to the spreadsheetPOST · changes data
- Returns the spreadsheet at the given IDPOST · changes data
- Copies a single sheet from a spreadsheet to another spreadsheetPOST · changes data
- Clears one or more ranges of values from a spreadsheetPOST · changes data
- Sets values in one or more ranges of a spreadsheetPOST · changes data
- Returns all developer metadata matching the specified DataFilterPOST · changes data
- Clears one or more ranges of values from a spreadsheetPOST · changes data
Questions
- Can HumDay sets values in a range of a spreadsheet in Google Sheets?
- Yes. This operation is published in Google Sheets's own API description, so HumDay can use it without a hand-built connector — once you have approved it for your automation.
- Will this change my Google Sheets data?
- Yes — this is a PUT operation, so it changes something in Google Sheets. HumDay holds anything that writes behind an approval you grant explicitly, and the contract you approve says what it may touch.
- Do I need to write code?
- No. You describe the outcome you want in plain words. HumDay agrees a contract with you, writes the program, and shows you a proof run before anything touches your Google Sheets account.
Where this came from
Read from a published API description for Google Sheets at sheets.googleapis.com/$discovery/rest?version=v4. The description above is the provider’s own wording, not ours. Last published 2023-04-21.