Skip to main content

​
Add the ‘Create Spreadsheet’ Tool step to your Tool

You can add the ‘Create Spreadsheet’ Tool step to your Tool by:
  1. Creating a new Tool, then searching for the ‘Create Spreadsheet’ Tool step
  2. Click ‘Expand’ to see the full Tool step
  3. Select the Drive you would like to use (defaults to “My Drive”).
  4. Select the name of the new spreadsheet you would like to create.
  5. Select the folder you would like to create the spreadsheet in.
  6. Optional: select the template you would like to use to create the spreadsheet.
  7. Click ‘Run step’ to test out the Tool

​
Using in an Agent

There are 3 ways to configure the tool step when using in an agent
This is the easiest way to configure the tool step. You can select the Drive, Folder and Spreadsheet from a list of options via the dropdown menu.Google Sheets Create Spreadsheet

​
Parameters

​
string
The Drive you want to use. By default, the tool uses “My Drive”.
​
string
required
The title of the new spreadsheet you want to create.
​
string
The folder you want to create the spreadsheet in. To get the folder ID, navigate to the folder and copy the ID from the URL (the long ID after /folders/).
​
string
Use one of your existing spreadsheets as a template. Leave this field blank to create a new spreadsheet from scratch.
You can use this tool to parse the spreadsheet ID from a url

​
Frequently asked questions (FAQs)

The dropdown menu is the easiest way to configure the tool step. You can select the Drive, Folder and Spreadsheet from a list of options via the dropdown menu.The input variables offer more flexibility e.g. you can use the same tool step for creating multiple spreadsheets, however you will need to manually provide the necessary Google Sheet IDs.
If you are using the tool in an agent, this is the recommended approach. You can use the dropdown menu to select the fields that don’t need to change, and then use the green input variables for “Title” to allow the agent to dynamically pick a name for the new sheet.