Category Archives: Google Apps Script

Google Apps Script

Google Apps Script – RSS reader – part 035.

This is a simple Google Apps Script for read a atom RSS file type. This not work with any rss file type , just with this type:

This is the script:

Google Apps Script – get all your liked videos – part 034.

In this tutorial, I will show you how to get the first 76 videos from youtube that you clicked on the like button. The dimension parameter is also displayed and its value is returned.

The result looks like this:

Google Apps Script – get all channels with your likes – part 033.

This tutorial contains a function that can be included in your Google Apps Script and will help you monitor likes based on the youtube channel you liked. The function returns the Youtube channel you liked in the order from the last like to the first.

The output results in the Execution log area show… Read More »

Google Apps Script – getValue or getDisplayValue – part 032.

In this tutorial, I will show you the differences between getValue and getDisplayValue in Google Apps Script. I used a default project with a default spreadsheet document with my birthday 1976-03-07 into A1 cell and format text as year-month-day. I add Apps Script API to my project. On the spreadsheet, I used Tools – Script… Read More »

Google Apps Script – shows a popup window – part 031.

The tutorial for today is about toast message into a spreadsheet. Use script editor, run the next code source it with authorization:

You will see a message toast in the bottom right area of the spreadsheet with this text: This is a toast message!

Google Apps Script – about Class GmailThread – part 030.

Today I will present briefly Class GmailThread. It can be used to retrieve data from incoming electronic mail received by Gmail. Let’s see a simple example. First, open a spreadsheet, and from Tools open the Script editor to run this source code:

. Add and run with authorization for Gmail A.P.I. and you will see… Read More »

Google Apps Script – delete a email – part 029.

This is simple to do. Open a GAS script in google editor. You can use the google drive menu New – Google Apps Script or create a new document and use from menu: Tools – Script editor to open a new google apps script editor. Select Gmail A.P.I. from the menu: Resources – Advanced Google… Read More »

Google Apps Script – get activities – part 028.

This is an update the last tutorial about Google Apps Script and shows you how to use App First, you need to update your Advanced Google services. Open an empty google document text or spreadsheet and using the main menu to open the Script editor from the menu Tools. You need to enable the API… Read More »