Sunday, December 3, 2023
HomeSoftware DevelopmentDiscover inspiration with Apps Script samples

Discover inspiration with Apps Script samples

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.

Do this answer >>

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.

Do this answer >>

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.

Do this answer >>

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.

Do this answer >>

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.

Do this answer >>

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.



Please enter your comment!
Please enter your name here

Most Popular

Recent Comments