This Google Apps Script tutorial will show you how to search for videos from YouTube. First, you need to run this script with and YouTube Data A.P.I. and one Spreadsheet. The script will get the title and id of the first 50 videos info and the result is put into the Shee1. This is the… Read More »
This is another example with Google Apps Script and Calendar A.P.I. The A.P.I. reference calendar can be found at the official webpage. This simple example gets all your calendars and put into Logger.
|
1 2 3 4 5 6 7 |
function get_calendars() { var calendars = CalendarApp.getAllCalendars(); for (var i = 0; i < calendars.length; i++) { var calendar = calendars[i]; Logger.log(calendar.getName()); } } |
The output can be seen on Logger from the main menu of script.google.com with View – Logs or pressing Ctrl +… Read More »
This simple apps script can get an image from the web , save it and return the URL from Google Drive.
|
1 2 3 4 5 6 7 8 9 |
imageUrl = 'http://0.gravatar.com/avatar/24617651310fd4e77c246f8e96efb900' function fetchImageToDrive(imageUrl){ //Fetch image blob var imageBlob = UrlFetchApp.fetch(imageUrl).getBlob(); //Create image file in drive var image = DriveApp.createFile(imageBlob); //return the URL of the newly created image in drive return image.getUrl(); } |
This type of new redirect link to the new project is a new way to write permissions to google apps script. This new way comes when you use the steps: – create a document; – write source code; – try to have permission to google account; This can be fixed using the old way by… Read More »