View json strings in a modal dialog. Activate the cell that contains a JSON string Click menu item A foldable JSON will be shown in the modal dialog
Handy little Google Apps Script snippet from Riël Notermans (Zzapps) that makes it easier to view any JSON you are storing in a Google Sheets cell.
Regular Google Apps Script Community contributor Bruce Mcpherson has published a list of all the Google Apps Script libraries he’s developed since 2012. The list includes links to the source repositories and if you spot a library you like the sound of you can search for more information on Bruce’s Desktop Liberation site .
Source: List of shared Apps Script libraries · Issue #31 · brucemcpherson/desktopliberation
A simple Google Apps Script bot that fetches news from an RSS feed and posts them to a Hangouts Chat room. – thmslprt/hangouts-chat-rss-bot
This one comes via @dersteppen and is a nice little code project to show how you can send messages into Google Hangouts Chat using Google Apps Script. If you are looking for a more secure way of posting into Hangouts Chat the official docs include information on Async messages.
🗺️ Develop Locally:
clasp allows you to develop your Apps Script projects locally. That means you can check-in your code into source control, collaborate with other developers, and use your favorite tools to develop Apps Script.
The Apps Script IDE is great, but with larger projects, I know I’ve wanted to be able to use a more powerful IDE.
clasp (Command Line Apps Script Projects) is a CLI that allows you to start, write, test, and deploy Apps Script projects from any text editor you want.
I’m a public school teacher writing Apps Script projects to manage documentation and to make life easier in general. You can read more on my blog, blog.ohheybrian.com or follow me on Twitter, @bennettscience.
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.
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.