#google appscript

Summary-  Google App Script are small snippets of code that add custom functions and integrations into your G Suite applications. It has a development environment that may be completely different from what we are used to.

Google App Script is a cloud-based and lightweight app developed by Google to automate simple tasks. If someone is already using G Suite apps for your enterprise, Apps Script comes at no extra cost. 

By using Google App Script

We can develop a browser-based code editor but can choose to develop locally if using CLASP, the command-line deployment tool for Apps Script

We can do coding in a specialized version of JavaScript customized to access G Suite, and other Google or external services.

We can safely ignore writing authorization code because Apps Script handles it for you

Do not have to host the app, it lives and runs on Google servers in the cloud

                                                 Picture Courtesy-Infiflex

Benefits of Using Google App Script

Google App Script is completely a perfect tool for anyone who wants to customize Google Apps for their organization. If someone uses Google Apps Script and if they are looking to automate simple tasks, unlock the potential of other G Suite apps, access data from Google cloud infrastructure, and share scripts with other users as add-ons. Most of the users can get their first experience with automation through the cloud scripting app.

It is based on JavaScript; easy to learn.

Provides a cloud based debugger for debugging App Scripts in the web browser.

We can create simple tools for an organization's internal consumption.

Used to perform simple system administration tasks.

Community based support model.

What can App Script Do?

Google App Script can do a lot of things like automatically transfer the emails from Gmail to Drive based on the labelling, give deadlines to tasks and sync it with Google Calendar to get notifications. 

Following are the other things which you can do by using App Script-

We can Add custom menus, dialogs and sidebars to Google Docs, Sheets and forums.

We can write custom functions for Google Sheets.

Publish web apps.

We can also interact with other google services that include AdSense, Analytics, Calendar, Drive, Gmail, and Maps.

Build add-ons to extend Google Docs, Sheets, Slides and Forms and publish them to the add-ons store.

Uses of Google App Script

Make bulk changes to services like Google Calendar 

Create Mail Merge to use in your Gmail emails 

Send multiple emails from a spreadsheet.

Google Appscript is a cloud based scripting language for extending the functionality of Google Apps and building lightweight web-based applications.This is a coding language where you can write small write small programs performing custom behaviors that go the standard featuresGoogle Apps. The code is stored and executed on Google’s servers.

It means you can do cool stuff like automating repetitive tasks, creating, modifying and emailing documents to people, and linking up your Google Sheets to other data sources. Heck, you can even build complex web forms, use a Google Sheet as your database, programatically create charts and publish it all to the web. In other words, you can build fully featured, lightweight web applications.

                                              Picture Courtesy-Infiflex

 Writing your first Google Apps Script

In this Google Sheets script tutorial, we’re going to write a script that is bound to our Google Sheet, or you might say contained within our Google Sheet. This is known in the jargon as a container-bound script.

Benefits of Google App Script

 Since it is based on javascript, it is very easy to learn and implement.

It provides a community-based support model.

It can be used to create simple tools for the organization internally as well as globally.

Since the script is executed in Google Cloud, it provides cloud debugger rather than client debugger which helps to debug the App Script in the Web Browser.

Apps Script lets you build powerful add-ons for Google Apps with snippets of JavaScript code. Take a few minutes to code a script, and you can mold apps like Gmail, Google Sheets, and Google Drive into custom tools for your business. A script could, for example, automatically send email thank-yous with Gmail and a Google spreadsheet, or automatically add new people from a spreadsheet to Google Contacts. 

There are two main types of scripts you can use with Google Apps: standalone and bound scripts.

1. Standalone scripts

Standalone scripts are not attached to any particular app in your Google account. Instead, think of them as macros that perform system-wide functions.

A standalone script could search your Google Drive for all items with the name ‘untitled’ (the default name Google gives to files when the name isn’t specified), for example, as a handy way to keep your Google Drive clutter-free.

You'll see standalone scripts alongside your other Google Drive files, and each file contains JavaScript for your particular function.

2. Bound scripts

Bound scripts extend the functionality of a certain file in one of your Google apps. They perform specific actions directly to that particular file.

Google Appscript is a cloud based scripting language for extending the functionality of Google Apps and building lightweight web-based applications.This is a coding language where you can write small write small programs performing custom behaviors that go the standard featuresGoogle Apps. The code is stored and executed on Google’s servers.

It means you can do cool stuff like automating repetitive tasks, creating, modifying and emailing documents to people, and linking up your Google Sheets to other data sources. Heck, you can even build complex web forms, use a Google Sheet as your database, programatically create charts and publish it all to the web. In other words, you can build fully featured, lightweight web applications.

Picture Courtesy-Infiflex

Writing your first Google Apps Script

In this Google Sheets script tutorial, we’re going to write a script that is bound to our Google Sheet, or you might say contained within our Google Sheet. This is known in the jargon as a container-bound script.

Benefits of Google App Script

Since it is based on javascript, it is very easy to learn and implement.

It provides a community-based support model.

It can be used to create simple tools for the organization internally as well as globally.

Since the script is executed in Google Cloud, it provides cloud debugger rather than client debugger which helps to debug the App Script in the Web Browser.

Apps Script lets you build powerful add-ons for Google Apps with snippets of JavaScript code. Take a few minutes to code a script, and you can mold apps like Gmail, Google Sheets, and Google Drive into custom tools for your business. A script could, for example, automatically send email thank-yous with Gmail and a Google spreadsheet, or automatically add new people from a spreadsheet to Google Contacts.

There are two main types of scripts you can use with Google Apps: standalone and bound scripts.

1. Standalone scripts

Standalone scripts are not attached to any particular app in your Google account. Instead, think of them as macros that perform system-wide functions.

A standalone script could search your Google Drive for all items with the name ‘untitled’ (the default name Google gives to files when the name isn’t specified), for example, as a handy way to keep your Google Drive clutter-free.

You'll see standalone scripts alongside your other Google Drive files, and each file contains JavaScript for your particular function.

2. Bound scripts

Bound scripts extend the functionality of a certain file in one of your Google apps. They perform specific actions directly to that particular file.

GoogleSpreadSheetでドキュメントを管理していたのだが、ある日シートが追加できなくなった。どうやら制限があるらしい…。

のでそれはそれとして別に保存しておいて、シートを削除して制限を逃れようと考えた。新しいのを作ってもいいんだけどそれだと共有ユーザとか色々面倒臭いので…。

結論

GoogleSpreadSheetが提供している機能ではできません。ので、GoogleAppScriptを書いて無理やり消します。

ソース

function onOpen() { var arr = [ {name: "シート削除", functionName: "delete_sheet"} ]; var spreadsheet = SpreadsheetApp.getActiveSpreadsheet(); spreadsheet.addMenu("マイメニュー", arr); } function delete_sheet(){ var sS = SpreadsheetApp.getActiveSpreadsheet(); var sheets = sS.getSheets(); //削除したくないシート var preserveSheets = [ "format", "readme" ]; for(var i = 0;i<sheets.length;i++){ var checkSheetName = sheets[i].getSheetName(); var isPreserve = false; for(var j = 0;j<sheets.length;j++){ if(j == checkSheetName){ isPreserve = true; break; } } if(!isPreserve){ sS.deleteSheet(sheets[i]); } } }