-
Notifications
You must be signed in to change notification settings - Fork 33
/
Copy pathscrapeCommentsWithoutReplies.gs
25 lines (23 loc) · 1.06 KB
/
scrapeCommentsWithoutReplies.gs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
function scrapeCommentsWithoutReplies(){
var ss = SpreadsheetApp.getActiveSpreadsheet();
var result=[['Name','Comment','Time','Likes','Reply Count']];
var vid = ss.getSheets()[0].getRange(1,1).getValue();
var nextPageToken=undefined;
while(1){
var data = YouTube.CommentThreads.list('snippet', {videoId: vid, maxResults: 100, pageToken: nextPageToken})
nextPageToken=data.nextPageToken
//console.log(nextPageToken);
for (var row=0; row<data.items.length; row++) {
result.push([data.items[row].snippet.topLevelComment.snippet.authorDisplayName,
data.items[row].snippet.topLevelComment.snippet.textDisplay,
data.items[row].snippet.topLevelComment.snippet.publishedAt,
data.items[row].snippet.topLevelComment.snippet.likeCount,
data.items[row].snippet.totalReplyCount]);
}
if(nextPageToken =="" || typeof nextPageToken === "undefined"){
break;
}
}
var newSheet=ss.insertSheet(ss.getNumSheets())
newSheet.getRange(1, 1,result.length,5).setValues(result)
}