Tag Archives: Google Apps Script

Google Workspace Updates Weekly Recap – September 23, 2022

New updates 


There are no new updates to share this week. Please see below for a recap of published announcements. 


Previous announcements

The announcements below were published on the Workspace Updates blog earlier this week. Please refer to the original blog posts for complete details.


Introducing new spacing feature on Google Sites
In addition to adjusting the spacing between content in Sites using a new density theme setting, you're now able to use spacers to add empty space to your Sites in specific places. | Learn more



Updated Apps Script integrated development environment will replace the legacy experience by Q4 2022 
By the end of Q3 2022, we will begin turning down the legacy experience. Beginning Q4 2022, the new IDE will become the default experience with no option to revert. | Learn more.


For a recap of announcements in the past six months, check out What’s new in Google Workspace (recent releases).

Google Workspace Updates Weekly Recap – September 23, 2022

New updates 


There are no new updates to share this week. Please see below for a recap of published announcements. 


Previous announcements

The announcements below were published on the Workspace Updates blog earlier this week. Please refer to the original blog posts for complete details.


Introducing new spacing feature on Google Sites
In addition to adjusting the spacing between content in Sites using a new density theme setting, you're now able to use spacers to add empty space to your Sites in specific places. | Learn more



Updated Apps Script integrated development environment will replace the legacy experience by Q4 2022 
By the end of Q3 2022, we will begin turning down the legacy experience. Beginning Q4 2022, the new IDE will become the default experience with no option to revert. | Learn more.


For a recap of announcements in the past six months, check out What’s new in Google Workspace (recent releases).

Updated Apps Script integrated development environment will replace the legacy experience by Q4 2022

What’s changing 

In December 2020, we announced an updated and improved experience for the Apps Script integrated development environment (IDE). Since then, it has been possible to access the legacy IDE. By the end of Q3 2022, we will begin turning down the legacy experience. Beginning Q4 2022, the new IDE will become the default experience with no option to revert. 


Who’s impacted 

Admins and developers 


Why it’s important 

Apps Script is a rapid application development platform that makes it fast and easy to create custom business solutions that integrate with Google Workspace and that increase the power of apps including Calendar, Docs, Drive, Gmail, Sheets, and Slides. With this launch, we’ve revamped the cloud-based IDE that helps you create, edit, and manage projects. The new IDE simplifies the experience of developing for Google Workspace — for more information, see our original announcement, as well as additional features we announced in April 2022 to reach parity with the legacy experience. 


Getting started 



Rollout pace 



Availability 

  • Available to Google Workspace customers, as well as legacy G Suite Basic and Business customers 

Resources 

Getting started is the hardest part: Find inspiration with Apps Script samples

Posted by Kara Ireland, Technical Writer & Charles Maxson, Developer Advocate

Google Apps Script is a hosted JavaScript development environment that makes it easy for anyone to build custom business solutions across several Google products. Figuring out where to begin can be a hurdle for such an expansive tool, so we've recently released 10 new inspirational sample solutions to help you get started. These additions bolster the Apps Script documentation, which now hosts more than 30 sample solutions.

Apps Script welcomes developers of all skill levels, from beginners to professionals. We’re consistently impressed with the creative and innovative ways developers have automated business processes with Apps Script–from published add-ons that help millions of users to simple automations that help small teams do big things. People all over the world use Apps Script to make work easier in ways we never could have imagined.

If you’re new to Apps Script, or simply looking for new ideas, we invite you to check out the sample solutions in our documentation.

Here are a few use cases our newest sample solutions address:

Summarize data from multiple sheets

Apps Script project type: Custom function

Coding level: Beginner

Custom functions can reduce spreadsheet complexity by replacing numerous built-in Sheets functions. If you have similarly structured data on multiple sheets in a spreadsheet, you can use this custom function to create a summary of each sheet.

You’ll learn how to programmatically:

  • Iterate through sheets in a spreadsheet to perform custom calculations.
  • Exclude specific sheets from your calculations.
  • Process spreadsheet data using optimized array objects.

Try this solution >>

Upload files to Google Drive from Google Forms

