google-app-script.md

Google App Script (GAS)

• Apps Script  |  Google Developers

  • A cloud-based JavaScript PLATFORM that lets you integrate with and automate tasks across Google products.

  Develop high quality solutions with ease

  • Automations: Write code that programmatically performs tasks across Google products. Automations are set in motion by custom menus, buttons, USER ACTIONS, or a TIME-BASED SCHEDULE.
  • Custom functions: Write Google Sheets functions in Apps Script and call them from your spreadsheet JUST LIKE BUILT-IN FUNCTIONS.
  • Add-ons: Build an app that automates tasks or connects to THIRD-PARTY SERVICES from within Google Workspace. Share your solution with others on the Google Workspace Marketplace.
  • Chat bots: Provide a conversational interface that lets Google Chat users interact with services as if the service were a person.

• Apps Script – Google Apps Script

  Build web apps and automate tasks with Google Apps Script

  • Apps Script is a rapid application development platform that makes it fast and easy to create BUSINESS APPLICATIONS that integrate with G Suite.

  • Build with Google: Feature-rich APIs let you extend Google services and build your own web applications.

  • Code on the Web: A web browser is all you need to build with Google Apps Script.

  • Share your App: Store and share your projects in Google Drive or publish on the Chrome Web Store.

    透過 Google Drive 分享!?

• Overview of Google Apps Script  |  Google Developers

  • Google Apps Script is a rapid application development platform that makes it fast and easy to create business applications that integrate with Google Workspace. You write code in modern JavaScript and have access to built-in libraries for favorite Google Workspace applications like Gmail, Calendar, Drive, and more.

    There's nothing to install—we give you a code editor right in your browser, and your scripts RUN ON GOOGLE'S SERVERS.

  What can Apps Script do?

  • Apps Script is versatile. Among other things, you can:

    • Add custom menus, dialogs, and sidebars to Google Docs, Sheets, and Forms.

    • Write custom functions and MACROS for Google Sheets.

    • Publish web apps — either standalone or embedded in Google Sites.

      可以做 web apps!? 感覺有很多的可能性 ...

    • Interact with other Google services, including AdSense, Analytics, Calendar, Drive, Gmail, and Maps.

    • Build ADD-ONS to extend Google Docs, Sheets, Slides, and Forms, and publish them to the ADD-ON STORE.

    • Convert an Android app into an ANDROID ADD-ON so that it can exchange data with a user's Google Doc or Sheet on a mobile device.

      跟 Android app 什麼關係??

    • Streamline Google Chat WORKFLOWS by building a chat bot.

• Google Apps Script: Automate, integrate with, and extend Google Workspace.

  Optimize how you work

  • Apps Script is the only LOW-CODE platform that makes it quick and easy to build business solutions that integrate, automate, and extend Google Workspace.

    With Apps Script, business users can build custom solutions on top of Google Workspace —no professional development experience required.

  • Apps Script is available to everyone with a Gmail account.

  Build quickly and easily

  • With Apps Script, business users can quickly create custom solutions to address the problems they experience every day—WITHOUT RELYING ON professional software development resources.

    這說法太理想? JavaScript 對於非技術人員還是有門檻的，畢竟 App Script 是 LOW-code platform 而非像是 No-code platform。

  Scale your productivity

  • Apps Script empowers users to focus on what matters and get the most out of Google Workspace by automating time-consuming, tedious tasks, creating integrations that connect the applications they use every day and adding functionality or customizations where and when needed.

  Use popular web languages

  • Apps Script lets you build with HTML, CSS and JavaScript—no need to learn a new proprietary framework.

  Built for Google

  • Apps Script comes ready to build. PRE-INTEGRATED Google Workspace APIs, as well as NATIVE integrations to 100+ other Google services, such as YouTube, Google Analytics, and BigQuery make it easy to take advantage of all Google has to offer.

  Example solutions

  • Create a mail merge using Gmail and Sheets

    Create and distribute visually rich MAIL MERGES with Gmail and Sheets.

  • Sign up for sessions at an event

    Enable event attendees to sign up for sessions at an event, then automatically create and email a personalized itinerary by integrating Sheets, Docs, Forms, and Gmail.

  • Analyze sentiment of open-ended feedback

    Analyze text data, such as open-ended feedback, at scale by performing entity and sentiment analysis, leveraging Cloud Natural Language directly in Sheets.

  Top questions about Apps Script

  • Do I need to pay for Google Workspace to use Apps Script?

    No. All you need is a Gmail account to begin building with Apps Script.

  • How do I get started with Apps Script?

    Explore templates for inspiration on how you can solve both common and complex business challenges in the SOLUTIONS GALLERY, or browse documentation for specifics, and take codelabs to learn more in the Google Workspace Developer Hub.

  • Where can I get support?

    Apps Script has a large online community on Google’s Apps Script Community and Stack Overflow to help answer any questions you have along the way.

