Skip to content

n8n: Email ​

9 active flows.

Summary ​

FlowTriggerCallsProcsTables
Email Queue - Send Prodschedule: every 3 minutes; called by other flow070
Email Queue - Send Testschedule: every 19 minutes; called by other flow070
Endata Prime Scope Email ImportOutlook email040
Hudu Backup Email Alertschedule: every months010
prime DataCentre Email - Attachment SWMS CountOutlook email050
prime DataCentre Email - closed job review (AR total)Outlook email010
prime DataCentre Email - Closed Job Review CostsOutlook email010
prime DataCentre Email - Coburg Utilisation ReportOutlook email030
prime DataCentre Email - Conversion ReportOutlook email020

Flows ​

Email Queue - Send Prod ​

Locking Clears the Lock if no emails or if the loop has finished

  • Triggers: schedule: every 3 minutes; called by other flow
  • Nodes: 23 · Integrations: SQL
  • HTTP targets: login.microsoftonline.com, graph.microsoft.com
  • Called by: Keep MFA Store Up-to-date (Email + Phone) v2; MakeSafe Phone Call Outcome Reminders
  • Stored procedures: spEthEmailMessageGetQueue, spEthEmailMessageMarkSent, spEthTaskLockInsert, spEthTaskLockIsLocked, spEthTaskLockClear, spEthEmailMessageGetAttachment, spEthEmailMessageMarkFailed

Email Queue - Send Test ​

Locking Clears the Lock if no emails or if the loop has finished

  • Triggers: schedule: every 19 minutes; called by other flow
  • Nodes: 23 · Integrations: SQL
  • HTTP targets: login.microsoftonline.com, graph.microsoft.com
  • Stored procedures: spEthEmailMessageGetQueue, spEthEmailMessageMarkSent, spEthTaskLockInsert, spEthTaskLockIsLocked, spEthTaskLockClear, spEthEmailMessageGetAttachment, spEthEmailMessageMarkFailed

Endata Prime Scope Email Import ​

About the Shared Mailbox One mailbox prime-datacentre-exports@ethosbuilding.com.au with many folders. A Mail rule will move the mail to the correct folder for this trigger to process

  • Triggers: Outlook email
  • Nodes: 17 · Integrations: Outlook, SQL
  • Stored procedures: spPrimeScope_MarkOriginStale_FromStage, spPrimeScope_MergeCSV_ToStage, spPrimeScope_UpsertStageRowToOrigin, spPrimeScope_EnrichDimensions_FromEstimates

Hudu Backup Email Alert ​

  • Triggers: schedule: every months
  • Nodes: 3 · Integrations: SQL
  • Stored procedures: spEthEmailMessageInsertText

prime DataCentre Email - Attachment SWMS Count ​

About the Shared Mailbox One mailbox prime-datacentre-exports@ethosbuilding.com.au with many folders. A Mail rule will move the mail to the correct folder for this trigger to process

  • Triggers: Outlook email
  • Nodes: 14 · Integrations: Outlook, SQL
  • Stored procedures: stored, spPrimeExportUpsertAttachmentSWMSCount, spEthTaskLockInsert, spEthTaskLockIsLocked, spEthTaskLockClear

prime DataCentre Email - closed job review (AR total) ​

About the Shared Mailbox One mailbox prime-datacentre-exports@ethosbuilding.com.au with many folders. A Mail rule will move the mail to the correct folder for this trigger to process

  • Triggers: Outlook email
  • Nodes: 10 · Integrations: Outlook, SQL
  • Stored procedures: spPrimeExportUpsertClosedJobReviewARTotal

prime DataCentre Email - Closed Job Review Costs ​

About the Shared Mailbox One mailbox prime-datacentre-exports@ethosbuilding.com.au with many folders. A Mail rule will move the mail to the correct folder for this trigger to process

  • Triggers: Outlook email
  • Nodes: 10 · Integrations: Outlook, SQL
  • Stored procedures: spPrimeExportUpsertClosedJobReviewCosts

prime DataCentre Email - Coburg Utilisation Report ​

About the Shared Mailbox One mailbox prime-datacentre-exports@ethosbuilding.com.au with many folders. A Mail rule will move the mail to the correct folder for this trigger to process

  • Triggers: Outlook email
  • Nodes: 12 · Integrations: Outlook, SQL
  • Stored procedures: spPrimeInsertExportAssetUtilisation, spPrimeExportAssetUtilisationSetStale, spPrimeDeleteExportAssetUtilisation

prime DataCentre Email - Conversion Report ​

About the Shared Mailbox One mailbox prime-datacentre-exports@ethosbuilding.com.au with many folders. A Mail rule will move the mail to the correct folder for this trigger to process

  • Triggers: Outlook email
  • Nodes: 10 · Integrations: Outlook, SQL
  • Stored procedures: stored, spPrimeUpsertExportConversionReport