Pebblemix: Training and How It Works

Data-Insite
D A T A - I N S I T E   |   P E B B L E M I X

Pebblemix: Training and How It Works

The Monday.com quote-to-completion system, its automations and the day-to-day operating procedure. Companion guide for the training video.

Board
Pebblemix, ID 2035824747, 727 projects, 46 columns, 12 groups
Audience
Pebblemix office and sales team; new-starter induction
Version
1.0, 27 September 2026
Prepared by
Mark Johnstone, Data-Insite; mark@data-insite.com.au, 0432 048 952

Contents

How to use this document. Sections 1 to 4 explain what the system does and how the board is laid out; read these first. Sections 5 to 9 are the working reference: the lifecycle, the automations, the quote and approval flow, payments and reporting. Section 10 is the day-to-day procedure by role and is the one to print and keep beside the desk. Sections 11 to 13 cover data hygiene, the training video and troubleshooting. Anything marked [CONFIRM] could not be read from the live systems and needs a person to fill it in, and these are all listed together in Appendix C.

============================ 1 ============================

1. Purpose and scope

Pebblemix runs its entire business, from a first website enquiry through to a completed, paid job, on one Monday.com board. The board is not just a task list: it is the quote register, the scheduling tool, the payment tracker and the reporting source. A set of automations sits around it so that repetitive work happens without anybody doing it.

This document exists so that:

In scope: the Pebblemix board (groups, columns, views), the Subitems and Proposals boards, the four live automations, the quote generation and client approval loop, the two automated SMS messages, the scheduled Data-Insite reports, and the operating procedure for each role.

Out of scope: Monday.com account administration and billing, Xero and general bookkeeping, the Pebblemix website itself, and the historical automations that have been switched off (listed in section 6.5 for completeness only).

727Projects on the board 67Quotes awaiting a decision $634,815Value of open quotes inc GST 175Completed works

Board position at 27 September 2026. These figures move daily; they are included to show the scale the system is operating at, not as a reporting statement.

============================ 2 ============================

2. How it works at a glance

Work enters the board from four places, moves left to right through twelve pipeline stages, and triggers an automation at four specific moments. Nothing in the system runs on a nightly batch except the reports; everything else fires on the event itself, or on a short reconciliation cycle.

  LEADS IN                          THE BOARD (2035824747)                        AUTOMATED OUT
  ---------                         ----------------------                        -------------

  Website enquiry  ------+
  (email parse)          |
                         |
  Monday form view ------+---->  [ New Leads ]  -------------------------------->  Google Review link set
  (46718002)             |             |                                           (Make 9873000, instant)
                         |             v
  Facebook / Instagram   |    [ Quote to be Prepared ] ---------------------->  Site-visit reminder SMS
  Lead Ads + Messenger --+             |                                       to the client, 24 h ahead
  (to Meta Contacts)     |             |                                       (Twilio, sync every 13 min)
                         |             v
  Phone / walk-in  ------+    [ Submitted Quotes ] ------------------------->  "Quote submitted" SMS
  (manual entry)               Project Status =                               sent once, immediately
                               Proposal Submitted                             (Twilio, sync every 13 min)
                                       |
                                       |   Generate Quote button -> DocuGen PDF -> Quote Doc column
                                       |   PDF carries an approval link per job
                                       |             |
                                       |             v
                                       |   Client clicks the link in the PDF
                                       |             |
                                       |             v
                                       |   Cloudflare Worker writes back to the board
                                       |   Client Approval = Go Ahead / Dont Proceed
                                       v
                       [ Jobs waiting on Client to be ready ]
                                       |
                                       v
                       [ Accepted Works to be scheduled ]  <-- Works Timeline set here
                                       |
                                       v
                             [ Active Works ]
                                       |
                                       v
                          [ Awaiting Payment ]  <-- payments recorded as subitems
                                       |
                                       v
                          [ Completed Works ]  Won/Lost = Won
                                                        |
                                                        v
                                             Google review link sent to client

  SIDE TRACKS (a job can move here from any stage)
    [ Client Interested but not ready ]   [ People to be follow up ]
    [ Unsuccessful ]  Won/Lost = Lost     [ Cancelled Works ]

  REPORTS OUT (scheduled, from Data-Insite)
    Friday 17:05   Quote Insite pipeline report  -> grant@pebblemix.com.au
    Saturday 08:00 Fortnightly activity report   -> grant@pebblemix.com.au

The one rule that makes all of it work. The automations watch the Project Status column, not the group an item is sitting in. Moving a card between groups is a visual change only. Changing Project Status is what makes things happen. Section 11 covers this in detail because it is where most mistakes occur.

============================ 3 ============================

3. Systems and connections

SystemWhat it does for PebblemixKey identifiers
Monday.com The system of record. Holds every lead, quote, job, payment and file. Provides the public enquiry form and the working views. pebblemix.monday.com
Account 30201591 · Workspace 2052261
Board 2035824747
Make.com Runs the instant automations that write the Google review link onto jobs, and previously handled the website enquiry parsing and Facebook lead capture. EU2 region · Data-Insite team 1529175
Scenarios 9873000, 9872992
Monday connection 13472545
Twilio Sends the two automated client SMS messages (site-visit reminder and quote-submitted notification) through a messaging service. Messaging Service MG0a3cad9633…f583
Reconciliation runs every 13 minutes
DocuGen (Monday app) Turns a board item into the client-facing quote PDF and files it back onto the item. 646 of the 727 items already carry a generated quote. Triggered by the Generate Quote button column, and from the Generate Quote Attachment view
Cloudflare Workers Hosts the approval endpoint that the button inside the quote PDF points at, so a client can approve a job with one click and the board updates itself. monday-approval-webhook.pebblemix.workers.dev
Facebook / Instagram Lead Ads form submissions and Messenger messages are captured to the Meta Contacts board for qualification before they become jobs. Make scenarios 8456235 and 8486406
Meta Contacts board 5025987098
Data-Insite reporting Generates and emails the weekly pipeline report and the fortnightly activity report from live board data. Scheduled Friday 17:05 and Saturday 08:00 AEST

