How to add a dropdown list to google sheet using Google Sheets API python

Question

Using Google Sheets API python How to add a dropdown list to google sheet with list items [YES. NO, MAYBE] for an invite asking friends if they will attend an event.

I looked at google developer sheets api documentation HERE and no example was provided.

Looking for the JSON structure.

The result would be something like this :

Thank you!

mongotop · Accepted Answer · 2017-04-16 22:21:11Z

19

I found the trick inside the setDataValidation property and choosing ONE_OF_LIST as the condition type and all I had to do is providing the list of items inside the value list

{
  "setDataValidation": {
    "range": {
      "sheetId": sheet_id,
      "startRowIndex": 1,
      "endRowIndex": 1,
      "startColumnIndex": 22,
      "endColumnIndex": 23
    },
    "rule": {
      "condition": {
        "type": 'ONE_OF_LIST',
        "values": [
          {
          "userEnteredValue": 'YES',
          },
          {
          "userEnteredValue": 'NO',
          },
          {
          "userEnteredValue": 'MAYBE',
          },
        ],
      },
      "showCustomUi": True,
      "strict": True
    }
  }
},

answered Apr 16, 2017 at 22:21

mongotop

5,78415 gold badges56 silver badges82 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

darul75 Over a year ago

worth mentioning that this type of data validation rule do not accept more than 500 elements into the list.

Vlad Over a year ago

Here is the doc developers.google.com/sheets/api/reference/rest/v4/spreadsheets/…

Ciasto piekarz Over a year ago

can I pass the entire dictionary above to spreadsheet_obj.update_ranges?

Collectives™ on Stack Overflow

How to add a dropdown list to google sheet using Google Sheets API python

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related