Unitalk Sheets icon

Unitalk Sheets

Read, update and write data to Google Sheets

Sheet Within Document → Create

AI-generated

Summary

Create a new sheet within an existing Google Sheets document specified by the user.

Inputs

  • Document (required) — The Google Sheets document in which to create the new sheet. It can be selected from a list, by URL, or by the document ID.
  • Title (required) — The name to assign to the newly created sheet.
  • Options — Optional settings for the new sheet, including visibility (hidden), text direction (right-to-left), sheet ID (immutable), sheet index (position), and tab color.

Output shape

A single record representing the created sheet's metadata and properties.

The response includes details of the created sheet such as its ID, title, and appearance options. Errors occur if required inputs are missing or invalid, such as an invalid document ID.

Examples

Example 1: Create a visible sheet named 'Budget 2024' in a specified Google Sheets document, setting its tab color to blue and positioning it as the second sheet.

Set the Document input via URL or list selection, provide 'Budget 2024' as Title, and in Options set tabColor to a blue hex code (e.g., '#0000FF') and index to 1.

Links

Discussion