Possible to make a dropdown list in a cell in Google Sheets?

Help Studio
, ,
1

Hello,

Curious if there is a way for Studio to write to a cell in a Google Sheet that creates a dropdown list?

2

The Google Sheets API allows programmatic access to sheets. However, creating dropdown lists through the API isn’t straightforward. It involves setting data validation rules, which requires additional steps:

  • Write data to the target cell using the Sheets API’s Values: update method.
  • Use the BatchUpdate method with a SetDataValidation request. This request defines the range of cells, the validation criteria (ONE_OF_LIST), and the list of dropdown options. Here’s a helpful reference: Operações de dados  |  Google Sheets  |  Google for Developers
1 Like
3

@Josh_James

You need to use google apis…there no direct activity as such

Cheers

4

Hello @mukesh.singh , thank you for the reply. In the code example from the link you sent me, where would I put (ONE_OF_LIST)? Could I see a code example of how this would work? Thank you!

{
“requests”: [
{
“setDataValidation”: {
“range”: {
“sheetId”:

SHEET_ID

,
“startRowIndex”: 0,
“endRowIndex”: 10,
“startColumnIndex”: 0,
“endColumnIndex”: 4
},
“rule”: {
“condition”: {
“type”: “NUMBER_GREATER”,
“values”: [
{
“userEnteredValue”: “5”
}
]
},
“inputMessage”: “Value must be > 5”,
“strict”: true
}
}
}
]
}

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.