Simple script to track new blog posts and send email notifications when they are published
Blog
A Script to Convert Google Sheets Dates to Salesforce DateTime Format
A short script that converts Google Sheets dates data to ISO format that Salesforce accepts
Reducing Apps Script Execution Time By Writing Everything All At Once
Reduce execution time significantly, by using batch operations
Avoid Errors When Moving Columns in Google Sheets With a Script
Reordering a range of columns using a script can raise an error. Here’s a simple way of avoiding it
Delete Google Sheets Rows Effectively With a Script
Deleting non-consecutive rows in Google Sheets using a script requires reversed loop. Here’s how to write it.
How to Embed an Animated Chart in a WordPress Blog Post
Learn how to add an animated Chart.js chart to a wordpress blog post with the HTML code block.
Set Currency Format Based on Another Cell with a Formula or Script
Learn how to change the number format of a Google Sheets cell based on the value of another cell with a formula or a script
Google Sheets Scripts: Solving The Last Row Problem
Find the last row in a Google Sheet in a column with continuous filled-in cells or a column with blank cells in-between entries.