Automate data collection from multiple workbooks in Google Sheets
Learn how to collect data from multiple Google Sheets workbooks and send them to a single sheet.
This video will teach you how to use Google Apps Script to program an automation that will collect data from all the workbooks in a Google Drive folder and send it to a single workbook.
The concepts in this video are discussed in some of my other videos, so if you're looking for a deeper dive then you might be interested in my "Automate Data Work in Google Sheets" playlist: • Automate Data Work in Google Sheets
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: • How to build a dashboard with dynamic...
If you're interested in learning about the most powerful function in Google Sheets then you can find it here: • How to use QUERY in Google Sheets
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.