3.1 Who has access

PersonMonday loginLevelTypical use
Grant Ilesgrant@pebblemix.com.auAdminOwns the board and the pipeline; 473 of 727 jobs are his
Steve Dawsonsteve@pebblemix.com.auMemberSales and quoting; 195 jobs
Shane Finnshanefinn19@gmail.comMemberSales and quoting; 58 jobs
Rachel Windsoraccounts@pebblemix.com.auMemberPayments, deposits, final invoices
Nicole Ilesnicole@pebblemix.com.auMemberOffice administration and scheduling
Mark Johnstonemark@data-insite.com.auMemberData-Insite support, automations and reporting

Connection ownership: read this before removing a user. The Make.com scenarios and the Cloudflare Worker authenticate to Monday.com using API tokens issued against a specific Monday user account. If that user is deactivated, or their API token is regenerated in Admin → Connections → API, every automation stops with an authentication error and will stay stopped until the connection is re-authorised. Tell Data-Insite before changing user access or rotating tokens.

Security item raised for action. The SMS reconciliation script currently holds a Monday.com API token in plain text inside the script file rather than reading it from the secure credential store, as the other integrations do. This is a credential-handling weakness rather than a fault (the automation works), but Data-Insite recommends moving that token into the vault and regenerating it. Noted here so it is visible and tracked.

============================ 4 ============================

4. The Pebblemix board

Board ID 2035824747, named Pebblemix, in the Main workspace. Items are called "projects". 727 projects, 12 groups, 46 columns.

4.1 Groups: the pipeline

Groups are the visible pipeline. They are worked top to bottom, and the colour in Monday matches the colour of the matching Project Status label.

#GroupGroup IDWhat is in itCount
1New LeadstopicsEnquiries that have arrived but have not been qualified or booked for a site visit.1
2Quote to be Preparedgroup_titleSite visit is booked. This is the trigger stage for the reminder SMS.5
3Submitted Quotesgroup_mkse8bkjQuote has gone to the client and is awaiting a decision. The live pipeline.67
4Jobs waiting on Client to be readygroup_mkseht0fQuote accepted, but the client has preparation to do first (concreting, tile removal, pressure washing).6
5Accepted Works to be scheduledgroup_mkse1bf5Ready to book into the calendar. Works Timeline is set here.10
6Active Worksgroup_mkseqms0On site now or scheduled within the works timeline.11
7Awaiting Paymentgroup_mkse3dwzWork finished, final payment outstanding.3
8Completed Worksgroup_mkseyr53Done and paid. Won/Lost is set to Won. The review request goes out from here.175
9People to be follow upgroup_mm4by2vgNeeds a call or chase. Use the Follow Up Date column so nothing is lost.20
10Client Interested but not readygroup_mkzs23z1Warm but deferred: budget, season, renovation timing. The reactivation pool.68
11Unsuccessfulgroup_mkse93a7Lost. Won/Lost is set to Lost.344
12Cancelled Worksgroup_mkwxkrnmAccepted then cancelled. Kept separate from Unsuccessful so the win rate is not distorted.17

4.2 Columns: the full reference

The board has 46 columns. They are grouped below by what they are for. Set by tells you whether a person types it or an automation writes it; anything marked automation should not be edited by hand.

Identification and ownership

ColumnColumn IDTypeSet byNotes
NamenameItem namePerson / formThe client's name. Used as the item title everywhere.
Quote Numbertext_mkw0b31qTextPersonFormat YYYY-NNNN, e.g. 2026-3775. The reference quoted to the client and printed on the quote PDF. Populated on 725 of 727 items.
Contact Nametext_mksfnr3xTextPerson / formWho to speak to when it is not the account name.
First Nameformula_mm66j73sFormulaCalculatedLEFT({name}, SEARCH(" ", {name}) - 1). Used to personalise the SMS messages. If the Name has no space, this returns an error; see section 13.
Sale Repcolor_mktmxvp3StatusPersonGrant, Steve or Shane. Drives every per-rep figure in the reports, so it must never be left blank.
Item IDpulse_id_mm0nx5pbItem IDAutomaticMonday's internal ID. Exists so DocuGen can print it into the approval link. Do not delete this column.

Contact and site

ColumnColumn IDTypeSet byNotes
Phonephone_mkseshxePhonePerson / formAustralian mobile. The automated SMS goes to this number, and a typo texts a stranger. Blank on 5 items.
Emailemail_mksekmv6EmailPerson / formQuote PDFs are emailed here and the address is quoted back to the client in the SMS. Blank on 7 items.
Site Addresslocation_mksea534LocationPerson / formFull address including suburb, state and postcode. The reports derive the state from this field, and it is read out in both SMS messages, so keep it tidy and complete.
Datedate4DatePersonThe site-visit date and time. The reminder SMS is scheduled 24 hours before this.
Follow Up Datedate_mksep8qnDatePersonWhen to next make contact. Set on 88 items.
Sourcecolor_mksfh4pqStatusPerson / automation14 labels. Currently Web Search 261, Facebook 127, RRS referral 86, Website Enquiries 86, Previous Customer 63. Complete on all 727 items, the best-kept field on the board.

