Create Sheet adds new sheet tabs to existing Google Spreadsheets. Essential for organizing data into separate categories, creating monthly reports, or structuring your spreadsheets for better data management.

​
Inputs

FieldTypeRequiredDescription
Spreadsheet URL/IDTextYesGoogle Sheets document link or ID where you want to create the new sheet
Sheet NameTextYesName for the new sheet/tab to be created

​
Outputs

OutputTypeDescription
Sheet IDNumberUnique identifier of the newly created sheet
Sheet NameTextName of the created sheet (as confirmed by Google Sheets)
Spreadsheet IDTextID of the parent spreadsheet containing the new sheet

​
Credits

This node consumes 1 credit per execution.

​
How It Works

This node connects to your Google Spreadsheet and creates a new sheet tab with your specified name. The new sheet will be empty and ready for data input using other Sheets nodes like Write Data.

​
Sheet Naming Guidelines

Best Practices:
  • Use descriptive names that clearly identify the content
  • Avoid special characters that might cause issues
  • Consider using date formats for time-based reports (e.g., “Report_2024_01”)
  • Keep names concise but meaningful

​
Common Use Cases

​
Data Organization

  • Separate Monthly Reports: Create a new sheet each month for time-based tracking
  • Campaign Segmentation: Organize different campaigns into their own sheets
  • Department Divisions: Create sheets for different teams or departments

​
Workflow Automation

  • Dynamic Sheet Creation: Use data from previous nodes to name sheets automatically
  • Template Setup: Create consistent sheet structures across multiple spreadsheets
  • Report Preparation: Set up new sheets before populating them with data

​
Project Management

  • Client Sheets: Create dedicated sheets for each client or project
  • Status Tracking: Set up sheets for different project phases
  • Archive Organization: Create sheets for historical data storage

​
Troubleshooting

Common Issues: Sheet Already Exists:
  • Google Sheets will append a number if the name already exists
  • Consider using dynamic naming with timestamps or counters
  • Check existing sheet names before creation
Permission Errors:
  • Ensure you have edit access to the target spreadsheet
  • Verify the spreadsheet URL/ID is correct and accessible
  • Check that your Google Sheets connection is properly configured
Invalid Characters:
  • Avoid special characters like /, , ?, *, [, ]
  • Keep sheet names under 100 characters
  • Use underscores instead of spaces for better compatibility