I
I
issssrt2019-05-19 11:18:40
API
issssrt, 2019-05-19 11:18:40

How to record google sheets dropdown value?

I work with Google Spreadsheets via the API, write the data collected to the $g array like this:

$body    = new Google_Service_Sheets_ValueRange( [ 'values' => $g ] );
  $options = array( 'valueInputOption' => 'USER_ENTERED' );
  $service->spreadsheets_values->update( $spreadsheetId, 'Leads!A2', $body, $options );

It writes normal cells, but there is a column with a drop-down list and nothing happens there.
For example, there is a drop-down list of values ​​[1,2,3,4,5,6]. The array contains values ​​from the given list, but they are not recorded

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question