AppsScriptPulse

How To Create An Android App That Posts Pictures to Google Sheets with Google Apps Script

I used the MIT App Inventor site to create an Android app that…
  • Uses the camera to take a picture and saves it to the device’s gallery
  • Let’s you select a picture from the gallery
  • The image is converted into base64 and uploaded to a web app
  • Additionally, it also sends rotation and lat/lng coordinates and lets you add a textual comment as well.
This Android app sends it to an Apps Script web application inside a Google Spreadsheet

Nice fun project from Tom Smith that use MIT App Inventor to create an Android app that is able to send data to a Google Sheet. Check out the source link for all the code you need.

Source: How To Create An Android App That Posts Pictures To Google Sheets

Google Sheets: Zapier app of the day

Need your spreadsheet to do a specialized task, such as detecting and deleting duplicate rows automatically? You can build and publish custom add-ons with the Google Apps Script to take your spreadsheets to the next level. Don’t know code? Browse the Google Sheets add-on store to see what features others have built.

Always nice to see other organisations highlight Google Apps Script.

Source: Google Sheets: Zapier app of the day

Build A Lookup Table Generator For Google Tag Manager with Google Sheets and Apps Script

The purpose of the Lookup Table generator is to automate the often tedious task of adding many, many rows to a Lookup Table within the Google Tag Manager UI. There are other solutions for this, but none (as far as I know) that uses the Google Tag Manager API.

Within the Google Apps Script community there is a strong representation from those working in analytics and SEO. Simo Ahava has shared a comprehensive tutorial which shows how you can interact with the Google Tag Manager API in Google Sheets. Click through to the source for more details and all the code you need.

Source: Build A Lookup Table Generator For Google Tag Manager | Simo Ahava’s blog

Send Tweets from Google Sheets using a Google Apps Script

In this post, you will learn how to send automated tweets from Google Sheets to Twitter using Google Apps Script.

This post includes everything you need to get started sending tweets for Google Sheets. This tutorial uses the community contributed Twitterlib library from Bradley Momberger, which has some implemented methods for sending and fetching tweets.

Source: Send Tweets from Google Sheets using a Google Apps Script

Control responses in Google Forms in 4 lines of Google Apps Script

If you are using Google Forms to handle sign-ups for an upcoming event, and you want to control the number of responses (Limit responses), guess what! you can do it using Google apps script (only in 4 Lines of Code)

Nice little snippet highlighted by Aya Sayed, click through to the source for the code snippet.

Source: Control responses in Google Forms! | by Aya Sayed | Jul, 2020 | Medium

Sync RingCentral Call Log into Google Sheets with Google Apps Script | by Embbnux Ji | RingCentral Developers | Medium

In this article, I would like to show you to how to create a Google Sheets add-on to help people sync RingCentral call log into spreadsheets.

Nice post highlighting how you can integrate the RingCentral service into a Sheets Add-on. The post includes more general information about setting up access to the RingCentral API which might be useful in your other projects.

Source: Sync RingCentral Call Log into Google Sheets with Google Apps Script | by Embbnux Ji | RingCentral Developers | Medium

First look at the new Google Apps Script Integrated Development Environment (IDE) Script Editor – MASHe

As part of Next OnAir week 2 the focus was on ‘Productivity and Collaboration’ Charles Maxson from the G Suite DevRel team not only provided some highlights from the week, but he also premiered the new Google Apps Script IDE.

This post includes a recording to a live demo of the new Google Apps Script editor. No news on when the new Script Editor will be generally available, but from the demo it looks like Google have focused on making it easier for developers to code and debug scripts.

Source: First look at the new Google Apps Script Integrated Development Environment (IDE) Script Editor – MASHe

Goa v8 changes and enhancements for OAuth2 and Google Apps Script

Goa tutorial

v8 and other htmlservice changes meant I had to make a few small changes to cGoa. The good news it’s easier to use than ever, and supports a few new services too. It’s best to look at the service list on github, as that’ll be kept up to date. Here’s a reminder of how to use it.

