ProtectedRange resource represents a protected range. Protected rangeĪ defined cell or range of cells that cannot be modified. Sheet1!RC refers to the cell that is three rows below and one column to the right of the current cell.Ī defined cell or range of cells with a custom name to simplifyįilterView resource represents a named range.R1C1:R2C2 refers to the first two cells in the top two rows of the first visible sheet.Sheet1!R1C1:R2C2 refers to the first two cells in the top two rows of Sheet1.Useful when referencing a range of cells relative to a given cell's This method is less common than A1 notation, but can be However, if there’s a named range titled 'Sheet1', then Sheet1 refers to the named range and 'Sheet1' refers to the sheet. Similarly, Sheet1 refers to all the cells in Sheet1. For example, A1 refers to the cell A1 in the first visible sheet, whereas 'A1' refers to all the cells in a sheet named A1. Tip: Where possible, use distinct names for the objects within your spreadsheets. 'My Custom Sheet' refers to all the cells in 'My Custom Sheet'.'My Custom Sheet'!A:A refers to all the cells in the first column of a sheet named 'My Custom Sheet.' Single quotes are required for sheet names with spaces, special characters, or an alphanumeric combination.Sheet1 refers to all the cells in Sheet1.A1:B2 refers to the first two cells in the top two rows of the first visible sheet.Sheet1!A5:A refers to all the cells of the first column of Sheet 1, from row 5 onward.Sheet1!1:2 refers to all the cells in the first two rows of Sheet1.Sheet1!A:A refers to all the cells in the first column of Sheet1.Sheet1!A1:B2 refers to the first two cells in the top two rows of Sheet1.When referencing an absolute range of cells. This method is the most common and useful 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

Public google docs spreadsheet