Urvah ShabbirFake calling to leave one meeting for the next — Google Apps Script to the rescueThis was a super fun project I did for a client. Solving problems like these make my day.May 14, 2020May 14, 2020
Urvah ShabbirMarketing Data Extraction using SOAP API — Apps Script AutomationI have hooked up lots of external APIs in Google Sheets using Apps Script. Mailchimp, Airtable, Twilio, 46elks to name a few. But they all…May 8, 20201May 8, 20201
Urvah ShabbirAutomate Adding Members to Google Group from Google Sheets — Google Apps ScriptSCENERIO: I was using Google Group to provide access to our dashboard in Google Data Studio. The members kept adding and the process…Feb 7, 20209Feb 7, 20209
Urvah ShabbirFREELANCING TIPS THAT WORKED FOR METhis is no particular order or has no particular thought process. Consider it a scribbles on the side of your classroom lecture notes.Jan 4, 2020Jan 4, 2020
Urvah ShabbirGoogle App Maker — Pre-fetch value for a relation dropdown widgetThis took me a week. Plain and simple. If you go to through the “Project Tracker” template in Google App Maker, you will learn multiple…Dec 19, 2019Dec 19, 2019
Urvah ShabbirCreating AirTable Google Data Studio Connector — My abandoned projectSo I abandoned this project because Airtable does not provide an API endpoint to verify if user entered API KEY is correct. I talked to…Dec 16, 2019Dec 16, 2019
Urvah ShabbirGoogle Apps Script —Track videos viewed on Google Drive within your organizationSCENERIO: You are admin of a G-Suite set up. You upload training videos for your organization members on Google Drive/Team Drive. To…Dec 16, 2019Dec 16, 2019
Urvah ShabbirAnalyzing Mailchimp Campaigns using Google Apps Script — PART IIThe Part I of this article explains, in a clumsy manner, how to automate creating and sending Mailchimp Campaigns right from within Google…Dec 15, 2019Dec 15, 2019
Urvah ShabbirAutomating Mailchimp Campaigns using Google Apps ScriptFirs thing, Mailchimp has an amazing, well documented RESTful API. I loved exploring all what it had to offer and using it with Google…Dec 15, 20191Dec 15, 20191
Urvah ShabbirGoogle Apps Script — AirTable APIJust 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…Nov 7, 20191Nov 7, 20191