⚙️ YouTube Channel -> Comments & Replies Workflow Formula By steve


Get all of the comments & replies for all of the videos in a given YouTube channel. This will first get all of the videos for the channel and then get all of the comments & replies for each video, performing pagination for both iterations automatically.

Getting Started

Import this formula and it will add three chained workflows to your account. You’ll want to begin by running the (1/3) workflow and enter the channel ID you want to get the comments for. This will then get the “uploads” playlist ID (needed to get all the videos) and pass this on to the (2/3) workflow (to get all the uploaded vidoes from the upload playlist ID). Once the (2/3) step is done, it will pass the list of all video IDs to the (3/3) step to get all of the comments.

Note: Be aware that this may result in making A LOT of requests to the YouTube API on your behalf. Note that you may be billed by Google for your usage of their API (a seperate charge from this platform). If you need to abort a workflow run, be sure to watch and stop all 3 workflow runs (stopping one will still allow subsequent workflow runs to proceed).

⚙️  YouTube Channel -> Comments & Replies (1/3)

Inputs

YouTube Channel IDs
List
➡️ Channel ID

The channel ID to look up. For example, in the URL https://www.youtube.com/channel/UCArmutk8nAbYQdaYzgqKOwA/ the channel ID would be UCArmutk8nAbYQdaYzgqKOwA. If you only know the username (the URL doesn’t contain /channel/), then see the YouTube User Channels endpiont to get the channel ID from the username.

Part Example: id,snippet,contentDetails,statistics

Parts to return in the response.

  • auditDetails
  • brandingSettings
  • contentDetails
  • contentOwnerDetails
  • id
  • localizations
  • snippet
  • statistics
  • status
  • topicDetails

Extractors

  • YouTube Channel Details .
⚙️  YouTube Channel -> Comments & Replies (2/3)

YouTube Channel -> Comments & Replies (1/3) (External Trigger) Extractor: YouTube Channel Details items[0].contentDetails.relatedPlaylists.uploads ➡️ Playlist ID

Playlist ID to return videos for

YouTube Playlist Videos - Pagination Token (Self-Loop) Pagination Limit: Unlimited ➡️ Pagination Token

Pagination token from the previous response. Leave this blank at first and then look for the nextPageToken value in the response’s root collection to get the next page of results.

Limit Example: 50

Number of videos to return from the playlist per request.

Pagination Token Example: QWRTSl9pMXBPTTB4Ulk1VVNxMFtPQjFrVEdMRFowbjhTdHFfaWdpUlBYVFBNLWFpc0M5Q3pPaXRTYXhKU1JKbDFsVjgxVDRQTjVYbUgxdw==

Pagination token from the previous response. Leave this blank at first and then look for the nextPageToken value in the response’s root collection to get the next page of results.

Part Example: id,snippet

Parts to return in the response per the “part” values allowed here: https://developers.google.com/youtube/v3/docs/videos/list

Extractors

  • YouTube Playlist Videos .items
⚙️  YouTube Channel -> Comments & Replies (3/3)

YouTube Channel -> Comments & Replies (2/3) (External Trigger) Extractor: YouTube Playlist Videos items.snippet.resourceId.videoId ➡️ Video ID

The video ID to look up. For example, in the URL https://www.youtube.com/watch?v=qRv7G7WpOoU the video ID would be qRv7G7WpOoU.

YouTube Comments - Pagination Token (Self-Loop) Pagination Limit: Unlimited ➡️ Pagination Token

Pagination token from the previous response. Leave this blank at first and then look for the nextPageToken value in the response’s root collection to get the next page of results.

Limit Example: 100

How many comments to return per request.

Order Example: time

Order to return the results back, either relevance or time.

Pagination Token Example: QWRTSl9pMXBPTTB4Ulk1VVNxMFtPQjFrVEdMRFowbjhTdHFfaWdpUlBYVFBNLWFpc0M5Q3pPaXRTYXhKU1JKbDFsVjgxVDRQTjVYbUgxdw==

Pagination token from the previous response. Leave this blank at first and then look for the nextPageToken value in the response’s root collection to get the next page of results.

Part Example: id,snippet,replies

Part to return

Extractors

  • YouTube Comment Replies .items.replies.comments
  • YouTube Comments .items
Posted by steve on April 9, 2020, 10:11 p.m. 🚩  Report