I’m looking for a way to dynamically change the name of my Google Sheets spreadsheet based on the value in a specific cell. Currently, my spreadsheet is titled KIT MAKING MACRO, and I want it to take the name from cell O1, which has the value A90241 - Batch 3. Can someone guide me on how to achieve this using Google Apps Script? What functions and methods should I use to read the cell value and update the spreadsheet name automatically? Any example code would be greatly appreciated!
hey! just get the value from O1 with getRange('O1').getValue() then use SpreadsheetApp.getActiveSpreadsheet().rename() to change the name. super easy, trust me! 
That approach works, but I’d add some error handling to make it more solid. I’ve used similar setups for automated reports and ran into issues where cell values had characters that Google Sheets won’t accept in tab names - stuff like brackets and special symbols. You can fix this by cleaning the cell value first, just swap out problem characters with underscores or dashes. If you want it to trigger automatically when O1 changes, you’ll need an installable trigger instead of a simple one since renaming needs authorization. Use SpreadsheetApp.newTrigger() to set up an onChange trigger for that specific range.
To rename your Google Sheets spreadsheet based on a cell reference, you need to create a function that retrieves the value from the cell and uses it as the new name. Here’s an example of how to do this:
function renameSpreadsheetFromCell() {
var sheet = SpreadsheetApp.getActiveSheet();
var newName = sheet.getRange('O1').getValue();
var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
if (newName && newName.toString().trim() !== '') {
spreadsheet.rename(newName.toString());
}
}
This script checks if the value in O1 is valid before renaming the spreadsheet. You can run this function manually or set it up with an onEdit trigger for automatic updates.