

A1 notationĪ syntax used to define a cell or range of cells with a string thatĬontains the sheet name plus the starting and ending cell coordinates usingĬolumn letters and row numbers. Instead, rowĪnd column coordinates identify the cells. AĬellData resource represents each cell, but Rows and columns, and can be grouped as a range of cells. Sheet resource represents each sheet and hasĬan find the sheet ID in a Google Sheets URL:Īn individual field of text or data within a sheet. Spreadsheet resource represents every spreadsheet and has aĬontaining letters, numbers, hyphens, or underscores.

With structured information contained in cells. The primary object in Google Sheets that can contain multiple sheets, each The most common uses of this API include the followingīelow is a list of common terms used in the Sheets API: Spreadsheet The Google Sheets API is a RESTful interface that lets you read and modify a
