I added a script to Google Sheets that auto added new email addresses to the Google Group every time the sheet was edited.
The author was using Google Group to provide access to their dashboard in Google Data Studio. The members kept adding and the process became tedious. They were already keeping/adding all emails in a Google Sheet for some mapping. So this is what they did.
Source: Automate Adding Members to Google Group from Google Sheets — Google Apps Script
So when you send out a campaign, Mailchimp tracks how many people opened the emails and which links were clicked within the email. So this information might not be available in a format you might like. So we will utilize the power of Mailchimp API and Google Sheets to put it in a format that we desire.
Source: Analyzing Mailchimp Campaigns using Google Apps Script — PART II
Mailchimp has an amazing, well documented RESTful API. I loved exploring all what it had to offer and using it with Google Sheets and automating the whole campaign process right at the click of the button was surely fun.
Some detailed guidance on composing marketing campaigns in Mailchimp using Google Apps Script.
Source: Automating Mailchimp Campaigns using Google Apps Script — PART I
SCENERIO: You are admin of a G-Suite set up. You upload training videos for your organization members on Google Drive/Team Drive. To increase productivity, you want to ensure all members watch the videos you upload.
SOLUTION: You utilize this amazing GSuite Reports API and use Google Sheets as your dashboard to view all details about your MP4 videos.
Source: Google Apps Script —Track videos viewed on Google Drive within your organization
Just putting it out there for some one who forgets syntax of RESTful API call in Google Apps Script.EVERY.SINGLE.TIME. This one is for AirTable API
I’ve not come across AirTable before but it looks like a nice service for creating database interfaces and in this post Urwa Shabir covers how you can access the AirTable API.
Source: Google Apps Script — AirTable API – Urwa Shabir – Medium