re: Using Sheets and the YouTube API to track video analytics VIEW POST

re: Two things come to mind: The named range may be ending on B50 rather than B1000. The YouTube API may have limitations on the number of video IDs ...

Hey Rick, thanks for a fantastic article — I've got mine all set up looking beautiful! I've also run into the 50 API calls limit and upon research found that it definitely is the ID call with a specific limit, which can't be changed.

To get around this, I've decided to create different sheets for each year's video uploads. However, it seems overkill to duplicate the script for each sheet. I noticed in another reply you mentioned iterating through multiple named ranges. How would I go about referencing either multiple named ranges, or triggering the script multiple times (in the event all named ranges combined are over 50)?


Code of Conduct Report abuse