Create and Seed a Spreadsheet

Create and Seed a Spreadsheet

Create a spreadsheet, append seed rows, and read them back.

1. Create a new spreadsheet with the supplied title and capture its generated spreadsheet ID and URL.
2. Append the supplied two-dimensional value block to the target range, letting the API find the table and write to the next available rows.
3. Read the appended range back from the spreadsheet to confirm the seed rows were written.

What you'll need to have ready

• accessToken: OAuth 2.0 bearer access token with the spreadsheets scope.
• title: The title to give the newly created spreadsheet.
• range: The A1 notation range to append the seed rows to (e.g. Sheet1!A1).
• values: A two-dimensional array of cell values to seed the spreadsheet with.

For your developer

Arazzo workflow google-sheets:create-and-seed-spreadsheet, 3 operations: createSpreadsheet → appendValues → getValues. Specs on APIs.io.