AppsScriptPulse
LibrarySheetsSolutions

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

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

SheetsSitesSolutions

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

SheetsSolutions

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

Tags:
| | 0 Comments |

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

Community News

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

Tags:
| | 0 Comments |

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

GmailSheetsSolutions

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

Tags:
| | 0 Comments |

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

App MakerSolutions

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

SheetsSolutions

Google Apps Script: Create a Select All Checkbox to Tick Checkboxes in Any Desired Range in Google Sheets – Yagisanatode

Tags:
| | 0 Comments |

Have you ever created a Google Sheet projects where you could really use a select all checkbox (they call them ‘Tick-boxes’ in Google Sheets)? Sure you can copy a range of … Continue reading

Great post not only showing you how to make a ‘select all’ checkbox but you also get an in depth explanation of how this works. Once you fishish this post you might want to read this other Yagisanatode on How to check if there is a Tick Box (Check Box) in a cell or range

Source: Google Apps Script: Create a Select All Checkbox to Tick Checkboxes in Any Desired Range in Google Sheets – Yagisanatode

Community News

The Google Apps Script Awesome List – Alexander Ivanov

Tags: ,
| | 0 Comments |

The usual list of links to interesting resources for Google Apps Script – contributorpw/google-apps-script-awesome-list

Alexander Ivanov has been curating this amzing list of Google Apps Script related resources for a number of years. The list includes links to a number of useful resources, cool Apps Script code projects, libraries and more.  If you have a suggestion for the ‘awesome list’ you can open an issue ticket.

Source: contributorpw/google-apps-script-awesome-list

Solutions

Google Apps Script for Developers – Amit Agarwal

Tags:
| | 0 Comments |

In this video tutorial, you’ll learn how to develop Google Apps Script projects locally on your computer inside Visual Studio Code. You can write your code in modern JavaScript, neatly organized in modules, and the build environment will use Babel and Webpack to transform your code into a version of JavaScript that is compatible with Apps Script.

Amit Agarwal has a great tutorial and boilerplate code for developers interested in locally Google Apps Script development.

Source: Google Apps Script for Developers