Skip to content
NigelBuilds

The Daily Playbook

One real AI build a day

A practical build a local business owner or their tech-comfortable staffer can run. Exact tools, exact steps, and a 30-day plan. Today's is free and in full below.

Today · 2026-07-26

Rockville Dental Gmail Triage Bot

A three-operatory dental office in Rockville can sort patient, insurance, schedule, vendor, and owner emails each morning, then call (301) 640-5507 for a free AI audit.

The Problem

At 7:42am, the three-operatory dental office in Rockville opens Gmail and finds a new-patient request buried under an insurance question, a crown reschedule, and a supply vendor email. The front desk starts the first cleaning while the new patient waits in the inbox and books with another Rockville dental office.

Why Now

Gmail labels and search operators are not new. The change is AI by Zapier, which can read each Gmail message for the three-operatory dental office in Rockville and return a category, reason, and next action before Zapier writes the row to Google Sheets. That puts new-patient requests, insurance questions, appointment changes, vendor emails, and owner-only issues into separate Gmail labels before the Rockville dental team opens the inbox.

Proof and Signals

Open Gmail Labels and confirm the three-operatory dental office in Rockville has Rockville Dental New Patients, Rockville Dental Insurance Questions, Rockville Dental Appointment Changes, Rockville Dental Vendor Messages, Rockville Dental Owner Review, and Rockville Dental Triaged. Search Gmail for `inbox newer_than:1d -label:triaged` and count how many messages still need sorting before the first patient sits down. Then open Google Sheets and check the Rockville Dental Inbox Triage Log for a row count, category, reason, next action, and Gmail link on each message. For a free AI audit, call (301) 640-5507.

The Gap

Gmail labels help a three-operatory dental office in Rockville see categories, but Gmail does not decide which new-patient request needs the front desk first. A Google Sheet can record the message, but it does not protect the Rockville dental office from owner-only issues sitting beside vendor emails before the first patient arrives. Check yesterday morning's Gmail inbox and count how many appointment changes, insurance questions, and new-patient requests needed a human decision before 8am.

