API Reference

• Top level
  • oauth()
  • service_account()
  • authorize()
• Auth
  • gspread.auth
  • FlowCallable
  • api_key()
  • authorize()
  • get_config_dir()
  • local_server_flow()
  • oauth()
  • oauth_from_dict()
  • service_account()
  • service_account_from_dict()
• Client
  • Client
• HTTP Client
  • HTTPClient
  • BackOffHTTPClient
• Models
  • Spreadsheet
  • Worksheet
  • Cell
• Utils
  • gspread.utils
  • DateTimeOption
  • Dimension
  • ExportFormat
  • GridRangeType
  • InsertDataOption
  • MergeType
  • MimeType
  • PasteOrientation
  • PasteType
  • StrEnum
  • ValidationConditionType
  • ValueInputOption
  • ValueRenderOption
  • a1_range_to_grid_range()
  • a1_to_rowcol()
  • absolute_range_name()
  • cast_to_a1_notation()
  • cell_list_to_rect()
  • column_letter_to_index()
  • combined_merge_values()
  • convert_colors_to_hex_value()
  • convert_credentials()
  • convert_hex_to_colors_dict()
  • extract_id_from_url()
  • fill_gaps()
  • finditem()
  • get_a1_from_absolute_range()
  • is_full_a1_notation()
  • is_scalar()
  • numericise()
  • numericise_all()
  • quote()
  • rightpad()
  • rowcol_to_a1()
  • to_records()
  • wid_to_gid()
• Exceptions
  • APIError
  • GSpreadException
  • IncorrectCellLabel
  • InvalidInputValue
  • NoValidUrlKeyFound
  • SpreadsheetNotFound
  • UnSupportedExportFormat
  • WorksheetNotFound