How-To Guides
Step-by-step guides to using software and automating everyday business tasks.
-
Audit Filled Next-Action Cells That Still Hide Missing Work
Check populated next-action cells in Google Sheets for vague instructions, using a temporary FILTER extract and text highlighting to guide a focused manual audit.
-
Audit Duplicate Job Rows That Can Hide Missing Next Actions
Use duplicate highlighting and a compact Google Sheets audit view to check whether repeated job records are masking a missing or unclear next action.
-
Prepare a HubSpot Leave Handover with Tasks and a Record Snapshot
Prepare coverage tasks and a separate contact snapshot for a colleague, with clear ownership, useful task notes, and checks for HubSpot access and export scope.
-
Build a Quote-Ready Lead Queue in Google Sheets
Create a shared quote-preparation queue with consistent dropdown labels and saved filter settings, so your team can separate ready-to-price leads from unfinished enquiries.
-
Prepare a HubSpot Import in Google Sheets with Validated Dropdowns
Build a controlled contact spreadsheet in Google Sheets, check its values against HubSpot properties, and use a small test batch before importing the remaining records.
-
Flag Missing Next Actions in Google Sheets with a Review Queue
Build a focused review queue for service jobs with missing next actions, using a manual review label, conditional formatting, and a filtered list in Google Sheets.