Blog
Practical answers on automating a small business with AI: what to automate first, costs, agents vs. automation, and owning your tools.
- Where AI Fits in Construction Admin (and Where It Doesn't) (Oct 31, 2026)
AI can read messy emails into fields for a construction office, with a person checking. It should not decide contracts, pricing or safety. - What 391 AI TikToks Taught Us: The Design Traits That Hold Up (Oct 31, 2026)
We catalogued 391 AI workflows from TikTok. Counts, how reliable they are, and the design traits worth copying: small jobs, a stop before live, a person. - How to Train a Small Team on AI Without the Hype (Oct 31, 2026)
A plain plan to train a small team on AI: pick real jobs, teach three habits, practice on your own work, write one rule and check back. No hype. - Build an Approval Workflow in Google Workspace (Forms, Sheets, Gmail) (Oct 31, 2026)
Build an approval workflow with Google Forms, Sheets and Gmail: approve and decline links, an audit trail and one reminder. Mock-tested, not run in Google. - Receive a Webhook in Google Sheets with Apps Script (doPost) (Oct 31, 2026)
Receive a webhook in Google Sheets with an Apps Script doPost web app, a shared key and a log tab. Mock-tested, not run in Google. Read the limits first. - Apps Script 'Exceeded Maximum Execution Time': How to Fix It (Oct 31, 2026)
Apps Script says Exceeded maximum execution time? Learn what the limit is, how to batch reads and writes, and how to split a long job across runs. - Google Apps Script Limits Every Builder Should Know (2026) (Oct 31, 2026)
The main Google Apps Script limits checked November 19, 2026: runtime, triggers, email and URL fetch. Includes a batch script that stops before the limit. - Apps Script onEdit Trigger Not Working: 7 Causes and Fixes (Oct 31, 2026)
Apps Script onEdit not firing? Check seven causes: wrong name, unbound script, read-only, script edits, permissions, the 30-second limit, manual runs. - Run an Apps Script on a Schedule and Get Told When It Fails (Oct 31, 2026)
Schedule an Apps Script with a time-driven trigger, log every run, get an email when it fails and when it goes quiet. Mock-tested, not run in Google. - 'Google Hasn't Verified This App' on Your Own Script: What It Means and What to Do (Oct 31, 2026)
What the unverified app warning means for your own Apps Script, when it is fine to continue and when to stop. Based on Google's own documentation. - How to Automate Client Onboarding for a High-Ticket Service Business (Oct 31, 2026)
Automate client onboarding after the contract is signed: a project folder, a draft welcome email and a kickoff block, with a person sending. Tested script. - Weekly Client Status Reports from Your Project Sheet (Professional Services) (Oct 31, 2026)
Draft a weekly client status report from a Google Sheet with a free Apps Script. You review and send. Script mock-tested, not run in Google. - Automation Freelancer, Agency or In-House Hire: How to Choose (Oct 31, 2026)
Choosing between an automation freelancer, an agency or an in-house hire comes down to scope, ownership and who maintains it. A plain way to decide. - How to Scope an Automation Project on One Page (Template) (Oct 31, 2026)
A one-page template to scope an automation project: inputs, trigger, outputs, owner, edge cases and done-when. Fill it in before you hire or build. - Back-in-Stock Waitlist Without a Paid App (Oct 31, 2026)
Build a back-in-stock waitlist in Google Sheets that emails each person once. Free Apps Script, mock-tested in Node, not run in Google. - Track Invitations to Bid and Sub Responses in One Sheet (Oct 31, 2026)
A one-sheet system for general contractors to track who got an invitation to bid, who answered and which trades still need quotes, with formulas. - Bid Leveling Spreadsheet: Compare Subcontractor Bids Line by Line (Oct 31, 2026)
Build a bid leveling spreadsheet that lines up subcontractor bids, flags scope gaps and unusually low lines, and shows who left what out. - Branded Short Links on Your Own Domain Without Bitly (Oct 31, 2026)
Make short links like go.yourdomain.com/call with one redirect file and no Bitly plan. What it needs, what it lacks and how to test it. - Build vs. Buy Automation: How to Decide for One Workflow (Oct 31, 2026)
Decide whether to buy software or build a custom automation for one workflow. Five questions, a decision table and a one-week test. No sales pitch. - Change Order Log That Tracks Approvals (Google Sheets + Gmail) (Oct 31, 2026)
A change order log for Google Sheets with status, dollar impact, approver and days waiting, plus a free script that emails you when approvals stall. - How to Brief Claude So It Writes an Apps Script You Can Trust (and Test It) (Oct 31, 2026)
Brief Claude so it writes an Apps Script you can check: a written brief, pure functions, a test you run in Node, and a review of every Google call. - Project Closeout Tracker: O&M Manuals, Warranties, As-Builts (Oct 31, 2026)
Track closeout documents in Google Sheets: O&M manuals, warranties and as-builts. Tracking aid only. Formulas tested in LibreOffice, not in Google. - Construction Automation Consultant: What to Look For Before You Hire (Oct 31, 2026)
Hiring help to automate construction office work? Learn what the job covers, which questions to ask, and what to get back before you pay. - Construction Bid Follow-Up: Email Templates and a Tracker That Reminds You (Oct 31, 2026)
Bid follow-up email templates for contractors, plus a free Google Sheets tracker that emails you each morning about bids that need a call. - Construction Daily Report with Google Forms (Photos, Weather, Manpower) (Oct 31, 2026)
Build a construction daily report in Google Forms for the phone, log it in a sheet, save a PDF per report and get alerted when a project has none. - Construction Document Control in Google Drive: Folders, Naming and Permissions (Oct 31, 2026)
Set up construction document control in Google Drive: a folder layout, a file naming rule you can check in Sheets, and who gets which permission. - OAC Meeting Minutes That Turn into Tracked Action Items (Oct 31, 2026)
Turn construction meeting minutes into tracked action items in Google Sheets. Tracking aid only. Formulas tested in LibreOffice, not in Google Sheets. - Construction Office Automation in Google Workspace: The Paperwork Map (Oct 31, 2026)
A map of the construction paperwork a small office can track in Google Workspace: RFIs, submittals, change orders, COIs, lien waivers, pay apps and more. - Do Small GCs Need Construction Management Software? A Google Workspace Setup First (Oct 31, 2026)
Before you buy construction management software, see what a Google Workspace setup covers, where it runs out, and when buying is the better call. - What It Costs to Run an AI Agent Every Month vs. a Script (Oct 31, 2026)
How to work out the monthly cost of a multi-step AI agent against a script, with a tested sheet formula and a worked example using example prices. - Creator Outreach Tracker with Follow-Up Drafts in Google Sheets (Oct 31, 2026)
Build an influencer outreach tracking spreadsheet that finds replies in Gmail and drafts the follow-up for quiet creators. Free Apps Script included. - Sort a Customer Service Inbox in Gmail (and the One Spot an LLM Helps) (Oct 31, 2026)
Sort a shared customer service Gmail inbox with keyword rules and labels, then use an LLM only on the leftovers. Free Apps Script, mock-tested. - A Daily Sales Summary Email for Your Store (Oct 31, 2026)
Send yourself a daily sales summary from a Google Sheet with a free Apps Script. Mock-tested in Node, not in Google. Includes test steps. - Create a Google Drive Folder for Every New Project Automatically (Oct 31, 2026)
Create a Google Drive project folder from a template for each new row in a Sheet, with the link written back. Apps Script with a mock-tested script. - Equipment Maintenance Reminders from a Google Sheet (Oct 31, 2026)
Track equipment service dates in Google Sheets and get a daily email of what is due. Tracking aid only. Script mock-tested, formulas tested in LibreOffice. - Fractional Chief of Staff vs. Operations Manager: Which Does a Growing Company Need? (Oct 31, 2026)
A fractional chief of staff and an operations manager solve different problems. Here is how to tell which one your company needs, and when it is neither. - How to Get AI Assistants to Mention and Cite Your Business (Oct 31, 2026)
What Google and OpenAI say about appearing in AI answers, a robots.txt check, and a monthly log to see what assistants say about you. No guarantees. - Find Any Project Email in Seconds: Gmail Labels by Job Number (Oct 31, 2026)
Label project emails by job number in Gmail with a filter, or with an Apps Script that reads the subject line. Script is mock-tested, not run in Google. - Can Google Calendar Replace Calendly? Appointment Schedules Compared (Oct 31, 2026)
Google Calendar appointment schedules can replace Calendly for one-to-one booking. What Google says, where Calendly goes further and how to test. - Google Sheets as a CRM: How Far It Goes and When to Stop (Oct 31, 2026)
Use a Google Sheet as a simple CRM with stages, follow-up flags and totals. Learn the signs that it is time to stop. Formulas tested in LibreOffice. - Send an Email from Google Sheets When a Cell Changes (Oct 31, 2026)
Email someone when a status cell changes in Google Sheets. Use the built-in notification rule, or a short Apps Script with an installable edit trigger. - Turn a Google Sheets Row into a Filled Doc or PDF Automatically (Oct 31, 2026)
Fill a Google Docs template from a Sheets row and save a PDF automatically. For proposals, change orders and packing slips. Mock-tested, not run in Google. - Automatic Timestamp When a Checkbox Is Ticked in Google Sheets (Oct 31, 2026)
Write the time next to a Google Sheets checkbox when someone ticks it, with a short Apps Script onEdit trigger. Mock-tested, not run in Google. - Google Workspace Automation Examples for Operations Teams (Oct 31, 2026)
Six Google Workspace automations an operations team can build with Forms, Sheets, Gmail and Apps Script, plus the limits and checks that keep them safe. - Hiring a Google Apps Script Developer: What to Expect and What to Ask (Oct 31, 2026)
Hiring someone to write Google Apps Script? Know what a good scope looks like, which questions to ask, and what to get back before you pay. - Import a CSV Report from Gmail into Google Sheets Automatically (Oct 31, 2026)
Copy CSV report attachments from Gmail into a Google Sheet with Apps Script. Each email is read once. Mock-tested with fake data, not run in Google. - Is a Lovable Website Good for SEO? What We Learned Fixing Ours (Oct 31, 2026)
Can a Lovable site rank on Google? What Lovable says it does, what we found on our own Lovable site, and a short check you can run on yours. - Catch Late or Stuck Shipments Before Customers Email You (Oct 31, 2026)
Flag late, stuck and unscanned shipments in Google Sheets and get one exceptions email each morning. Formulas and script tested, not run in Google. - Lien Waiver Tracking Spreadsheet: Conditional vs. Unconditional, Per Pay App (Oct 31, 2026)
Track conditional and unconditional lien waivers per pay app in Google Sheets, and get a weekly email of waivers still missing. Tracking only. - Replace Linktree With a Page on Your Own Domain (Oct 31, 2026)
Linktree does not support custom domains. Build a links page at yourdomain.com/links instead: what goes on it, a starter file and how to track clicks. - Lovable Site Shows 404 When You Refresh a Page: The Fix (Netlify, Vercel) (Oct 31, 2026)
Your Lovable site works until you refresh or open a link to an inner page. Add one redirect rule on Netlify or one rewrite on Vercel to fix the 404. - Host a Lovable Site on Cloudflare Pages with Your Own Domain (Oct 31, 2026)
A pre-flight checklist for hosting a Lovable site on Cloudflare Pages with your own domain: what to confirm, what to test, and what I could not verify. - Lovable Contact Form Not Sending Email? Get Notified Without a Paid Tool (Oct 31, 2026)
A website form cannot email you on its own. Here is a small Google Apps Script that sends you one email per submission, with spam and quota guards. - Lovable Custom Domain Not Working? The Fixes for Pending, SSL and www Errors (Oct 31, 2026)
Fix a Lovable custom domain stuck on Pending, Verifying, SSL errors or the wrong site. Check each status, DNS record and www setting in order. - Send Lovable Form Submissions to Google Sheets (No Paid Tool) (Oct 31, 2026)
Send form submissions from a Lovable site to a Google Sheet for free. Paste one short Apps Script, deploy it as a web app, and point your form at it. - Add Google Analytics 4 to a Lovable Site (and Check It's Actually Recording) (Oct 31, 2026)
Add GA4 to a Lovable site, then prove it is recording. Includes a weekly check that catches a tag that has silently stopped, with a tested formula. - Connect a Lovable Site to Google Search Console (and Read the First Report) (Oct 31, 2026)
Connect a Lovable site to Google Search Console, submit the sitemap, and know what to check in week one: indexing, sitemap status, and pages not indexed. - Lovable Link Preview Not Showing? Fix Your og:image and Titles (Oct 31, 2026)
Shared Lovable links show no image or the same preview on every page? Set unique Open Graph tags per page, size the image, and refresh the cache. - Lovable Site Shows the Same Title on Every Page in Google: The Fix (Oct 31, 2026)
If a Lovable site shows one title on every page in Google, the page title is set in one HTML file. Here is how to set one per page, and how to check it. - Add a Sitemap and robots.txt to a Lovable Site (Oct 31, 2026)
Add a sitemap.xml and robots.txt to a Lovable site. A small tested script writes the sitemap, and a plain robots.txt points to it. Google's limits quoted. - Deploy a Lovable Site to Vercel With Your Own Domain (Oct 31, 2026)
Move a Lovable site to Vercel through GitHub and point your own domain at it: the steps, the DNS records and what to check before you switch. - From Lovable Prototype to Real Business Website: A Launch Checklist (Oct 31, 2026)
A launch checklist for taking a Lovable site from prototype to a real business site: domain, forms, titles, sitemap, analytics, search and link previews. - www or No www? Pick One for Your Lovable Site and Redirect the Other (Oct 31, 2026)
Pick www or non-www for your Lovable site, redirect the other with a permanent redirect, and check it with four curl commands. Google quotes included. - Low-Stock Alerts from a Google Sheet (Email or Slack) (Oct 31, 2026)
Get an email or Slack message when an item in your Google Sheet drops to its reorder point. A free script checks daily and alerts once per dip. - A Near-Miss and Incident Report Form That Alerts the Right People (Oct 31, 2026)
Collect near-miss reports with Google Forms and email the right person. Recordkeeping only, not safety advice. Script mock-tested, not run in Google. - A One-Page AI Policy for a Small Business (Template) (Oct 31, 2026)
A one-page AI policy template for a small business, with blanks to fill in and the questions to decide first. Not legal advice. Ask an attorney. - Send an Order Confirmation Email From a Google Sheet or Form (Oct 31, 2026)
Send an order confirmation email from a Google Sheet or Form for wholesale, custom and off-platform orders. Includes a tested Apps Script and its limits. - Pay Application Tracking for Subcontractors, Retainage Included (Oct 31, 2026)
Track subcontractor pay applications and retainage in Google Sheets with tested formulas and a sub summary. Tracking only, not accounting advice. - Operations Automation for Product Brands: What to Automate After Orders Pile Up (Oct 31, 2026)
A plain map of what a product brand can automate once orders pile up: order mail, returns, stock, wholesale, creators and reviews, in a safe order. - Proposal Follow-Up for High-Ticket Service Firms (Architects, Engineers, Specialty Trades) (Oct 31, 2026)
Track proposals in Google Sheets and get a daily email of which are due for a follow-up. Script mock-tested, formulas tested in LibreOffice. - Punch List in Google Sheets with Photo Links and Owner Reminders (Oct 31, 2026)
Build a punch list in Google Sheets with photo links, status and overdue reminders sent by email. Free Apps Script included. Tracking only, not advice. - Purchase Order Tracker That Chases Late Suppliers (Oct 31, 2026)
Build a purchase order tracker in Google Sheets that flags late suppliers, times your follow-ups and drafts the message. Formulas tested, no script. - Questions to Ask Before You Hire Automation Help (Oct 31, 2026)
A checklist of questions to ask an automation consultant or freelancer before you hire, with what a good answer sounds like. Copy it into an email. - Reorder Point Formula in Google Sheets: Lead Time and Safety Stock (Oct 31, 2026)
Calculate a reorder point in Google Sheets from daily usage, lead time and safety stock, with a status column that shows which items to reorder. - Return Request Form and Returns Log in Google Sheets, With Status Emails (Oct 31, 2026)
Build a return request form in Google Forms with a returns log in Sheets that suggests refund, exchange or review, and emails customers at each status. - Ask for a Review After Delivery, Without Forgetting Anyone (Oct 31, 2026)
A Google Sheets tracker that shows which orders are due a review request, holds the ones with an open return, and drafts the message. Formulas tested. - RFI Log in Google Sheets That Chases Its Own Answers (Oct 31, 2026)
Build an RFI log in Google Sheets with due dates, an overdue flag and email reminders from a short Apps Script. Copy the columns, formulas and code. - Save Gmail Attachments to Google Drive Automatically, by Sender or Job (Oct 31, 2026)
Use a free Google Apps Script to save Gmail attachments to Google Drive by job label or sender, with clean file names. Invoices and submittals example. - Send Shopify Orders to Google Sheets Without a Paid App (Oct 31, 2026)
Export Shopify orders to CSV, paste them into Google Sheets and turn line items into one row per order with a free script. Mock-tested, not run in Google. - A Deal Pipeline Inside Gmail Without Streak (Oct 31, 2026)
Track leads and bids in Gmail without Streak: labels for stages, one Google Sheet for the list and a formula that flags deals gone quiet. - Certificate of Insurance Tracking: Expiry Reminders from a Google Sheet (Oct 31, 2026)
Track subcontractor certificates of insurance in Google Sheets and get 30, 14 and 0 day expiry reminders by email. Tracking only. - Subcontractor Onboarding Checklist: Collect W-9s, COIs and Licenses Without Chasing (Oct 31, 2026)
A subcontractor onboarding checklist and tracking sheet for W-9s, certificates of insurance and licenses, with a missing-items column and a reminder flag. - Subcontractor Prequalification Form That Scores Itself in Google Sheets (Oct 31, 2026)
Build a subcontractor prequalification form in Google Forms that scores each answer in Sheets and sorts new subs into a review queue. Formulas included. - Submittal Log That Tells You What's Overdue (Google Sheets) (Oct 31, 2026)
Build a submittal log in Google Sheets with review due dates, needed-by dates and a weekly email of overdue submittals. Tracking only, free to copy. - Time Audit Template: Find the Hours Your Business Loses (Oct 31, 2026)
A free time audit template for Google Sheets: log your tasks for a week, score them and see the hours and the first thing to automate. Formulas included. - Digital Toolbox Talk Sign-In Sheets with Google Forms (Oct 31, 2026)
Keep toolbox talk sign-in records with Google Forms and Sheets. Recordkeeping only, not safety advice. Formulas tested in LibreOffice, not Google. - Drawing Transmittal Log That Sends Itself (Oct 31, 2026)
Track drawing transmittals in Google Sheets and get a daily email of overdue lines. Tracking aid only. Formula tested in LibreOffice, script mock-tested. - Replace Typeform With a Form You Own (Google Sheets Backend) (Oct 31, 2026)
Replace a paid Typeform with a Google Form that saves answers to your own Google Sheet: setup, embedding on your site and what you give up. - Track Creator Content Usage Rights and Expiry Dates (Oct 31, 2026)
A Google Sheets tracker for creator content usage rights: start and end dates, where each asset runs and a status that flags what to renew or take down. - Warranty Tracking After Closeout with Expiry Reminders (Oct 31, 2026)
Track warranties in Google Sheets and get a daily email of ones that expire soon. Tracking aid only. Script mock-tested, formulas tested in LibreOffice. - Weekly Owner Report for Construction, Built From Your Project Sheets (Oct 31, 2026)
Build a weekly owner report from your RFI, change order and schedule note tabs. A tested Apps Script makes a Google Doc and PDF every Friday. - When to Hire Someone to Automate a Workflow (and When Not To) (Oct 31, 2026)
Signs you should do the automation yourself, signs you should hire help, and what to have ready before you talk to anyone. No savings promises. - Where an LLM Actually Belongs in a Workflow: 5 Spots That Earn It (Oct 31, 2026)
Five places in a business workflow where an LLM earns its place, with an example, a check and a failure mode for each. Everything else stays plain rules. - Who Fixes the Automation When It Breaks? Plan Maintenance Before You Build (Oct 31, 2026)
Every automation breaks eventually. Plan the owner, alerts, logs and handover document before you build, so a failure is a short fix and not a mystery. - Wholesale Application Form That Scores and Answers Itself (Google Forms + Sheets) (Oct 31, 2026)
Build a wholesale inquiry form in Google Forms that scores each application, emails you the result and sends the buyer a reply. Free script included. - Remind Wholesale Accounts to Reorder (Oct 31, 2026)
A Google Sheets tracker that predicts when each wholesale account should reorder, flags the ones due or overdue and drafts the reminder. Formulas tested. - Zapier vs. a Custom Script: What Each Costs After a Year (Oct 31, 2026)
Compare Zapier and a custom Google Apps Script by year-one cost. A worksheet with the math shown, and the costs both sides tend to leave out. - Why AI Agents Break in Production (and What to Build Instead) (Oct 20, 2026)
Why AI agents fail in production: inconsistent results, compounding errors, tool mistakes, model retirements, prompt injection, and what to build instead. - Virtual Assistant or Automation? How to Decide What to Hand Off (Sep 9, 2026)
Virtual assistant vs automation: a simple test for which tasks go to a person, which go to a system, and why the best setup usually uses both. - How Much Does Small Business Automation Cost? (Real Numbers for 2026) (Jul 29, 2026)
How much does automation cost a small business? Real 2026 numbers for tools, build, running costs and upkeep, plus a simple payback formula. - Replace Your Paid Tools: A Small Business Guide to Owning Your Stack (Jun 16, 2026)
A plain guide to reduce software subscriptions in a small business: audit what you pay for, replace single-purpose tools, and know what to keep. - What to Automate First in a Small Business (Before You Hire) (May 6, 2026)
Automate work that's frequent, rule-based and already in your tools. The 5 automations we recommend first, what to leave alone, and how to find lost hours. - The Follow-Up Engine: Draft a Gmail Follow-Up When Nobody Replies (Apr 6, 2026)
Use a free Google Apps Script to find Gmail threads with no reply after a few days and draft the follow-up for you to check and send. - The Phoebe Daily Briefing: Build a Morning Summary Email From Your Calendar and Tasks (Apr 6, 2026)
Build a daily summary email from Google Calendar and Google Tasks with Apps Script. Tested with a mock, not in Google. Plus what the Phoebe version adds. - AI Agents vs. Automation: Why We Let AI Write the Code and Keep It Out of the Loop (Mar 10, 2026)
AI agents decide on the fly; automations follow rules you can read. Why we let AI write the code, keep it out of the running system, and when agents are worth it. - The MailerLite + Lovable Trap: Why Their Embed Code Fails and How to Actually Fix It (Feb 9, 2026)
MailerLite's embed code spins, shows a blank form or breaks in Lovable. Use an iFrame component instead, then test it in preview and on your live site. - DNS Crash Course for Founders and Clients (2026 Update) (Jan 27, 2026)
DNS explained for small business owners: what the records do, which ones you touch, and how to change them without breaking your site or email. - AI Primer Series | The New Cybersecurity Threat (2026 Update) (Jan 5, 2026)
How AI changes phishing, voice cloning and fake video, the SHIELD checklist, and what a small business should do this month. Updated October 2026. - Making Your Lovable Website AI-Crawler Friendly (2026 Update) (Sep 15, 2025)
Check what AI crawlers see on your Lovable site with a curl test, then fix an empty page by prerendering. Says what I could not confirm. - Before the First Meeting: The Marketing Infrastructure Every Founder Needs to Raise (Apr 7, 2026)
Nobody told her she needed an investor newsletter. This article is the 20-minute conversation I had with a founder at SXSW about the infrastructure you build before you ever ask for a check. - What Is Google Apps Script (And Why It Belongs in Your Tech Stack) (Apr 20, 2026)
The most underrated tool in your Google Workspace. Why I build client systems on Apps Script + Claude — and how it removes the entire onboarding conversation for the people you work with. - How to Deploy Your Lovable Website to Your Own Domain (Complete Tutorial, 2026) (Jan 28, 2026)
Deploy your Lovable website to your own domain: Lovable's built-in option, the free GitHub and Netlify route, or your own hosting. Updated for 2026. - The One-Pager That Gets Things Done (Oct 13, 2025)
How to use AI, HTML, and CSS to turn your ideas into action. The non-negotiable skill every professional needs in the AI era. - The Definitive Guide to Using AI in Story Production for Journalists (Feb 15, 2026)
How journalists can use AI to strengthen integrity, reduce cognitive load, and produce better stories—without compromising ethics. - LLM Visual Format Reference Guide for Tactical AI Workflows (Jan 10, 2026)
This guide demonstrates how various text and visual formats perform when communicating with LLMs. Refer to the rankings to choose the most effective format for your task.