Provide your subscribers an option to opt-out of mailing lists by adding unsubscribe link using Google Apps Script.
A useful post on creating a system to allow users to indicate they wish to opt-out of further mailings (useful for PECR or similar electronic communications regulation compliance). The post has the broad steps and code needed for this solution and you will need to fill in some of the blanks like how to record the unsubscribe_hash in the Google Sheet.
The new Twitter API brings a much better way to get a list of publicly available Tweets in Google Sheets to retrieve Tweets and their details, including the username of the author.
Always nice to see when other web services feature Google Apps Script. This is a great example from Daniele Bernardi (@i_am_daniele), DevRel at Twitter, highlighting how Google Sheets custom functions can be used to interact with the Twitter API. The post has everything you need to know plus a link to a gist with all the code.
Totally Unscripted is back on Thur 11 Feb at 1200 PST / 1500 EST / 2000 UTC and in this episode we we look at no-code solutions for Google Workspace automation. As part of this we are joined by no-code and automation experts Vahid Taslimi and Aravin Srinivasan from zenphi. Zenphi is a no-code business process automation platform, designed from the ground up for Google Workspace. With Vahid and Aravin we will see how zenphi can be used to automate processes such as Mail Merge to more advanced multi-step approval processes. As part of the show we will learn how they have approached the challenge to support users in taking more ownership of their business processes.
Tune in live to contribute to the YouTube live chat (recording immediately available).
Recently I raised a support ticket with a tech company I was subscribed to where we were trying to resolve an integration issue I had with their service. Once we had it all resolved they followed up with a feedback form. That feedback form just happened to be a Google Form.
In this tutorial, I’ll walk you through accessing the prefill tool in Google Forms. Then, if you are keen on doing some coding, we’ll create a little custom feedback form for unique users that we will deliver via email.
Nice tutorial from Scott ‘Yagi’ Donald on using prefilled Google Form links. For beginners the post includes everything you need to know. For more experienced developers Scott includes some nice code for handling Google Sheet data.
Handy snippet from Andras Sztrokay to handle inline images when using Gmail draft messages as part of your script projects. As highlighted by Romain Vialard in the Google Apps Script community:
Google added the ability to easily retrieve the inline images in an existing draft via the getAttachments() method on October 30, 2018 (see Apps Script release notes)
This walkthrough will let you build a tracker for email opens using Gmail, Google Sheet, and Google Apps Script.
Interesting solution that popped up in the Google Apps Script community for logging email opens using Google Apps Script. The post includes a detailed walkthrough for setting this up as well as some caveats about reliability.
“When was the last time this sheet was uploaded?” Probably one of the biggest requests I get is how do I add a timestamp to check when some particular range was changed. Well, [here] is a simple function you can add to your Google Sheets doc to add the formula LASTEDIT()
The question of recording when a cell/range has been edited has landed in my inbox before. I’ve not tested this solution myself but from the scan of the script worth noting that this solution will only work on one cell array per Google Sheet, so some modification might be required if you have more than one range you’d like to monitor.
A tutorial on how you can sync and analyze your Peloton workout stats into Coda with custom dashboards. Sync with a Google Apps Script or serverless function on Google Cloud
Nice post from Al Chen for Peloton users keen to add to their ‘quantified self’ pool of data. This post might be of particular interest for community members interested to see how authentication cookies can be handled with UrlFetchApp.
This post shows how to setup Libraries in Google Apps Scripts to share code and functions. We will use this while using Slack for logging.
Nice post from Matt “Rudy” Benton on using libraries in your Apps Script projects to make it easier to share code/credentials. Matt illustrates this with a Slack app that has also been documented.
