Usecase: I am iterating through rows in a Google sheet and taking some actions dependant on the value in different fields.

    rows = sheet_data.get_all_values()

    for row in rows[2:]:  # Skip header and template row
        channel_link_id = row[sheet_data.get_column_index(ActivationSheets.CAREEM_CHANNEL_LINK_ID.value)]
        careem_mapped = row[sheet_data.get_column_index(ActivationSheets.CAREEM_MAPPED.value)]
        menu_pushed = row[sheet_data.get_column_index(ActivationSheets.CAREEM_MENU_PUSHED.value)]
        created = row[sheet_data.get_column_index(ActivationSheets.CAREEM_DRECT_CREATED.value)]

        if (careem_mapped == "TRUE" and menu_pushed != "Yes" and created == "TRUE"):
            print(row)

Issue: menu_pushed is a drop down in the sheet using data validation. This does not seem to pick up any values using the get_all_values() function.

Do you know how I can access the data validation from a cell? All I can seem to find in the docs is set_data_validation()