Tag Archives: Google Apps Script

Google Apps Script

Google Apps Script – Google Analytics API usage limit error – part 051.

1
2
3
GoogleJsonResponseException: API call to youtube.channels.list failed with error:
The request cannot be completed because you have exceeded your
<a href="/youtube/v3/getting-started#quota">quota</a>.

… indicating that you have reached the usage limit for the YouTube API. for each A.P.I. comes a different limit of usage, on the case of YouTube API, each user is assigned a set of quota units per day, which can be used to make requests to the A.P.I. and once the usage limit… Read More »

Google Apps Script – Google Analytics API service – part 050.

This is a simple example with Google Analytics API service settings. You need to add the Analytics service version 3.

JavaScript
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
function getAnalytics() {
  // get data with Google Analytics API service settings version 3
  var viewId = "ga:YOUR_views_number";
  var metrics = [{expression: "ga:sessions"}];
  var dimensions = [{name: "ga:date"}];
  var startDate = "2022-01-01";
  var endDate = "2022-01-31";
  var results = Analytics.Data.Ga.get(
    viewId,
    startDate,
    endDate,
    'ga:visitors,ga:visits,ga:pageviews',
    {dimensions: "ga:date"});
  Logger.log(results);
}

The result is shown in the Google Apps Script editor with Logger.log :

1
2
3
4
5
6
7
8
{kind=analytics#gaData, id=https://www.googleapis.com/analytics/v3/data/ga?ids=ga:
YOUR_views_number&dimensions=ga:date&metrics=ga:visitors,ga:visits,ga:
pageviews&start-date=2022-01-01&end-date=2022-01-31, columnHeaders=[{name=ga:date,
dataType=STRING, columnType=DIMENSION}, {columnType=METRIC, name=ga:visitors,
dataType=INTEGER}, {name=ga:visits, dataType=INTEGER, columnType=METRIC},
{dataType=INTEGER, columnType=METRIC, name=ga:pageviews}], totalResults=31.0, rows=
[[20220101, 33, 33, 41],
...

Google Apps Script – custom google search engine – part 048.

This Google Apps Script can get a label email and parse the content with regular expressions. In this case, it is an email sent by google and the script will search by the label “alerts” then the result is parsed with regular expressions to find a title and a description. The primary condition is to… Read More »

Google Apps Script – custom google search engine – part 047.

In this tutorial, I will show you how to create a custom google search engine to search large images. You can customize this engine if you want. The first step is to set the YOUR_API_KEY using the webpages from the commented source code: In the next one, you need to set the YOUR_SEARCH_ENGINE_ID using the… Read More »

Google Apps Script – Gmail A.P.I. – part 046.

In this tutorial, I will show you how to select only those that correspond to a list of email addresses from the list of emails received on a Gmail account. Obviously, you can modify this script to perform other operations: delete them, assign them a label, … Create a spreadsheet in Google Drive and from… Read More »

Google Apps Script – OpenAI and testing with google youtube A.P.I. – part 045.

Open the OpenAI Chat and ask to create a script for Google Apps Script, see my example: The result was this script:

JavaScript
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 getLastUploadedVideo(channelId) {
  // Use the YouTube Data API to get information about the channel
  var channelResponse = YouTube.Channels.list('contentDetails', {
    id: channelId
  });
 
  // Get the uploads playlist ID from the channel response
  var playlistId = channelResponse.items[0].contentDetails.relatedPlaylists.uploads;
 
  // Use the YouTube Data API to get information about the latest video in the uploads playlist
  var playlistResponse = YouTube.PlaylistItems.list('snippet', {
    playlistId: playlistId,
    maxResults: 1
  });
 
  // Get the video ID and title from the playlist response
  var videoId = playlistResponse.items[0].snippet.resourceId.videoId;
  var videoTitle = playlistResponse.items[0].snippet.title;
 
  // Return an object containing the video ID and title
  return {
    id: videoId,
    title: videoTitle
  };
}

You need to create a Google Apps script or use a script from an older project, and it will ask for YouTube permissions. I need to change this source code with the… Read More »

Google Apps Script – testing online google youtube A.P.I. – part 044.

If you still haven’t figured out how Google’s A.P.I. works, here’s a simple example to help you understand. Open this link and fill in only the fields part and channelId with: snippet and UChdrIsYOHZXgEyCLaOHc2Ew. This string ID UChdrIsYOHZXgEyCLaOHc2Ew is the channelId for the TVRcanaluloficial youtube channel. Then press Execute button and give the authorization for… Read More »