Project Inspection Status

Track inspection status for specific projects

Automation Status

Idle

Emails Processed: 0

Select Project

Connection Settings

Gmail Settings

For security, use an App Password

Dropbox Settings

Get your token from the Dropbox Developer Console

Google Sheets Settings

Found in your Google Sheet URL
Current file: credentials.json

Project Codes

The following project codes are currently configured:

Location Project Code
Willoughby S21206801-Willoughby
St leonards S21206501-St Leonards
Kensington S23203302-kensington

Project codes are shared with the Inspection Automations feature.

How It Works

This feature helps you track the inspection status for a specific project:

  1. Select a project from the dropdown menu.
  2. Choose a time period to search for relevant emails.
  3. The system will search for emails related to the selected project.
  4. For each email found, it will extract information about:
    • Structural Elements (from email subject)
    • Whether inspection reports are saved in Dropbox
    • Whether rectifications are required
    • Whether rectifications were received
    • Whether work was approved
    • Inspector name
    • Folder path in Dropbox
    • Processing date and email date
  5. The information will be added to a separate spreadsheet for tracking.
Note: Make sure your spreadsheet has the following columns:
  • Column A: Structural Elements
  • Column B: Inspection Report Saved
  • Column C: Rectification Required
  • Column D: Rectification Received
  • Column E: Approved?
  • Column F: Inspector
  • Column G: Folder Directions
  • Column H: Date Processed
  • Column I: (blank column)
  • Column J: Email Date

Automation Logs

No logs yet. Run the automation to see logs.