In this TU special we are joined by Bruce Mcpherson who will share work on detecting similarities and duplication between films digitally using the trained ML models in the Google Video Intelligence API. With this the video content itself can be identified, tracked, searched, visualized and compared.
This video comes via a share from Alan Wells on the Google Apps Script community group. As pointed out by Alan whilst this webinar recording from SCORE focuses on mobile app development and distribution via Apple and Google the principles in terms of privacy policies, terms of service and intellectual property broadly apply if you are developing a distributing add-ons or other products developed using Google Apps Script.
In this episode of Totally Unscripted we are joined by Praveen Seshadri co-founder of AppSheet, the no-code mobile-application-building platform recently acquired by Google. Joining Praveen will be Christian Schalk, Developer Advocate at Google and long time advocate of entry level application development tools. In this session we will discuss the AppSheet philosophy and how the platform can be used to help deliver Google Workspace based solutions.
If you have any questions for this episode they can be emailed to [email protected] or tweeted @AppsScriptInfo
Thursday, 12 November 2020 at 1200 PST / 1500 EST / 2000 UTC
Guests – Mike Rhemtulla (Product Manager, Google Workspace), Steven Bazyl (Developer Relations, Google Cloud) and Steve Webster (SW gApps LLC, President)
In this episode we are joined by Mike Rhemtulla and Steven Bazyl exploring Google Workspace Add-on development. As part of this with Mike will share the impact and opportunity of being of contributing to the Google Workspace Marketplace, while Steven will share tips on building Add-ons. Finally, Steve will share tips on migrating existing HTMLService based Add-ons to the new Card Service
Use the YouTube comments to share any Marketplace and Workspace Add-on questions before the show or email them to [email protected]
Totally Unscripted is a Google Workspace and Apps Script developer show organized by the community for the community. We invite members of the community to share their Google Workspace developer tips, tricks and triumphs.
Totally Unscripted the Google Workspace and Apps Script developer community show returns! The shows are an opportunity to learn about the very latest Google Workspace and Apps Script updates from both the community and Google. We are returning with a series of six weekly shows starting with ‘Meet the new Google Workspace Developers Experts‘ on 05 November 2020 at 20:00 UTC (TZ conversion).
In this show you have an opportunity to meet some of the new Google Developers Experts (GDE) in Google Apps Script. As well as finding out how our experts got involved in Apps Script, we find out why they think it is different to other platforms, their favourite killer app and why you should learn Apps Script. The show is also an opportunity to find out if you’ve got what it takes to become our next newest GDEs. For this episode we are joined by:
I’m a teacher-turned-developer actively searching my first software engineer job during the pandemic after graduating from Hackbright Academy. As a bootcamp new grad, I am lucky to get an internship opportunity to develop a gmail add-on product at dialoggBox to gain my first industry experience and learn how to work with stakeholders.
My article will be composed of three parts:
What service do dialoggBox and this gmail add-on provide?
What was my experience using Google Apps Script to build an add-on product?
How did I develop each section of the gmail add-on?
The actual details of the add-on developed by the author, Nancy Dai, are promised in a follow-up post but this post serves as a useful insight into the main things to look out for when developing Gmail Add-ons.
It’s always nice to see members of the community contribute new resources. The latest comes from a growing list of videos produced by Chanel Greco Founder & CEO of saperis. These videos are designed to show how repetitive tasks in G Suite can be automated using Google Apps Script. Chanel has lots of other G Suite problem solving solutions posted on the saperis YouTube channel.
I’m sure for many pro Google Sheets users when you look at a Google Sheet what you see on screen is different for what you ‘see’ in your mind. Researchers from Coburg University, Microsoft Research and the University of Cambridge have potentially bridged this gap showing what Google Sheets can look like virtual reality (VR).
Whilst the video embedded above is not explicitly about Google Apps Script, I think it’s always worth keeping an eye on the horizon to see what the future might bring (you might want to skip through to 05:12 to see what I mean). You can also read the full research paper, in which the researchers explain how they used the Google Sheets API to build the experimental interface in the Unity game engine.
For Google Apps Script developers I’m sure you’ll be able to see how this solution could also benefited from the built-in SpreadsheetApp methods like getCurrentCell() and activate(), rather than using the the Sheet API, which reported as a limitation that haas reported in the research paper:
Since the Google Sheets API exposes no functionality to track client-side interactions, operations of users with the web page were tracked inside Unity. In particular, tracking of cell selection was implemented by constructing virtual-cells in the Unity space using oriented bounding boxes, and spatially position them in their corresponding places to fit the spreadsheet texture. Tracking of the pen and the Unity collision detection mechanism is used to detect whether the pen tip lies inside a certain cell.
This add-on makes it easy to move high-value emails into your other apps with just a click, without ever leaving Gmail.
You can use the add-on to create customized one-click workflows that give you seamless productivity—by moving important messages out of a private inbox and into a shared tool like Slack, for example, or by routing emails to apps like Asana to streamline your project management.
Following on from our recent repost of Zapier’s Google Sheets app of the day, Zapier are continuing their love of Google Apps Script with a new Gmail Add-on. The source code for this add-on is proprietary but again useful to see firms investing in G Suite solutions for the marketplace.
QUnit2GS is a Google Apps Script Library that allows Apps Script projects to be tested using the QUnit JavaScript testing framework – qunitjs.com. Just add this library to your project and start writing tests in just a few minutes.
Created by Andrew Roberts and Alejo Grigera Sutro this library will make it easier to adopt test-driven development with your Google Apps Script projects. The site is worth an explore to see what is possible…
