AppsScriptPulse

Add-on, Community News, Solutions

🎂 Happy anniversary Google add-ons! 🎂 Long live MERGO the new mail merge add-on from @romain_vialard

| | 2 Comments |

Ain’t no party like a mail merge party and Romain Vialard knows how to celebrate!

Community News, Solutions, Beginner

Find and clone Apps Script projects from GitHub directly into the IDE with scrviz – Desktop Liberation

Tags:
| | 0 Comments |

I thought it might be useful if you are learning Apps Script to be able to pull in examples to play around with. This latest release adds the ability to configure and clone projects from github directly into the Apps Script IDE.

We’ve previously highlighted Bruce Mcpherson’s visual Google Apps Script explorer tool, ‘scrviz’. If you are not familiar with this it is Bruce has figured a way to search and identify Google Apps Script projects publicly shared on GitHub. In this latest update to the tool you can now clone public Google Apps Script projects from scrviz straight into the Apps Script IDE.

The source link explains more about how you can do this:

Source: Find and clone Apps Script projects from github directly into the IDE with scrviz – Desktop Liberation

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

Community News

A SyntaxHighlighter Evolved WordPress plugin for Google Apps Script contributors

Tags:
| | 0 Comments |

With my published content I like to include useful code snippets. As I published on a self-hosted WordPress blog I’ve used plugins to help format the code to make it easier to understand and also aesthetically look nice. In this post I share a WordPress plugin I’ve developed for Google Apps Script syntax highlighting.

Source: A SyntaxHighlighter Evolved WordPress plugin for Google Apps Script contributors

Community News

Totally Unscripted: Modernize your Workspace Editor Add-ons development with Angular – Thur 25 Feb at at 1200 PST / 1500 EST / 2000 UTC

Tags:
| | 0 Comments |

We all love the flexibility HTMLService gives us when developing Google Workspace Editor Add-ons, but what happens when you need to scale your production? Web application frameworks provide a way to deploy and develop your code in a structured way making it easier to maintain your code base. Angular is one open-source web application framework that can be used to modernize your Workspace Editor Add-on development. In this episode we are joined by Spencer Easton who will share how Amplified IT have adopted Angular for their Add-on development. As part of this we will explore the benefits using Angular including a component-based architecture, internationalization and performance.

Tune in live to contribute to the YouTube live chat (recording immediately available). – https://youtu.be/mtDsScbfRIU

For previous episodes, information and resources visit https://tu.appsscript.info/

Community News

Hackers abuse Google Apps Script to steal credit cards, bypass CSP

Tags:
| | 0 Comments |

Image: Google

Attackers are abusing Google’s Apps Script business application development platform to steal credit card information submitted by customers of e-commerce websites while shopping online.

Interesting report highlighting how Google Apps Script is being exploited as a vector to skim card data. The post is worth reading for more details but in short the script.google.com address for webapps is being used as a trusted domain to avoid detection. The post also mentions how Google Analytics is being used for a similar exploit.  How this will all play out is yet to be seen.

Source: Hackers abuse Google Apps Script to steal credit cards, bypass CSP

Community News

Totally Unscripted: No-Code Workflow Automation in Google Workspace – Thur 11 Feb at at 1200 PST / 1500 EST / 2000 UTC

Tags:
| | 0 Comments |

Totally Unscripted is back on Thur 11 Feb at 1200 PST / 1500 EST / 2000 UTC and in this episode we we look at no-code solutions for Google Workspace automation. As part of this we are joined by no-code and automation experts Vahid Taslimi and Aravin Srinivasan from zenphi. Zenphi is a no-code business process automation platform, designed from the ground up for Google Workspace. With Vahid and Aravin we will see how zenphi can be used to automate processes such as Mail Merge to more advanced multi-step approval processes. As part of the show we will learn how they have approached the challenge to support users in taking more ownership of their business processes.

Tune in live to contribute to the YouTube live chat (recording immediately available).

For previous episodes, information and resources visit https://tu.appsscript.info/

Community News

Totally Unscripted: Preaching to the Converted – Convert Microsoft Excel files with macros to Google Sheets – Thur 04 Feb at 0800 PST / 1100 EST / 1600 UTC

Tags:
| | 0 Comments |

Totally Unscripted is back on 04 Feb at the slightly earlier time of 0800 PST / 1100 EST / 1600 UTC.

In this episode we are joined by some of the team at Google behind the development of the Macro Converter. The Macro Converter is an add-on that makes it easier to convert Excel files that have Visual Basic for Applications (VBA) code to Google Sheets files and Apps Script. You can use the Macro Converter add-on to determine the compatibility of your files and automatically convert them.

This show is your opportunity to learn more about Macro Converter and get your questions in to the developers. Tune in live to contribute to the YouTube live chat (recording immediately available).

For previous episodes, information and resources visit https://tu.appsscript.info/

Community News

Totally Unscripted: Getting Schooled on Apps Script – Using Automation in EDU – Thur 28 Jan at 1200 PST / 1500 EST / 2000 UTC

Tags:
| | 0 Comments |

Totally Unscripted is back on Thur 28 Jan at 1200 PST / 1500 EST / 2000 UTC and in this episode we will explore how Google Apps Script is supporting educators around the world to become more productive and efficient. From grading quizzes to administering class rosters and everything in between, Apps Script can be used to help educators save time in the administration of teaching and learning and spend more time with their students.

For this episode we are joined by noted teacher and Apps Script creator Alice Keeler (alicekeeler.com) as well as Dave Abouav who is a Google Employee and part-time physics teacher and the creator of the popular grading tool Flubaroo. With Alice and Dave we will discover some of the opportunities for using Google Apps Script in education as an end user and developer.

Tune in live to contribute to the YouTube live chat (recording immediately available).

For previous episodes, information and resources visit https://tu.appsscript.info/

Community News

Every Google Apps Script project on Github visualized – Desktop Liberation

Tags:
| | 0 Comments |

Visualization of apps script projects

There are so many Apps Script projects out there where the source code is published on Github, but it’s hard to find what you want. Whether it’s a library, an example of an add-on, how to use an advanced service, or just see who is working on what. I figured it would be nice if we had a searchable visualization of everything that’s public.

Source: Every Google Apps Script project on Github visualized – Desktop Liberation