AppsScriptPulse

Build it for G Suite – Everyone has their own superpowers | Sheets to Apps

Everyone has their own superpowers. Whether you’re an Data Analyst, Data Scientist, Task Automater, or Programmer, you can use G Suite to support these talents. In this video, we’ll go over what tools you can use to support these different talents.

Send content automatically via a Google Sheet and an Apps Script | Sheets to Apps

In this episode of Sheets to Apps, see why it can be handy to use a Google Form to help requestors receive assets like e-books or online white papers automatically by email using Apps Script.

Full tour of Google App Maker’s interface | Sheets to Apps – YouTube

We’ve gone over the basics of App Maker, but now it’s time to explore the interface further. Alexandrina Garcia-Verdin goes over how to utilize and modify tools and widgets, in this episode of Sheets to Apps!

Write Apps Script Offline with clasp

🗺️ Develop Locally: clasp allows you to develop your Apps Script projects locally. That means you can check-in your code into source control, collaborate with other developers, and use your favorite tools to develop Apps Script.

Source: google/clasp

The Apps Script IDE is great, but with larger projects, I know I’ve wanted to be able to use a more powerful IDE. clasp (Command Line Apps Script Projects) is a CLI that allows you to start, write, test, and deploy Apps Script projects from any text editor you want.

Getting started, quickly build a basic app on Google App Maker – Sheets to Apps – YouTube

In this episode, we give you some brief examples of what kind of apps you can create with App Maker. Learn how to get started and quickly build a basic app on App Maker!

G Suite Updates Blog: Goal Seek add-on now available for Google Sheets

You can use the Goal Seek add-on to calculate the required value of a cell to achieve a desired value in another cell. This is particularly useful when conducting break-even analysis or sensitivity calculations, like determining how changing one value affects other correlated values in your sheet.

Interesting to see Google extending the functionality of Google Sheets with this official add-on

Source: G Suite Updates Blog: Goal Seek add-on now available for Google Sheets

How To: Add add-ons in Google Sheets – YouTube

A short promo video from the official G Suite account showing users how to install add-ons in Google Sheets, which developers might find useful to reference or see how to structure their own add-on videos.

Example apps you can build on Google App Maker – Sheets to Apps – YouTube

In this episode, we give you some brief examples of what kind of apps you can create with App Maker. Learn how to build dashboards, human resource apps, and so much more!

The problems I can solve with App Maker – Sheets to Apps – YouTube

Welcome to the Sheets to Apps Show, where we talk about how to tame endless spreadsheets into productive applications. App Maker is a tool that empowers a wide range of individuals in an organization to turn important processes that live in spreadsheets. Join us and see how App Maker can help you in your everyday tasks!

Celebrating 10 years of Apps Script: looking back on how it started | Google Cloud Blog

10 years ago this week we introduced Google Apps Script, G Suite’s scripting platform. What started as a small experiment has grown into one of Google’s most popular developer products. To commemorate the moment, I sat down with Mike Harm, the creator of Apps Script, to reflect back on how it all got started.

Source: Celebrating 10 years of Apps Script: looking back on how it started | Google Cloud Blog