How to Insert Tab Names into Cells in Google Sheets Using App Script In this video from Better Sheets, you will learn how to create a custom function in Google Sheets to insert tab names into cells. The tutorial covers how to use Google Apps Script to write a function called 'tabName' that retrieves the name of the active sheet. The video guides you through the steps of creating and saving the script, turning it into a custom function, and using it to display tab names within your spreadsheet cells. Additionally, you'll see tips on how to ensure the tab names update correctly and options for refreshing the data. 00:00 Introduction to Tab Names in Google Sheets 00:56 Creating a Custom Function for Tab Names 01:33 Implementing the Custom Function 02:04 Testing and Troubleshooting 02:41 Conclusion and Additional Resources