Get a list of up to 1,000 YouTube subscribers for your channel, including name, channel ID & photo, of users who subscribe to you and make their subscription data public. This formula’s workflow will automatically paginate through the YouTube Data API Subcriptions Endpoint on your behalf, aggregating all the results together into a single CSV file.
Import this formula to copy the workflow into your account, which will ask you for your OAuth Access Token. You can go to the Google OAuth Playground to get your token, just select
https://www.googleapis.com/auth/youtube.readonly for your scope and click the next button to get your Access Token. Run the workflow and you’ll get back your subscriber data in a single CSV.
Note: The API seems to returns duplicates when paginating through multiple pages. Be sure to de-duplicate the
items.id column (which is done automatically if you use this in another workflow like the YouTube Subcriptions Formula).