AppsScriptPulse

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

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

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

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/

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

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/

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

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/

Every Google Apps Script project on Github visualized – Desktop Liberation

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

Totally Unscripted: Get AMPed about Email – Thur 21 Jan at 1200 PST / 1500 EST / 2000 UTC

Totally Unscripted is back again on Thur 21 Jan at 1200 PST / 1500 EST / 2000 GMT. This time we will be joined by Jon Harmer (Product Manager, Google Workspace) and Steve Bazyl (Developer Relations, Google Cloud) who will give an overview of how you can start using AMP with your Google Workspace Gmail users and beyond.

Unfamiliar with AMP for email? This “allows senders to include AMP components inside rich engaging emails, making modern app functionality available within email. This dynamic email format provides a subset of AMPHTML components for use in email messages, that allows recipients of AMP emails to interact dynamically with content directly in the message” [ref]

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

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

Trend of google-apps-script Tag on Stackoverflow 2021

Year vs. number of Questioners and Answerers. These all questions include the tag of "google-apps-script" in the tags

Year vs. number of Questioners and Answerers. These all questions include the tag of “google-apps-script” in the tags

Trend of google-apps-script Tag on Stackoverflow 2021

Kanshi Tanaike returns with an updated look at trends in the [ google-apps-script ] tag on Stackoverflow. A highlight from the report is the continued growth in new questioners, indicating that the Google Apps Script community is continuing to grow.

Source: Trend of google-apps-script Tag on Stackoverflow 2021

Workspace Devs Directory – a new community initiative to help Google Workspace and Apps Script developers connect

Directory | Workspace Devs

A directory of Google Workspace and Apps Script Developers.

This space is to help bridge that gap within the Google Workspace (previously, G Suite) Developers community and mostly geared towards users who work within the Apps Script ecosystem.

Sourabh Choraria has created a new initiative to help Google Workspace and Apps Script developers connect. Anyone can submit their profile to be included in the directory.

Source: Directory | Workspace Devs

Google to offer free training courses in AI, Kubernetes and multi-cloud | IT PRO

Image: © Google Cloud

The cloud giant is offering 30 days of free training and routes to certification.

Budding learners can access all of these through a set of ‘skills challenges’ which give participants greater knowledge of each subject and a chance to earn a Google skill badge to prove their competency.

Participants will have 30 days of free access to Google Cloud Labs to work their way through four skill challenges: ‘Getting Started’, ‘Data Analytics’, Hybrid and Multi-cloud’ and finally ‘Machine learning and Artificial Intelligence’.

The Data Analytics course is for more experienced participants to expand their skills into AI and machine learning with a chance to demonstrate an understanding of BigQuery. They can learn how to do everything from writing and troubleshooting SQL queries and using Apps Script, to building classification and forecasting models.

IT PRO has picked up on some free training from Google, which includes an opportunity to use your Google Apps Script knowledge in the Data Analytics course. To start the challenges you need to register by January 31, 2021, 11:59 PT.

Source: Google to offer free training courses in AI, Kubernetes and multi-cloud | IT PRO

Totally Unscripted: A 2020 Google Apps Script recap for Google Workspace solution builders – Thur 14 Jan at 1200 PST / 1500 EST / 2000 UTC

Totally Unscripted returns and we kick off the year looking at some of the highlights and developments you may have missed in 2020 for Google Workspace solution builders. Our panel includes Olaf Hubel, Google Workspace Developer Relations Manager, and other noted experts from the community. As well as looking at Workspace highlights from 2020 we’ll look at what might be in store for 2021. Tune in live to contribute to the live chat.

Totally Unscripted: Becoming a Google Workspace Solutions Gallery contributor – Thur 17 Dec at 1200 PST / 1500 EST / 2000 UTC

In this session we will have a look at the Google Workspace Solutions Gallery. “The Google Workspace Solutions Gallery is a collection of sample solutions that demonstrates how you can solve common business challenges with Google Workspace Developer technologies. These samples showcase different ways to integrate and customize the productivity tools you’re already using.” – https://developers.google.com/gsuite/solutions

As part of the Gallery anyone can suggest new solutions and we speak Jasper Duizendstra who has contributed the Record time and activities in Calendar and Sheets solution. We speak to Jasper about his experience summitting and getting a solution published.

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

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

Totally Unscripted: New workflow solutions with Tables and Google Apps Script – Thur 10 Dec at 1200 PST / 1500 EST / 2000 UTC

In this episode we’ll be joined by Carlin Yuen Co-founder & Product Lead, Tables (Google, Area 120) and Ben Collins Educator at benlcollins.com and Google Developer Expert. The Tables beta is the latest product to emerge from Google’s Area 120. Currently Tables is only available to US customers so this show is an opportunity to have an expert tour from the co-founder/product lead Carlin Yuen. We’ll also be joined by Ben Collins who has been using Tables and he’ll be sharing some insight into how Tables can be used with Google Apps Script.

Join Adam Morris (@clssrmtechtools) in the Advent of Code with Google Apps Script challenge

When and where I can, I’ll be trying to complete the advent of code challenges in appscripts. You can follow along here … I find these sorts of exercises really valuable. It makes you think about the language you’re using very carefully. – Adam Morris

In the Google Apps Script Community Google Group Adam Morris is participating where he can in the Advent of Code

Advent of Code is an Advent calendar of small programming puzzles for a variety of skill sets and skill levels that can be solved in any programming language you like. People use them as a speed contest, interview prep, company training, university coursework, practice problems, or to challenge each other.

If you would like to play along with Adam follow the link to the Google Apps Script Community Google Group thread.

Source: Advent of Code w/ AppsScripts – Google Apps Script Community Google Group

Totally Unscripted: “The State of Script” address from Google – Fri 04 Dec at 1200 PST / 1500 EST / 2000 UTC

In this episode of Totally Unscripted we are joined by Keith Einstein Product Manager for Apps Script and Charles Maxson (TU host and Developer Advocate at Google). As part of this show Keith will review the current state of Apps Script and also exclusively reveal some forthcoming soon to be released features.

The show is also an opportunity to get your Apps Script related questions in which can be emailed to [email protected] or asked live via YouTube chat.

Subscribe to Apps Script Pulse...