Project type: Automation with an event-driven trigger

Coding level: Beginner

Automations can programmatically perform tasks across Google products and can be set in motion by custom menus, buttons, user actions, or a time-based schedule. Use this automation to simultaneously upload and organize files in Drive using Forms. The customizable sample form includes inputs for the files to upload and how to organize them.

You’ll learn how to programmatically:

  • Implement a trigger to run a script with every form submission.
  • Capture and process user inputs from a form.
  • Organize uploaded files within Drive.

Try this solution >>

Clean up data in a spreadsheet

Project type: Editor Add-on

Coding level: Intermediate

Editor Add-ons are highly customizable and can automate common tasks in Google Docs, Sheets, Slides, or Forms. With this add-on, you can clean up spreadsheet data in Sheets by automatically removing empty rows and columns, cropping the spreadsheet to the edges of the data range, and filling in gaps in the data.

You’ll learn how to programmatically:

  • Use arrays to efficiently identify and delete empty rows and columns.
  • Fill in data gaps without overwriting non-empty cells.
  • Build an Editor Add-on menu that displays under the Extensions menu in Sheets.

Try this solution >>

Schedule meetings from Google Chat

Project type: Google Chat app

Coding level: Intermediate

Google Chap apps provide a conversational interface that lets Chat users interact with services as if the service were a person. Use this Chat app to schedule a meeting in Google Calendar from within a direct message or a space in Chat. You can set specific details for the meeting, such as subject, start time, or duration, or use the default settings for instant meeting scheduling.

You’ll learn how to programmatically:

  • Send a response when a Chat app is messaged or added to a space.
  • Gather user inputs with a custom dialog.
  • Add a new Calendar event and respond in Chat with the event URL.

Try this solution >>

Copy macros to other spreadsheets

Project type: Google Workspace Add-on
Coding level: Intermediate

Google Workspace Add-ons offer a standardized user interface and can be used across several Google Workspace applications. With this add-on, you can automatically copy a script project and attach it to a specified spreadsheet. Though this add-on focuses on Sheets macros, you can use it to copy and share any container-bound script.

You’ll learn how to programmatically:

  • Create a card-based interface for a Google Workspace Add-on.
  • Copy files from a container-bound Apps Script project.
  • Create a new container-bound Apps Script project and add the copied files.

Try this solution >>

Find more samples and connect with us

The above is just a sampling (pun intended) of the solutions we’ve built for our developer community. To get inspired for your next Apps Script project, view all the sample solutions in our documentation. Also, check out the latest feature updates of the Apps Script IDE to help you build quickly and easily.

We’d love to know what you think. To give feedback on a sample, at the top of the documentation page, click Send feedback. For more updates and news about the Google Workspace Platform, subscribe to our developer newsletter.

Build custom, integrated solutions across Google Workspace with the new AppSheet Apps Script connector

What’s changing 

We’re introducing a new AppSheet and Apps Script connector which allows you to extend custom, no-code apps to integrate and automate workflows across Google Workspace. 


The Apps Script Connector will be available for users in the AppSheet Core plan and above, which is available to users of the Google Workspace Enterprise edition. Users in the AppSheet Starter plan can test the feature. Learn more from AppSheet documentation. 


Who’s impacted 

Admins, end users, and developers 


Why it matters 

AppSheet is Google’s platform for building no-code custom apps and workflows to automate business processes. AppSheet works well with mixed data sources, even if customer data is stored across Sheets, CloudSQL, or on-premise databases. 


Apps Script is Google’s hosted JavaScript platform that makes it easy to build solutions that integrate, automate, and extend Google Workspace. Apps Script is integrated with Google Workspace APIs and includes native integrations to Google services such as YouTube, Google Analytics, and BigQuery. 


You can use the AppSheet Apps Script connector to extend custom no-code apps to integrate and automate workflows across Google Workspace. This is useful in a variety of scenarios, such as use cases in the retail, manufacturing or public sector. For example, you could use the connector with your AppSheet app to: 
  • Receive employee travel requests via the web, and when a request is made, it can look up the requestor’s manager and send a chat or email notification for approval. 
  • Allow workers to capture photos from their mobile device for on-site inspections, and upload images and media to Google Drive and adjust Drive sharing settings to ensure auditors have access. 
  • Manage shift schedules and appointments through a simple web interface, and when a time slot is booked, create an event on Google Calendar with the requestor invited. 


