Company:
Team size:
7 peoples
Localisation:
Poland 🇵🇱
Language
Polish🇵🇱, German🇩🇪, English🏴
Cooperation type:
One-time implementation
Time savings:
About 250hours monthly due to build platform and automate backoffice Depends on cars and clients base
Introduction
Autohauslager, a platform for car sales intermediaries, needed a system to automate communication and display available cars between sellers and buyers.
The main challenge was synchronising car information between both parties.
Client Background
Autohauslager connects car sellers and buyers through a streamlined platform.
Sellers add cars for sale, and buyers browse and purchase them.
The admin controls visibility of cars via an internal "Backoffice" system.
Buyers view cars on an external marketplace.
Challenge
Autohauslager struggled with synchronizing car information between sellers and buyers. Additionally, margin details needed to be accessible only to the business owner.
Solution
We developed a web application and backoffice system with the following features:
- Adding cars and clients
- Automatic notifications for car and client verification
- Automatic reservation notifications
- Email notifications about new cars
- Integration of Airtable, Bubble.io, and Sendgrid via Make.com
- Real-time data updates
- Centralized management in Airtable
- External marketplace for buyers
- Email templates in Sendgrid for personalized communication
- Margin details restricted to the business owner
- Automatic content translation using Weglot
Implementation
We developed a comprehensive system consisting of a web application and a backoffice, enabling various functionalities:
Web Application (Autohauslager.com)
- Allows buyers to view available cars.
- Includes automated notifications for:
- New car additions.
- Progress of car verification.
- Car reservation statuses.
Backoffice System
- Enables employees to manage which cars are displayed on the platform.
- Centralized management of clients, cars, and orders using Airtable.
Automation and Integration
- Automated email notifications for new cars, progress updates, and reservations via Sendgrid.
- Data and process integration between Airtable, Bubble.io, and Sendgrid using Make.com.
- Real-time data synchronization between sellers and buyers.
- Automated content translation on the site using Weglot.
Result
The implementation resulted in significant time savings and improved efficiency.
Communication Automation:
- Email notifications about new cars and car verification saved 208 hours per month (5 minutes per car/client, 50 cars, 50 clients).
- Reservation notifications streamlined the process.
Data Synchronization:
- Real-time updates between sellers and buyers saved 10-20 hours weekly.
Centralized Management:
- Admins control car visibility, manage clients, cars, and orders centrally, saving 10-20 hours weekly.
Efficient Sales:
- External marketplace viewing saved Autohauslager 4 hours monthly (5 minutes per client, 50 clients).
- Buyers accessed cars in real-time without team involvement.
Translation Automation:
- Weglot automated multi-language content translation, saving several days of manual translation.
Total time savings: We saved about 250hours monthly due to build platform and automate backoffice
Technologies used
Tool | Purpose |
Airtable | Internal CRM for managing clients, cars, and orders. |
Bubble.io | Web application for buyers to view available cars. |
Sendgrid | Email communication with dedicated templates. |
Make.com | Data and process integrator between Airtable, Bubble.io, and Sendgrid. |
Weglot | Automated content translation. |
Conclusions
The Autohauslager platform enhanced communication, centralized data management, and streamlined sales processes.
This resulted in significant time savings and improved operational efficiency, enabling the client to focus on growing their business.
Total time savings: We saved about 250hours monthly due to build platform and automate backoffice
Manual vs Automation approach
Process | Manually | Automatically |
Communication Automation | Employee manually sends emails about new cars to clients. | System automatically sends email notifications about new cars to clients after approval and adding a few additional details. |
Communication Automation | Employee manually informs the client about the progress of car addition and verification. | System automatically notifies the client about the progress of car addition and verification. |
Communication Automation | Employee manually sends notifications about car reservations. | System automatically sends notifications about car reservations. |
Data Synchronization | Employee manually updates data between different systems for sellers and buyers. | Make.com automatically integrates data and processes between Airtable, Bubble.io, and Sendgrid. |
Data Synchronization | Employee manually updates data in real-time between sellers and buyers. | System automatically synchronizes data between sellers and buyers. |
Centralized Management | Employee manually decides who sees a specific car and manages it in several systems. | Backoffice allows administrators to decide who sees a specific car from a central location. |
Centralized Management | Employee manually manages clients, cars, and orders across several different systems. | Centralized management of clients, cars, and orders in Airtable. |
Effective Sales | Employee manually shares car information across various platforms. | Cars can be viewed on an external marketplace platform. |
Effective Sales | Employee creates and sends personalized emails to clients. | Dedicated email templates in Sendgrid enable quick and personalized communication. |
Personalization and Control | Employee manually shares sales margin information only with the company owner. | Sales margin information is available only to the company owner in the system. |
Personalization and Control | Employee manually manages client relationships and updates data across various systems. | Internal CRM manages client relationships and automatically updates data. |
Translation Automation | Employee manually translates content on the site into different languages. | Weglot automatically translates content on the site into multiple languages. |
Sales funnel diagram
