How I Replaced Evernote with Google Drive (Part II): App Script Code
In the first part of this article , I explored my decision to free up from Evernote to a custom solution using Google Drive. I set up a simple workflow with Google Sheets to organize tasks, categorize projects, and link other Google Docs and Sheets. Using conditional formatting and custom columns to visually manage priorities, due dates, and tags, worked well but still required manual effort. Here Google Apps Script came handy to automate tasks like creating files, adding links, and setting calendar events, creating a powerful solution only with Google Drive. In this update, I’ll include the overall explanation of the App Script code used to automate tasks for the workflow I used to finally replace Evernote with Google Drive. Parameters To configure the script without altering code directly, there is a 'Parameters' sheet where some configuration will be performed. Column “A” has the name of the parameter to be referenced in the parameters array (see Utilities section). Column