Appearance
n8n: Other
58 active flows.
Summary
| Flow | Trigger | Calls | Procs | Tables |
|---|---|---|---|---|
| A&G catalog refresh | schedule: every 2 months | 0 | 0 | 0 |
| Adding Jobs to Peer Review Queue | Outlook email | 1 | 4 | 2 |
| AI Peer Review - Error Handler | error handler | 0 | 2 | 0 |
| AI peer Review 3.0 | schedule: every 1 minutes | 4 | 10 | 10 |
| Amend Missing Schedules and Schedule Items | schedule: every 3 hours | 2 | 6 | 0 |
| Azure SQL Server Index Optimise | schedule: every weeks | 0 | 1 | 0 |
| Booking KPI Alert - Run | schedule: cron 0 8 * * 1-5 | 0 | 3 | 0 |
| Bookings Point Distance Purge Orphans | schedule: cron 0 3 * * 0 | 0 | 1 | 0 |
| Client WIP Updates - Process Queue | schedule: every minutes; webhook GET (unguessable path) | 0 | 3 | 0 |
| Client WIP Updates - Stuck Check | schedule: cron 0 9 * * 1-5 | 0 | 0 | 0 |
| Crunchwork Nexus - Webhooks | webhook GET (unguessable path); webhook GET (unguessable path); webhook GET (unguessable path); webhook GET (unguessable path) | 0 | 0 | 0 |
| Discover and remove deleted invoices | schedule: every 20 minutes | 2 | 1 | 2 |
| Discover and remove deleted schedule items (Batched) | schedule: every weeks; schedule: every 20 minutes | 2 | 4 | 1 |
| ElevenLabs Uploaded Audio | schedule: every undefined | 0 | 2 | 0 |
| ENData Request for Service Email | Outlook email | 1 | 3 | 0 |
| Estimator Live Desk Refresh (hourly) | schedule: every 1 hours | 0 | 1 | 0 |
| EthCalendar Upsert | schedule: every 2 months | 0 | 1 | 0 |
| Failed Claims Updates | schedule: every undefined | 0 | 1 | 0 |
| Generate AI Job Summaries | schedule: cron */27 8-17 * * 1-5; cron 0 */2 * * 6,0; cron 0 0,2,4,6,8 * * 1-5; cron 0 18,20,22 * * 1-5; webhook GET (unguessable path) | 0 | 0 | 0 |
| Generate AI Job Summary for Job | webhook GET (unguessable path) | 0 | 0 | 0 |
| Get Current OTP Code | webhook POST /mfa-as-a-service/otp/get-code/:account_name | 0 | 0 | 1 |
| Get Latest MFA Code For Service | webhook POST /mfa-as-a-service/get-mfa-latest-email/:service_provider_name | 0 | 0 | 1 |
| Global Error Handler | error handler | 0 | 1 | 0 |
| Keep MFA Store Up-to-date (Email + Phone) v2 | webhook POST /mfa-as-a-service/update-service-mfa; Outlook email | 1 | 1 | 1 |
| Kitchen Roster - Send Next Week | schedule: cron 0 9 * * 5 | 0 | 0 | 0 |
| n8n Error Handler | error handler | 1 | 1 | 0 |
| Nightly Refreshes | schedule: cron 0 30 4 * * * | 0 | 13 | 0 |
| Ontology Column Profile (rolling quarterly) | schedule: cron 0 25 20 * * 0,1,3,5 | 0 | 1 | 0 |
| Ontology Table Sample (weekly) | schedule: cron 0 25 20 * * 6 | 0 | 1 | 0 |
| PDP Intelligence Report - Run | schedule: cron 0 7 * * 6 | 0 | 0 | 0 |
| Peer Review - Predefined Suggestion | called by other flow | 0 | 2 | 3 |
| Peer Review Queue from Status Webhooks | schedule: every 1 minutes | 2 | 1 | 6 |
| Populate Invoice Check | schedule: every weeks | 0 | 2 | 0 |
| Qdrant Health Check | schedule: every undefined | 0 | 0 | 0 |
| Queue AI Job Summary Tasks | schedule: every 17 minutes | 0 | 1 | 0 |
| Queue Missing Schedules | schedule: every weeks | 0 | 1 | 0 |
| Quote Submission Automation | Outlook email; called by other flow | 1 | 6 | 5 |
| Refresh Catastrophy Data | schedule: every days | 0 | 1 | 0 |
| Register OTP Account | webhook POST /mfa-as-a-service/otp/register-account | 0 | 0 | 1 |
| Remove OTP Account | webhook POST /mfa-as-a-service/otp/remove-account | 0 | 0 | 1 |
| Report Freshness Check | schedule: every hours | 0 | 0 | 55 |
| Schedule Prod Deploy | 0 | 0 | 0 | |
| Scheduled Report Refresh | schedule: every 3 hours | 0 | 20 | 2 |
| Sedgwick Repairline Make Safe Email | Outlook email | 1 | 3 | 0 |
| SharePoint Overdue Process Alert | schedule: every weeks | 0 | 0 | 0 |
| SimpleKPI Ingest | schedule: every undefined | 0 | 0 | 1 |
| SOM Supervisor invoicing dashboard maintenance | schedule: every 4 hours; schedule: every undefined | 0 | 4 | 0 |
| Stagehand - Error handler | error handler | 0 | 0 | 0 |
| Supplier Compliance - Make Lapsed Contacts Inactive (daily) | schedule: cron 0 5 * * *; schedule: cron 0 8 * * * | 2 | 1 | 2 |
| Task Queue - Depth API | webhook GET /72d81790-71b3-4bbd-8078-1a6b80dacf00/task-queue/count | 0 | 3 | 0 |
| TEMP - Pulsed index build primeSiteFormItems LastChangedAt v2 (SFA) | schedule: every 12 minutes | 0 | 0 | 0 |
| Twillio inbound Test | webhook POST (unguessable path) | 0 | 0 | 0 |
| UniFi Door Unlocked QLD | webhook POST (unguessable path) | 0 | 0 | 0 |
| VA Booking WebAPI Process Events | schedule: every 3 minutes; webhook GET (unguessable path) | 1 | 3 | 0 |
| WebAPI Process Location Queue | schedule: every 11 minutes | 0 | 3 | 0 |
| Webhook ElevenLabs ConversationInitialization | webhook POST (unguessable path) | 0 | 1 | 0 |
| WIP Action Split - Daily Rebuild | schedule: every 1 days | 0 | 1 | 0 |
| WIP Applied - Skipped - No action refresh | schedule: every undefined | 0 | 1 | 0 |
Flows
A&G catalog refresh
A&G Catalog Refresh This flow exists because Prime does not automatically refresh the A&G catalog and there is no way to verify if/when it needs to be done, as such we will bother them on a bi-monthly basis
- Triggers: schedule: every 2 months
- Nodes: 3 · Integrations: Outlook
Adding Jobs to Peer Review Queue
- Triggers: Outlook email
- Nodes: 15 · Integrations: Outlook, SQL
- Calls: Prime Get Api Token from SQL
- Stored procedures:
spEthTaskInsert,spEthTaskGetNext,spEthPeerReviewTaskCheck,spN8nGetPrimeRateLimitPercent - Tables/views read or written:
primejobs,ethTask
AI Peer Review - Error Handler
- Triggers: error handler
- Nodes: 6 · Integrations: SQL
- HTTP targets: n8n API
- Stored procedures:
spEthTaskFailAndRetrySoon,spEthEmailMessageInsertHtml
AI peer Review 3.0
ANG Pipeline This pathway cares about Item Notes more than descriptions
- Triggers: schedule: every 1 minutes
- Nodes: 192 · Integrations: SQL, OpenAI
- HTTP targets: Ethos WebAPI, www.primeeco.tech
- Calls: Prime Get Api Token from SQL; Prime Push Estimate Item Corrections; Prime Create Reviewed Estimate; Prime Record Rate Limit and Query
- Stored procedures:
spN8nGetPrimeRateLimitPercent,spEthTaskClaimNext,spPrimePeerReviewformdetails,spPrimePeerReviewEstimatedetails,spEthTaskComplete,spPrimePeerReviewJobSummary,spEthPeerReviewedErrors,spEthEmailMessageInsertHTMLWithAttachments,spPrimePeerReviewLockedLines,spEthCaptureEstimateArchive - Tables/views read or written:
primeJobs,primeUsers,primeContacts,ethTask,primejobs,primeEstimateTemplateItems,primeNonPredefinedItemLog,EthPeerReviewStatus,EthPeerReviewCatalogueRun,EthCatalogueCandidateDecision
Amend Missing Schedules and Schedule Items
- Triggers: schedule: every 3 hours
- Nodes: 17 · Integrations: SQL
- HTTP targets: www.primeeco.tech
- Calls: Prime Get Api Token from SQL; Prime Record Rate Limit and Query
- Stored procedures:
spN8nGetPrimeRateLimitPercent,spEthGetQueuedIDs,args,spPrimeUpsertSchedule,spPrimeUpsertScheduleItem,spEthSyncQueueDelete
Azure SQL Server Index Optimise
- Triggers: schedule: every weeks
- Nodes: 2 · Integrations: SQL
- Stored procedures:
IndexOptimize
Booking KPI Alert - Run
- Triggers: schedule: cron 0 8 * * 1-5
- Nodes: 8 · Integrations: SQL
- HTTP targets: Ethos WebAPI
- Stored procedures:
spEthTaskLockIsLocked,spEthTaskLockInsert,spEthTaskLockClear
Bookings Point Distance Purge Orphans
UserStory1727 - point distance cache housekeeping Runs dbo.spEthBookingPointDistancePurgeOrphans weekly. A re-geocoded address leaves its old location point behind, and an ended relocation leaves its hotel's. Their cached Google distances are never read again.
- Triggers: schedule: cron 0 3 * * 0
- Nodes: 4 · Integrations: SQL
- Stored procedures:
spEthBookingPointDistancePurgeOrphans
Client WIP Updates - Process Queue
Generates client WIP updates from the trigger queue (Epic473 / UserStory507) Two things enqueue a Client WIP trigger and neither does any work itself: PrimeWebhookQueueService, when a Prime job status change is drained, and spEthWIPJobEmailMarkSent, when a cus
- Triggers: schedule: every minutes; webhook GET (unguessable path)
- Nodes: 11 · Integrations: SQL
- HTTP targets: Ethos WebAPI
- Stored procedures:
spEthTaskLockIsLocked,spEthTaskLockInsert,spEthTaskLockClear
Client WIP Updates - Stuck Check
Client WIP stuck jobs (UserStory1859) Weekdays 9am: POST api/clientwipupdate/stuckcheck. 1. Resends each job's last real client update once a week, up to the rule's Max sends (written as IsResend rows on ethClientWIPUpdate). 2. After the rule's Stuck after day
- Triggers: schedule: cron 0 9 * * 1-5
- Nodes: 4
- HTTP targets: Ethos WebAPI
Crunchwork Nexus - Webhooks
Check "Prime Job Events" Mailbox (Automation Folder) for the MFA code - WEBHOOK
- Triggers: webhook GET (unguessable path); webhook GET (unguessable path); webhook GET (unguessable path); webhook GET (unguessable path)
- Nodes: 11 · Integrations: Outlook
Discover and remove deleted invoices
- Triggers: schedule: every 20 minutes
- Nodes: 12 · Integrations: SQL
- HTTP targets: www.primeeco.tech
- Calls: Prime Get Api Token from SQL; Prime Record Rate Limit and Query
- Stored procedures:
spN8nGetPrimeRateLimitPercent - Tables/views read or written:
primeinvoicecheck,primeAccountsReceivableInvoices
Discover and remove deleted schedule items (Batched)
Batched replacement for "Discover and remove deleted schedule items" INACTIVE until spPrimeMarkScheduleItemCheckBatch is created in the DB. Do not activate alongside the original - both drain the same primeScheduleItemCheck queue. The original called /schedule
- Triggers: schedule: every weeks; schedule: every 20 minutes
- Nodes: 16 · Integrations: SQL
- HTTP targets: www.primeeco.tech
- Calls: Prime Get Api Token from SQL; Prime Record Rate Limit and Query
- Stored procedures:
spPopulateScheduleItemCheck,spPrimeRemoveDeletedScheduleItems,spN8nGetPrimeRateLimitPercent,spPrimeMarkScheduleItemCheckBatch - Tables/views read or written:
primeScheduleItemCheck
ElevenLabs Uploaded Audio
- Triggers: schedule: every undefined
- Nodes: 6 · Integrations: SQL
- HTTP targets: api.elevenlabs.io
- Called by: Webhook ElevenLabs MakeSafe Call; Webhook ElevenLabs Message
- Stored procedures:
spElevenLabsConversationGetAudioQueue,spElevenLabsConversationSetStatus
ENData Request for Service Email
- Triggers: Outlook email
- Nodes: 10 · Integrations: Outlook, OpenAI, SQL
- Calls: SMS Send Queued Messages
- Stored procedures:
spMakesafeInsertPhoneCall,spMakesafeQueuePhoneCallSMSMessages,spIsOutsideBusinessHours
Estimator Live Desk Refresh (hourly)
- Triggers: schedule: every 1 hours
- Nodes: 3 · Integrations: SQL
- Stored procedures:
spRefreshEthEstimatorOpenJobs
EthCalendar Upsert
ethCalendar Calendar of past and future dates indicating public holidays and business days
- Triggers: schedule: every 2 months
- Nodes: 3 · Integrations: SQL
- Stored procedures:
spEthCalendarUpsertNextYear
Failed Claims Updates
- Triggers: schedule: every undefined
- Nodes: 2 · Integrations: SQL
- Stored procedures:
spPopulateEthQuoteOutcomes
Generate AI Job Summaries
Processes the Task Queue Gets the Prime Objects via the API Checks for Prime Data Generates and Saves a summary using OpenAI
- Triggers: schedule: cron */27 8-17 * * 1-5; cron 0 */2 * * 6,0; cron 0 0,2,4,6,8 * * 1-5; cron 0 18,20,22 * * 1-5; webhook GET (unguessable path)
- Nodes: 8
- HTTP targets: Ethos WebAPI
Generate AI Job Summary for Job
Generates one job's AI Job Summary (UserStory1272) FormsPortal calls this webhook on triage submission (via CommonWebhooks.IWebhookHandler.AIJobSummaryGenerateForJob), passing ?jobId=<guid. It targets the single job rather than draining the whole queue, so a b
- Triggers: webhook GET (unguessable path)
- Nodes: 6
- HTTP targets: Ethos WebAPI
Get Current OTP Code
Get Current OTP Code GET mfa-as-a-service/otp/get-code/:accountname Decrypts the stored secret and returns the current TOTP code plus the window start time. codeupdatedat = ISO start of the current window, so consumers can judge freshness. 404 when unknown, 50
- Triggers: webhook POST /mfa-as-a-service/otp/get-code/:account_name
- Nodes: 8 · Integrations: SQL
- Tables/views read or written:
EthMFAOtpAccounts
Get Latest MFA Code For Service
- Triggers: webhook POST /mfa-as-a-service/get-mfa-latest-email/:service_provider_name
- Nodes: 3 · Integrations: SQL
- Tables/views read or written:
EthMFAAsAService
Global Error Handler
Global error handler Set this workflow as the Error Workflow on any flow that should be watched (Workflow settings Error Workflow). It then fires whenever that flow fails. As at 2026-09-03 about 60 active flows point at it. Two rules. Five consecutive failures
- Triggers: error handler
- Nodes: 7 · Integrations: SQL
- Stored procedures:
spEthEmailMessageInsertHTMLWithAttachments
Keep MFA Store Up-to-date (Email + Phone) v2
Keeps the shared MFA store (dbo.EthMFAAsAService) up to date from BOTH channels in one pipeline: Mason's phone SMS (POST webhook /mfa-as-a-service/update-service-mfa) and the shared mailbox (Outlook poll trigger). Flow: Normalize Message builds one text field
- Triggers: webhook POST /mfa-as-a-service/update-service-mfa; Outlook email
- Nodes: 14 · Integrations: Outlook, OpenAI, SQL
- Calls: Email Queue - Send Prod
- Stored procedures:
spEthEmailMessageInsertHtml - Tables/views read or written:
EthMFAAsAService
Kitchen Roster - Send Next Week
- Triggers: schedule: cron 0 9 * * 5
- Nodes: 3
- HTTP targets: Ethos WebAPI
n8n Error Handler
Exaction Handler Set this flow as the exception handler for another n8n flow
- Triggers: error handler
- Nodes: 4 · Integrations: SQL
- Calls: SMS Send Queued Messages
- Stored procedures:
spMakesafeQueueException
Nightly Refreshes
Nightly Refreshes Once-a-day report tables, 04:30 Sydney time (after the 03:40 three-hourly run, before the 05:00 attachment slot). Each table here has a 26h row in Report Freshness Check. A table lives in ONE refresh flow only - remove it from Scheduled Repor
- Triggers: schedule: cron 0 30 4 * * *
- Nodes: 31 · Integrations: SQL
- Stored procedures:
spRefreshEthAGCatalogueLineUsage,spRefreshEthPeerReviewIssues,spRefreshEthQuoteRequests,spCompletiontimesObjectivedb,spEthjobsdataObjectivedb,spEthretroactivejobsdataObjectivedb,spEthinvoicedataObjectivedb,spEthSalesPipelinejobsObjectivedb,spRefreshEthAGTemplateWordingCodes,spRefreshEthWorkOrderFirmMainTrade,spRefreshEthCatalogueLockedUsage,spRefreshEthValidationRequest,spPrimePopulateJobPackReport
Ontology Column Profile (rolling quarterly)
- Triggers: schedule: cron 0 25 20 * * 0,1,3,5
- Nodes: 2 · Integrations: SQL
- Stored procedures:
spRefreshEthOntologyColumnProfile
Ontology Table Sample (weekly)
- Triggers: schedule: cron 0 25 20 * * 6
- Nodes: 2 · Integrations: SQL
- Stored procedures:
spRefreshEthOntologyTableSample
PDP Intelligence Report - Run
- Triggers: schedule: cron 0 7 * * 6
- Nodes: 4
- HTTP targets: Ethos WebAPI
Peer Review - Predefined Suggestion
- Triggers: called by other flow
- Nodes: 11 · Integrations: SQL, OpenAI
- Stored procedures:
spPrimePeerReviewEstimatedetails,once - Tables/views read or written:
primeEstimateTemplateItems,primeNonPredefinedItemLog,EthPeerReviewCatalogueRun
Peer Review Queue from Status Webhooks
- Triggers: schedule: every 1 minutes
- Nodes: 16 · Integrations: SQL
- HTTP targets: www.primeeco.tech
- Calls: Prime Get Api Token from SQL; Prime Record Rate Limit and Query
- Stored procedures:
spEthTaskInsert - Tables/views read or written:
ethPrimeWebhookLog,ethTask,primeJobs,primeStatuses,primeSiteForms,primeEstimates
Populate Invoice Check
- Triggers: schedule: every weeks
- Nodes: 3 · Integrations: SQL
- Stored procedures:
spPopulateInvoiceCheck,spPrimeRemoveDeletedInvoices
Qdrant Health Check
keeps the qdrant cluster alive
- Triggers: schedule: every undefined
- Nodes: 4
- HTTP targets: a680a2ad-1b05-45ad-9c02-f4aa30e1ccce.us-east4-0.gcp.cloud.qdrant.io:6333
Queue AI Job Summary Tasks
Queuing only Runs the SP to create Task where there isn't a Pending Task for the JobID or the Hash has changed
- Triggers: schedule: every 17 minutes
- Nodes: 3 · Integrations: SQL
- Stored procedures:
spEthAIPrimeUpsertJobSummaryQueue
Queue Missing Schedules
- Triggers: schedule: every weeks
- Nodes: 2 · Integrations: SQL
- Stored procedures:
spEthQueueMissingSchedules
Quote Submission Automation
- Triggers: Outlook email; called by other flow
- Nodes: 34 · Integrations: Outlook, SQL
- HTTP targets: Ethos WebAPI, graph.microsoft.com
- Calls: Prime Get Api Token from SQL
- Stored procedures:
spN8nGetPrimeRateLimitPercent,spEthTaskInsert,spEthQuoteSubmissionEstimateLines,spEthTaskComplete,spEthEmailMessageInsertHTMLWithAttachments,spEthQuoteSubmissionCsvInsert - Tables/views read or written:
primeJobs,primeContacts,ethTask,EthCHUTradeMap,EthCHUUnitAlias
Refresh Catastrophy Data
- Triggers: schedule: every days
- Nodes: 2 · Integrations: SQL
- Stored procedures:
spPopulatePrimeExportCatastropheReport
Register OTP Account
Register OTP Account POST mfa-as-a-service/otp/register-account Body: { accountname, secret }. secret = raw base32 or otpauth:// URI. Validates by generating a TOTP proof code, encrypts the secret with ENCRYPTBYPASSPHRASE, upserts (re-register replaces). GOTCH
- Triggers: webhook POST /mfa-as-a-service/otp/register-account
- Nodes: 6 · Integrations: SQL
- Tables/views read or written:
EthMFAOtpAccounts
Remove OTP Account
Remove OTP Account POST mfa-as-a-service/otp/remove-account Body: { accountname }. Deletes the row and reports whether anything was removed. 404 when the account was not registered. GOTCHA: webhook path has NO leading slash. Header auth applied before publish.
- Triggers: webhook POST /mfa-as-a-service/otp/remove-account
- Nodes: 6 · Integrations: SQL
- Tables/views read or written:
EthMFAOtpAccounts
Report Freshness Check
Report table freshness, and alert delivery Runs hourly at :10, between the 3-hourly refreshes in Scheduled Report Refresh. Why this exists. Every refresh node in that workflow carries onError: continueRegularOutput, so one refresh can fail while the workflow s
- Triggers: schedule: every hours
- Nodes: 7 · Integrations: SQL
- Tables/views read or written:
EthEstimatorQuoteLife,EthEstimatorOpenJobs,EthRpt922JobClaimLifecycle,EthPeerReviewIssues,EthRpt922Allocations,EthEstimatorValidationLoops,EthEstimatorInsurerResponse,EthEstimatorVariations,EthEstimatorVariationJobs,EthJobCustomFieldNarrow,EthEstimatorAwaitingInfoSpells,EthRpt922InvoicedAwaitingPayment,EthWIPUpdatesReport,EthWorkOrderTrade,EthSiteEstablishmentTimer,EthQuoteRequests,EthHOWCompliance,EthEstimatorPerformance,EthJobLastCustomerContact,EthSwmsWorkOrderDecision,EthProcurementJob,EthProcurementWorkOrder,EthCompletiontimesObjectivedb,ethjobsdataObjectivedb,ethretroactivejobsdataObjectivedb,ethinvoicedataObjectivedb,EthSalesPipelinejobsObjectivedb,PrimeSOMdrilldown,primeSOMSummary,EthCatalogueItemUsage,EthEstimateCatalogueSummary,EthEstimateLineCatalogueMatch,ethWIPActionSplitByWeek,SOMdrilldownsnapshot,SOMsummarysnapshot,EthAGCatalogueLineUsage,EthAGTemplateWordingCodes,EthWorkOrderFirmMainTrade,EthCatalogueItemLockedUsage,EthValidationRequest,JobWIPDashboard,ethWIPJobWeeklySnapshot,primejobs,primeStatusHistories_Job,EthPeerReviewStatus,EthPeerReviewCatalogueRun,ethTask,EthEstimateArchive,ethEmailMessage,primeSiteForms,EthRpt922SiteFormAnswer,primeSiteFormItems,ethSyncProgress,primeStatusHistories_Allocation,EthEstimatorEffortPerQuote
Schedule Prod Deploy
- Triggers: none (only called or disabled triggers)
- Nodes: 5 · Integrations: GitHub
Scheduled Report Refresh
- Triggers: schedule: every 3 hours
- Nodes: 44 · Integrations: SQL
- Stored procedures:
spRefreshEstimatorQuoteLife,spRefreshEthRpt922JobClaimLifecycle,spRefreshEthRpt922Allocations,spRefreshEthEstimatorValidationLoops,spRefreshEthEstimatorInsurerResponse,spRefreshEthEstimatorVariations,spRefreshEthJobCustomFieldNarrow,spRefreshEthEstimatorAwaitingInfoSpells,[redacted-blob],spRefreshEthWIPUpdatesReport,spEthPopulatePeerReviewStatus,SPEthHOWCompliance,spEthEstimatorPerformance,spRefreshEthWorkOrderTrade,spRefreshEthSiteEstablishmentTimer,spRefreshEthJobLastCustomerContact,spRefreshEthSwmsWorkOrderDecision,spRefreshEthProcurement,spRpt922RefreshSiteFormAnswer,spRefreshEthEstimatorEffortPerQuote - Tables/views read or written:
EthPeerReviewStatus,EthPeerReviewedErrors
Sedgwick Repairline Make Safe Email
- Triggers: Outlook email
- Nodes: 10 · Integrations: Outlook, OpenAI, SQL
- Calls: SMS Send Queued Messages
- Stored procedures:
spMakesafeInsertPhoneCall,spMakesafeQueuePhoneCallSMSMessages,spIsOutsideBusinessHours
SharePoint Overdue Process Alert
- Triggers: schedule: every weeks
- Nodes: 5 · Integrations: Outlook
SimpleKPI Ingest
- Triggers: schedule: every undefined
- Nodes: 21 · Integrations: SQL
- HTTP targets: ethos.simplekpi.com
- Tables/views read or written:
ethSimpleKpiEntry
SOM Supervisor invoicing dashboard maintenance
- Triggers: schedule: every 4 hours; schedule: every undefined
- Nodes: 6 · Integrations: SQL
- Stored procedures:
spprimeGenerateSOMSummary,spPrimeBuildSOMdrilldown,spSOMdrilldownsnapshot,spSOMsummarysnapshot
Stagehand - Error handler
Stagehand - Error handler Set as the Error Workflow on every workflow under infra/n8n/, apps//n8n/ and packages/common/mfa/n8n/. n8n runs it whenever one of them fails in production (schedule, webhook or sub-workflow execution; never a manual test run). One fa
- Triggers: error handler
- Nodes: 4 · Integrations: Outlook
Supplier Compliance - Make Lapsed Contacts Inactive (daily)
- Triggers: schedule: cron 0 5 * * *; schedule: cron 0 8 * * *
- Nodes: 26 · Integrations: SQL
- HTTP targets: www.primeeco.tech
- Calls: Prime Get Api Token from SQL; Prime Record Rate Limit and Query
- Stored procedures:
spN8nGetPrimeRateLimitPercent - Tables/views read or written:
vEthSupplierComplianceLapse,EthSupplierComplianceAction
Task Queue - Depth API
Task Queue - Depth API KEDA polls GET /webhook/.../task-queue/count?TaskName=<name (every 60s per worker job) and reads the numeric count. The gate is paused on the automation-settings data table. A queue answers its real count only when its row says paused=fa
- Triggers: webhook GET /72d81790-71b3-4bbd-8078-1a6b80dacf00/task-queue/count
- Nodes: 18 · Integrations: SQL
- Stored procedures:
spEthTaskLockIsLocked,spN8nGetPrimeRateLimitPercent,spEthTaskGetCount
TEMP - Pulsed index build primeSiteFormItems LastChangedAt v2 (SFA)
- Triggers: schedule: every 12 minutes
- Nodes: 4 · Integrations: SQL
Twillio inbound Test
- Triggers: webhook POST (unguessable path)
- Nodes: 3
UniFi Door Unlocked QLD
- Triggers: webhook POST (unguessable path)
- Nodes: 3 · Integrations: Outlook
VA Booking WebAPI Process Events
Cloned from 'Booking WebAPI Process Events' Same schedule + SQL task-lock (spEthTaskLock) guard, retargeted at the VA booking endpoints with its own lock name (n8nVABookingProcessEvents) so it can never contend with the estimator booking flow's lock. Webhook t
- Triggers: schedule: every 3 minutes; webhook GET (unguessable path)
- Nodes: 12 · Integrations: SQL
- HTTP targets: Ethos WebAPI
- Calls: Webhook Send Queued SMS
- Stored procedures:
spEthTaskLockIsLocked,spEthTaskLockInsert,spEthTaskLockClear
WebAPI Process Location Queue
- Triggers: schedule: every 11 minutes
- Nodes: 9 · Integrations: SQL
- HTTP targets: Ethos WebAPI
- Stored procedures:
spEthTaskLockInsert,spEthTaskLockIsLocked,spEthTaskLockClear
Webhook ElevenLabs ConversationInitialization
- Triggers: webhook POST (unguessable path)
- Nodes: 3 · Integrations: SQL
- Stored procedures:
spElevenLabsGetConversationInitialization
WIP Action Split - Daily Rebuild
- Triggers: schedule: every 1 days
- Nodes: 3 · Integrations: SQL
- Stored procedures:
spEthWIPBuildActionSplitByWeek
WIP Applied - Skipped - No action refresh
- Triggers: schedule: every undefined
- Nodes: 2 · Integrations: SQL
- Stored procedures:
spEthWIPBuildActionSplitByWeek

