AppsScriptPulse

Guide To The New Google Apps Script IDE Covering 135 Features

Explore the fantastic new Google Apps Script IDE and see features that will make your life easier, whether you’re a beginner or pro developer.

Ben Collins can never be accused of slacking off and this post is the perfect example. As announced on Totally Unscripted the new Apps Script IDE is rolling out and Ben lists 135 features for developers to look out for. View the source post for these features plus a video of Ben highlighting his favorites.

Source: Guide To The New Google Apps Script IDE Covering 135 Features

Totally Unscripted: New workflow solutions with Tables and Google Apps Script – Thur 10 Dec at 1200 PST / 1500 EST / 2000 UTC

In this episode we’ll be joined by Carlin Yuen Co-founder & Product Lead, Tables (Google, Area 120) and Ben Collins Educator at benlcollins.com and Google Developer Expert. The Tables beta is the latest product to emerge from Google’s Area 120. Currently Tables is only available to US customers so this show is an opportunity to have an expert tour from the co-founder/product lead Carlin Yuen. We’ll also be joined by Ben Collins who has been using Tables and he’ll be sharing some insight into how Tables can be used with Google Apps Script.

Totally Unscripted Exclusive: Detailed look at the new Google Apps Script IDE/Script Editor and launch

New Apps Script Editor

In the episode we broke the exclusive news that the new Script Editor will be rolling out to all users starting on 07 December 2020. I can’t thank Keith enough for taking the time out to share this news to the Totally Unscripted audience first and also to Charles for making possible as well as providing an expert tour of the new Apps Script Editor.

More official news and resources will be published next week and we’ve setup a category on AppsScriptPulse to capture these and community contributions.

If you missed the live episode the recording is included in the source post.

Source: Totally Unscripted Exclusive: Detailed look at the new Google Apps Script IDE/Script Editor and launch – MASHe

Finding Merged Cells In Your Google Sheet using Apps Script (And When To Be Careful)

Learn how to merge cells in Google Sheets, when to use them and when to avoid them [and] finding merged cells in your Google Sheet using Apps Script

Some very useful guidance from Ben Collins on merged cells within Google Sheets. As well as how to merge/unmerge cells Ben also highlights some of the pitfalls when merging cells. The post also includes a very useful snippet for detecting merged cells using . getMergedRanges() .

Source: How To Merge Cells In Google Sheets And When To Be Careful

How to Share User Properties between Google Apps Script Projects – Digital Inspiration

The Properties Service of Google Apps Script is used by developers to store app configuration and user specific settings. The properties data is scoped to a specific user, or a specific project, and cannot be shared between different projects. … In some specific cases, we may want to give access to our store data to another user so they may build upon the existing configuration rather than having to build everything from scratch.

Amit Agarwal shares a useful snippet for letting users export and import data from PropertiesService . There are some nice touches in this solution including using the JavaScript File Reader API.

Source: How to Share User Properties between Google Apps Script Projects – Digital Inspiration

Join Adam Morris (@clssrmtechtools) in the Advent of Code with Google Apps Script challenge

When and where I can, I’ll be trying to complete the advent of code challenges in appscripts. You can follow along here … I find these sorts of exercises really valuable. It makes you think about the language you’re using very carefully. – Adam Morris

In the Google Apps Script Community Google Group Adam Morris is participating where he can in the Advent of Code

Advent of Code is an Advent calendar of small programming puzzles for a variety of skill sets and skill levels that can be solved in any programming language you like. People use them as a speed contest, interview prep, company training, university coursework, practice problems, or to challenge each other.

If you would like to play along with Adam follow the link to the Google Apps Script Community Google Group thread.

Source: Advent of Code w/ AppsScripts – Google Apps Script Community Google Group

How to Create JSON Web Token (JWT) with Google Apps Script – Digital Inspiration

You can use Google Script to create JSON Web Tokens (JWT) that can be provided to secure routes so that only authenticated requests that contain a valid token can connect to the APIs (e.g., the Zoom API)

Nice little snippet from Amit Agarwal for both creating and decoding JSON Web Tokens (JWT).

Source: How to Create JSON Web Token (JWT) with Google Apps Script – Digital Inspiration

Totally Unscripted: “The State of Script” address from Google – Fri 04 Dec at 1200 PST / 1500 EST / 2000 UTC

In this episode of Totally Unscripted we are joined by Keith Einstein Product Manager for Apps Script and Charles Maxson (TU host and Developer Advocate at Google). As part of this show Keith will review the current state of Apps Script and also exclusively reveal some forthcoming soon to be released features.

The show is also an opportunity to get your Apps Script related questions in which can be emailed to [email protected] or asked live via YouTube chat.

Creating an embedded interactive Chain Story app with Google Apps Script and Google Sheets – Yagisanatode

In this tutorial, we are going to create an interactive story chain app that we can embed into a Google Site or your own site like WordPress.

Yagi uses a simple but very effective interactive story chain app to explore and explain some very powerful Apps Script functionality all developers should know about. This includes using the LockService which can be used to prevent concurrent access to sections of code. Yagi also highlights some recent discussions around the limitations of Web Apps and concurrent users. Click through to the source for all this and more.

Source: Creating an embedded interactive Chain Story app with Google Apps Script and Google Sheets – Yagisanatode

Alexa Rank Tracker built in Google Sheets with formulas and Google Apps Script – bencollins.com

Tutorial on how to build an Alexa Rank tracker in Google Sheets, using the powerful IMPORTDATA and REGEXEXTRACT functions and Apps Script.

Clever post from Ben Collins highlighting how Google Sheets functions can be used to scrape Alexa tracking data. As a bonus Ben includes a little snippet of Google Apps Script to let you archive data over time.

Source: Alexa Rank Tracker built in Google Sheets with formulas and Apps Script

Check Twilio Balance using Google Apps Script

In this post, we will learn how to check the Twilio Balance using Apps Script and send an email to the user when the threshold level meets.

Nice post that introduces interacting with the Twilio service using Google Apps Script. The post includes lots of useful screenshots and illustrations to help you create you own billing alert system.

Source: Check Twilio Balance using Apps Script

Integrating AppSheet with Google Workspace – #BuildingWithAppSheet

Did you know that AppSheet can integrate with Google Workspace? In this video, we speak to how AppSheet – Google Cloud’s no-code application platform – helps citizen developers streamline their workflows, and demo how you can create your own app in Google Sheets. Watch to explore the possibilities of AppSheet!

TU Special: Using the Google Video Intelligence API to index and disambiguate films by content – 24 Nov at 0800 PST / 1000 EST / 1600 UTC

In this TU special we are joined by Bruce Mcpherson who will share work on detecting similarities and duplication between films digitally using the trained ML models in the Google Video Intelligence API. With this the video content itself can be identified, tracked, searched, visualized and compared.

Mobile App Development: Legal Considerations (top level guidance for Google Apps Script Add-on developers)

This video comes via a share from Alan Wells on the Google Apps Script community group. As pointed out by Alan whilst this webinar recording from SCORE focuses on mobile app development and distribution via Apple and Google the principles in terms of privacy policies, terms of service and intellectual property broadly apply if you are developing a distributing add-ons or other products developed using Google Apps Script.

Collect and approve timesheets via Google Sheets and Apps Script- Sheets to Apps

In this episode of Sheets to Apps, we show you how you can easily build a payroll app that makes approving timesheets easier and communication with management seamless. Watch to learn how you can build a timesheet application with zero code!

Click through to the YouTube page and check the video description for all the resources to replicate this solution.

Subscribe to Apps Script Pulse...