Scope of works and specification

ColumnColumn IDTypeSet byNotes
Standard or Premiumcolor_mksn74qzStatusPersonProduct tier. Reported as the product mix.
PebbleMixcolor_mksfd60yStatusPersonThe stone colour or blend: Greystone, Arctic Grey, Black Gold, Sandstone and roughly thirty more, including bespoke mixes written as free labels.
Finishcolor_mkv6xew5StatusPersonResin system and depth, e.g. 12-15 mm in 2K Polyurethane Resin.
Areas to be Donedropdown_mkvyzh68DropdownPersonMulti-select: driveway, steps, pool surround, alfresco and so on.
Preparationdropdown_mktkvbmzDropdownPersonMulti-select preparation items. Several labels place the obligation on the client, and these are the jobs that sit in Jobs waiting on Client to be ready.
Finishingdropdown_mktmkrvjDropdownPersonMulti-select trims, edging, drains and ramps with quantities.
Trim Colourcolor_mkvze3cpStatusPersonBlack aluminium, aluminium, white, bronze, TBA.
m2numeric_mksfdwskNumbersPersonArea in square metres. Column footer is set to sum.
Vertical LM Pebblemixnumeric_mksny94wNumbersPersonVertical linear metres.
20mm Trim/Treads 3mnumeric_mktkyszmNumbersPersonTrim and tread count.
Edge Trim LMnumeric_mkw0jxecNumbersPersonEdge trim in linear metres.
Number of batches and bagsshort_textjq6g5hazTextPersonMaterials call-off for the crew, e.g. 5x5.
Notes About Joblong_text_mkvj9s9dLong textPersonFree notes from the site visit. Reads through to the crew.

Money

ColumnColumn IDTypeSet byNotes
Value of Works inc gstnumeric_mksep76zNumbers ($)PersonThe quoted total including GST. This is the money field: every value figure in every report comes from it. Blank on 55 items.
Depositnumeric_mkvqqmtpNumbers ($)PersonDeposit taken.
Labournumeric_mkvqe5msNumbers ($)PersonLabour component.
Final Paymentformula_mm2n48phFormulaCalculatedValue of Works − Deposit − Labour, formatted as currency. Read-only.
Paymentslookup_mkse94xwMirrorCalculatedRolls up the Payment amounts recorded on the subitems.
Payment Typecolor_mksf2nq4StatusPersonBank transfer, cash, credit card, labour cash / mats EFT, not specified.
Seniors Discountcolor_mktkem6aStatusPersonDiscount applied: senior, trade, cash, 10% promotion, or no discount.

Status, workflow and automation

ColumnColumn IDTypeSet byNotes
Project StatusstatusStatusPersonThe control column. 14 labels. Quote to be prepared and Proposal Submitted each fire an automation. Populated on all 727 items.
Won/Lostcolor_mkvynn1cStatusPersonWon or Lost. Drives the conversion and win-rate reporting. Blank on 159 items, which is correct for the 67 still open but not for the rest; see section 11.
Client Approvalcolor_mm0nka77StatusAutomationGo Ahead or Dont Proceed, written by the Cloudflare Worker when the client clicks the link in the quote PDF. Set on 11 items so far. Do not type into it. If you do, you lose the evidence that the client themselves approved.
ResponseLinklink_mm0ngtx3LinkAutomationThe per-job approval URL, displayed as "Click on link to approve". DocuGen prints this into the quote PDF. Never edit.
Google Reviewlink_mm7kmtxvLinkAutomationThe standing Pebblemix Google review URL, written onto every item automatically. Present on all 727 items.
Buttonbutton_mktedfgqButtonPerson clicksLabelled Generate Quote, yellow. Runs DocuGen for that item.
Days Since Proposal Sentnumeric_mkx67y7eNumbers[CONFIRM]Populated on 308 items. Whether this is maintained by a native Monday automation or typed needs confirming; see Appendix C.
Works Timelinetimerange_mktm2nk9TimelinePersonScheduled start and finish on site. Set on 125 items. Drives any calendar or Gantt view of the crew's work.
Completed Datedate_mm57cabyDatePersonCurrently empty on all 727 items. Either adopt it or remove it; see section 11.
Submission linkwf_edit_link_albkuLinkAutomaticMonday's own link back to the form submission. Hidden from the form builder.
Subitemssubtasks_mksevd83SubitemsPersonPayment records; see section 8.
Subitems Statuslookup_mkse4hwfMirrorCalculatedRolls up the Status of the subitems.
Filesfile_mksee6tbFilesPersonSite photos, plans, client correspondence.
Quote Docfile_mkse5hq1FilesDocuGenThe generated quote PDF, named Pebblemix - YYYY-NNNN - <site address>.pdf. Present on 646 items.

4.3 Views

