AppsScriptPulse

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.

Quickstart: Check student attendance in Google Meet from a Google Classroom roster using Google Apps Script

Complete the steps on this page to create a Google Sheets add-on that tracks attendance for Google Classroom courses delivered using Google Meet conferencing.

Nice spot via @barrielroberts/@alicekeeler for an official Google Apps Script quickstart which combines Google Sheets, Google Classroom and Admin Reports which lets you create an automated Google Meets attendance roster tool. The quickstart has all the code and instructions you need to get this working.

Source: Quickstart: Check student attendance in Google Meet courses

Google Workspace Add-ons now generally available in Google Docs, Sheets, and Slides

Google Workplace Add-ons are now available for Google Docs, Sheets, and Slides. Google Workspace Add-ons are already available for Calendar, Gmail, and Google Drive.

There have been Editor Add-ons for a number of years, with Google Workspace Add-ons developers can tap into a new integrated user experience. One of the main differences with Workspace Add-ons is the use of the Card service rather than custom HTML (HTMLService). The benefit of switching to a Card service is cross platform support including integration into Google’s Workspace mobile apps.

Follow the link to the source post for links to all the relevant developer documentation.

Source: Google Workspace Add-ons now generally available in Google Docs, Sheets, and Slides

When to use AppSheet or Apps Script in Google Workspace | Google Cloud Blog

AppSheet and Apps Script bring together a lot of powerful customization and functionality to Google Workspace, but you may be wondering when to use which platform. Here’s the answer.

This post covers various scenarios where you might want to use “AppSheet, Google Cloud’s no-code development platform, and Apps Script, Google Workspace’s integrated low-code development platform”.

It was the last line in the post that particularly caught my eye:

We plan to continue to integrate AppSheet and Apps Script in interesting ways, and to make it even easier for you to build powerful solutions. We’re eager to see what you create.

Source: When to use AppSheet or Apps Script in Google Workspace | Google Cloud Blog

Google Developers Blog: Building solutions using the G Suite developer platform

Millions of users know G Suite as a collection of communication and productivity apps that enables teams to easily create, communicate, collaborate, and discover content to supercharge teamwork. Beneath the surface of this well-serving collection of apps is also an extensible platform that enables developers to build targeted custom experiences and integrations utilizing these apps, allowing G Suite’s vast user base to get even more value out of the platform. At first glance, it may not be natural to think of the tools you use for day-to-day productivity and collaboration as a developer platform. But consider what makes up a developer platform; Languages, APIs, runtimes, frameworks, IDEs, ecosystem, etc; G Suite offers developers all of these things and more. Let’s take a closer look at what makes up the G Suite developer platform and how you can use it.

Nice overview of the G Suite developer platform from Charles Maxson. I always find it useful to see how others pitch the platform and from this piece useful to see how Apps Script is put in context with other G Suite development options.

Source: Google Developers Blog: Building solutions using the G Suite developer platform

How to send text messages using Google Sheets and Twilio – Sheets to Apps

Did you know that you can send text messages via Google Sheets? In this episode of Sheets to Apps, we show you how to easily send text messages with Google Sheets via Twilio – an online communications provider.

Back in January Sourabh Choraria highlighted a Medium post from AVG showing how to Send SMS event updates or discount codes using Twilio from a Google Sheet. AVG has now created a short explanatory video covering this solution. You can view the video description for all the code and resources you need to try out this solution.

Create personalized functions in sheets – Sheets to Apps

In this episode of Sheets to Apps, learn how to create a personalized formula using JavaScript to auto-calculate rooms needed for an event.

Google Developers Blog: Building G Suite Add-ons with your favorite tech stack

Let’s talk about the basics of G Suite Add-ons. G Suite Add-ons simplify how users get things done in G Suite by bringing in functionality from other applications where you need them. They provide a persistent sidebar for quick access, and they are context-aware — meaning they can react to what you’re doing in context. … Up until recently, G Suite Add-ons leaned on Apps Script to build Add-ons, but choice is always a good thing, and in some cases you may want to use another scripting language.. So let’s talk about how to build Add-ons using additional runtimes.

Google recently announced the ability to develop G Suite Add-ons using other frameworks other than Google Apps Script. This post on the Google Developers Blog introduces how you can develop G Suite Add-ons with something other than Google Apps Script.

Source: Google Developers Blog: Building G Suite Add-ons with your favorite tech stack

Build Apps Powered by Language with Semantic ML with the new Semantic Reactor Google Sheets Add-on

