create_spreadsheet
Generate a new Google Spreadsheet with specified title and optional sheet names. Input user Google email and receive details like ID and URL of the created spreadsheet.
Instructions
Creates a new Google Spreadsheet.
Args:
user_google_email (str): The user's Google email address. Required.
title (str): The title of the new spreadsheet. Required.
sheet_names (Optional[List[str]]): List of sheet names to create. If not provided, creates one sheet with default name.
Returns:
str: Information about the newly created spreadsheet including ID and URL.
Input Schema
Name | Required | Description | Default |
---|---|---|---|
service | Yes | ||
sheet_names | No | ||
title | Yes | ||
user_google_email | Yes |
Input Schema (JSON Schema)
{
"properties": {
"service": {
"title": "service",
"type": "string"
},
"sheet_names": {
"anyOf": [
{
"items": {
"type": "string"
},
"type": "array"
},
{
"type": "null"
}
],
"default": null,
"title": "Sheet Names"
},
"title": {
"title": "Title",
"type": "string"
},
"user_google_email": {
"title": "User Google Email",
"type": "string"
}
},
"required": [
"service",
"user_google_email",
"title"
],
"title": "create_spreadsheetArguments",
"type": "object"
}