ViewIDWhat it is for
Form46718002The public enquiry form. Submissions land straight into the board as new items. First question is "Project Name".
Quote to check48673177The quoting queue: jobs whose quote needs checking before it goes to the client.
Generate Quote Attachment48673414The DocuGen working view: select the jobs that need a quote PDF and generate from here.
Custom Item ID & subitem ID - administration48279621Administration view exposing the Monday IDs. Used when troubleshooting an automation.
Build Vibe view51933581Monday Vibe app view.

Suggested addition. There is no filtered view for the 67 open quotes or for jobs whose follow-up date has passed, which is the work the team chases most often. Two saved views, Open Quotes (Project Status = Proposal Submitted) and Follow-ups Due (Follow Up Date is in the past), would remove a daily filtering step. Data-Insite can add these on request.

============================ 5 ============================

5. The job lifecycle, stage by stage

For each stage: what has to be true to enter it, what the team does, what happens automatically, and what has to be true before it moves on.

StageThe team doesThe system doesBefore it moves on
1. New Leads Qualify the enquiry. Call the client, confirm the address, set Source and Sale Rep, book the site visit into the Date column. Item is created by the form, the website email parser or manual entry. The Google review link is written immediately. Name, Phone, Email, Site Address, Sale Rep, Source and a site-visit Date are all filled in.
2. Quote to be Prepared Set Project Status to Quote to be prepared. Attend the site visit. Record the scope: areas, m², preparation, finishing, colour, finish, trim. A site-visit reminder SMS is scheduled to the client for 24 hours before the Date. If the date, time, phone, name or address changes, the SMS is automatically rescheduled or cancelled. Scope and measurements complete; Value of Works inc gst entered; Quote Number allocated.
3. Quote checked Work the Quote to check view. Verify the figures, then generate the PDF from the Generate Quote Attachment view or the Generate Quote button. Email the PDF to the client. DocuGen builds the PDF, files it into Quote Doc, and prints the client's one-click approval link into it. Quote Doc attached and the PDF emailed.
4. Submitted Quotes Set Project Status to Proposal Submitted. Move the card to Submitted Quotes. Follow up on the agreed rhythm. A "quote submitted" SMS is sent to the client once, immediately, naming the site address and the email the quote went to. If the client clicks the approval link, Client Approval is set to Go Ahead or Dont Proceed. A decision: accepted, deferred or lost.
5a. Jobs waiting on Client to be ready Accepted, but the client owes preparation. Set Won/Lost to Won, take the deposit, agree what the client will do and set a Follow Up Date. Nothing automatic Client confirms the area is ready.
5b. Accepted Works to be scheduled Set Won/Lost to Won. Record Deposit and Payment Type. Set the Works Timeline. Book the crew and confirm materials in Number of batches and bags. Final Payment recalculates itself from Value of Works, Deposit and Labour. Timeline agreed with the client and the crew.
6. Active Works Crew on site. Add progress photos to Files. Log any variation in Notes About Job and adjust Value of Works if the scope changes. Nothing automatic Work physically complete.
7. Awaiting Payment Invoice the balance. Record each receipt as a subitem with its date, amount and comment. The Payments mirror adds the subitem amounts up onto the job. Payments received equal Value of Works inc gst.
8. Completed Works Confirm Won/Lost = Won. Send the client the Google review link from the item. Close the job. The review link is already on the item, ready to copy. Nothing: this is the end state.
Side: Client Interested but not ready Record why and when to come back, in Notes About Job and Follow Up Date. Leave Won/Lost blank until it is actually decided. Nothing automatic Revive to Submitted Quotes, or mark Lost.
Side: People to be follow up Always set a Follow Up Date. This group is a queue, not a graveyard. Nothing automatic Back into the pipeline, or Unsuccessful.
Side: Unsuccessful Set Won/Lost = Lost and note the reason. The reason is what makes the lost-quote analysis worth reading. Nothing automatic Closed.
Side: Cancelled Works Accepted then cancelled. Note who cancelled and why. Keep it out of Unsuccessful. Nothing automatic Closed.
============================ 6 ============================

6. Automations and integrations reference

Four automations are live. Each is described below with its trigger, what it writes, and how to tell whether it ran.

6.1 Google review link on new items

Platform and IDMake.com scenario 9873000, "Pebblemix - New Item -> Set Google Review link". Instant, active.
TriggerMonday webhook 4397872: any new item created on board 2035824747.
What it writesThe Google Review column (link_mm7kmtxv) is set to https://g.page/r/CYCcJ7YPtMc3EBM/review.
WhyMonday's native automations cannot write a fixed value into a link column, so the review link has to come from outside.
How to checkCreate a test item; the link should appear within seconds. All 727 items currently have it.

6.2 Google review link on "Quote to be prepared"

Platform and IDMake.com scenario 9872992, "Pebblemix - Quote to be prepared -> Set Google Review link". Instant, active.
TriggerMonday webhook 4397868: a column value changes, filtered to Project Status = Quote to be prepared.
What it writesThe same review URL into the same column.
WhyA safety net for items that predate 6.1 or were created by an import rather than the item-created webhook.

6.3 Site-visit reminder SMS

