Tag Archives: Google Apps Script

Google Apps Script

Google Apps Script – search YouTube videos by location – part 013.

This is a simple example of how to search on YouTube by location. You need to use the same steps as in my previews tutorials. Use this source code of Google Apps Script to see result into menu: View Logs.

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
26
27
28
29
30
// Apps Script to remove parameters that don't have values before sending API request
function removeEmptyParams(params) {
  for (var p in params) {
    if (!params[p] || params[p] == 'undefined') {
      delete params[p];
    }
  }
  return params;
}
 
// Apps Script code for printing API response data
 
function printResults(response) {
  Logger.log(response);
}
 
function searchListByLocation(part, params) {
  params = removeEmptyParams(params); // See full sample for function
 
  var response = YouTube.Search.list(part,
      params);
  printResults(response);
}
 
function Main() {
  searchListByLocation('snippet', {'location': '47.4616,26.3015',
'locationRadius': '10mi',
'q': '',
'type': 'video'});
}

Google Apps Script – extract text from PDF file – part 012.

This tutorial has two parts. The first part refers to a book about javascript in different formats. The second part is about processing PDF files with Google Apps Script. Let’s start with the first part. The book is at this web address. The author comes with this brief introduction: Eloquent JavaScript 3rd edition This is… Read More »

Google Apps Script – the CLASP tool – part 011.

This tutorial is about CLASP. You can use locally this tool that lets you to create, edit, and deploy Apps Script projects. The clasp requires Node.js >= v4.7.4 to be installed.

Shell
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
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
C:\nodejs>npm i @google/clasp -g
C:\Users\catafest\AppData\Roaming\npm\clasp -> C:\Users\your_account\AppData\Roaming
\npm\node_modules\@google\clasp\src\index.js
+ @google/clasp@1.6.3
added 278 packages from 159 contributors in 161.263s
 
C:\nodejs>clasp
Usage:  <command> [options]
 
clasp - The Apps Script CLI
 
Options:
  -h, --help                                       output usage information
 
Commands:
  login [options]                                  Log in to script.google.com
  logout                                           Log out
  create [options] [scriptTitle] [scriptParentId]  Create a script
  clone [scriptId] [versionNumber]                 Clone a project
  pull [options]                                   Fetch a remote project
  push [options]                                   Update the remote project
  status [options]                                 Lists files that will be push
ed by clasp
  open [options] [scriptId]                        Open a script
  deployments                                      List deployment ids of a scri
pt
  deploy [version] [description]                   Deploy a project
  undeploy <deploymentId>                          Undeploy a deployment of a pr
oject
  redeploy <deploymentId> <version> <description>  Update a deployment
  versions                                         List versions of a script
  version [description]                            Creates an immutable version
of the script
  list                                             List App Scripts projects
  logs [options]                                   Shows the StackDriver logs
  run [options] <functionName>                     Run a function in your Apps S
cripts project
  apis                                             List, enable, or disable apis
  help                                             Display help
  *                                                Any other command is not supp
orted
 
C:\nodejs>clasp login
No credentials given, continuing with default...
?  Authorize clasp by visiting this url:
https://accounts.google.com/o/oauth2/v2/auth?access_type=offline&scope=https...

This will open a webpage to authenticate with your Google account. Next step: create your project folder and use it with Google Apps… Read More »