AppsScriptPulse

Solutions, Advanced

Analyze your friends Peloton workout stats with real-time updates (using Google Apps Script)

Tags:
| | 0 Comments |

A tutorial on how you can sync and analyze your Peloton workout stats into Coda with custom dashboards. Sync with a Google Apps Script or serverless function on Google Cloud.

We’ve featured this example from Al Chen on interacting with Peleton data with Google Apps Script before. Al has recently updated the post to include a “new table ‘Friend Workouts’ contains latest 10 cycling workouts from people you follow”. Follow the source link for more details…

Source: Analyze your Peloton workout stats with real-time updates

Community News, Solutions, Advanced

Modern Angular in Google Workspace Editor Add-ons

Tags:
| | 0 Comments |

I intend this post for established Add-on developers who want to use Angular in Google Workspace editor Add-ons and Google Apps Script webapps. This does not attempt to show how to create Add-ons or Angular apps, but the tooling and build process to use Angular apps in Add-ons. I am also assuming familiarity with installing and using CLI tools in your development workflow.

We recently had the author of this post, Spencer Easton, on an episode of Totally Unscripted to talk about this topic. This companion post provides an overview of using Angular for Add-on development. There is a cost associated with this solution has separate hosting is required for the Webpacks, but as covered by Spencer the cost is low (for a 100K+ users add-on the cost is $8/month).

Source: Modern Angular in Google Workspace Editor Add-ons

Solutions, Advanced

Maintain Google Apps Script in an Enterprise environment – Google Apps Script deployment with Cloud Build

Tags:
| | 0 Comments |

In this article I will showcase the way I deploy Google Apps Script code in an Enterprise environment. I will share the actual build file and the necessary steps and tools to reproduce my workflow. This approach does require Google Cloud Platform knowledge and a credit card. The instructions are high level, this article is not a codelab.

For those interested in scaling up their Google Apps Script development Jasper Duizendstra outlines how you can use Google Cloud Build for version control and Continuous Deployment (CD). As Jasper notes:

When the CD pipeline is in place it becomes easy to deploy the script, separate the responsibilities and support multiple versions and implementations of the code …  the most important advantage of using CD is the mindset that it enables. It provides an environment where I feel confident and safe to create small incremental changes in my applications.

Source: Google Apps Script deployment with Cloud Build

Solutions, Advanced

Use Google Cloud AI to find the right answers from the Calendar TV contest

Tags:
| | 0 Comments |

I have programmed an application that searches for (or rather knows) the correct answers to the competition questions from the Kalendárium program, all using Google Cloud AI. I decided to write the entire application in Google Apps Script technology, which offers an online IDE editor, application operation in the cloud and the possibility of a quick connection to Google services. [auto-translated]

You’re going to have to hit Google Translate to read this post from Ivan Kutil, but it’s worth it is a nice example of how Google Apps Script can be used for orchestration. All the details are in the post and it’s also a nice reminder of the Parser library Ivan released in 2016, which makes it easy to scrape data from websites using UrlFetchApp (read more about the web scraping).

Source: Využití Google Cloud AI pro hledání správných odpovědí z televizní soutěže Kalendárium

Solutions, Gmail, V8, Advanced

Everything you ever wanted to know about Gmail draft inline images and Google Apps Script but were afraid to ask

Tags:
| | 0 Comments |

Image order in Gmail draft

A common workflow solution in Google Apps Script is to use a Gmail draft message as a template for sending emails. For the user the benefit is they can draft a message in a familiar environment adding formatting without having to worry about writing HTML. A problem often encountered is the inclusion of inline images. This post looks at solving the issue of missing inline images.

Source: Everything you ever wanted to know about Gmail draft inline images and Google Apps Script but were afraid to ask – MASHe

Solutions, Advanced

Analyze your Peloton workout stats with real-time updates (template and scripts) – Google Apps Script

Tags:
| | 0 Comments |

A tutorial on how you can sync and analyze your Peloton workout stats into Coda with custom dashboards. Sync with a Google Apps Script or serverless function on Google Cloud

Nice post from Al Chen for Peloton users keen to add to their ‘quantified self’ pool of data. This post might be of particular interest for community members interested to see how authentication cookies can be handled with UrlFetchApp.

Source: Analyze your Peloton workout stats with real-time updates (template and scripts)

Solutions, Sheets, V8, Advanced

How to write a custom function library for Google Sheets

Tags:
| | 0 Comments |

In this article I will showcase one of the many ways you can customize your Google Workspace environment. We will implement two custom functions in Google Sheets. With these functions as an example I will demonstrate how to use Google Apps Script Libraries to organise and distribute your solution. There are multiple ways to distribute your Apps Script code within the Google Workspace, and this article will help you decide if this library method is right for you.

Always nice to have some advanced techniques in your toolbox. In this example from Jasper Duizendstra he explores how custom functions in Google Sheets can be packaged and used in Libraries.
Source: How to write a custom function library for Google Sheets

Solutions, Advanced

Google Apps Script deployment with Cloud Build

Tags:
| | 0 Comments |

Photo by David Gilbertson on Unsplash

Google Apps Script can go way beyond a simple script that solves a problem. In this article I will showcase the way I deploy Google Apps Script code in an Enterprise environment. I will share the actual build file and the necessary steps and tools to reproduce my workflow. This approach does require Google Cloud Platform knowledge and a credit card.

Source: Google Apps Script deployment with Cloud Build

New IDE, Advanced, Beginner, Intermediate

16 secrets tips, tricks and features for new Google Apps Script Editor (v2020)

Tags:
| | 0 Comments |

Google Apps Script has a new editor, which is better, nicer, and completed ready for future new features. Today, I would like to introduce you to several dirty and secret tricks, what you can do.

If you like a keyboard shortcut you’ll love this post from Ivan Kutil! For those less keen on keyboard commands there is still plenty of other productivity tips from Ivan shared in this post.

Source: 16 secrets tips, tricks and features for new Google Apps Script Editor (v2020)

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