Today I will show you how to make a SideBar addon with Google Apps Script. This tutorial is very simple. Open one sheet into your google drive account. Go to Tools – Script editor … and that will open a new tab into your browser with the script editor. Save your sheet and your project… Read More »
This is a five example with google script using Youtube API. You can see my last tutorials about learning with Google Apps Script to add and use a script. The example is very simple , just see the source code:
|
1 2 3 4 5 6 7 8 |
function YT_Details() { var ytsheet = SpreadsheetApp.getActiveSheet(); var ytvideo = ytsheet.getRange("A2").getValue(); var data = YouTube.Videos.list('snippet, statistics',{id: ytvideo}); var item = data.items[0]; var info = [item.snippet.title,item.snippet.tags,item.statistics.viewCount]; ytsheet.getRange("B2:D2").setValues([info]); } |
The SpreadsheetApp take active sheet from your document. The content of A2 cell is… Read More »
This tutorial is about how to add a custom into your google document using the google app script. First you need to have one open document and then click into menu : Tools – Script editor … You will see a new document into your browser with a link like this: https://script.google.com … This will… Read More »
The Maps Services service allows scripts to generate static maps, find directions, convert addresses into geocode coordinates, and sample elevations. This is a simple example about how to make one static map using data from one spreadsheet. Also you need to follow this tutorial. I put all comments on script to make simple to read… Read More »
What is a trigger ? The google come with : A trigger is a type of script resource that listens for a particular event and executes a function when that event fires. Let’s make a simple example using triggers. I will make a script to sent a simple mail every 1 minute. First will need… Read More »