AppSheet {: #vs-appsheet }

• When to use AppSheet or Apps Script in Google Workspace | Google Cloud Blog (2020-10-21)

  • We recently announced Google Workspace, which seamlessly brings together messaging, meetings, docs, and tasks to help our customers create, communicate, and collaborate even more effectively. This includes the ability to EXTEND AND CUSTOMIZE PRODUCTIVITY in ways beyond Google Workspace, through AppSheet, Google Cloud’s NO-CODE development platform, and Apps Script, Google Workspace’s integrated LOW-CODE development platform.

    注意 low-code 與 no-code 的差別。AppSheet 是 Google 的產品? 為何沒有免費提供

  • The power of these platforms comes from their ability to let anyone—even people without coding backgrounds—customize their work. Whether that means building an app that your FIELD TEAM can use to track customer visits, a custom function in Sheets that performs a specific calculation, or even a macro that automates a repetitive task, with AppSheet and Apps Script, you can create these types of custom solutions more easily than ever.

  • AppSheet and Apps Script empower users to extend the power of Google Workspace by building business apps, workflows, and automations. AppSheet lets you build custom applications on top of Google Workspace applications, as well as all other services and applications in your environment, all without writing any code.

    Meanwhile, with just a few lines of code, Apps Script lets you EXTEND AND MODIFY THE BEHAVIOR of Google Workspace applications with customizations like Sheet functions, menu items, triggers, data validation, and more.

  How no-code extends Google Workspace

  • As a TRUE NO-CODE platform, AppSheet requires no coding experience to create and deploy an app or workflow, including those that leverage your favorite Google Workspace applications. Everything can be done using AppSheet’s UI, which includes natural language capabilities powered by machine learning as well as expressions that translate complex code into user-friendly forms, similar to Sheets formulas.

    Common use cases include FIELD SERVICE (現場服務) and data capture, transportation logistics, compliance reporting, delivery tracking, facilitation of property surveys, and much more.

  • AppSheet applications allow you to harness a broad range of data sources and functions. From data captured in custom applications and SQL databases to other sources including Google Maps and Google Workspace applications like Sheets, Drive, Docs, Calendar, and Meet.

    AppSheet offers a myriad of possibilities for creating business solutions and improving workflows. AppSheet applications are deployed as MOBILE AND WEB APPS and are therefore supported by your favorite browser, whether it be on your desktop, iOS or Android platforms, giving your teams the flexibility to use their everyday work devices.

新手上路 {: #getting-started }

• Your first script - Overview of Google Apps Script  |  Google Developers

  • Build and run a simple standalone script that creates a Google Doc and emails you a link to it.

  Set it up: To build the script, follow the steps below.

  1. Sign in to your Google Account.

  2. To open the script editor, go to script.google.com. If this is the first time you've been to script.google.com, click View Dashboard.

  3. At the top left, click New project.

  4. Delete any code in the script editor and paste in the code below.

     /**
      * Creates a Google Doc and sends an email to the current user with a link to the doc.
      */
     function createAndSendDocument() {
       // Create a new Google Doc named 'Hello, world!'
       var doc = DocumentApp.create('Hello, world!');
     
       // Access the body of the document, then add a paragraph.
       doc.getBody().appendParagraph('This document was created by Google Apps Script.');
     
       // Get the URL of the document.
       var url = doc.getUrl();
     
       // Get the email address of the active user - that's you.
       var email = Session.getActiveUser().getEmail();
     
       // Get the name of the document to use as an email subject line.
       var subject = doc.getName();
     
       // Append a new string to the "url" variable to use as an email body.
       var body = 'Link to your doc: ' + url;
     
       // Send yourself an email with a link to the document.
       GmailApp.sendEmail(email, subject, body);
     }
     

  5. At the top, click Save save.

  6. At the top left, click Untitled project.

  7. Enter a name for your script and click Rename.

  Try it out: To execute the script, follow the steps below.

  1. At the top of the editor, click Run.

  2. In the first dialog box that appears, click Review permissions. In the second dialog box, review the permissions your script uses and click Allow.

     按下 Review Permission 後有一堆授權限要處理：

     • Authorization required: This project requires your permission to access your data.

     • Choose an account to continue to Hello, World!

     • Google hasn’t verified this app: The app is requesting access to sensitive info in your Google Account. Until the developer (xxx@gmail.com) VERIFIES THIS APP WITH GOOGLE, you shouldn't use it.

     • Hello, World! wants to access your Google Account: This will allow Hello, World! to:

       • Read, compose, send, and permanently delete all your email from Gmail
       • See, edit, create, and delete all your Google Docs documents

       因為用到 DocumentApp 跟 GmailApp，就會要求對應的權限。

  3. When the script execution completes, check your Gmail inbox for the new email.

  4. Open the email and click the link to open the Google Doc you created.

參考資料 {: #reference }

• My Projects - Apps Script
• Solutions Gallery

社群：

• 'google-apps-script' Questions - Stack Overflow
• script.gs
• AppsScriptPulse

手冊：

• Reference |  Apps Script
• Release Notes | Apps Script

相關：

• AppSheet