Level of Difficulty: Beginner. There are multiple ways to download files from Google Drive, some of which require authenticaton and others that require lots of code. Here’s the simplest way to download the files, provided you’ve got the right file url. The above approach also works when writing to memory stream, instead of copying toContinue reading “[Automation] Download Files from Google Drive in C#”
Category Archives: Google
[Business Intelligence] Connecting a Google Sheet to Power BI as a Data Source
Level of Difficulty: Beginner – Senior. The market for data collection, visualisation and analysis tools spans across many different providers on many different platforms and in some cases, the best way to become exposed to the variety of tools is by mixing and matching between them. So why not visualise a Google Sheet on PowerContinue reading “[Business Intelligence] Connecting a Google Sheet to Power BI as a Data Source”
[Automation] Using Google Drive, Google Sheets and Python in Google Colaboratory to Automate Rubric Creation and Synchronisation
Level of Difficulty: Intermediate – Senior. Have you ever run into a situation where you have over 200 students whose work needs to be marked and the admin around it is enough to make anyone go crazy? Well here’s a step towards getting around the labour-intensive admin that goes hand-in-hand with marking student projects, usingContinue reading “[Automation] Using Google Drive, Google Sheets and Python in Google Colaboratory to Automate Rubric Creation and Synchronisation”
[Automation] YouTube Playlist Monitoring Using Python
Level of Difficulty: Beginner – Senior. There are many different workflow and automation suites/platforms available out there (some of which include IFTTT, Power Automate and Tonkean) that allow users to interact with their YouTube connector. Most of these workflows classify the functions within the connectors as either a Trigger or an Action. A trigger wouldContinue reading “[Automation] YouTube Playlist Monitoring Using Python”
[Automation] Monitoring Gmail Inbox Using Python
Level of Difficulty: Beginner – Senior. Many automation solutions make use of the functionality provided by mail services as it serves as an important element that allows for communication between humans and the automation process. There are many benefits provided by using Google Mail (Gmail), one of which is cost – for that reason, thisContinue reading “[Automation] Monitoring Gmail Inbox Using Python”
The JPanda 