Add file for coming-soon Apps Script quickstart guide.

youtube · Apr 25, 2017 · 875d380 · shuv2866 · May 29, 2020 · veemusica
1 parent 954f7e0
commit 875d380
Showing 1 changed file with 36 additions and 0 deletions .
diff --git a/apps-script/quickstart.gs b/apps-script/quickstart.gs
@@ -0,0 +1,36 @@
+// Note: Apps Script automatically requests authorization
+// based on the API's used in the code.
+
+function
 channelsListByUsername
(
part
,
 params
)
 {
+  var
 response
 =
 YouTube
.
Channels
.
list
(
part
,
+                                       params
)
;
+  var
 channel
 =
 response
.
items
[
0
]
;
+  var
 dataRow
 =
 [
channel
.
id
,
 channel
.
snippet
.
title
,
 channel
.
statistics
.
viewCount
]
;
+  SpreadsheetApp
.
getActiveSpreadsheet
(
)
.
appendRow
(
dataRow
)
;
+}
+
+function
 getChannel
(
)
 {
+  var
 ui
 =
 SpreadsheetApp
.
getUi
(
)
;
+  var
 channelName
 =
 ui
.
prompt
(
"Enter the channel name: "
)
.
getResponseText
(
)
;
+  channelsListByUsername
(
'snippet,contentDetails,statistics'
,
+                         {
'forUsername'
: 
channelName
}
)
;
+}
+
+function
 getGoogleDevelopersChannel
(
)
 {
+  channelsListByUsername
(
'snippet,contentDetails,statistics'
,
+                         {
'forUsername'
: 
'GoogleDevelopers'
}
)
;
+}
+
+function
 onOpen
(
)
 {
+  var
 firstCell
 =
 SpreadsheetApp
.
getActiveSheet
(
)
.
getRange
(
1
,
 1
)
.
getValue
(
)
;
+  if
 (
firstCell
 !=
 'ID'
)
 {
+    var
 headerRow
 =
 [
"ID"
,
 "Title"
,
 "View count"
]
;
+    SpreadsheetApp
.
getActiveSpreadsheet
(
)
.
appendRow
(
headerRow
)
;
+  }
+  var
 ui
 =
 SpreadsheetApp
.
getUi
(
)
;
+  ui
.
createMenu
(
'YouTube Data'
)
+  .
addItem
(
'Add channel data'
,
 'getChannel'
)
+  .
addSeparator
(
)
+  .
addItem
(
'Add GoogleDevelopers data'
,
 'getGoogleDevelopersChannel'
)
+  .
addToUi
(
)
;
+}