Google Apps Script Get Spreadsheet Id

Jul 27, 2019
val spreadsheetId = SpreadsheetApp.getActiveSpreadsheet().getId()

Same as spreadsheet id as shown in url: https://docs.google.com/spreadsheets/d/SPREADSHEET_ID/edit#gid=0.

❤️ Is this article helpful?

Buy me a coffee ☕ or support my work via PayPal to keep this space 🖖 and ad-free.

Do send some 💖 to @d_luaz or share this article.

✨ By Desmond Lua

A dream boy who enjoys making apps, travelling and making youtube videos. Follow me on @d_luaz

👶 Apps I built

Travelopy - discover travel places in Malaysia, Singapore, Taiwan, Japan.

Tags
Related articles
Google Sheets App Scripts: Make PubSub Publish CallGoogle Apps Script: Loop ArrayGoogle Apps Script: Confirm DialogUrlFetchApp With Login CredentialsGoogle Apps Script: Http GET Request With Query ParameterGoogle Apps Script: Global VariableGoogle Sheets App Scripts: Show and Close SidebarGoogle Sheets App Scripts: Show AlertGoogle Sheets Add Button With Apps Script EventGoogle Apps Script: Format StringGoogle Sheets Apps Scripts: Custom Function Convert Unix Timestamp to DateGoogle Apps Script: Google Sheets Click Event Trigger on Mobile/AndroidGoogle Apps Script: Update Column When Row Is Modified/Edited