Rob Diaz, an automotive performance-tuning entrepreneur, was manually fulfilling more than 200 digital-product orders every month. Each completed purchase required him to verify the payment, identify the product type, locate an unused license key, update his inventory, and send a customized confirmation email.
Alltomate built a custom workflow automation that connected Stripe, PayPal, Squarespace, Google Sheets, and Gmail through Zapier. The resulting system automatically classifies each order, assigns the correct license key, updates the inventory, and sends the customer an immediate confirmation email.
The workflow eliminated 10–15 hours of repetitive administrative work each month, equivalent to 120–180 hours per year, while creating an order-fulfillment process capable of supporting increased sales volume without additional fulfillment staff.
Workflow Automation Case Study at a Glance
- Client: Rob Diaz
- Industry: Automotive performance tuning
- Business model: Digital product sales
- Company structure: Solo founder
- Monthly order volume: More than 200 orders
- Technology stack: Zapier, Stripe, PayPal, Squarespace, Google Sheets, and Gmail
- Workflow automated: Payment verification, product classification, license-key assignment, inventory updates, and customer confirmation emails
- Verified time savings: 10–15 hours per month and 120–180 hours per year
The Challenge: Manual Digital-Product Order Fulfillment
Rob sells automotive performance-tuning products that require each customer to receive a unique license key. The correct key depends on whether the customer purchases a Single ECU or Dual ECU product.
Orders were processed through Stripe, PayPal, and Squarespace. Because these sales channels were not connected to Rob’s license-key inventory or email account, every order created a separate manual fulfillment process.
For each completed purchase, Rob had to:
- Log in to the relevant payment or sales platform
- Verify that the payment had been completed successfully
- Identify whether the customer purchased a Single ECU or Dual ECU product
- Open the license-key inventory in Google Sheets
- Find an unused key that matched the product
- Copy the license key manually
- Compose a customized confirmation email in Gmail
- Insert the correct key into the message
- Send the email to the customer
- Return to Google Sheets and mark the key as used
This process was repeated more than 200 times each month.
Ten to Fifteen Hours Lost Every Month
Although the individual steps were straightforward, their combined volume consumed approximately 10–15 hours every month. For a solo founder, that represented time that could not be used for customer support, marketing, product development, or revenue growth.
Risk of Duplicate or Incorrect License Keys
Manually copying keys from a spreadsheet introduced the risk of assigning the wrong key or sending a key that had already been used. An error could prevent a customer from accessing the purchased product and create additional support work.
Delayed Customer Confirmations
Confirmation timing depended on when Rob was available to review his sales platforms and inbox. Customers who completed purchases outside his working hours could not receive their license keys until he returned and processed the order manually.
Growth Increased the Administrative Burden
The previous system created a direct relationship between sales volume and manual work. Every additional sale required another payment check, spreadsheet lookup, inventory update, and customer email.
The business could generate more orders, but its fulfillment capacity remained limited by Rob’s availability.
The Goals of the Custom Workflow Automation
Rob engaged Alltomate to remove the repetitive fulfillment work without replacing the applications his business already used.
The new workflow needed to:
- Detect successful purchases across Stripe, PayPal, and Squarespace
- Capture the customer and order information automatically
- Distinguish between Single ECU and Dual ECU products
- Select the correct unused license key from Google Sheets
- Mark each assigned key as consumed
- Send a product-specific confirmation email immediately
- Reduce duplicate and incorrect key assignments
- Support increased order volume without increasing administrative work
The objective was not simply to automate an email. Alltomate needed to automate the complete operational sequence from successful payment through license-key delivery.
The Alltomate Approach
Alltomate began by mapping the entire order-fulfillment workflow, including the payment triggers, product-classification rules, license-key storage structure, inventory statuses, and communication requirements. This broader business process automation approach helped ensure that the full operational sequence was understood before individual automation steps were configured.
Businesses evaluating similar manual handoffs can use Alltomate’s automation audit checklist to document repetitive tasks, disconnected applications, workflow dependencies, and operational bottlenecks before deciding what should be automated.
Rather than introducing a completely new software environment, the solution was designed around Rob’s existing technology stack. Zapier became the automation backbone connecting every stage of the process. Alltomate’s Zapier automation guide explains how triggers, conditional logic, transformations, and downstream actions can be combined into multi-step workflows across connected applications.
Alltomate supports workflow automation and integration projects across multiple markets and regions. Businesses evaluating similar systems can explore our service locations to learn more about regional availability.
Tools Used in the Automated Fulfillment Workflow
- Stripe: Monitored for successfully completed customer payments
- PayPal: Captured completed transactions from customers paying through PayPal
- Squarespace: Supplied storefront, order, and product information
- Zapier: Connected the applications and controlled the workflow logic
- Google Sheets: Functioned as the structured database of available and consumed license keys
- Gmail: Sent the completed confirmation and license-key email to each customer
Zapier served as the orchestration layer. It received transaction data, evaluated the product, followed the appropriate conditional path, retrieved the correct license key, updated the inventory, and initiated the customer email.
Businesses with similar disconnected systems can use Zapier automation services to connect payment platforms, spreadsheets, databases, email applications, and other operational tools.
How the Custom Workflow Automation Works
1. A Successful Payment Triggers the Workflow
The automation begins when a customer completes a purchase through Stripe, PayPal, or Squarespace.
Zapier captures the transaction immediately and extracts the available order details. This removes the need for Rob to monitor three separate platforms before beginning fulfillment.
Using a completed payment as the trigger also prevents the workflow from delivering a license key for an incomplete or unsuccessful transaction.
2. Customer and Order Data Are Captured
The system automatically extracts the information required to fulfill the order, including:
- Customer name
- Customer email address
- Product purchased
- Order source
- Single ECU or Dual ECU classification
Rob no longer needs to manually copy transaction information from the payment platform into another application.
3. Conditional Logic Identifies the Correct Product Path
Zapier applies predefined filters and conditional paths to determine which fulfillment process the order requires.
- Single ECU purchases: Follow the Single ECU license-key path
- Dual ECU purchases: Follow the Dual ECU license-key path
This routing step ensures that the automation selects a license key from the correct product inventory and sends the appropriate product-specific message. It demonstrates the kind of Zapier Paths and branching logic used when one trigger can lead to different actions depending on the incoming order data.
4. Google Sheets Assigns the Next Available License Key
The workflow searches the Google Sheets license-key database for the next available unused key matching the purchased product.
After selecting the key, the automation:
- Assigns it to the customer’s order
- Passes it to the confirmation-email step
- Marks the key as consumed in Google Sheets
- Prevents the same key from being selected for another order
This replaces the manual process of searching the spreadsheet, copying a key, and returning later to update its status.
5. Gmail Sends a Dynamic Confirmation Email
Once the appropriate license key is selected, Zapier passes the customer, product, and key information into a prepared Gmail template.
The email is automatically populated with:
- The customer’s name
- The product purchased
- The correct license key
- Product-specific messaging
- Relevant activation or support instructions
The completed confirmation email is sent immediately after the order is processed.
6. The License-Key Inventory Is Updated Automatically
The assigned license key is marked as consumed as part of the same connected workflow. The assignment and inventory update no longer rely on Rob remembering to complete two separate manual actions.
During the documented project period, the automated allocation system resulted in zero duplicate license-key distribution.
Before and After the Workflow Automation
| Metric or Process | Before Alltomate | After Alltomate |
|---|---|---|
| Monthly order volume | 200+ orders processed manually | 200+ orders supported through the automated workflow |
| Administrative time | 10–15 hours per month | Removed from standard order fulfillment |
| Annual time requirement | 120–180 hours of repetitive work | 120–180 hours available for higher-value work |
| Payment monitoring | Stripe, PayPal, and Squarespace checked manually | Completed payments trigger the workflow automatically |
| Product classification | Single and Dual ECU orders identified manually | Conditional logic routes each order automatically |
| License-key assignment | Keys searched for and copied manually | The next available matching key is assigned automatically |
| Inventory management | Key status updated manually | The assigned key is marked as consumed automatically |
| Customer confirmation | Dependent on Rob’s availability | Sent immediately after order completion |
Results of the Workflow Automation
Ten to Fifteen Hours Saved Every Month
The automation removed the repeated process of checking transactions, classifying products, finding keys, updating inventory, and composing confirmation emails.
This saved Rob approximately 10–15 hours each month.
One Hundred Twenty to One Hundred Eighty Hours Saved Annually
Across a full year, the monthly reduction in repetitive work represented approximately 120–180 hours that Rob could redirect toward strategic and revenue-generating activities.
Immediate Order Confirmations
Customers no longer need to wait for Rob to review the transaction manually. Standard order confirmations and license keys are sent immediately after the completed purchase triggers the workflow.
Zero Duplicate License-Key Distribution
The connected assignment and inventory-update process eliminated duplicate license-key distribution during the documented project period.
Once a key is allocated, its status is updated automatically before it can be selected for another order.
Consistent Customer Communication
Each customer receives a prepared, product-specific email containing the required purchase information. This standardizes the fulfillment experience across the different sales channels.
Scalable Order Fulfillment
Under the previous process, every additional sale created another set of manual tasks. The automated workflow can process increased transaction volume without creating the same proportional increase in Rob’s administrative workload.
The fulfillment infrastructure did not require additional staff to support the automated standard-order process.
More Time for Higher-Value Work
With repetitive fulfillment work removed, Rob can devote more attention to:
- Strategic marketing initiatives
- Customer engagement and technical support
- Product development and expansion
- Following up with high-intent prospects
- Revenue-growth activities
- Orders or exceptions that genuinely require manual review
Client Testimonial
“It was great success 😄 thank you”
— Rob Diaz
Why This Custom Workflow Automation Worked
The automation worked because Alltomate treated fulfillment as one connected operating sequence rather than a series of unrelated tasks. Stripe, PayPal, and Squarespace supplied completed-order data, Zapier classified each order and coordinated downstream actions, Google Sheets controlled license-key availability, and Gmail delivered the final customer communication.
Product-specific routing, license-key allocation, and inventory updates occurred within the same workflow, reducing the risk that one fulfillment step happened without the others. Standard orders could move automatically from payment through delivery, while unusual cases or exceptions remained available for manual review.
What the Rob Diaz Project Shows About Custom Workflow Automation
The Rob Diaz project shows that custom workflow automation is most effective when an entire repeatable operating sequence is designed as one connected system rather than automating isolated tasks independently.
- Start from a reliable operational trigger: Fulfillment begins only after a completed purchase is detected.
- Classify before taking action: Product type determines which license-key inventory and customer message the workflow should use.
- Keep allocation and inventory status connected: Assigning a key and marking that key as consumed are handled as part of the same operational sequence.
- Move order data once: Customer and purchase information flows through the workflow without repeated manual copying between systems.
- Automate standard fulfillment while preserving exceptions: Routine orders can move automatically, while situations that require judgment remain available for manual review.
Other workflows such as refund processing, subscription lifecycle management, cancellation handling, additional internal notifications, or automated error-alert systems may also be candidates for automation, but they were not part of the Rob Diaz implementation described in this case study.
Build a Custom Workflow for Your Business
Alltomate provides automation and integration services for businesses that need to connect payment platforms, spreadsheets, databases, email systems, and other operational applications.
Request a free business process audit to identify which parts of your order, fulfillment, or administrative workflow can be automated.
For another implementation example, see how Alltomate created a practice management automation system that connected website inquiries, contact records, digital-resource delivery, and follow-up communication.
You must be logged in to post a comment.