In this article I’ll show you how to setup reminder emails that will get sent automatically each day if there are any pending tasks in your spreadsheet. Stay tuned until the end, where I’ll show you an easier way to accomplish this using Coda.
Eric Koleda must be the undisputed master of the Apps Script demo. The ‘random cat’ Add-on, is one of my favourite examples where Eric finds a really simple hook to get you engaged in what can often be a complex project. Eric is now Developer Advocate at Coda and he’s not lost is eye. In this post Eric gives the gift of script with a basic example of how you can handle email notifications from Google Form responses in batches with a timed trigger (cats being replaced for cakes). Eric also shows how a no-code alternative can be accomplished in Coda.
As part of our last episode of Totally Unscripted we spoke to former Google Workspace DevRel Eric Koleda about his new role supporting the Coda community.
Coda provides word-processing, spreadsheet, and database functions. It’s a canvas that blends spreadsheets, presentations, apps, and documents together. The software can integrate with third-party services like Slack and Gmail.
Eric gave a fantastic overview of the Coda platform highlighting opportunities for developers to integrate with services like Google Apps Script via the Coda REST API and the new Coda Packs, which are currently in beta.
The clip is an excerpt from the full show where we get to see these features in action and some additional resources referenced are linked below:
For my Next session earlier this year I needed to show the Gmail inbox of my test account, but didn’t want it appear empty. So I throw together a quick #appsscript to create dummy emails, using data generated in @mockaroodev. Now you can too! https://t.co/CgEQU5WnJJpic.twitter.com/Y8tHb6Ynch
After 10 years at Google I had accumulated a lot of labels in Gmail, most of them unused for years. Managing them in the UI was too tedious, so I put together a Sheet + Apps Script to allow me to manage them in bulk. Now you can too! https://t.co/YTLVNFgbKdpic.twitter.com/p0NX8hJpRe
Use this spreadsheet to manage your Gmail labels in bulk! To get started, follow the steps below:
Make a copy of this spreadsheet.
Wait a few moments for the “Bulk Labels” menu to appear.
Click “Bulk Labels > Pull labels”.
When prompted, grant the script authorization to your account.
You can then use the spreadsheet to create, rename, and delete labels. You can also merge labels, which deletes a label but also moves all of it’s messages to another label.
When ready, click “Bulk Labels > Perform actions” to make the updates.