This automation seamlessly connects your Matterport notifications to your Monday.com workspace. It monitors your inbox for "ready to view" emails, extracts the property address, and automatically checks off the corresponding order in your Monday.com board.
flowchart TD
A["Gmail: Matterport Email"] --> B["Extract Address from Subject"]
B --> C["Normalize Address (e.g., ST to Street)"]
C --> D{"Search Monday.com Orders"}
D -- "Match Found (within 5 days)" --> E["Update Order to Checked"]
D -- "No Match / Outside Date" --> F["Skip Update"]How the automation works
The workflow runs entirely in the background using a series of automated steps to ensure high accuracy when matching emails to your orders.
- 1
Monitor Gmail
The system constantly watches your connected Gmail account for messages from
no-reply@matterport.comthat contain the phrase"is ready to view"in the subject line. - 2
Extract and clean the address
When an email arrives, the automation isolates the property address from the subject line. It removes extra text (like the "is ready to view" portion) and trims away any accidental spaces or commas.
- 3
Normalize abbreviations
Because addresses are often typed differently (e.g., "Main St" vs. "Main Street"), a custom script standardizes the address to ensure a perfect match in Monday.com.
- 4
Find and verify the order
The system searches your 🏠 Orders board in Monday.com for the cleaned address. It applies strict validation rules to ensure it updates the correct item.
- 5
Update Monday.com
Once the exact match is verified, the automation automatically updates the relevant status checkbox on the Monday.com order.
Smart matching logic
To prevent accidentally updating the wrong property—especially if you visit the same address multiple times a year—the automation uses a strict validation process before making any changes.
Validation Rules
An order will only be updated if it meets both of the following conditions:
Recent Schedule: The scheduled date on the Monday.com order must be within 5 days of the email arriving.
Measurements Required: The order must have the measurements column marked as "Yes" or checked.
Address normalization
To maximize the chances of finding a match, the automation automatically expands common street abbreviations into their full words and converts everything to Title Case (e.g., 8 BAIR CIR becomes 8 Bair Circle).
Here are the abbreviations the system automatically translates:
| Abbreviation | Expanded Form | Abbreviation | Expanded Form |
|---|---|---|---|
| ST | Street | PL | Place |
| RD | Road | TER | Terrace |
| AVE | Avenue | PKWY | Parkway |
| DR | Drive | WAY | Way |
| LN | Lane | HWY | Highway |
| CT | Court | TRL | Trail |
| CIR | Circle | HTS | Heights |
| BLVD | Boulevard |
If you need to audit or adjust this logic, the underlying Python script uses a simple dictionary for these replacements:
# Expanded list of abbreviations
abbreviations = {
"ST": "STREET", "RD": "ROAD", "AVE": "AVENUE", "DR": "DRIVE",
"LN": "LANE", "CT": "COURT", "CIR": "CIRCLE", "BLVD": "BOULEVARD",
"PL": "PLACE", "TER": "TERRACE", "PKWY": "PARKWAY", "WAY": "WAY",
"HWY": "HIGHWAY", "TRL": "TRAIL", "HTS": "HEIGHTS"
}Troubleshooting
If you notice a Matterport email arrived but your Monday.com board didn't update, check these common scenarios:
The order date is too old or too far in the future
The automation has a DAYS_TOLERANCE of 5 days. If the Monday.com order was scheduled more than 5 days ago (or is scheduled more than 5 days in the future), the system will ignore the email to prevent updating outdated duplicate orders.
The measurements box wasn't checked
The automation specifically looks for orders that require measurements. Ensure the relevant column on your Monday board contains "yes" or is checked.
The address formatting is too unique
While the system handles standard abbreviations (like "St" or "Blvd"), highly unusual formatting or misspellings in the Monday.com board might prevent a match. Ensure the street address in Monday.com closely resembles standard postal formatting.
If you consistently run into matching issues, verify that your Monday.com board columns haven't been deleted or recreated. The automation relies on specific internal column IDs (like text0__1 for the street address and date_mkvn1we4 for the date) to perform its search.