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

Help Studio
, ,
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