Ever wanted your Python scripts to run automatically — every hour, every morning, or after reboot? You don’t need to keep your terminal open or build a full app for that. Windows Task Scheduler can handle it for you — and you can even run your scripts silently in the background. In this post, we’ll cover: Step 1: Yes, You Can Schedule Python Scripts! Windows Task Scheduler is...
I recently came across a forum post where someone asked about creating a scheduling system using Google Sheets. As I thought about it, I realized that while scheduling is important, why stop there? A complete system should also handle time-off requests, payroll calculations, and paystub distribution—all while keeping things simple and automated. That idea led to this restaurant workforce automation system, which uses Google Sheets and Google Apps...
When working with financial data, efficiency matters. Traders, analysts, and data scientists rely on various storage formats—CSV, Parquet, and SQLite—for backtesting trading strategies. But which format offers the best performance? In this post, I benchmark three widely used storage formats while backtesting Apple Inc. (AAPL) stock data. The goal? To determine which format provides the fastest execution time while ensuring accuracy across different trading strategies. The Experiment I...
Introduction Key Points To Call Out
This is just my solution to reminders for open items. This uses a combination of Google Sheets & Google Apps Scripts. I am a big fan of using Google Apps Scripts for email notifications/alerts. This example will send up to 3 emails provided columnD does not say “Complete” Google Sheets Sample Layout Google Apps Script Code Trigger Setup I then schedule this to run every day at a...
The purpose of this is to show how you can use Google Apps Script to send an email of files in a Google Drive Folder. This stemmed from a project and my approach to the solution. The goal of the project was – create 500 PDFs and email those PDFs out using the Google Suite of products. I ended up generating PDFs using python due to efficiency and...
This stemmed from a project and my approach to the solution. The goal of the project was to create 500 PDFs and email those PDFs out using the Google Suite of products. I have alot of experience with Google Apps Scripts and have generated PDFs before. However, it is always slightly challenging due to rate limits. As a result, I decided to use Google Colab to create the...
The purpose of this is to demonstrate the power of VBA with formatting a file, creating a pivot table, and saving files as PDFs. The PDF portion is something I’ll be exploring over a series of posts, but long story short – VBA is more powerful than Google Apps Script for creating PDFs. In addition, it is easier to create a PDF template in Excel vs python. We...
I recently learned that you can create a Google Form by calling a function in Google Sheets. I am going to demonstrate how this is possible using Google Apps Scripts. The code above does the following The above should give a taste for what is possible. This process is also useful if you want to share the Google Sheets file that logs the responses of the Form /...
Introduction This tool enables control of: In addition, you can create drafts of the email to manually review/proof or automatically send the emails. For example, I proof 2 emails and once I am happy with how they look, I automatically send 500 emails to reach out to everyone more efficiently. Tiers & Pricing There are 3 Tiers of versions of the tool. The lowest tier provides the most...
All rights are reserved.
