DEV Community

Discussion on: Using Sheets and the YouTube API to track video analytics

 
sorinamzu profile image
Sorin Amzu

Yup. Works like a charm now.
Can this be modified to track several sheets? Or would I need to create a script for each sheet?

Thanks again!

Thread Thread
 
rick_viscomi profile image
Rick Viscomi

The script needs to know which video IDs to look up, so if you want to spread the IDs over multiple sheets, you can create multiple named ranges and iterate through each one. No need for multiple scripts.