Getting started 


Rollout pace 


Availability 

  • The Apps Script Connector will be available for users in the AppSheet Core plan and above (available to Google Workspace Enterprise, see AppSheet pricing). Users in the Starter plan can test the feature. 

Resources 

Build custom, integrated solutions across Google Workspace with the new AppSheet Apps Script connector

What’s changing 

We’re introducing a new AppSheet and Apps Script connector which allows you to extend custom, no-code apps to integrate and automate workflows across Google Workspace. 


The Apps Script Connector will be available for users in the AppSheet Core plan and above, which is available to users of the Google Workspace Enterprise edition. Users in the AppSheet Starter plan can test the feature. Learn more from AppSheet documentation. 


Who’s impacted 

Admins, end users, and developers 


Why it matters 

AppSheet is Google’s platform for building no-code custom apps and workflows to automate business processes. AppSheet works well with mixed data sources, even if customer data is stored across Sheets, CloudSQL, or on-premise databases. 


Apps Script is Google’s hosted JavaScript platform that makes it easy to build solutions that integrate, automate, and extend Google Workspace. Apps Script is integrated with Google Workspace APIs and includes native integrations to Google services such as YouTube, Google Analytics, and BigQuery. 


You can use the AppSheet Apps Script connector to extend custom no-code apps to integrate and automate workflows across Google Workspace. This is useful in a variety of scenarios, such as use cases in the retail, manufacturing or public sector. For example, you could use the connector with your AppSheet app to: 
  • Receive employee travel requests via the web, and when a request is made, it can look up the requestor’s manager and send a chat or email notification for approval. 
  • Allow workers to capture photos from their mobile device for on-site inspections, and upload images and media to Google Drive and adjust Drive sharing settings to ensure auditors have access. 
  • Manage shift schedules and appointments through a simple web interface, and when a time slot is booked, create an event on Google Calendar with the requestor invited. 


Getting started 


Rollout pace 


Availability 

  • The Apps Script Connector will be available for users in the AppSheet Core plan and above (available to Google Workspace Enterprise, see AppSheet pricing). Users in the Starter plan can test the feature. 

Resources 

Additional functionality for the Apps Script Integrated Development Environment (IDE) Script Editor

What’s changing 

In December 2020, we announced a redesign of the Integrated Development Environment (IDE) for Google Apps Script. The modern and simplified development experience makes it quicker and easier to build solutions that make Google Workspace apps more useful for your organization. 


We’re now adding several new features to the IDE to help achieve functional parity with the legacy IDE experience. These features are: 
  • Script Properties 
  • Add-on Testing 
  • Time Zone Setting 
  • Rhino Debugging 


See below for more information. 



Who’s impacted 

Admins and developers 



Why it’s important 

Apps Script is a rapid application development platform that makes it fast and easy to create custom business solutions that integrate with Google Workspace and that increase the power of apps including Calendar, Docs, Drive, Gmail, Sheets, and Slides. For more information, see the original announcement on the Workspace Updates Blog


This launch ensures Apps Script users can utilize the legacy features in the new environment: 
  • Script Properties: Allows you to store simple data in key-value pairs scoped to one script. Script properties are typically used to store developer configuration data. The new IDE has now integrated the interface to edit, delete and create up to 50 new script properties. 
  • Add-on Testing: Allows add-on developers to test their add-ons before publishing them broadly.
  • Time Zone Setting: Allows you to update the time zone of the script and its executions. 
  • Rhino Debugging: Adds the ability to debug Rhino subroutines on V8 debugger, without migrating to V8. If the code is not V8 compatible, users will get a warning message. 

We hope these additional features empower you to create solutions and integrations for Google Workspace applications faster and easier. 


Getting started 


Rollout pace 


