Productivity

Google Script for Automatically Adding Links to Spreadsheet Cells This Google Script allows you to automatically add <a href=""></a> tags to cells in a Google Spreadsheet when another cell in the same row becomes not empty. The script retrieves the search term and URL from a second sheet in the spreadsheet and adds the <a href=""></a> tags around the search term in the specified column of the first sheet. Prerequisites A Google account A Google Spreadsheet with at least two sheets: one for the target cells to be updated, and one for the search terms and URLs....

Introduction Do you have a large directory of markdown blog posts that you want to add cover images to? This script makes it easy to do just that. It inserts the cover image information into the front matter section of the markdown files, and also uses regular expressions to extract the subject and company of the image from the markdown file. Requirements To use this script, you will need to have Python and the os and re modules installed on your computer....

Introduction Do you ever struggle to keep track of all the feature images in your Markdown files? This script is here to help. The Purpose The main purpose of this script is to list all the broken feature images in your Markdown files. It searches for files with the “.md” extension within a specified directory and reads the contents of each file. The script then checks for the existence of feature images and extracts the image URL....