In this post, I’ll show you how to use beginner-friendly ML tools–Semantic Reactor and TensorFlow.js–to build an app that’s powered by natural language.

NEW: Semantic Reactor has been officially released! Add it to Google Sheets here.

We’ve previously highlighted how TensorFlow.js can be used in Google Apps Script. In this latest example the new Semantic Reactor Google Sheets Add-on published by Google Research is highlighted. Semantic Reactor is designed to make it easier to start exploring Natural Language Understanding (NLU) and with this tutorial you can learn how you can deploy your model to code.

Source: Build Apps Powered by Language with Semantic ML

How to build a Google Analytics Dashboard with Apps Script and Google Sites – Sheets to Apps

Using Google Analytics and looking for a new way to aggregate, store, and efficiently organize the data from your website in a Google Sheet? In this episode of Sheets to Apps, we show you how to combine the Google Analytics add-on with Apps Script, resulting in the automation of cohesive data summaries that are compatible with Google Sites.

In this latest episode Alexandrina Garcia-Verdin demonstrates how the Google Analytics Add-on can be combined with macros to automate regular reporting. The video description has links to all the resources you need to set this up.

Whilst ‘Sheets to Apps’ videos are targeted at low/no coders as an Apps Script Developer I always find it useful to have a look at the code to see how it is done, as more often than not there will be a technique or method I’ve not come across. In the case of this example my new discovery was the .autoFill() and after browsing the documentation, .autoFillToNeighbor() methods in SpreadsheetApp. These methods allow you to replicate the auto-fill functionality users have in Google Sheets.

Another discovery was the various .setOption() calls when building the charts. I’ve used .setOption() in projects in the past and the issue I’ve had is navigating the long list of options you can use for various chart types. Using the macro recorder seems like a great way to capture all the options you want to add to your script project.

First look at the new Google Apps Script Integrated Development Environment (IDE) Script Editor – MASHe

As part of Next OnAir week 2 the focus was on ‘Productivity and Collaboration’ Charles Maxson from the G Suite DevRel team not only provided some highlights from the week, but he also premiered the new Google Apps Script IDE.

This post includes a recording to a live demo of the new Google Apps Script editor. No news on when the new Script Editor will be generally available, but from the demo it looks like Google have focused on making it easier for developers to code and debug scripts.

Source: First look at the new Google Apps Script Integrated Development Environment (IDE) Script Editor – MASHe

How macros can be used to build Apps Scripts for cleaning data – Sheets to Apps

Cleaning up data from downloaded accounting reports or from other systems can take up valuable time and resources. In this episode of Sheets to Apps, we’ll walk you through adding automation to your monthly Excel accounting data that records your steps into a script that you can run repeatedly with Google Sheets macro recorder.

From the video description you’ll find all the links you need to the example Google Sheet, instructions and more

Getting started with the Google Vision API from G Suite | Google Cloud Blog

The Google Cloud Vision API is a powerful tool that helps developers build apps with visual detection features, including image labelling, face and landmark detection, and optical character recognition (OCR). Getting started building with these services is relatively simple with Apps Script, as it uses simple REST calls to interact with the API directly, eliminating the need to set up SDKs or to download client libraries.

In this post Christian Schalk, Google Cloud Developer Advocate, provides details for setting up a Google Apps Script project with the Google Vision API, using this service to perform optical character recognition on a user selected image.

Source: Getting started with the Google Vision API from G Suite | Google Cloud Blog

Auto respond to feedback via Apps Script – Sheets to Apps

Course evaluations can be a bit overwhelming when receiving mass amounts of feedback, but thanks to Apps Script this is a problem of the past. In this episode of Sheets to Apps, we’ll show you how to create and use an Apps Script for Google Sheets that allows you to respond to feedback on Google Forms via email.

In a recent episode of Sheets to Apps Ben Collins’ clever ‘Respond to feedback from students in a course’ in the G Suite  Solutions Gallery is featured. See the YouTube video description for related links.

Streamline access to resources for vendors via Google Sheet – Sheets to Apps

Need to share a variety of documents with vendors? Don’t want to share access one by one? In this episode of Sheets to Apps, we’ll cover how to use an Apps Script in a Google Sheet to automatically add members to a Google Group, helping you share documents at a large scale that will save you time.

We’ve previously shared the Medium post that provides more details for setting up this solution. If you missed that post or were unclear Alexandrina Garcia-Verdin, better known in the community as AGV, provides a very useful overview.

The code and other resources presented in this episode are available from the video description.

Subscribe to Apps Script Pulse...