I'm trying to create a dropdown menu in Google sheets using the PHP API, but not having an luck and unable to source any examples
There is an accepted answer at How to set validation method in Google spreadsheets API
but it fails at the final command
$result = $service->spreadsheets->batchUpdate($fileId, $bodyReq);
with:
"error": {
"code": 400,
"message": "Invalid value at 'requests.set_data_validation.range.sheet_id' (TYPE_INT32),
\"1sEoQb5TVYSWHByiDNWGF6B....\""
If anyone has a working example it would be greatly appreciated.