An end-to-end document automation workflow that generates branded service reports, converts them to PDF and delivers them to clients automatically — triggered by a single status update in Notion.
Watch Project WalkthroughThe challenge
Every completed service request at FlowForge Plumbing required staff to manually create a service report, fill in customer details, export it as a PDF, attach it to an email, send it to the client and update internal records to reflect completion. Each step was straightforward in isolation but together they created a repetitive administrative burden that grew heavier as service volume increased. The process was slow, inconsistent and entirely dependent on staff remembering to complete every step correctly every time. One missed step meant a client did not receive their report or internal records stayed out of date.
The solution
Designed an automated workflow that transforms a validated service request into a completed client deliverable with minimal manual intervention. Once a service request is marked as Processing in Notion, the system validates the request, personalizes the communication, generates a branded report from a Google Docs template, converts it to PDF, emails it to the client and updates the internal record to confirm completion.
Workflow diagram
System architecture
What I built
Fires the entire workflow the moment a service request is marked Processing in Notion.
One status update replaces six manual steps.
Confirms the request is ready for processing before any action is taken.
Prevents incomplete requests from triggering document generation.
Uses Formatter by Zapier to extract the client first name.
Every email greets the client by name rather than using a generic salutation.
Pulls service request data from Notion and maps it into a branded Google Docs template automatically.
No manual report creation required.
Converts the completed Google Doc into a PDF via Google Drive.
Delivers a professional formatted document rather than a raw editable file.
Sends the completed PDF report to the client via Gmail with a personalized greeting.
Client receives their report without any staff involvement.
Marks the Notion service request as Completed and logs that the email was sent.
Keeps internal records accurate without a separate manual update step.
Automation engine
Operational impact
Measurable results
Reduction in manual administrative steps per service request
Improvement in report delivery consistency
Time saved per completed service request
Screenshots
Full 7 step automation from Notion trigger to final record update.
Purpose · Visualizes the end-to-end automation chain.
Service request records showing client details, status and email confirmation.
Purpose · Shows the single source of truth that starts and closes the workflow.
Automated email received by client with PDF report attached.
Purpose · Demonstrates the final deliverable clients receive automatically.
Branded service report showing client information, issue reported and technician notes.
Purpose · Confirms the polished, professional document generated from the template.
Personalized service summary page showing dynamic data population.
Purpose · Shows the personalization achieved through Formatter and template mapping.
Key outcomes
Every completed service request required six manual steps to produce and deliver a client report, creating a repetitive administrative burden that scaled poorly with service volume.
A single Zapier workflow with seven steps connecting Notion, Formatter, Google Docs, Google Drive and Gmail — triggered by one status update.
This project demonstrates automation at the execution level — taking a validated business process and building the logic, personalization and document workflow to run it automatically. The combination of validation filtering, data transformation via Formatter by Zapier and dynamic document generation from a template shows an understanding of how to build automations that are accurate, professional and production ready rather than just functional.
All data shown in screenshots is sample data used for demonstration purposes.