AppsScriptPulse

Resumable Upload For Google Drive with Google Apps Script Example

This is a Javascript library to achieve the resumable upload for Google Drive. When a file more than 5 MB is uploaded to Google Drive with Drive API, the resumable upload is required to be used.  tanaikech/ResumableUploadForGoogleDrive_js

Kanshi TANAIKE has some amazing GitHub contributions and this is another one. Whilst this is designed as a Javascript library you can use in any project Kanshi provides and an example of how this could be used in a Google Apps Script add-on.

Source: tanaikech/ResumableUploadForGoogleDrive_js

Using Apps Script, a Google Sheets Macro and Benford’s Law to Detect Potential Fraud – Laura Taylor

As one of the only technologists in a family of CPAs I’m always seeking ways to participate in the discussion. So when the topic of using Benford’s Law as a risk assessment tool recently surfaced in conversation I decided to develop a custom macro to automate the analysis inside Google Sheets.

Laura Taylor tackles an interesting topic is this post highlighting how Benford’s Law can be used to detect anomalies in data. Google Apps Script developers might also be interested in the way macros are introduced to the reader.

Source: Using Apps Script, a Google Sheets Macro and Benford’s Law to Detect Potential Fraud

Using RingCentral API in Google Apps Script – DZone Integration

This tutorial gives us an explanation on how to use RingCentral’s API in Google Apps Script.

Nice little tutorial written by Embbnux Ji that shows how you can use Google Apps Script to connect with RingCentral, an “All-In-One: Voice, Fax, Video and Team Messaging” service. The tutorial includes an example for connecting with the RingCentral SMS API. There are many more APIs provided by RingCentral you could use. As a RingCentral administrator I’ve often considered using the RingCentral Configuration API and our team Google Calendar to setup call redirection…

Source: Using RingCentral API in Google Apps Script – DZone Integration

BkperApp – An example 3rd party client library for Google Apps Script 

Google Apps Script library for Bkper.

Bkper “provide a simple way to work with Finances and Accounting on Google Cloud”. The BkperApp is a Google Apps Script library they have published so that other developers have an easy way to interact with the Bkper API. There are a couple of reasons for highlighting BkperApp. First it’s great to see a company invest in developing and publishing a Google Apps Script library for their product. The BkperApp code is worth looking at because the code has been developed in clasp using TypeScript. Finally the code is open source (Apache License 2.0) so if you are thinking of developing a library for your own product BkperApp might provide a useful starting point in terms of how you structure your project.

Source: bkper/bkper-app

TSDataTable — Simple, Elegant Data Tables for Google Sheets & Sites – Laura Taylor

The challenge? Make this table powerfully configurable, simple to use, private to the client domain and employ existing G Suite tools.

After some dedicated design and development with Google Apps Script … 💥 TSDataTable!

Source: TSDataTable — Simple, Elegant Data Tables for Google Sheets & Sites

Analyzing text in a Google Sheet using Cloud Natural Language API and Apps Script | Google Cloud Blog

Try out Apps Script on a Google Sheet populated with a Kaggle Dataset: interpret with Cloud Natural Language, and visualize the output in DataStudio.

As part of this post you can see how you can send and update data from a Google Sheet to Cloud Natural Language.

Source: Analyzing text in a Google Sheet using Cloud Natural Language API and Apps Script | Google Cloud Blog

G Suite Developers Blog: Sheetcaster: 3D in Apps Script

Sheetcaster: 3D in Apps Script

Guest post by Thomas Coudray, Amaury de la Vieuville, and Ahmed Bougacha. Thomas, Amaury, and Ahmed attended the Google Apps Script Hackathon in Paris, and in this post they are sharing their creative use of Google Apps Script to render a 3D scene in a Google Spreadsheet

An old project but hopefully something nice to delve into for the weekend…

Source: G Suite Developers Blog: Sheetcaster: 3D in Apps Script

Repost: Sending bulk email (mail merge) using Gmail and Google Sheets – MASHe

Simplify the process of producing visually rich mail merges using Gmail and combining it with data from Google Sheets. With this solution you can automatically populate an email template created as a Gmail draft with data from Google Sheets. Merged emails are sent from your Gmail account allowing you to respond to recipient replies.

Source: Repost: Sending bulk email (mail merge) using Gmail and Google Sheets – MASHe

Digitize Mail & Parcels Tracking with Google App Maker

A few months ago my team was challenged to digitize the work of the General Services Department in our offices. To improve the process we created a Google App Maker web-app designed to be used on Chromebooks in tablet mode. To track usage and movements, Cloud SQL stores data in tables: packages, movements/history and anomalies declared by teams. In order to retrieve the hexadecimal code of the badge, it’s really easy. A card reader behaves like a keyboard !

Source: Digitize Mail & Parcels Tracking with Google App Maker

Subscribe to Apps Script Pulse...