Google Sheets
Data manipulation, reporting automation, collaborative data analysis, and spreadsheet-based workflows.
Productivity
Get spreadsheet
spreadsheets:readRetrieves spreadsheet metadata.
Read values
spreadsheets:readGets cell values from ranges.
Update values
spreadsheets:writeWrites values to cells.
Append values
spreadsheets:writeAdds rows to sheets.
Clear values
spreadsheets:writeClears cell ranges.
Create spreadsheet
spreadsheets:writeCreates new spreadsheets.