What you can do with Google Sheets
Every task in plain language. Pick one, and we can help you get access.
12 things you can do
Google Sheets
API for reading, writing, and formatting data in Google Sheets.
12 multi-step recipesRecipes: multi-step jobs
Append Rows and Format the HeaderCreate a spreadsheet, append rows, and bold the header row.Archive and Clear Multiple Ranges
Snapshot several ranges, clear them all, and confirm they are empty.Bulk Load Multiple Ranges
Create a spreadsheet and bulk write and read multiple ranges.Copy a Sheet Between Spreadsheets
Copy a single sheet from one spreadsheet into another and confirm it.Create With an Extra Sheet and Write
Create a spreadsheet, add a second sheet, and write values into it.Create and Seed a Spreadsheet
Create a spreadsheet, append seed rows, and read them back.Create, Write, and Verify
Create a spreadsheet, write values, and read them back to verify.Overwrite or Append Rows
Overwrite a range in place when populated, otherwise append the rows.Refresh a Range
Snapshot, clear, and rewrite the values of a single range.Seed a Range Only If Empty
Write seed values into a range only when that range is currently empty.Tag and Find a Spreadsheet With Developer Metadata
Create a spreadsheet, tag it with developer metadata, and search for the tag.Update and Read Values by Data Filter
Update and read spreadsheet values selected by an A1 data filter.