Google Sheets
Rename Sheet
Change the names of existing sheets/tabs in your Google Spreadsheets.
Rename Sheet changes the names of existing sheet tabs in Google Spreadsheets. Essential for updating sheet names to reflect current data, standardizing naming conventions, or organizing your spreadsheet structure.
Inputs
| Field | Type | Required | Description |
|---|---|---|---|
| Spreadsheet URL/ID | Text | Yes | Google Sheets document link or ID containing the sheet to rename |
| Current Sheet Name | Text | Yes | Current name of the sheet/tab to be renamed |
| New Sheet Name | Text | Yes | New name for the sheet/tab |
Outputs
| Output | Type | Description |
|---|---|---|
| Sheet ID | Number | Unique identifier of the renamed sheet |
| Old Sheet Name | Text | Previous name of the sheet (before renaming) |
| New Sheet Name | Text | Current name of the sheet (after renaming) |
| Spreadsheet ID | Text | ID of the parent spreadsheet containing the renamed sheet |
Credits
This node consumes 1 credit per execution.How It Works
This node connects to your Google Spreadsheet and changes the name of the specified sheet tab from the current name to your new desired name. All data within the sheet remains unchanged - only the tab name is updated.Naming Guidelines
Best Practices:- Use descriptive names that clearly identify the sheet content
- Follow consistent naming conventions across your spreadsheet
- Include dates or version numbers for time-based data
- Avoid special characters that might cause compatibility issues
Configuration Examples
Update Report Names with Current Date
Scenario: Rename sheets to include current month for better organization Configuration:- Spreadsheet URL/ID:
1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms - Current Sheet Name:
Monthly_Report - New Sheet Name:
Monthly_Report_{{current_month}}_{{current_year}}
Standardize Sheet Names
Scenario: Update sheet names to follow company naming conventions Configuration:- Spreadsheet URL/ID:
1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms - Current Sheet Name:
Q1 sales data - New Sheet Name:
Sales_Data_Q1_2024
Dynamic Campaign Renaming
Scenario: Update sheet names based on campaign performance status Configuration:- Spreadsheet URL/ID:
1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms - Current Sheet Name:
{{campaign_name}} - New Sheet Name:
{{campaign_name}}_{{status}}_{{end_date}}
Common Use Cases
Data Organization
- Version Control: Add version numbers or dates to sheet names
- Status Updates: Include current status in sheet names (Active, Archive, Complete)
- Category Sorting: Prefix sheet names with categories for better organization
Workflow Management
- Process Tracking: Update names to reflect processing stages
- Archive Management: Rename sheets when moving to archive status
- Template Updating: Standardize names across multiple spreadsheets
Reporting
- Date Stamping: Add current dates to report sheet names
- Period Updates: Change names to reflect new reporting periods
- Client Organization: Include client names or project codes in sheet names
Troubleshooting
Name Conflicts:- Add timestamps or unique identifiers to ensure uniqueness
- Check for hidden or special characters in existing names
- Use the list sheets functionality to see all current names
- Update any workflows that reference the old sheet name
- Check formulas in other sheets that might reference the renamed sheet
- Update any external links or references to the sheet
- Keep track of old names for potential rollback
- Consider testing rename operations in non-production environments first
- Have a plan for updating dependent systems