Availability 

  • Available to Google Workspace Essentials, Business Starter, Business Standard, Business Plus, Enterprise Essentials, Enterprise Standard, and Enterprise Plus, as well as G Suite Basic, Business, Education, Enterprise for Education, and Nonprofits customers 

Resources 

Extend Google Apps Script with your API library to empower users

Posted by Keith Einstein, Product Manager

Banner image that shows the Cloud Task logo

Google is proud to announce the availability of the DocuSign API library for Google Apps Script. This newly created library gives all Apps Script users access to the more than 400 endpoints DocuSign has to offer so they can build digital signatures into their custom solutions and workflows within Google Workspace.

The Google Workspace Ecosystem

Last week at Google Cloud Next ‘21, in the session “How Miro, DocuSign, Adobe and Atlassian are helping organizations centralize their work”, we showcased a few partner integrations called add-ons, found on Google Workspace Marketplace. The Google Workspace Marketplace helps developers connect with the more than 3 billion people who use Google Workspace—with a stunning 4.8 billion apps installed to date. That incredible demand is fueling innovation in the ecosystem, and we now have more than 5,300 public apps available in the Google Workspace Marketplace, plus thousands more private apps that customers have built for themselves. As a developer, one of the benefits of an add-on is that it allows you to surface your application in a user-friendly manner that helps people reclaim their time, work more efficiently, and adds another touchpoint for them to engage with your product. While building an add-on enables users to frictionlessly engage with your product from within Google Workspace, to truly unlock limitless potential innovative companies like DocuSign are beginning to empower users to build the unique solutions they need by providing them with a Google Apps Script Library.

Apps Script enables Google Workspace customization

Many users are currently unlocking the power of Google Apps Script by creating the solutions and automations they need to help them reclaim precious time. Publishing a Google Apps Script Library is another great opportunity to bring a product into Google Workspace and gain access to those creators. It gives your users more choices in how they integrate your product into Google Workspace, which in turn empowers them with the flexibility to solve more business challenges with your product’s unique value.

Apps Script libraries can make the development and maintenance of a script more convenient by enabling users to take advantage of pre-built functionality and focus on the aspects that unlock unique value. This allows innovative companies to make available a variety of functionality that Apps Script users can use to create custom solutions and workflows with the features not found in an off-the-shelf app integration like a Google Workspace Add-on or Google Chat application.

The DocuSign API Library for Apps Script

One of the partners we showcased at Google Cloud Next ‘21 was DocuSign. The DocuSign eSignature for Google Workspace add-on has been installed almost two-million times. The add-on allows you to collect signatures or sign agreements from inside Gmail, Google Drive or Google Docs. While collecting signatures and signing agreements are some of the most common areas in which a user would use DocuSign eSignature inside Google Workspace, there are many more features to DocuSign’s eSignature product. In fact, their eSignature API has over 400 endpoints. Being able to go beyond those top features normally found in an add-on and into the rest of the functionality of DocuSign eSignature is where an Apps Script Library can be leveraged.

And that’s exactly what we’re partnering to do. Recently, DocuSign’s Lead API Product Manager, Jeremy Glassenberg (a Google Developer Expert for Google Workspace) joined us on the Totally Unscripted podcast to talk about DocuSign’s path to creating an Apps Script Library. At the DocuSign Developer Conference, on October 27th, Jeremy will be teaming up with Christian Schalk from our Google Cloud Developer Relations team to launch the DocuSign Apps Script Library and showcase how it can be used.

With the DocuSign Apps Script Library, users around the world who lean on Apps Script to build their workplace automations can create customized DocuSign eSignature processes. Leveraging the Apps Script Library in addition to the DocuSign add-on empowers companies who use both DocuSign and Google Workspace to have a more seamless workflow, increasing efficiency and productivity. The add-on allows customers to integrate the solution instantly into their Google apps, and solve for the most common use cases. The Apps Script Library allows users to go deep and solve for the specialized use cases where a single team (or knowledge worker) may need to tap into a less commonly used feature to create a unique solution.

See us at the DocuSign Developer Conference