PlatformTwilio, driven by a Data-Insite reconciliation job that runs every 13 minutes.
TriggerProject Status contains Quote to be prepared and the Date column holds a future date and time.
What it sendsScheduled for 24 hours before the Date: "Hi {First Name}, this is a reminder that our Pebblemix consultant will be attending {Site Address} on {Date} to inspect the area and prepare a quote for you. If you need to change the time or day, please contact Pebblemix on (03) 9888 9888 or email sales@pebblemix.com.au. Thank you,"
It reconcilesNew items are scheduled. If the status moves away or the item is deleted, the pending SMS is cancelled. If the date, time, phone, address or first name changes, it is cancelled and rescheduled. A date already in the past is cancelled. Less than 16 minutes of lead time and it sends immediately, because Twilio requires at least 15 minutes to schedule.
It will refuse to sendNo valid phone; a name containing "test", "dummy", "sample" or "xxx"; a site address shorter than 10 characters.
How to checkThe run log records every decision by client name. Ask Data-Insite for the log if a client says they did not get a reminder.

This is the highest-risk automation on the board, because it texts real clients. Before setting a job to Quote to be prepared, check the phone number and the site-visit date. If a job is entered with the wrong date, the client is texted about a visit that is not happening; if the phone number is wrong, a stranger is texted. The reconciliation cycle means a correction made within the 13-minute window is picked up automatically, so fix the data rather than asking anyone to unsend.

6.4 Quote-submitted SMS

PlatformTwilio, same 13-minute reconciliation job.
TriggerProject Status contains Proposal Submitted.
What it sendsSent once, immediately, signed by Grant Iles as Managing Director: "PEBBLEMIX. Hi {First Name}, this SMS is to let you know that we have submitted a quote for works at {Site Address}. A copy of the quote has also been emailed to {Email}. If you would like to proceed, please contact Pebblemix on (03) 9888 9888 or email sales@pebblemix.com.au. Please note: this SMS number is not monitored."
Sent once onlyThe job remembers that it has sent. Moving a job out of and back into Proposal Submitted does not re-send. Items that already existed when the feature was switched on were marked as handled so nobody was texted about an old quote.
It will refuse to sendNo valid phone; no valid email (because the message quotes the email address back to the client); a suspicious test-looking name; a site address shorter than 10 characters.

Consequence worth knowing. Because a valid Email is required, a job quoted to a client with no email address on the board will never get the quote-submitted SMS. If a client is phone-only, either record an email or follow up by phone knowing the SMS did not go.

6.5 Client approval from inside the quote PDF

PlatformCloudflare Worker monday-approval-webhook.pebblemix.workers.dev.
How it is wiredThe worker writes a per-job URL into ResponseLink, shown as "Click on link to approve". The DocuGen template prints that link into the quote PDF as a green button.
What happens on a clickThe worker sets Client Approval (color_mm0nka77) to Go Ahead or Dont Proceed on that job, and shows the client a branded confirmation page.
Current use11 items carry a client approval. This is a low adoption rate against 646 generated quotes and is worth a look; see Appendix C.

6.6 Lead capture

RouteStatusWhat it does
Monday form (view 46718002)LiveCreates the item directly on the Pebblemix board. No middleware, nothing to break.
Facebook / Instagram Lead Ads
Make 8456235
LiveCreates an item on the Meta Contacts board (5025987098) with name, email, phone, the service requested, the platform and the Meta lead ID. Qualify there, then create the job on the Pebblemix board.
Facebook Messenger
Make 8486406
LiveWrites the message text to Meta Contacts so nothing said in Messenger is lost.
Website enquiry email
Make 8440827
Switched offParsed the website enquiry email with regular expressions and created the item in New Leads with Source = Website Enquiries. 86 items on the board came from it. It is off, so [CONFIRM] whether website enquiries now arrive by another route or are entered by hand.
============================ 7 ============================

7. Quoting and client approval

The quote PDF is the main thing Pebblemix sends a client, and it is generated from the board rather than written by hand. That is why the board fields have to be right before the button is pressed: whatever is in the columns is what the client reads.

Generating a quote

  1. Open the Quote to check view and confirm the scope, the measurements and Value of Works inc gst.
  2. Check that Quote Number, Site Address, Contact Name and Email are all present and correctly spelled, because they print onto the document.
  3. Generate the PDF from the Generate Quote Attachment view, or press Generate Quote on the item.
  4. The PDF is filed into Quote Doc as Pebblemix - YYYY-NNNN - <site address>.pdf.
  5. Open it and read it before it goes out. The PDF is the last chance to catch a data error.
  6. Email it to the client, then set Project Status to Proposal Submitted, which is what triggers the quote-submitted SMS.

Order matters. Generate and check the PDF before setting the status to Proposal Submitted. Setting the status first texts the client to say a quote has been emailed to them when it has not been sent yet.

The approval loop

The quote PDF carries a green button. When the client clicks it, Client Approval on the job is set without anybody at Pebblemix touching it, and the client sees a confirmation page. That is a dated, client-initiated record of approval. It is worth pointing the button out to the client in the covering email, because the low number of recorded approvals (11) against the number of quotes issued suggests clients are not noticing it.

============================ 8 ============================

8. Payments and subitems

Payments are recorded as subitems on the job, on the Subitems of Pebblemix board (2035903423, 2,504 records). One subitem per payment received.

Subitem columnIDTypeUse
NamenameItem nameWhat the payment is: "Deposit", "Final payment", "Progress payment 2".
OwnerpersonPeopleWho recorded or is chasing it.
StatusstatusStatusNot Started, In Progress, Completed. Rolls up to Subitems Status on the job.
Datedate0DateDate received or due.
Commenttext_mkseacz9TextReference, receipt number or note.
Paymentnumeric_mksehwevNumbers ($)The amount. Rolls up to Payments on the job.

