Stack Overflow in 2023: Predicting with ARIMA and BigQuery – Can you predict the top Stack Overflow tags of 2023? BigQuery makes this easy, with its new support for training time-series analysis models with ARIMA.
Felipe mentioned in a tweet that the prediction was Google Apps Script was to continue to grow:
Programming languages trends, by % of Stack Overflow views:
Andrew Roberts has shared a tutorial and boilerplate for using the Materialize CSS framework in the Google Sheets sidebar. Materialize is based on Material Design and the framework is lightweight and easy to use. This framework will also work for other G Suite editor sidebars (Docs, Sheets, Forms, Slides). If you plan to use Materialize in your Editor Add-on Google ask that the design adheres to the UI style guide.
Have you ever asked for a list from a client, another department or agency and instead of saving into a file that might even be considered marginally useful, they give it to you as a pdf. … Continue reading “Google Apps Script: Extract Specific Data From a PDF and insert it into a Google Sheet”
Yagi shares a comprehensive walk-through of how you can sometimes extract data from .PDF documents using Google Apps Script and the advance Drive service. The solution is also able to work on .PDFs created from images using the built-in OCR features of Google Drive and you might want to drop the getTextFromPDF() function shared in the post.
Cleaning up data from downloaded accounting reports or from other systems can take up valuable time and resources. In this episode of Sheets to Apps, we’ll walk you through adding automation to your monthly Excel accounting data that records your steps into a script that you can run repeatedly with Google Sheets macro recorder.
From the video description you’ll find all the links you need to the example Google Sheet, instructions and more
Por esa razón me he puesto manos a la obra y he preparado MEDIAMOVIL(), una función personalizada GAS capaz de calcular varios tipos de medias móviles, que puede ser utilizada (como todas las funciones personalizadas) de manera combinada con el resto de funciones integradas que nos ofrecen las hojas de cálculo de Google.
TRANSLATED: For this reason I have gotten to work and have prepared MEDIAMOVIL(), a custom GAS function capable of calculating various types of moving averages, which can be used (like all custom functions) in combination with the rest of the integrated functions. offered by Google spreadsheets.
Great post from Pablo Felip (@pfelipm) on calculating moving averages in Google Sheets. As part of this Pablo has developed and shared the MEDIAMOVIL() custom function he has developed in Google Apps Script. Clicking through to the source code on Github Pablo has also shared lots of advice on developing custom functions for Google Sheets including using the contextual help features available in custom functions as well as handling parameters and throwing appropriate error messages to the user.
How to use the Zoom API to automatically create and schedule Zoom meetings with Google Apps Script
Great little snippet from Amit Agarwal showing how you can interact with the Zoom API using Google Apps Script. This post is also a great example if you are also looking for a code pattern for interacting with APIs using JSON Web Token (JWT). As Amit mentions it’s worth noting that:
We can build Zoom apps with the OAuth2 library as well but since this app is only for internal use and will not be publish to the Zoom marketplace, the JWT approach is easier.
Retrieve the source code linked to a specific version of your Apps Script project then save it as a new Apps Script project – RomainVialard/access-code-of-older-versions
Neat solution from Romain Vialard to retrieve a previous version of your Apps Script code. There is an open feature request to have this as a built-in feature of Apps Script (as noted by Romain recovering a previous script version is also possible using clasp using pull and an optional version number).
Talk presented at 24hrs of Google Cloud Talks by DevRel on 23 June 2020 by Martin Hawksey
The Google Cloud Vision API is a powerful tool that helps developers build apps with visual detection features, including image labelling, face and landmark detection, and optical character recognition (OCR). Getting started building with these services is relatively simple with Apps Script, as it uses simple REST calls to interact with the API directly, eliminating the need to set up SDKs or to download client libraries.
In this post Christian Schalk, Google Cloud Developer Advocate, provides details for setting up a Google Apps Script project with the Google Vision API, using this service to perform optical character recognition on a user selected image.
Course evaluations can be a bit overwhelming when receiving mass amounts of feedback, but thanks to Apps Script this is a problem of the past. In this episode of Sheets to Apps, we’ll show you how to create and use an Apps Script for Google Sheets that allows you to respond to feedback on Google Forms via email.
In a recent episode of Sheets to Apps Ben Collins’ clever ‘Respond to feedback from students in a course’ in the G Suite Solutions Gallery is featured. See the YouTube video description for related links.
This is a GAS library for copying the rich text with the text styles from Google Document to Google Spreadsheet or from Google Spreadsheet to Google Document using Google Apps Script (GAS). And, also the rich texts in the cells can be converted to HTML format.
Nice little helper library for copying rich text formatting from Google Docs and Sheets. You can view the project README for information on the formats that are currently supported. Personally, the inclusion of the RichTextToHTMLForSpreadsheet method looks particularly useful for converting rich text formatting in Google Sheets cells to HTML for mail merge applications.
This is a sample script for disabling the buttons put on Google Spreadsheet using Google Apps Script. When a script is run by clicking a button on Google Spreadsheet, there is the case that you don’t want to make users run the script in duplicate.
Nice little Google Apps Script snippet that prevents a function assigned to an image or drawing in Google Sheets from being run simultaneously. The clever bit is the code uses Google Apps Script to modify the function assigned to the button/image when it is running.
With Creator Studio, you can easily convert your Google Slides presentation into animated GIFs and video slideshows. The add-on can also extract speaker notes from your slides and export them as a text file in Google Drive. Internally, the app uses Google Apps Script to export Speaker Notes from your Google presentation and writes them to a text file inside Google Drive.
In this post Amit Agarwal share some very clean code for iterating across each slide in Google Slides and export the speaker notes into a single file. Click through to the post for the source code.
Kanshi Tanaike is a prolific Google Apps Script developer and we’ve often featured solutions are reports that Tanaike has shared. With this in mind Tanaike’s list of Google Apps Script resources is well worth a browse.
Last year I published a tutorial on how to sync data between two Coda docs and data between two Google Sheets. What was missing from the tutorial was how to sync data between a Coda doc and a Google Sheet.
While looking for a solution to my problem, I landed with Google Data Studio (GDS). Have you ever heard of GDS? Lucky you! Many people don’t even know that such a powerful tool exists and that it’s for free. Some years ago I was playing around with GDS for analyzing our Google Analytics data that we had gathered from the usage of our Android App. That’s exactly where GDS originates. It was designed as a simple but handy tool to dig through your Google Analytics data.
This article will explain some common use cases of data inside Google Data Studio and elaborate on how they impact your code and how data is being retrieved from your custom API. It may help you to decide whether to stick with your current solution or start implementing a custom connector for Google Data Studio.
Using the UrlFetchApp library and the fetch method we call the Plex media server to retrieve all the contents of our library. We parse the XML response to JSON using a method that you can find here. You can add the parsing method to the same file, if you want.
This tutorial is going to cover what it takes to automatically cleanup a Plex media server, using Google Apps Scripts.
My small team relies on automation to make things run. Part of our PD process is a Google Form workflow that kicks off calendar events, document creation, and email notifications. Since we’ve moved to online learning, we wanted to update that process to automatically add a Google Meet link for any PD that doesn’t have to be in person.
There are some official Google guides that show how to attach a Meet event to the Calendar, but nothing from the perspective of Apps Script specifically, so that’s what is shown here.