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.
You can use Google Script to create JSON Web Tokens (JWT) that can be provided to secure routes so that only authenticated requests that contain a valid token can connect to the APIs (e.g., the Zoom API)
Nice little snippet from Amit Agarwal for both creating and decoding JSON Web Tokens (JWT).
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.
In this tutorial, we are going to create an interactive story chain app that we can embed into a Google Site or your own site like WordPress.
Yagi uses a simple but very effective interactive story chain app to explore and explain some very powerful Apps Script functionality all developers should know about. This includes using the
which can be used to prevent concurrent access to sections of code. Yagi also highlights some recent discussions around the limitations of Web Apps and concurrent users. Click through to the source for all this and more.
Tutorial on how to build an Alexa Rank tracker in Google Sheets, using the powerful IMPORTDATA and REGEXEXTRACT functions and Apps Script.
Clever post from Ben Collins highlighting how Google Sheets functions can be used to scrape Alexa tracking data. As a bonus Ben includes a little snippet of Google Apps Script to let you archive data over time.
Did you know that AppSheet can integrate with Google Workspace? In this video, we speak to how AppSheet – Google Cloud’s no-code application platform – helps citizen developers streamline their workflows, and demo how you can create your own app in Google Sheets. Watch to explore the possibilities of AppSheet!
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 Sheets to Apps, we show you how you can easily build a payroll app that makes approving timesheets easier and communication with management seamless. Watch to learn how you can build a timesheet application with zero code!
Click through to the YouTube page and check the video description for all the resources to replicate this solution.
push data from web captioner to google sheets via webhooks built using apps script.
the problem – playing with webcaptioner.com which lets you specify a webhook url. i was experimenting with adding captions to a google doc in realtime but apps script couldn’t keep up dropping ~20% of the captions sent via the hook
Sourabh Choraria kindly helped me solve an issue I was having passing data from webcaptioner.com to Google Sheets. Click through to the source link for the full explanation from Sourabh, but in essence the problem was I was losing data because I wasn’t using the
In the meantime webcaptioner.com have also updated there channel webhooks so you can set a data chuck size so if you are looking to capture a transcript in Google Docs you can use the following published as a container bound web app:
If your organization is using G-Suite (now known as Google Workspaces) then you’re hopefully using Google Apps Script to automate your email communication. (If you aren’t, why not? It’s a brilliant way to manage your communications.) You probably have different types of emails — for different purposes.
Do all of your emails have the same look-and-feel? Do they all match your organization’s branding requirements? How easy is it to update the format for all of them if you need to change a core/base element? Maybe the company tagline and color theme changed — how quickly can you get all of your emails updated?
I am going to show you how to create templated emails so that all of the emails you send have the same look-and-feel and are easy to maintain/update.
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
Complete the steps on this page to create a Google Sheets add-on that tracks attendance for Google Classroom courses delivered using Google Meet conferencing.
Nice spot via @barrielroberts/@alicekeeler for an official Google Apps Script quickstart which combines Google Sheets, Google Classroom and Admin Reports which lets you create an automated Google Meets attendance roster tool. The quickstart has all the code and instructions you need to get this working.