Goodmerch Supply, based in Honolulu, is a creative powerhouse specializing in custom promotional products designed to leave a lasting impression.
As Goodmerch Supply expanded its global reach and diverse product offerings—from custom apparel to corporate gifts—the complexities of managing highly personalized orders became increasingly burdensome. Their existing process for converting initial client inquiries and detailed specifications into internal work orders, design briefs, and production requests was largely manual. This involved:
Manual Data Entry: Sales representatives manually transcribed client requirements from various communication channels into internal tracking sheets and documents.
Time-Consuming Document Generation: Creating tailored work orders for production, detailed design briefs for the creative team, and internal quotes required significant administrative effort, often involving copy-pasting and formatting.
Communication Silos: Information hand-offs between sales, design, production, and finance were often fragmented, leading to delays and potential miscommunications.
Risk of Errors: Manual data transfer introduced a high risk of transcription errors, impacting design accuracy, production schedules, and ultimately, client satisfaction.
Scalability Concerns: The administrative overhead associated with manual processing limited the company's ability to efficiently handle a growing volume of custom orders without increasing staff or slowing down turnaround times.
These challenges led to slower order fulfillment, increased operational costs, and diverted valuable time from creative design and client engagement to repetitive administrative tasks.
Recognizing the critical need for a more efficient and accurate workflow, Goodmerch Supply sought an automation solution that could integrate seamlessly with their existing Google Workspace environment. They discovered Jivrus Form Director, a powerful Google Workspace add-on designed to automate workflows triggered by Google Form submissions.
Goodmerch Supply implemented Form Director to transform its entire custom order intake and processing. The solution centered around:
Automated Client Order Forms: Clients now submit their detailed custom order requirements through a comprehensive Google Form.
Instant Document Generation: Upon submission, Form Director instantly triggers the creation of critical internal documents:
* A detailed Work Order (Google Doc converted to PDF) is generated for the production team, outlining all specifications.
* A comprehensive Design Brief (Google Doc) is created for the creative team, ensuring all design nuances are captured.
Centralized Data Tracking: All submission data is automatically appended to a master Order Tracking Google Sheet, providing a real-time, centralized repository for all orders.
Real-time Notifications: Automated email notifications are sent to relevant departments (sales, design, production, and finance), instantly informing them of new orders and providing direct links to the generated documents and tracking sheet.
This integrated approach eliminated manual data entry, streamlined communication, and ensured that every order was accurately processed from the moment of submission.
The implementation of Form Director at Goodmerch Supply was systematic and user-friendly, allowing their team to quickly configure the automated workflow:
1. Google Form Design: The team designed a detailed Google Form that captured all necessary information for a custom promotional product order, including product type, quantity, branding requirements, design notes, preferred colors, and delivery timelines.
2. Template Preparation: Goodmerch created professional Google Docs templates for their `Work Orders` and `Design Briefs`. These templates incorporated placeholders (e.g., `{{Client Name}}`, `{{Product Description}}`, `{{Quantity}}`) that Form Director would dynamically populate.
3. Form Director Configuration:
* Using Form Director's intuitive GUI, the team mapped the fields from their Google Form directly to the placeholders in their `Work Order` and `Design Brief` Google Docs templates.
* Conditional logic was set up to handle variations, for instance, tailoring specific sections of the `Work Order` based on whether the order was for "screen printing" or "embroidery."
* Services were configured to automatically generate PDF versions of the `Work Orders` for ease of distribution and record-keeping.
* A "Google Sheet Append Row" service was added to update the main `Order Tracking Sheet` with each new submission.
* Email notification services were set up to send alerts to specific team members in sales, design, and production with direct links to the generated documents and the updated tracking sheet.
4. Testing and Rollout: Extensive testing was conducted with various order scenarios to ensure the automation functioned flawlessly, generating accurate documents and sending correct notifications before the system was fully rolled out to the entire team and clients.
The implementation of Jivrus Form Director delivered significant, measurable benefits to Goodmerch Supply, transforming their operational efficiency and accuracy:
80% Reduction in Document Generation Time: The time taken to generate internal work orders and design briefs was slashed from hours to mere minutes per order, allowing the team to focus on core tasks.
Elimination of Manual Data Entry Errors: Automation ensured that client-submitted data was accurately transferred directly into internal documents and tracking sheets, virtually eliminating transcription errors.
Streamlined Order-to-Production Workflow: The entire process, from client inquiry to the initiation of design and production, became significantly faster and more coherent.
Enhanced Cross-Departmental Communication: Instant, automated notifications kept sales, design, production, and finance teams simultaneously informed of new orders and their details, fostering seamless collaboration.
Improved Scalability: Goodmerch Supply can now efficiently handle a higher volume of custom orders without increasing administrative overhead, supporting their growth objectives.
Professional and Consistent Documentation: All generated documents maintain a consistent, professional appearance, reinforcing Goodmerch's brand image and attention to detail.
Building on the success with Form Director, Goodmerch Supply has several exciting opportunities to further enhance its automation strategy with other Jivrus Technologies products:
Form Presenter: Could be used to create interactive design approval forms or product configurators for clients, allowing them to visualize custom options and provide real-time feedback, further enhancing the client experience.
Sheet Director: To automate the flow of data from their `Order Tracking Sheet` to other external systems (e.g., a simple client portal for order status updates, or a specialized CRM/ERP if implemented) for two-way synchronization.
Fillable Document: To generate more complex, multi-page client proposals, contracts, or detailed production specifications that require review, e-signatures, or dynamic content based on order value or product type.
AppiWorks: For advanced integration needs that extend beyond Google Workspace, connecting to specialized design software, inventory management systems, or shipping platforms for end-to-end hyper-automation.
Jivrus Technologies is a software products company focused on intelligent integration and hyper-automation. "Form Director" is a Google Workspace add-on that enables intelligent routing of Google Form responses to various applications and services, helping users streamline workflows, enhance productivity, and connect seamlessly across platforms.