Tool
New spreadsheet
Google Sheets - New Spreadsheet tool allows you to instantly create a new Google Spreadsheet with a custom title, optional worksheet name, and defined column headers. It returns the spreadsheet ID and URL, enabling seamless integration with other tools to manage and manipulate data efficiently.
Features
- Create a new Google Spreadsheet by specifying a title.
- Optionally name the first worksheet (default is 'Sheet1').
- Add custom column headers as the first row to organize your data.
- Receive the spreadsheet ID and URL for easy access and further automation.
- Compatible with other tools to read and write data in the created spreadsheet.
Benefits
- Streamlines the process of generating new spreadsheets directly via API.
- Enhances data management by predefining headers and worksheet names.
- Facilitates automation workflows by returning essential identifiers (ID and URL).
- Saves time and reduces manual errors in spreadsheet creation.
- Integrates smoothly with other applications to build complex data pipelines.
Description
Create a new Google Spreadsheet with an optional worksheet name and column headers. Returns the spreadsheet ID and URL. Use the spreadsheet ID with other tools to read/write data.
IMPORTANT: The arguments have specific formats. Please follow the instructions below:
- headers: Return JSON in this format: string[]
Parameters
3 parameters
| Name | Type | Description |
|---|---|---|
| titlerequired | string | The title of the new spreadsheet. |
| sheetName | string | Name for the first worksheet. Default: |
| headers | string[] | Column headers to add as row 1. Example: |