v1
latestOpenAPI 3.0.32026-08-061874701.5 MBAdd rows
Inserts one or more rows into the sheet specified in the URL. If you want to insert the rows in any position but the default, use location-specifier attributes (that is, toTop, toBottom, parentId, siblingId, above, indent, outdent). See language tabs for variations in syntax.
Note: This operation does not add rows with cells that have images. However, you can upload an image to a cell after the cell exists in a sheet. To do so, call the operation described in the Add Image to Cell page.
This operation supports both single-object and bulk semantics. For more information, see Optional Bulk Operations.
Query parameters
Allows COMMENTER access for inputs and return values. For backwards-compatibility, VIEWER is the default. For example, to see whether a user has COMMENTER access for a sheet, use accessApiLevel=1.
When specified with a value of true, enables partial success for this bulk operation. See Bulk operations > Partial success for more information.
You may use the query string parameter overrideValidation with a value of true to allow a cell value outside of the validation limits. You must specify strict with a value of false to bypass value type checking.
Headers
Required for POST and PUT requests. Defines the structure for the request body.
Request body
Response
Returns Result object containing the newly created rows -- either a single Row object or array of Row objects, corresponding to what was specified in the request, as well as the new version of the sheet.
Example response
{
"message": "SUCCESS"
}