The job is fully paid when the Payments roll-up equals Value of Works inc gst. Final Payment is a separate calculation (Value of Works minus Deposit minus Labour) used to work out what to invoice, not what has been received. Keep the two apart when reconciling.

8.1 The Proposals board

A separate line-item quoting board (2039188342, 5 proposals, with its own Products subitem board) that produces a proposal with gross amount, discount, tax and grand total, a customer link, an expiry date and its own DocuGen document. It is a parallel, more detailed quoting tool used for a small number of proposals rather than the main pipeline. [CONFIRM] whether it is still in use or should be archived, because running two quoting mechanisms is a reporting risk.

============================ 9 ============================

9. Reporting

Reports are generated by Data-Insite from live board data and emailed automatically. Nothing needs to be exported by hand.

ReportWhenGoes toWhat it covers
Quote Insite pipeline reportEvery Friday, 17:05 AESTgrant@pebblemix.com.au, cc mark@data-insite.com.auQuotes in the last 28 days grouped by sales rep: new quotes, total and average value, won / pending / lost, win rate on decided quotes, lead source, state, product mix, and recommendations for quotes sitting in Proposal Submitted. HTML and PDF.
Fortnightly activity reportEvery Saturday, 08:00 AESTgrant@pebblemix.com.au, mark@data-insite.com.auThe last 14 days only: period activity, rep performance, lead sources, new proposals, jobs won and lost, and recommendations. PDF.
Executive summaryOn requestOn requestWhole-of-pipeline analysis: stage-by-stage position, lead source return, financial breakdown, product and colour mix, stale proposals, reactivation candidates, risk assessment and prioritised recommendations with costs.

What the reports depend on. Every figure traces back to five fields: Sale Rep, Value of Works inc gst, Project Status, Won/Lost and Source. If one of those is blank or wrong on an item, the item either disappears from the analysis or lands in the wrong bucket. This is the single best reason to keep the board tidy. Section 11 lists what is currently out.

============================ 10 ============================

10. Day-to-day operating procedure

10.1 Every morning: whoever opens the office

  1. New Leads: is anything sitting there from overnight? Qualify it, set Sale Rep and Source, book the site visit.
  2. Quote to be Prepared: check today's and tomorrow's site-visit dates and phone numbers. Tomorrow's reminder SMS goes out today, so this is the last chance to correct it.
  3. People to be follow up and Client Interested but not ready: anything with a Follow Up Date of today or earlier gets a call.
  4. Awaiting Payment: anything received yesterday gets recorded as a subitem.
  5. Meta Contacts: any new Facebook or Instagram leads get qualified and, if genuine, created as a job on the Pebblemix board.

10.2 Sales rep: for each job

10.3 Accounts: Rachel

10.4 Weekly: Grant

10.5 Monthly: Grant with Data-Insite

============================ 11 ============================

11. Data hygiene rules and current exceptions

11.1 The rules

RuleWhy it matters
Project Status and the group must agree.The automations read Project Status; people read the group. When they disagree, the board tells two different stories and a client can be texted about a stage the job is not at.
Sale Rep is never blank.An unassigned job vanishes from every per-rep figure in the reports.
Value of Works inc gst is entered as soon as the quote is priced.It is the only money field the reports read. Blank means the job counts as nil value.
Won/Lost is set the day the decision is known.Win rate, conversion and lost-quote analysis all depend on it.
Phone and Site Address are checked before status goes to "Quote to be prepared".Both are read out in an SMS to a real client.
Never type into Client Approval, ResponseLink or Google Review.These are written by automations. Editing Client Approval by hand destroys the evidence that the client approved. Editing ResponseLink breaks the approval button in quotes already issued.
Every client name has a first name and a surname.The First Name formula splits on the first space. A single word produces an error and personalises the SMS badly.
Do not rename status labels.The automations match on the exact label text: Quote to be prepared and Proposal Submitted. Rename a label and the automation silently stops firing.

11.2 Exceptions found on 27 September 2026

These were read from the live board while preparing this document. They are the practical starting list for a clean-up, and the same checks are worth repeating monthly.

FindingCountAction
Group and Project Status disagree8Named below. Decide which is right and align the other.
Won/Lost blank outside the open pipeline9265 in Client Interested but not ready, 19 in People to be follow up, 5 in Quote to be Prepared, 2 in Jobs waiting on Client, 1 in New Leads. Blank is legitimate while a job is genuinely undecided, but 65 undecided in the interested pool is really a backlog of decisions. (The 67 in Submitted Quotes are correctly blank.)
Value of Works inc gst blank55Fill in where a price was given; where no quote was ever issued, the job belongs in Unsuccessful or New Leads.
Completed Date never used727Empty on every item. Either start filling it when a job completes, which would let the reports measure job duration and seasonality, or delete the column so it stops looking like missing data.
No quote document attached81646 of 727 items have a Quote Doc. Check the ones that do not and that should.
Phone blank5No phone means no SMS. Fill in or accept that the job is email-only.
Email blank7No email means the quote-submitted SMS will never send for that job.
Site Address blank5Blocks both SMS messages and drops the job out of the state analysis in the reports.
Sale Rep blank1Assign it.
Quote Number blank2Allocate the next number in the 2026-NNNN sequence.

The eight group / status mismatches

