Automate workbook creation with filtered data in Google Sheets
This video will teach you how to write a script that automates the creation of a Google Sheets workbook for every name in a dataset. Once the workbook has been created, the script will continue updating the workbook and will create new workbooks for new names. Timestamps Intro and script demo 5:08: Set up our environment 7:00: Declare our constants 9:40: Create opener() function 10:27: Create getSheetById() function 14:28: Create nameExtractor() function 20:50: Create dataExtractor() function 22:26: Create folderExtractor() function 26:50: Create main() function 33:55: Name exclusion logic 37:38: Identify the new workbooks that need to be created 43:07: Create new workbooks and populate them with filtered data 53:28: Identify workbooks that need to be updated 60:00: Demo the code 62:42: Recap If this is the first time you've seen one of my videos: welcome :) this is the sixth video in my data automation series. I have a playlist if you'd like to check them out: https://www.youtube.com/playlist?list=PL_xiAt6o4ZXwRQZ6sDpJJpcjoa7XPUPhW My channel focuses creating lessons to help people learn how to work with data. The intention of these videos is to explain the fundamentals so that you can build data projects. I think this lesson is a wonderful compliment to my beginner dashboard build: https://youtu.be/E_BvNw0_h68 If you're interested in learning about the most powerful function in Google Sheets then you can find it here: https://www.youtube.com/playlist?list=PL_xiAt6o4ZXyQn8xkOCMfgdUlu36ZOkYB I plan on adding modules in the future that will explore other lessons. Please subscribe to my channel if you'd be interested in finding out when I release new material.
This video will teach you how to write a script that automates the creation of a Google Sheets workbook for every name in a dataset. Once the workbook has been created, the script will continue updating the workbook and will create new workbooks for new names. Timestamps Intro and script demo 5:08: Set up our environment 7:00: Declare our constants 9:40: Create opener() function 10:27: Create getSheetById() function 14:28: Create nameExtractor() function 20:50: Create dataExtractor() function 22:26: Create folderExtractor() function 26:50: Create main() function 33:55: Name exclusion logic 37:38: Identify the new workbooks that need to be created 43:07: Create new workbooks and populate them with filtered data 53:28: Identify workbooks that need to be updated 60:00: Demo the code 62:42: Recap If this is the first time you've seen one of my videos: welcome :) this is the sixth video in my data automation series. I have a playlist if you'd like to check them out: https://www.youtube.com/playlist?list=PL_xiAt6o4ZXwRQZ6sDpJJpcjoa7XPUPhW My channel focuses creating lessons to help people learn how to work with data. The intention of these videos is to explain the fundamentals so that you can build data projects. I think this lesson is a wonderful compliment to my beginner dashboard build: https://youtu.be/E_BvNw0_h68 If you're interested in learning about the most powerful function in Google Sheets then you can find it here: https://www.youtube.com/playlist?list=PL_xiAt6o4ZXyQn8xkOCMfgdUlu36ZOkYB I plan on adding modules in the future that will explore other lessons. Please subscribe to my channel if you'd be interested in finding out when I release new material.