#92 · $300K/mo AI Automation Expert Answers Questions For 2Hrs

youtube ↗AI & Automation

If you're in my shoes, how would you approach automating time sheet tracking for a mining company?

Well, this is an established system, so you have a couple of options. You could develop a brand‑new system because the client is unhappy with the current manual process, which is prone to dishonest reporting and hurts margins. Expect resistance from low‑level workers when you change the workflow, and the transition may initially feel worse than the current setup. People are often the bottleneck, so consider simplifying the process first. For example, replace manual Excel entry with an OCR solution that lets clerks upload scanned timesheets. You could also add barcodes or QR codes to each employee’s sheet; a clerk photographs the code, OCR converts it to data, and the information is uploaded automatically. Payments could be processed on a bi‑weekly basis with a quick audit to catch major issues. If you want a more robust solution, install NFC/RFID tags for each worker. They tap in and out, and you enforce rules such as a required tap‑out time or a maximum shift length. Pair the RFID system with a camera to verify taps and resolve disputes quickly. Disputes will still happen—perhaps once a week—but you can review the footage and the tap data to settle them fast. Enforce an SOP that unpaid overtime is forfeited if the worker fails to tap out. This physical, hardware‑based approach isn’t as simple as a cloud‑only solution, but modern phones can read RFID/NFC, and platforms like UniFi can trigger webhooks when a tag is scanned. Those webhooks can feed into a central employee database and automatically generate timesheets in tools like ClickUp, Toggl, Harvest, or any other system you prefer. This should give you a solid starting point for automating time‑sheet tracking in a mining operation.

time-trackingautomationminingrfid

Related answers

youtube ↗Lead Generation

What should a freelancer on Upwork track in a simple system (e.g., Google Sheets) to monitor inputs and outcomes?

He recommends columns for each lead‑gen activity (Upwork proposals, cold emails, communities) with sent, interviews, calls, closed, plus replies/positive replies, and a revenue column; keep it simple, track daily counts, and calculate ratios (interview‑to‑proposal, close‑to‑call, revenue‑per‑proposal, etc.) to measure performance.

trackingmetricsupworkcrm
youtube ↗Agency Operations

I think you do a lot of tracking and logging like your end learnings in a sheet or another video. I'd be really interested in hearing more about that.

Sure. I use a deliverable tracker. I haven't used this personally, but here's how it works: each hour I note what I accomplished—e.g., created a hiring pipeline, updated a content calendar, added templates, etc. I let AI itemize it into a big sheet. The tracker lists all expenses and tasks, so I can quickly see what I did in the first hour, second hour, and so on. It serves as an accountability metric and I share it with others for transparency.

trackingdeliverableautomation
youtube ↗AI & Automation

How can I set up an automated invoice‑collection system for my agency, and how should I sell it to clients?

The automation works by using a Google Sheet as a simple database of invoices you’ve sent. For each invoice you record the date, then calculate how many days have passed. Based on the age you trigger follow‑up emails: after 7 days send follow‑up A, after 14 days send B, and so on (7, 14, 21, 28, 35, 42 days). The sheet can be built in any system you prefer—Google Sheets, a CRM, Stripe, QuickBooks, etc.—as long as you can pull the invoice date and payment status. A second automation watches for incoming payments (e.g., via Stripe) and marks the invoice as paid, so only unpaid invoices continue to receive follow‑ups. The email templates are simple reminder messages that reference the invoice and ask if the client needs anything to expedite payment. This low‑cost setup automates the entire follow‑up process without manual effort.

invoice automationgoogle sheetsstripe
youtube ↗Offers

I struggle with shiny object syndrome, jumping between automation ideas and can't stick to one. I'm offering consultation calls to identify a business's workflow pain points in real time and provide tailored automation solutions. What do you think of this approach?

Basically, Autobuild guy is not offering a specific solution; instead, he asks what you need help with, offers to do an audit, and then provides a hyper‑fine‑tuned automation solution. In theory it's a great idea, but in practice it's not very good because a detailed workflow business audit isn't as sexy as promising 20 booked appointments in 60 days with a money‑back guarantee. Everybody sells the latter because it's easier: you guess the problem, present the problem and solution with a guarantee, and skip the audit. You don't need to ask what the client needs; just assume they have a common problem and sell a solution for it. Agencies often struggle with lead generation at the top of the funnel, project management, client notifications, and client comps. I solve those with systems, create many campaign variants, test them at scale, and pick the best performer. That's what I do, and I don't recommend the audit approach. I'm still experimenting with audits for larger deals (e.g., leftclick) to see how it works, but generally productizing your service is the way to go, and I'd recommend that. We probably won't be doing the audit approach for long.

consultationauditproductized