Martin Hawksey – Page 92 – AppsScriptPulse

I created a Twitter Bot from nothing but a Google Sheet – And I Didn’t Even Know The Scripting Language…

| 16 October, 2019 | 0 Comments |

… that job taught me two very important lessons: repetitive stuff needs to be automated; the best way to learn to code is with a tangible, objective problem that needs a solution. … It was then I decided to go all-out and make a Twitter Bot. Having no relevant experience or clue of what I was doing, my goal was simple: send a few tweets with relevant quotes, readings, and information for Orthodox Christians

Very detailed post from Peter Berthelsen on his journey from no-code to making a functional Twitter bot and if you keep reading to the end you’ll get a link to Peter’s follow-up post with a template and setup instructions. These posts are great examples of the empowerment Google Apps Script can give to people.

Source: I created a Twitter Bot from nothing but a Google Sheet

Solutions Web App

Take Me There – URL Shortener powered by Google Apps Script | Product Hunt

Tags: script.gs

| 14 October, 2019 | 0 Comments |

This tool is a URL Shortening service powered by Google Apps Script and hosted using Github Pages.

Lovely little project from Sourabh Choraria which uses some contributions from the Apps Script community. The code for the ‘Take me There’ URL shortener is open source making it easy to deploy your own version. You can read about the development of this project including discovering issues with e.pathInfo in Sourabh’s blog post.

Source: Take Me There – URL Shortener powered by Google Apps Script | Product Hunt

Community News

New blog on Google Apps Script for Education – Peter Whitehead

Tags: gas4edu.com

| 14 October, 2019 | 0 Comments |

Delighted to have finally got round to creating a blog as a repository for all my #AppsScript code for teachers, educators and IT support in schools/college. #GAS4edu #Edtech #gsuiteedu https://t.co/2p9qBRJGvX pic.twitter.com/GYgHGh4g5u

— Peter Whitehead (#FE) (@Whitehead_Maths) October 12, 2019

Peter Whitehead is Head of Mathematics in a large Further Education College in London, UK and has started a blog sharing “Google Apps Script code that will make life easier for teachers, educational managers and educational IT support”.

You can follow Peter’s work at www.gas4edu.com

Library Solutions

Resumable Upload For Google Drive with Google Apps Script Example

Tags: GitHub, tanaikech

| 11 October, 2019 | 0 Comments |

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

App Maker Official News Sheets

Example apps you can build on Google App Maker – Sheets to Apps – YouTube

Tags: Sheets to Apps

| 10 October, 2019 | 0 Comments |

In this episode, we give you some brief examples of what kind of apps you can create with App Maker. Learn how to build dashboards, human resource apps, and so much more!

Sheets Solutions

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

Tags: @techstreams, Medium

| 9 October, 2019 | 0 Comments |

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

Solutions

Using RingCentral API in Google Apps Script – DZone Integration

Tags: dzone.com

| 8 October, 2019 | 0 Comments |

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

Library Sheets Solutions

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

Tags: bkper, GitHub

| 7 October, 2019 | 0 Comments |

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

Sheets Sites Solutions

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

Tags: @techstreams, Medium

| 6 October, 2019 | 0 Comments |

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!