There are a couple of OAuth 2 Google Apps Script libraries out there but cGoa from Bruce Mcpherson is the easiest one I used, particularly, when it comes to setup. Bruce’s post has more details including various ways you can use the library.

Source: Goa v8 changes and enhancements

Converting SVG Format to PNG Format using Google Apps Script · tanaike

This is a sample script for converting the SVG image data to PNG image data using Google Apps Script. Unfortunately, in the current stage, there are no methods for directly converting the SVG to PNG in Google Drive service. But it can be achieved by Drive API

Nice trick to get .svg files stored in Google Drive in a raster format.

Source: Converting SVG Format to PNG Format using Google Apps Script · tanaike

Google Apps Script – Stack Overflow growth trends and predictions 

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 Hoffa has prepared an interesting post looking at current Stack Overflow tag usage and future trends. You can read more details about the trends for the big hitters like Python and JavaScript in the source blogpost. Felipe’s post also gives you the opportunity for a little ‘exploratory analyses’ as he has also provided a link for you to play with an interactive dashboard on Data Studio.

Felipe mentioned in a tweet that  the prediction was Google Apps Script was to continue to grow:

Given this I decided to have a look at the google-apps-script tag and a couple around it in the Data Studio dashboard and came up with this:

Stack Overflow tag trends: Historic + predictions

Stack Overflow tag trends: Historic + predictions
By @felipehoffa
Read more: bit.ly/arima_so

So Google Apps Script, continuing to grow, currently more viewed than Google Cloud Platform and on a par with FFmpeg ;)

Source: Stack Overflow in 2023: Predicting with ARIMA and BigQuery

Google Sheets Sidebar with Materialize CSS & jQuery – Andrew Roberts

Materialize

Tutorial on creating a Google Spreadsheet Sidebar with Materialize CSS framework, jQuery JavaScript framework, and Google Apps Script.

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.

Source: GSheet Sidebar with Materialize CSS & jQuery – Andrew Roberts

Google Apps Script: Extract Specific Data From a PDF and insert it into a Google Sheet – Yagisanatode

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.

Source: Google Apps Script: Extract Specific Data From a PDF and insert it into a Google Sheet – Yagisanatode

How macros can be used to build Apps Scripts for cleaning data – Sheets to Apps

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

Calculating moving averages in Google Sheets with Google Apps Script (and tips on writing custom functions)

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.

Source: Calculando medias móviles con Google Apps Script

How to Create Zoom Meetings with Google Apps Script – Digital Inspiration

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.

Source: How to Create Zoom Meetings with Google Script – Digital Inspiration

Retrieve previous versions of Google Apps Script projects

Photo by James Lee on Unsplash

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).

Source: RomainVialard/access-code-of-older-versions

All about Apps Script – Presented at 24hrs of Google Cloud Talks by DevRel

It’s serverless, it’s integrated, it’s JavaScript. Google Apps Script is a powerful enterprise ready productivity and rapid application development platform that makes it fast and easy to create business applications that integrate with G Suite. In this session you will provide an introduction to the Google Apps Script platform and highlight some example solutions that you can start using today.

Talk presented at 24hrs of Google Cloud Talks by DevRel on 23 June 2020 by Martin Hawksey

Slides – https://go.alt.ac.uk/24hr

Getting started with the Google Vision API from G Suite | Google Cloud Blog

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.

Source: Getting started with the Google Vision API from G Suite | Google Cloud Blog

Auto respond to feedback via Apps Script – Sheets to Apps

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.

Highlighting Row and Column of Selected Cell in Google Sheets using Google Apps Script · tanaike

This is a sample script for highlighting the row and column of the selected cell using Google Apps Script … and the OnSelectionChange event trigger

Nice little script solution which could be a very useful addition to your script projects as an accessibility feature.

Source: Highlighting Row and Column of Selected Cell using Google Apps Script · tanaike

Subscribe to Apps Script Pulse...