Hi, I am building an application which uses the Google Spreadsheet API to dynamically create spreadsheets. To this end, we need to be able to set up custom data validations to cell ranges. Ideally, we could set up, via the API, that cell B5 can have one of the values ["apple", "dog", "cat"]. When editing the cell in the browser it should show a drop-down with those values.
We were able to find the required setting in the browser tool, but not a corresponding API call. Is it possible to do this via the API? If not, any idea if this will be available anytime soon? Thank you, Alex Tandrau
