TSFormBot is an Apps Script powered Google Form Hangouts Chat Bot which creates form submission webhook notifications for Hangouts Chat Rooms.
Need a structured ping on your Hangouts chat whenever someone submits a form? Laura Taylor has built a perfect solution with an ever more easier workflow documentation on how to implement it.
The article is an overview of the workflow covered in the author’s presentation along with install instructions for trying it out in your G Suite domain.
Source: G Suite Solutions — Apps Script Powered Workflow Automation
In my previous post, I outlined the power of Google document URLs to perform “Simple, Powerful, Work” and promised to share several tools I’ve developed to aid in building them.
Source: TSDynamicUrls (#1) — Leverage the URL Power of Google Docs, Sheets, Slides, Drawings & Forms 💥
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
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