ItemGroup saysProject Status says
Moustafa MohamadJobs waiting on Client to be readyNew Leads
Peter CoxonCompleted WorksWaiting Payment
Loren McCleanPeople to be follow upJobs waiting on client to be ready
Sajeewa MapaPeople to be follow upJobs waiting on client to be ready
Brian ValentinePeople to be follow upJobs waiting on client to be ready
Dianne MawbyClient Interested but not readyJobs waiting on client to be ready
Grant KellyClient Interested but not readyJobs waiting on client to be ready
Peter DickensClient Interested but not readyNew Leads

Worth automating. Monday can move an item into the matching group when Project Status changes, using a native automation, one recipe per stage. That would remove this class of error permanently and is a short piece of configuration work. Ask Data-Insite to set it up.

============================ 12 ============================

12. Training plan and video storyboard

12.1 Induction plan for a new starter

SessionLengthCovers
1. Orientation20 minSections 1 to 4. Walk the twelve groups in order and explain that the board is the business, not a to-do list. Show the difference between the group and Project Status.
2. A job end to end30 minSection 5 with a real completed job open on screen. Read its columns and tell the story of the job from the data.
3. Quoting25 minSection 7. Price a practice job, generate the PDF, read it, and point out how a typo in a column becomes a typo in front of a client.
4. What happens by itself20 minSection 6. The two SMS messages, the review link and the approval button. Emphasise that a status change sends a real text to a real client.
5. Money15 minSection 8. Subitems, the Payments roll-up, Final Payment versus Value of Works.
6. Routine and standards20 minSections 10 and 11. The morning routine and the eight hygiene rules. Finish by having them clear two real exceptions from section 11.2.

12.2 Storyboard for the training video

Ch.On screenWhat to say
1
0:00
Board main table, zoomed out so all twelve groups are visible."This one board is the whole business: every enquiry, every quote, every job and every payment. Work flows top to bottom through these twelve stages."
2
0:45
One item opened, scrolling through its columns."Everything we know about a job lives in these columns. Some you fill in, some fill themselves in. The ones that fill themselves in are the ones not to touch."
3
2:00
Highlight Project Status, then drag a card between groups."This is the most important idea in the video. The automations watch Project Status. Dragging a card between groups looks like progress but tells the system nothing. Change the status."
4
3:00
A New Leads item; fill in Sale Rep, Source and the visit Date."Qualifying a lead: who owns it, where it came from, and when we are going out. The moment I set the status to Quote to be prepared, the client gets a reminder text a day before the visit, so the phone number and date have to be right."
5
4:30
Site-visit fields: areas, m², preparation, finishing, colour, finish, trim."This is the scope. It prints onto the quote, so what I type here is what the client reads."
6
6:00
The Quote to check and Generate Quote Attachment views; press Generate Quote; open the PDF."Check the numbers, generate, then read the PDF before it goes out. Notice the green approval button. That is the client's one-click yes, and it writes straight back to the board."
7
8:00
Set status to Proposal Submitted; move to Submitted Quotes."Email the quote first, then set the status, because this is what texts the client to say the quote is on its way."
8
9:00
Won/Lost, then the accepted stages and the Works Timeline."The day we know the answer, we record it. Win rate, conversion, every report: all of it comes from this one field."
9
10:30
Subitems on a paid job; Payments roll-up."Every payment is a subitem. The total rolls up here. When it matches the value of works, the job is paid."
10
11:30
Completed Works; copy the Google Review link."Job done, paid, marked Won, and the review link is already sitting on the item, ready to send."
11
12:15
The Friday report PDF."Every Friday this arrives by email, built from the board. It is only as good as the five fields it reads, which is why we keep the board clean."
12
13:00
Section 11.1 rules on screen."Eight rules. Get these right and everything else looks after itself."
============================ 13 ============================

13. Troubleshooting

SymptomLikely causeWhat to do
Client did not get the site-visit reminderNo valid phone; the Date was inside the 24-hour window when the status changed; the name looked like a test record; the site address is under 10 characters; the status was not actually set to Quote to be prepared.Check phone, Date, name and address on the item. Correct them, and the next 13-minute cycle picks the change up. If everything looks right, ask Data-Insite for the run log.
Client did not get the quote-submitted textMissing or invalid Email (this message requires one), missing phone, or the SMS was already sent once for that job.Fill in the email. If it had already sent, follow up by phone; it will not send twice by design.
Client got a text about a visit that is not happeningThe Date or status was set on the wrong item, or the visit was cancelled without changing the status.Fix the Date or move the status off Quote to be prepared. Pending messages are cancelled on the next cycle. Then call the client.
Google Review link missing on a new itemMake scenario 9873000 is off, or its Monday connection needs re-authorising.Contact Data-Insite. Setting the status to Quote to be prepared triggers the backup scenario and fills it in.
SMS says "Hi #ERROR" or similarThe client Name has no space, so the First Name formula cannot split it.Put a first name and surname in the Name field.
Quote PDF has blank or wrong detailsThe source columns were blank or wrong when the document was generated.Fix the columns and regenerate. The PDF is a snapshot; it does not update itself.
Approval button in a quote does nothingResponseLink was edited or cleared, or the quote was generated before the link was populated.Do not edit ResponseLink. Regenerate the quote and reissue it.
Report figures look wrongBlank Sale Rep, Value of Works, Won/Lost or Source; or the group and status disagree.Run the section 11.2 checks and clear the exceptions, then ask for the report to be regenerated.
A whole automation has stoppedAn API token was regenerated, or a Monday user was deactivated.Contact Data-Insite. Do not create a replacement automation; the connection just needs re-authorising.

