7 posts tagged with "Automation"

Over the past few days, we've built an automated system to streamline the creation of personalized cover letters using Google Apps Script. This integration automates the process of generating, storing, and accessing cover letters directly from a Google Sheets spreadsheet.

Key Accomplishments​

• Efficient Cover Letter Creation: Users can now generate cover letters with a single click, eliminating manual editing.
• Automated Document Management: Documents are automatically organized in Drive for easy access and tracking.
• User-Friendly Integration: A custom menu in Google Sheets makes it simple to trigger the entire process without needing to handle any code.

Streamlining the Deployment Pipeline​

Today, we took a major step toward automating the deployment of this site, eliminating manual steps and reducing the risk of errors.

Now, every pull request (PR) generates a preview build, and every merge to the main branch automatically triggers a production deployment. This new setup speeds up the process, ensures consistency, and minimizes the chances of mistakes.

Today, we focused on streamlining our automated preview deployment process for PRs, ensuring that each pull request includes a live preview of the Docusaurus site, Storybook components, and test reports.

The Challenge​

The main goal was to automate the deployment of a fully functional preview for every PR, complete with Docusaurus builds, Storybook, and test results. This meant dealing with dynamic URLs, managing build artifacts, and ensuring everything worked in harmony.

Why This Matters​

Automating the preview process means changes to the site are instantly available for review, speeding up development and reducing the chance of bugs. This allows us to deliver updates faster while keeping quality high.

Automating Test Reporting with Vitest and Istanbul​

As part of our commitment to ensuring high-quality code, we've set up an automated testing and reporting workflow using Vitest, Istanbul, and XUnit Viewer. Here’s a quick overview of how we made that happen.

Choosing the Right Tools​

We opted for:

• Vitest: A fast testing framework tailored for projects using Vite and TypeScript.
• Istanbul: A comprehensive code coverage tool, ensuring detailed metrics like branch, function, and statement coverage.
• XUnit Viewer: A simple way to convert XML test results into clean, shareable HTML reports.

Yesterday I posted about setting up Zapier to automate posting to my LinkedIn profile whenever I create a new post here.

I've since looked into alternatives and have moved from Zapier to Make.

This post is just a listing of some of the things I'm planning to add here in the coming days.

One of the first things my outplacement coach told me was that I ought to be posting to LinkedIn regularly. I knew I wanted to have updates specific to this website here on my blog, and I figured I'd just have to cross-post them manually.

It turns out that's not so!