-
Learn Data Engineering with Google Sheets
Four years ago, I had no idea what data engineering was. I wasn’t familiar with data stacks, APIs, ETL/ELT, warehouses, or SQL. I was a freelance web developer using HTML/CSS/JavaScript, WordPress, and Webflow. But when a client asked me to automate some reporting processes, I unknowingly took the first steps on my data engineering journey. […]
-
Web Scraping with Tampermonkey
I ran into a scenario today where a client needed data scraped from a website, but the website offers no API, cURL, or fetch capabilities as far as I can tell. The data can be presented in a datatable, but this would require some scripting to run through multiple pages of results, each row being […]
-
Using Excel to List and Count Files
On one of my recent web scraping projects, I got a follow-up request from a client to add some additional data to my results. The scraped data was dumped into individual folders in PDF format, often with multiple documents per folder. The client wanted to know if I could provide them with a count of […]
-
Turning Trello into a Fully Functional Ticket System
If you haven’t heard of Trello by now…have you been living under a rock? Seriously, though – Trello is a powerful and user-friendly board-style app. People use it for all sorts of things, but for me it has always been a handy organization system for my work. Trello boards consist of lists and cards; cards […]
-
Sending Values from an HTML Form to a JavaScript File
I was doing some UX/UI tweaking on a Google Sheet today and did some experimentation with custom menus vs. custom sidebars. Menus are nice when you just need to execute script files. But when you need to pass values into a script, your options are: A) making the user enter data into cells, or B) […]
-
Switching Between Companies with the QuickBooks API
I’ve got a client whose accounting team manages several companies in QuickBooks. We’ve automated some processes for them using the ultra-useful QuickBooks Accounting API and the powerful flexibility of Google Sheets, but up until now I’ve been setting up API connections on a per-company basis, which is kind of a pain to manage and would […]
-
Sheets to Docs Mail Merge
TL;DR: I needed a way to perform a mail merge, passing data from a Google Sheet over to a Doc. Nearly everything works, with the exception of two complicating factors – the template file I’m copying includes a table, and one of the table cells must contain an image. I’m stumped! If you’re anything like […]
-
You Get What You Pay For
I learned an important lesson this week. In my role as a professional web designer, I do my best to respect my clients’ budgets. I know that not everyone has $40,000 laying around for a website. Sometimes – especially when using an open-source system like WordPress – you’ll find there are multiple ways to get […]