Google Sheets

Creates a new spreadsheet and optional initial sheets or titles in the connected Google account.

Reads cell values from a range, table, or named range in an existing spreadsheet.

Overwrites values in a target range without inserting rows; use append to add new rows.

Appends rows after the last row of a table or range, expanding the sheet as needed.

Finds a row by a key column value and overwrites it, or appends a new row when no match exists. Returns whether the row was created or updated and the resulting row number.