AppsScriptPulse

Solutions, Sheets

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

Tags:
| | 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, Sheets, Sites

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

Tags:
| | 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!

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

Solutions, App Maker

Digitize Mail & Parcels Tracking with Google App Maker

Tags:
| | 0 Comments |

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

Solutions, Gmail, Sheets, YouTube

Automating YouTube comment notifications using Google Sheets

Tags:
| | 0 Comments |

Clever little script that extracts comments from YouTube videos and posts notifications to Gmail … this solution is useful if you want to track comments on other peoples YouTube videos

Source: Automating YouTube comment notifications using Google Sheets

Solutions

Structure and simplify your Google Apps Script – Jasper Duizendstra – Medium

Tags:
| | 0 Comments |

Jasper Duizendstra provides some Google Apps Script coding tips…

Organise your JavaScript objects in Google Apps Script with the constructor pattern by Douglas Crockford.

Source: Structure and simplify your Google Apps Script – Jasper Duizendstra – Medium

Solutions

Build a query analysis and visualization tool with G Suite and Zendesk API (Japanese)- Medium

Tags:
| | 0 Comments |

Yuki Tanabe gives an overview of how to use Google Apps Script and Data Studio to create a visualization and analysis tool for services that provide web APIs

Source: G Suite x Zendesk API で問い合わせの分析・可視化ツールを作ってみた – google-cloud-jp – Medium

Solutions, Calendar, Sheets

Record time and activities with Google Sheets, Calendar and Apps Script

Tags:
| | 1 Comment |

Jasper Duizendstra demonstrates how with a little bit of Google Apps Script you can easily use your Google Calendar to keep a record of how much time you spend on tasks and then query/report this via Google Sheets. The post contains instructions and code for getting started

Source: Record time and activities with Google Sheets, Calendar and Apps Script

Comment, Solutions

I summarized my own practices on what Google Apps Script is strong and when to use it

Tags:
| | 0 Comments |

Yuki Tanabe shares some strengths and weaknesses of Google Apps Script as well as criteria for choosing Google Apps Script for your coding project

Source: I summarized my own practices on what Google Apps Script is strong and when to use it

Solutions, Sheets

Create BigQuery tables with Google Sheets and Apps Script

Tags:
| | 0 Comments |

Creating BigQuery tables using the GUI can be a hassle. This article describes an alternative way to create BigQuery tables

Source: Create BigQuery tables with Google Sheets and Apps Script

Comment

Why you shouldn’t use Google Sheets as a database – Eric Koleda – Medium

Tags:
| | 0 Comments |

At this year’s Google Cloud Next I co-presented a session entitled “How to grow a spreadsheet into an application,” where the thesis was that it’s OK to start with a spreadsheet and layer on additional technologies as you gain adoption and your requirements change. However that doesn’t mean that Sheets is always a great choice for storing your application’s data, and in this post I’ll explore some of the signals that you should be looking into other database options. Sheets are for people!

Source: Why you shouldn’t use Google Sheets as a database – Eric Koleda – Medium