The Build

  1. 1.Open Gmail for the three-operatory dental office in Rockville. Click Settings, then See all settings. Click Labels, then click Create new label. Type Rockville Dental New Patients, then click Create. Repeat the same label step for Rockville Dental Insurance Questions, Rockville Dental Appointment Changes, Rockville Dental Vendor Messages, Rockville Dental Owner Review, and Rockville Dental Triaged. These labels give the Rockville dental team a clean morning inbox before the first patient sits down. 2. Open Google Sheets. Click Blank spreadsheet. Click the file name at the top left and type Rockville Dental Inbox Triage Log. In row 1, type these column names from left to right: sender, subject, category, reason, next action, Gmail link. Freeze the first row by clicking View, Freeze, 1 row. Click Share, add the Google account that Zapier uses, set access to Editor, then click Send. 3. Open Zapier. Click Create, then click Zaps. Name the Zap Rockville Dental Gmail Inbox Triage. In the first trigger box, click Trigger. Search for Gmail, select Gmail, then choose New Email Matching Search as the trigger event. Click Continue. Click Sign in, connect the Gmail account used by the Rockville dental office, then click Continue. 4. In the Gmail Search String field inside Zapier, type: inbox newer_than:1d -label:triaged. This tells Zapier to look only at inbox messages from the last day that the Rockville dental office has not already sorted. Click Test trigger. Open the test email Zapier finds. Confirm that the sender, subject, body preview, and Gmail link fields appear in the test data. 5. Click the plus button under the Gmail trigger. Search for OpenAI. Select OpenAI. Choose the action that sends text to OpenAI, then click Continue. Connect the OpenAI account. In the input field, insert the Gmail sender, subject, and body preview from the Zapier trigger. Label the input clearly so OpenAI sees each part: Sender, Subject, Body Preview. 6. In the OpenAI instruction field, type this fixed prompt: "You sort Gmail messages for a three-operatory dental office in Rockville. Choose exactly one category from this list: new patient request, insurance question, appointment change, vendor message, owner review. Choose exactly one next action from this list: call patient, verify insurance, update schedule, review vendor message, owner decision needed. Return only JSON with category, reason, and next_action. The reason must be one short sentence tied to the dental office email." Click Test step. Confirm the output contains one category, one reason, and one next action. 7. Click the plus button under the OpenAI step. Select Paths by Zapier. Name the first path New Patient Request. Set the rule to continue only if the OpenAI category exactly matches new patient request. Add a Gmail action inside this path. Choose Add Label to Email. Select the connected Gmail account. In the Email field, select the Gmail message ID from the trigger. In the Label field, select Rockville Dental New Patients. Add a second Gmail action in the same path. Choose Mark Email as Unread. Select the same Gmail message ID. 8. Add the second Zapier Path. Name it Insurance Question. Set the rule to continue only if the OpenAI category exactly matches insurance question. Add a Gmail action. Choose Add Label to Email. Select the Gmail message ID from the trigger. In the Label field, select Rockville Dental Insurance Questions. Add another Gmail action. Choose Mark Email as Unread. Select the same Gmail message ID. This keeps insurance cards, benefit questions, and plan details visible for the Rockville dental front desk. 9. Add the third Zapier Path. Name it Appointment Change. Set the rule to continue only if the OpenAI category exactly matches appointment change. Add a Gmail action. Choose Add Label to Email. Select the Gmail message ID from the trigger. In the Label field, select Rockville Dental Appointment Changes. Add another Gmail action. Choose Mark Email as Unread. Select the same Gmail message ID. This catches hygiene reschedules, crown appointment changes, cancellations, and arrival-time questions before the office opens. 10. Add the fourth Zapier Path. Name it Vendor Message. Set the rule to continue only if the OpenAI category exactly matches vendor message. Add a Gmail action. Choose Add Label to Email. Select the Gmail message ID from the trigger. In the Label field, select Rockville Dental Vendor Messages. Add another Gmail action. Choose Mark Email as Unread. Select the same Gmail message ID. This separates supply invoices, lab notes, equipment notices, and service emails from patient work. 11. Add the fifth Zapier Path. Name it Owner Review. Set the rule to continue only if the OpenAI category exactly matches owner review. Add a Gmail action. Choose Add Label to Email. Select the Gmail message ID from the trigger. In the Label field, select Rockville Dental Owner Review. Add another Gmail action. Choose Mark Email as Unread. Select the same Gmail message ID. Use this path for lease notes, payroll questions, bank messages, legal notices, and anything the owner of the Rockville dental office should read directly. 12. In each Zapier Path, add one more Gmail action after the category label step. Choose Add Label to Email. Select the Gmail message ID from the trigger. In the Label field, select Rockville Dental Triaged. This stops the same Gmail message from running through the Zap again tomorrow. After that, keep the Mark Email as Unread action as the final Gmail step so the front desk still sees the sorted message in the morning. 13. In each Zapier Path, add a Google Sheets action after the Gmail label steps. Choose Create Spreadsheet Row. Connect the same Google account that owns the Rockville Dental Inbox Triage Log. Select the Google Drive, select the spreadsheet named Rockville Dental Inbox Triage Log, then select the worksheet. Map sender to the Gmail sender. Map subject to the Gmail subject. Map category to the OpenAI category. Map reason to the OpenAI reason. Map next action to the OpenAI next_action. Map Gmail link to the Gmail message link from the trigger. Click Test step and confirm a new row appears in the Google Sheet. 14. Before turning the Zap on, open Zapier Pricing in a browser tab and check current pricing for the number of tasks this Rockville dental office expects to run each business day. Open OpenAI Pricing in a browser tab and check current pricing for the model used in the Zapier OpenAI action. Do not guess the monthly cost. Write the current Zapier plan, OpenAI model, and expected daily email count in a note inside the Google Sheet above the log table or in a separate tab named Cost Check. 15. Send five test emails to the connected Gmail inbox. Use one subject for each Rockville dental case: crown appointment request, insurance card attached, hygiene reschedule, supply invoice, and owner-only issue. Put a short body in each email that matches the subject. Run the Zap test or turn the Zap on briefly after confirming the pricing check. Open Gmail and verify each test email has the right Rockville Dental label and remains unread. 16. Open the Rockville Dental Inbox Triage Log in Google Sheets. Confirm all five test emails created rows. Check that the crown appointment email went to new patient request or appointment change based on the email body. Check that the insurance card went to insurance question. Check that the hygiene reschedule went to appointment change. Check that the supply invoice went to vendor message. Check that the owner-only issue went to owner review. Fix the OpenAI instruction if any category is wrong, then test again before the Rockville dental office uses the bot on live email.

