AppsScriptPulse

Add-on, Official News

Google Developers Blog: Evolving Google Workspace Add-ons with Alternate Runtimes

Tags:
| | 0 Comments |

Today we are pleased to announce that building Google Workspace Add-ons has evolved once again, this time to offer developers an alternative to using Apps Script for building add-ons with the general availability of Alternate Runtimes for Google Workspace Add-ons.

While Alternate Runtimes enables the same functionality that Apps Script does for building add-ons, the flexibility and the freedom to choose your dev environment plus the opportunity to decouple from Apps Script will likely yield greater developer productivity and performance gains for future projects. This commonly requested feature by Google Workspace solution developers has finally become a reality.

As part of this post there is an example from Riël Notermans, owner of Zzapps (and Google Developer Expert), highlighting some key takeaways on Alternate Runtimes development and deployment.

Source: Evolving Google Workspace Add-ons with Alternate Runtimes

Community News, Official News

Meet the Google Workspace Developer Experts – making connections with the community 

Tags:
| | 0 Comments |

Meet the Google Workspace Developer Experts, a global network of experienced technology experts, thought leaders, and influencers who actively support developer communities around the world.

If you are starting out on a new product, environment or beginning to learn to code finding people to connect with within an existing community can often be a challenge. Thanks to the efforts of Charles Maxson hopefully those connections are made a bit easier.

Source: Meet the Google Workspace Developer Experts

New IDE, Official News, Advanced, Beginner, Intermediate

Get ready to up your Apps Script! – Google Developers Blog

Tags:
| | 0 Comments |

The new Apps Script IDE features the same rich integration with Google Workspace as it did before, allowing you to get started building solutions without having to install or configure anything. If you are working on a standalone script project application, you can use the Apps Script Dashboard to launch your project directly, or if you are working on a container bound project in Sheets, Slides or Docs, you can do so from selecting Tools > Script editor from their top menus.

Charles Maxson, Developer Advocate Google Cloud, has highlighted some features Google Apps Script developers new and old should keep an eye out for. I think one of the big ones for experienced Apps Script developers who work mostly in the online editor is going to be the context menu options and the Command Palette. Find out more in the source post.

Source: Get ready to up your Apps Script! – Google Developers Blog

Official News, Solutions, Sheets, Beginner

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

Tags:
| | 0 Comments |

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.

Official News, Solutions, Classroom, Meet, Sheets, Beginner

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

Tags:
| | 0 Comments |

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

Add-on, Official News

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

Tags:
| | 0 Comments |

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

Official News

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

Tags:
| | 0 Comments |

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

Official News

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

Tags:
| | 0 Comments |

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

Official News, Solutions, Sheets, Video Tutorial

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

Tags:
| | 0 Comments |

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.

Official News, Solutions, Sheets, Video Tutorial

Create personalized functions in sheets – Sheets to Apps

Tags:
| | 0 Comments |

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