Getting started with google-apps-script Spreadsheet Service DriveApp Service - Files by type and search string Spreadsheet Add Menu Apps Script Web Apps Google sheets MailApp DriveApp Create a custom function for Google Sheets SpreadsheetApp Active Sheet GmailApp DriveApp - getFileById(id)DriveApp Service Google Web App Script To Auto Download From Google Drive Client calls to Google apps-script Firebase and AppScript : Introduction

SpreadsheetApp Active Sheet

Remarks:

Method: getActive()

Return Type: Spreadsheet

getActive() - Get active spreadsheet

This returns the currently active spreadsheet, or null if there is none.

var currentSheet = SpreadsheetApp.getActive();
var url = currentSheet.getUrl();
Logger.log( url );

Contributors

Topic Id: 5861

Example Ids: 20627

This site is not affiliated with any of the contributors.