Tools and Real Cost

  • Gmail, check current pricing. The three-operatory dental office in Rockville uses Gmail Labels and the search string `inbox newer_than:1d -label:triaged` so yesterday's new-patient requests, insurance questions, appointment changes, vendor emails, and owner-only issues are ready before the first patient sits down. - Google Sheets, check current pricing. The Rockville dental office uses `Rockville Dental Inbox Triage Log` with sender, subject, category, reason, next action, and Gmail link so the front desk can check what the Zap did. - Zapier, check current pricing. The Rockville dental office uses Gmail `New Email Matching Search`, Google Sheets `Create Spreadsheet Row`, and Gmail label actions to move each message into the right morning bucket. - OpenAI inside Zapier, check current pricing. The Rockville dental office uses the prompt only to classify the email and write the reason, not to send patient replies.

30-Day Plan

Week 1: Finish the Zapier Gmail trigger for the three-operatory dental office by testing `inbox newer_than:1d -label:triaged` against live Gmail messages, then confirm Zapier finds new-patient requests, insurance questions, appointment changes, vendor emails, and owner-only issues before opening. Week 2: Add the AI by Zapier action that writes one category, one reason, one next action, and the Gmail link into Google Sheets for each Rockville dental office email, then review 20 rows by hand against the original Gmail thread. Week 3: Add the Zapier Gmail action that applies the matching Rockville Dental label plus Rockville Dental Triaged, then open Gmail Labels and verify no patient request sits only in the general inbox.

One Next Step

When the Zap runs, open Gmail before the Rockville dental office opens and check that each new message picked up one of the Rockville Dental labels, then open Google Sheets and confirm the sender, subject, category, reason, next action, and Gmail link landed in the Rockville Dental Inbox Triage Log.

Previous playbooks

Get the daily playbook by email

One real build a day. No fluff. Unsubscribe anytime.

2026-07-25

Rockville dental desk AI from Google Drive

Build a private AI assistant for a three-operatory dental office in Rockville, fed only by your office docs, then book a free AI audit at (301) 640-5507.

The Problem

At the three-operatory dental office in Rockville, the front desk has a patient on hold asking if her crown post-op pain is normal, while another caller needs an insurance note checked before scheduling. The answer sits somewhere in Google Drive, a PDF, or a printed referral script, so the missed moment is the quiet delay before the caller hangs up or the team interrupts the doctor.

Enter your email above to read the full build, tools, and 30-day plan.

2026-07-24

Daily Voicemail Digest for a Rockville Dental Office

A three-operatory dental office in Rockville turns after-hours appointment voicemails into one morning SMS for the office manager, then verifies each callback from the call log before calling (301) 640-5507 for a free AI audit.

The Problem

At 6:18pm, a patient calls the three-operatory Rockville dental office to move tomorrow's appointment and lands in OpenPhone voicemail. The office manager starts the next morning digging through recordings instead of seeing one clean SMS digest with the caller name, callback number, appointment request, and no medical details. Check the OpenPhone voicemail sample before connecting Zapier and OpenAI, so the three-operatory Rockville dental office only captures scheduling facts.

Enter your email above to read the full build, tools, and 30-day plan.

2026-07-23

Auto-draft your Google review replies in your own voice

A same-afternoon build that turns every new review into a ready-to-post reply that sounds like you, so nothing sits ignored.

The Problem

It is Friday and six new Google reviews came in this week. Three are five stars, one is a three-star about a wait time, and two ask a question inside the review. You mean to reply, but by closing time you are wiped, and by Monday they are buried. Unanswered reviews make a business look absent, and the ones with a real complaint keep sitting in public with no response while the next customer reads them.

Enter your email above to read the full build, tools, and 30-day plan.

2026-07-22

Turn last week's customer questions into a self-serve FAQ that answers at 2am

Collect the questions your team answers over and over, and turn them into a page that deflects calls and books the ready buyers.

The Problem

Your phone and inbox get the same ten questions all week. Hours, parking, do you take my insurance, can I get in today. Every one pulls a staffer off what they were doing, and the after-hours versions go unanswered until morning, by which point the person found the answer somewhere else or gave up.

Enter your email above to read the full build, tools, and 30-day plan.