Delivery Breach Report

Email the 5-day breach report for a company.

About

This workflow automates the generation and distribution of a report detailing shipments for company that have breached a 5-day turnaround time (TAT) with Delivery. It queries data from BigQuery to identify orders stuck for over five days. The report is then uploaded and emailed to relevant stakeholders. This workflow is ideal for logistics teams at Puma to ensure timely delivery and identify bottlenecks in the shipping process. By automating this reporting, teams can focus on resolving delays and improving operational efficiency.

How to use this template

Ensure access to BigQuery with the necessary permissions to query data.
Verify that the email addresses for company and Delivery stakeholders are correct.
Set up the schedule trigger to run daily at 4:30 AM.
The workflow will automatically query the database, generate a report, and email it to the specified addresses if breaches are found.
Check your email for the report and take necessary actions based on the data.

FAQs

What happens if no orders breach the 5-day TAT?

If no orders breach the 5-day TAT, the workflow will not send an email.

Can I change the schedule for the report generation?

Yes, the schedule trigger can be adjusted to run at a different time as needed.

Similar Templates

View all

Workflow

Market Research And Business Case Generator

Used by 1k

Automates market research and business case generation via email.

market researchbusiness case+4

Workflow

URL Index Check via Google Search Engine

Used by 1k

Check URL indexing on Google and report via Slack.

urlindexing+5

Workflow

Resume Analysis

Used by 1k

Automates resume analysis and sends evaluation scores via email.

resume analysisemail automation+3