Google Script – Email from a Google Sheet
Often times in Accounting or Finance, there is a need to track important transactions that happen throughout the month that are outside of expected results.…
Category: Informational
KNIME Installation
KNIME Download KNIME is a data extract, transform, and load tool that can be used to capture data and reformat data from multiple sources. One…
Accounting and Finance Automation
Automation in Accounting and Finance Fields Accounting and finance tasks like journal entries, account reconciliation, and budget creation are usually strenuous and time-consuming. As your…
Sikuli: Taking Screenshots
Taking Images/Screenshots using Sikuli Sikuli works by using image recognition modules for screen automation. Writing scripts requires screenshots to be taken and placed into the…
Filtering Using Google Script
When handling data inside reports, filtering is an essential feature of google sheets. Filtering is used to look at data from a certain view or…
Opening Applications & Files Using Sikuli
App.open() Since Sikuli is a python interpreter, python modules can be used to open programs and files. Sikuli does come with a command that opens…
Google Script Logging
Google Script logging Google Apps Script is an administration given by Google that permits little bits of JavaScript that can associate with other Google Services…
Python If/Elif/Else Statements
If/Else Decision Making With Python Python is a programming language created by Guido van Rossum in 1991. It is one of the most widely used…
Google Script Triggers
How To Setup Triggers on Google Sheets Ever had a google sheets macro that you wanted to run multiple times, but had to always kick…
Modules in Sikuli
Sikuli Modules While Sikuli by itself is capable of great automation, using modules can make it ten times more resourceful. Modules are python packages can…