AppsScriptPulse

Solutions, Calendar

Fake calling to leave one meeting for the next — Google Apps Script to the rescue

Tags:
| | 0 Comments |

All through the day, I want call reminders for specific events 10 mins before the meeting time, so I can leave my current meeting with out a hitch and go for the next one. So I used 3 tools for this: Google Calendar to fetch meeting times, Google Calendar to fetch meetings. Twilio to make calls. And finally Google Apps Script to put it altogether.

An interesting implementation by Urwa Shabir on managing meeting schedule using Twilio, Google Calendar and Apps Script.

Source: Fake calling to leave one meeting for the next — Google Apps Script to the rescue

Solutions, Sheets

Marketing Data Extraction using SOAP API — Apps Script Automation

Tags:
| | 0 Comments |

Recently I had setup a daily extraction automation from a marketing platform and they had SOAP API. I had worked with xml before, so after some trial and error I was able to fetch marketing data from trafficvance.com platform right inside Google Sheets

Nice post from Urwa Shabir highlighting how to interact with 3rd party APIs using SOAP which relies heavily on XML. The post covers formatting a SOAP request now that SOAPService is deprecated in Apps Script, as well as parsing the XML response.

Source: Marketing Data Extraction using SOAP API — Apps Script Automation

Solutions, Groups, Sheets

Automate Adding Members to Google Group from Google Sheets — Google Apps Script

Tags:
| | 0 Comments |

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

Solutions, Sheets

Analyzing Mailchimp Campaigns using Google Apps Script — PART II

Tags:
| | 0 Comments |

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

Solutions, Sheets

Automating Mailchimp Campaigns using Google Apps Script — PART I

Tags:
| | 0 Comments |

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

Solutions, Drive, Sheets

Google Apps Script —Track videos viewed on Google Drive within your organization

Tags:
| | 0 Comments |

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

Solutions

Google Apps Script — AirTable API – Urwa Shabir – Medium

Tags:
| | 0 Comments |

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