Escalation. Anything to do with the automations, the SMS messages, the approval worker or the reports goes to Mark Johnstone, Data-Insite: mark@data-insite.com.au, 0432 048 952. Board layout, views, users and data belong to Pebblemix; Grant is the board owner and admin.

============================ APPENDIX A ============================

Appendix A: Using this document as a template

The structure of this document is deliberately reusable. To produce the same document for another client or another board, keep the section skeleton and replace the content. The Data-Insite house style is:

ElementSpecification
Navy#1A2744: cover band, section headings, table headers, bold emphasis
Cyan#00AEEF: rules under headings, sub-headings, callout edges, accents
Soft cyan#E8F6FC: information callouts and KPI tiles
Grey#8C8C8C: headers, footers and secondary text
CoverFull-bleed navy band with the logo top right, spaced eyebrow line D A T A - I N S I T E  |  C L I E N T, title, one-line purpose, then a document control table and a confidentiality footer above a cyan rule.
Footer"Prepared by Data-Insite | Turning Data into Direction | data-insite.com.au" with page n of m.
CalloutsCyan for information, amber for warnings and risks, green for tips and recommendations.

Section skeleton

  1. Purpose and scope: including what is explicitly out of scope
  2. How it works at a glance: one monospaced flow diagram covering the whole system
  3. Systems and connections: one row per system with its identifiers, plus who has access
  4. The board: groups, every column with its ID, type and who sets it, and views
  5. Lifecycle stage by stage: what the team does, what the system does, exit criteria
  6. Automations reference: trigger, what it writes, guard conditions, how to verify
  7. The client-facing document and approval loop
  8. Money and roll-ups
  9. Reporting: what runs, when, to whom, and which fields it depends on
  10. Operating procedure by role and rhythm
  11. Data hygiene rules, then live exceptions with counts
  12. Training plan and video storyboard
  13. Troubleshooting: symptom, cause, action
  14. Appendices: template notes, glossary, open items

Two habits that make these documents useful rather than shelfware. First, always record the column ID next to the column name, because it is what you need when an automation misbehaves, and it is the one thing nobody can work out from the screen. Second, always include real counts read from the live board. Naming the eight mismatched items is what turns a policy document into a work list.

============================ APPENDIX B ============================

Appendix B: Glossary

TermMeaning
BoardA Monday.com table. The Pebblemix board is the master register of every job.
Item / projectOne row on the board. On this board an item is one job, named after the client. Monday calls them "projects" here.
SubitemA child row under an item. Used here to record individual payments.
GroupA coloured band of items on a board. Used here as the visible pipeline stage.
Column IDMonday's permanent internal name for a column, e.g. numeric_mksep76z. Automations refer to this, not to the column title, so a column can be renamed safely but not deleted and recreated.
Status labelOne of the coloured options in a status column. Automations match on the exact text, so labels must not be renamed.
Mirror / roll-upA column that displays or totals values from another board. Read-only.
Formula columnA calculated column. Read-only; it recalculates itself.
WebhookA message Monday sends the instant something happens, so an automation can react immediately instead of polling.
Make.com scenarioAn automation built outside Monday that connects systems Monday cannot reach on its own.
DocuGenA Monday app that fills a Word template with board data and files the result back onto the item as a PDF.
Cloudflare WorkerA small piece of code on a public web address. Here it receives the client's approval click and updates the board.
IdempotentSafe to run repeatedly without doing the same thing twice, which is why the SMS job can run every 13 minutes without re-texting anybody.
============================ APPENDIX C ============================

Appendix C: Open items to confirm

These could not be established from the live systems and need a decision or an answer from Pebblemix. Once answered, fold them into section 4 or 6 and issue the document as version 1.1.

#ItemQuestion
1Native Monday automationsMonday does not publish its automation recipes through the API, so any board-level automations could not be read. Grant to open Automations on the board and list what is there, so this document records the full picture.
2Days Since Proposal SentPopulated on 308 items. Is it maintained by a native automation, an app, or typed by hand? If it is manual it will drift and should be replaced by a calculation.
3Completed DateEmpty on all 727 items. Start using it, or remove it?
4Website enquiriesThe email-parsing automation is switched off but 86 items came from that source. How do website enquiries reach the board now?
5Proposals boardStill in use, or archive it? Two quoting mechanisms means two versions of the truth.
6Approval button adoption11 recorded approvals against 646 generated quotes. Are clients missing the button, or is the team not relying on it? Worth a look at the covering email wording.
7DocuGen templateThe Word template's placeholder list is not readable from outside DocuGen. Attach a copy of the current template to this document so the field mapping is recorded.
8Meta Contacts handoverWho checks Meta Contacts, how often, and what the rule is for promoting a lead onto the Pebblemix board.
9SMS token in plain textApproval to move the hardcoded Monday API token into the secure credential store and regenerate it (section 3.1).
10Status-to-group automationApproval to add the native automations that move an item into the matching group when Project Status changes, removing the mismatch problem permanently.

Document control. Version 1.0, 27 September 2026. Prepared by Mark Johnstone, Data-Insite, from the live Pebblemix Monday.com configuration, the live Make.com blueprints and the live automation scripts. Review when the board layout, an automation or the reporting schedule changes, and at minimum every six months. Commercial in confidence. Prepared for Pebblemix Pty Ltd.