Google Sheets Automation Expert – Build Bullet-Proof Lead & Inventory Tracking System (Notifications / Status Logic)
Budget: €30 – €250 EUR
We are looking for an advanced Google Sheets / Apps Script / Automation expert to upgrade our current Google Sheets system used for automotive inventory tracking and marketing workflow.
The goal is to make the system bullet-proof, automated, and safe for multiple users, with automatic notifications and status logic connected to our marketing team.
We already have a working sheet, but we need a senior expert to rebuild / optimize / automate it.
Project context
We manage car inventory for a dealership group and use Google Sheets to track:
• cars in stock
• ads status
• video status
• sales status
Multiple people edit the file:
• sales agents
• marketing team
• video team
• management
Because of this, the system must be safe and automated.
Main tasks
1. Inventory workflow logic
Sales agents add new cars in the sheet.
Each row contains:
• Model
• Consultant
• VIN
• Stock age
• Status
• Video status
• Ad status
• Price
We need validation, dropdowns, protected ranges, and automation.
2. Status change automation
When Status changes to:
• SOLD
• RESERVED
• TRANSFER
• MOBILITATE
The system should automatically:
• send notification to Ads team
• send notification to Marketing
• highlight row
• lock editing if needed
Notification via:
• email
3. Price change automation
When price changes:
• detect change automatically
• log old price / new price
• send notification to Ads team
Example:
“Price changed for VIN XXXXX – update Facebook Ads”
4. Ad status logic
Columns:
• Video = YES / NO
• Ad active = YES / NO
• Status = AVAILABLE / SOLD / RESERVED / TRANSFER
We need logic like:
IF Status = SOLD
→ Ad must be NO
→ notify team
IF Video = NO
→ highlight row
IF Ad active = YES but Status ≠ AVAILABLE
→ error highlight
5. Notifications system
We need automatic notifications when:
• car sold
• price changed
• new car added
• video missing
• ad active but car sold
Prefer:
• Google Apps Script
• email notifications
6. Multi-user safe editing
We need:
• protected columns
• user permissions
• dropdown only editing
• no manual typing where not allowed
• no formula breaking
System must be safe even with 10+ users editing.
7. Dashboard / summary (optional but preferred)
We want summary:
• cars in stock
• cars with ads active
• cars without ads
• sold cars
Required skills
• Advanced Google Sheets
• Google Apps Script
• Automation / triggers
• Data validation / protected ranges
• Workflow logic
• Experience with multi-user sheets
The goal is to make the system bullet-proof, automated, and safe for multiple users, with automatic notifications and status logic connected to our marketing team.
We already have a working sheet, but we need a senior expert to rebuild / optimize / automate it.
Project context
We manage car inventory for a dealership group and use Google Sheets to track:
• cars in stock
• ads status
• video status
• sales status
Multiple people edit the file:
• sales agents
• marketing team
• video team
• management
Because of this, the system must be safe and automated.
Main tasks
1. Inventory workflow logic
Sales agents add new cars in the sheet.
Each row contains:
• Model
• Consultant
• VIN
• Stock age
• Status
• Video status
• Ad status
• Price
We need validation, dropdowns, protected ranges, and automation.
2. Status change automation
When Status changes to:
• SOLD
• RESERVED
• TRANSFER
• MOBILITATE
The system should automatically:
• send notification to Ads team
• send notification to Marketing
• highlight row
• lock editing if needed
Notification via:
3. Price change automation
When price changes:
• detect change automatically
• log old price / new price
• send notification to Ads team
Example:
“Price changed for VIN XXXXX – update Facebook Ads”
4. Ad status logic
Columns:
• Video = YES / NO
• Ad active = YES / NO
• Status = AVAILABLE / SOLD / RESERVED / TRANSFER
We need logic like:
IF Status = SOLD
→ Ad must be NO
→ notify team
IF Video = NO
→ highlight row
IF Ad active = YES but Status ≠ AVAILABLE
→ error highlight
5. Notifications system
We need automatic notifications when:
• car sold
• price changed
• new car added
• video missing
• ad active but car sold
Prefer:
• Google Apps Script
• email notifications
6. Multi-user safe editing
We need:
• protected columns
• user permissions
• dropdown only editing
• no manual typing where not allowed
• no formula breaking
System must be safe even with 10+ users editing.
7. Dashboard / summary (optional but preferred)
We want summary:
• cars in stock
• cars with ads active
• cars without ads
• sold cars
Required skills
• Advanced Google Sheets
• Google Apps Script
• Automation / triggers
• Data validation / protected ranges
• Workflow logic
• Experience with multi-user sheets