The DocuSign Apps Script Library is now available in beta and if you’d like to know more about it drop a message to [email protected]. And be sure to register for the session on "Building a DocuSign Apps Script Library with Google Cloud", Oct 27th @ 10:00 AM. For updates and news like this about the Google Workspace platform, please subscribe to our developer newsletter.

Use the new Apps Script Integrated Development Environment (IDE) Script Editor

What’s changing 

We’ve redesigned the Integrated Development Environment (IDE) for Google Apps Script. The new IDE offers a more modern and simplified development experience which makes it quicker and easier to build solutions that make Google Workspace apps more useful for your organization. 

You can learn more about these improvements in this video from our Next OnAir session earlier this year. 


Who’s impacted 

Developers 


Why it’s important 

Apps Script is a rapid application development platform that makes it fast and easy to create custom business solutions that integrate with Google Workspace and that increase the power of apps including Calendar, Docs, Drive, Gmail, Sheets, and Slides. With this launch, we’ve revamped the cloud-based IDE that helps you create, edit, and manage projects. The new IDE simplifies the experience of developing for Google Workspace and offers: 
  • A state of the art code editor, which uses Monaco and that offers advanced autocomplete, auto-formatting, and more. 
  • An enhanced troubleshooting experience by improving the debugger and adding real-time streaming logs. 
  • Integration between the IDE and the Google Workspace Developer hub to provide a seamless, end-to-end experience to design, develop, deploy and manage Apps Script projects in one place. 
  • Updated look and feel, with a user-friendly interface which is more similar to other Google Workspace apps that use the Material Design framework. 

Getting started 

  • Admins and developers: This feature will be ON by default for all users. However, users can opt out to use the legacy IDE by clicking on “Use legacy editor” in the toolbar next to the Execution log button. Use our developer documentation to learn more about working with Apps Script
New Apps Script IDE 

Improved code editing experience 


Rollout pace 

Availability 

  • Available to Google Workspace Essentials, Business Starter, Business Standard, Business Plus, Enterprise Essentials, Enterprise Standard, and Enterprise Plus, as well as G Suite Basic, Business, Education, Enterprise for Education, and Nonprofits customers 

Resources 

Roadmap 

Automate and expand Connected Sheets updates with new APIs, connections, and capabilities

What’s changing 

We recently launched Connected Sheets, which connects Google Sheets and BigQuery to help you analyze large datasets using familiar spreadsheet tools. We’re now adding support for macros and APIs to help you automate tasks, as well as providing mobile access. Specifically, you can now use Connected Sheets with: 

Who’s impacted 

Developers and end users 


Why you’d use it 


Sheets Macro recorder 
You can use the macro recorder to record when to create, edit, delete, and refresh Connected Sheets objects. This generates macros which you can then directly run in Sheets to refresh the data. This can automate common tasks, saving time and reducing errors. 

Apps Script and Sheets API 
You can use these APIs to write scripts and applications that automate tasks. For example, you can automate CRUD functions for Connected Sheets objects, including sheets, formulas, pivot tables, and extracts. Additionally, you can use the APIs to refresh these objects, as well as to refresh charts. 

Mobile app support 
You can now view Connected Sheets on mobile devices. You can also copy and paste data from Connected Sheets using the mobile apps. At this stage, you can’t create, edit, or refresh data in Connected Sheets on mobile. 


Getting started 

Rollout pace 

  • Rapid and Scheduled Release domains: 
    • Sheets Macro recorder: Gradual rollout (up to 15 days for feature visibility) starting on August 26, 2020. 
    • Apps Script: Available now for all users. 
    • Sheets API: Available in September. 
    • Android app: Gradual rollout (up top 15 days for feature visibility) starting on August 17, 2020. To get access, update to the latest version of the Sheets Android app
    • iOS app: Gradual rollout (up top 15 days for feature visibility) starting on August 24, 2020. To get access, update to the latest version of the Sheets iOS app

Availability 

  • Connected Sheets is available to G Suite Enterprise, G Suite Enterprise for Education, and G Suite Enterprise Essentials customers 
  • Connected Sheets is not available to G Suite Basic, G Suite Business, G Suite for Education, G Suite for Nonprofits, and G Suite Essentials customers 

Resources