Browse published operations

Creates a new, empty spreadsheet (developers.google.com/sheets/api/reference/rest/v4/spreadsheets/create): the body is a Spreadsheet resource, e.g. { properties: { title }, sheets: [...] }, carried through verbatim; an empty body creates a default single-sheet spreadsheet titled "Untitled spreadsheet".

Reads a spreadsheet's metadata (and, optionally, its cell data) (developers.google.com/sheets/api/reference/rest/v4/spreadsheets/get): spreadsheetId is a path field, includeGridData is the query field the docs define.

Appends rows after the last row of data in a range (developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/append): spreadsheetId and range are path fields, valueInputOption ("RAW" or "USER_ENTERED") is a required query field, values (a 2D array of rows) is the required body field the docs define.

Reads cell values from one range (developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/get): spreadsheetId and range (A1 notation, e.g. "Sheet1!A1:D10") are the path fields the docs define.

Overwrites cell values in one range (developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/update): spreadsheetId and range are path fields, valueInputOption is a required query field, values is the required body field the docs define.

Exports a Google Workspace file (Docs, Sheets, Slides) to another format. Send fileId and mimeType. Use a text type such as text/plain, text/csv or text/html; binary types such as application/pdf are not supported yet.

Returns one Google Drive file's metadata. Send fileId; fields picks which fields come back. For a Google Docs, Sheets or Slides file's content, use google-drive-files-export.