Posted by Kara Eire, Technical Author & Charles Maxson, Developer Advocate
Google Apps Script is a hosted JavaScript improvement surroundings that makes it simple for anybody to construct customized enterprise options throughout a number of Google merchandise. Determining the place to start is usually a hurdle for such an expansive instrument, so we have lately launched 10 new inspirational pattern options that will help you get began. These additions bolster the Apps Script documentation, which now hosts greater than 30 pattern options.
Apps Script welcomes builders of all talent ranges, from newcomers to professionals. We’re constantly impressed with the artistic and progressive methods builders have automated enterprise processes with Apps Script–from revealed add-ons that assist tens of millions of customers to easy automations that assist small groups do massive issues. Individuals everywhere in the world use Apps Script to make work simpler in methods we by no means may have imagined.
In the event you’re new to Apps Script, or just on the lookout for new concepts, we invite you to try the pattern options in our documentation.
Listed below are a number of use circumstances our latest pattern options deal with:
Summarize knowledge from a number of sheets
Apps Script undertaking kind: Customized operate
Coding stage: Newbie
Customized features can scale back spreadsheet complexity by changing quite a few built-in Sheets features. In case you have equally structured knowledge on a number of sheets in a spreadsheet, you should use this practice operate to create a abstract of every sheet.
You’ll learn to programmatically:
- Iterate by sheets in a spreadsheet to carry out customized calculations.
- Exclude particular sheets out of your calculations.
- Course of spreadsheet knowledge utilizing optimized array objects.
Add information to Google Drive from Google Varieties
Venture kind: Automation with an event-driven set off
Coding stage: Newbie
Automations can programmatically carry out duties throughout Google merchandise and may be set in movement by customized menus, buttons, person actions, or a time-based schedule. Use this automation to concurrently add and set up information in Drive utilizing Varieties. The customizable pattern kind consists of inputs for the information to add and learn how to set up them.
You’ll learn to programmatically:
- Implement a set off to run a script with each kind submission.
- Seize and course of person inputs from a kind.
- Manage uploaded information inside Drive.
Clear up knowledge in a spreadsheet
Venture kind: Editor Add-on
Coding stage: Intermediate
Editor Add-ons are extremely customizable and might automate frequent duties in Google Docs, Sheets, Slides, or Varieties. With this add-on, you may clear up spreadsheet knowledge in Sheets by mechanically eradicating empty rows and columns, cropping the spreadsheet to the sides of the info vary, and filling in gaps within the knowledge.
You’ll learn to programmatically:
- Use arrays to effectively determine and delete empty rows and columns.
- Fill in knowledge gaps with out overwriting non-empty cells.
- Construct an Editor Add-on menu that shows underneath the Extensions menu in Sheets.
Schedule conferences from Google Chat
Venture kind: Google Chat app
Coding stage: Intermediate
Google Chap apps present a conversational interface that lets Chat customers work together with providers as if the service had been an individual. Use this Chat app to schedule a gathering in Google Calendar from inside a direct message or an area in Chat. You possibly can set particular particulars for the assembly, similar to topic, begin time, or length, or use the default settings for fast assembly scheduling.
You’ll learn to programmatically:
- Ship a response when a Chat app is messaged or added to an area.
- Collect person inputs with a customized dialog.
- Add a brand new Calendar occasion and reply in Chat with the occasion URL.
Copy macros to different spreadsheets
Venture kind: Google Workspace Add-on
Coding stage: Intermediate
Google Workspace Add-ons supply a standardized person interface and can be utilized throughout a number of Google Workspace functions. With this add-on, you may mechanically copy a script undertaking and fasten it to a specified spreadsheet. Although this add-on focuses on Sheets macros, you should use it to repeat and share any container-bound script.
You’ll learn to programmatically:
- Create a card-based interface for a Google Workspace Add-on.
- Copy information from a container-bound Apps Script undertaking.
- Create a brand new container-bound Apps Script undertaking and add the copied information.
Discover extra samples and join with us
The above is only a sampling (pun supposed) of the options we’ve constructed for our developer group. To get impressed on your subsequent Apps Script undertaking, view all of the pattern options in our documentation. Additionally, try the newest function updates of the Apps Script IDE that will help you construct shortly and simply.
We’d like to know what you suppose. To provide suggestions on a pattern, on the high of the documentation web page, click on Ship suggestions. For extra updates and information concerning the Google Workspace Platform, subscribe to our developer publication.
