Create Sheets
Use the Create Sheets action to create one or more sheets in the specified spreadsheet.
Complete the following steps to use the Create Sheets action in your workflow:
1. Drag the Create Sheets action under Google Sheets to the canvas, place the pointer on the action, and then click or double-click the action. The Create Sheets window opens.
2. Edit the Label, if needed. By default, the label name is the same as the action name.
3. To add a Google Sheets connector type, refer to Supported Google Sheets Connector Types.
If you previously added a connector type, select the appropriate Connector Type, and under Connector Name, select the connector.
4. Click TEST to validate the connector.
5. Click MAP CONNECTOR to execute the action using a connector that is different from the one that you are using to populate the input fields. In the Runtime Connector field, provide a valid Google Sheets connector name. For more information about MAP CONNECTOR, see Using Map Connector.
6. In the Spreadsheet ID list, select or specify the ID of the spreadsheet where you want to add sheets.
7. Under the Add Sheets group, do the following:
a. In the Title field, provide the title of the sheet.
b. In the Number of Row(s) field, provide the number of rows that you want in the new sheet.
c. In the Number of Column(s) field, provide the number of columns that you want in the new sheet.
Click Add to add multiple sheets. Click to delete any sheet that you added.
8. Click Done.
Output schema
Was this helpful?