📖 Introduction
The Lost and Found App is a no-code automation project built using Zapier, designed to help users report, track, and find lost items through automated workflows.
Instead of using traditional programming languages, the project leverages automation tools and integrations to connect platforms like Airtable, Gmail, Google Sheets, and Webflow/Glide.
This demonstrates how powerful no-code platforms can be in creating real-world solutions — without writing a single line of backend code.
⚙️ Key Features
🧾 Submit Lost or Found Items using online forms (Netlify or Google Forms).
🧠 Automatic Data Storage in Airtable or Google Sheets.
📬 Instant Notifications via Gmail when a new item is posted.
🔍 Smart Matching System that compares new “found” items with “lost” ones using Zapier Filters and Paths.
🔔 Email Alerts to both users if a potential match is found.
🌐 Web App Interface built using Glide / Webflow / Softr connected to Airtable.
🧰 Tools & Platforms Used
| Tool | Purpose |
|---|
| Zapier | Core automation and workflow engine |
| Airtable | Database to store lost/found item data |
| Gmail Integration | Email alerts and communication |
| Netlify / Google Form | User input form for submitting reports |
| Webflow / Glide | Frontend UI for displaying items |
| Make.com (optional) | For complex conditional automation |
🏗️ Workflow Architecture
1️⃣ Form Submission
A user submits a Lost or Found item form (with details like name, category, description, and contact).
The form data automatically gets stored in Airtable.
2️⃣ Zapier Trigger
3️⃣ Automation Steps (Example: Lost Item)
Step 1: Trigger → New Record in Airtable
Step 2: Action → Search in Airtable for Matching Found Items
Step 3: Filter → Category and Location Match
Step 4: Action → Send Email via Gmail to both users notifying a possible match.
🔌 Zapier Automation Example
Zap 1. Handle Lost Items
| Step | Action | Description |
|---|
| 1 | Trigger: Airtable (New Record in “Lost Items”) | Starts when someone reports a lost item |
| 2 | Action: Find Record in “Found Items” | Looks for similar found item |
| 3 | Filter: Check if “Category” and “Location” match | Continue only if match found |
| 4 | Action: Gmail (Send Email) | Sends notification to both users |
Zap 2. Handle Found Items
Similar to Zap 1 but reversed — triggers when someone adds a found item.
💾 Airtable Database Schema
| Field | Type | Description |
|---|
| Item Name | Text | Name of lost/found item |
| Type | Dropdown | “Lost” or “Found” |
| Description | Long text | Details about the item |
| Location | Text | Where it was lost/found |
| Contact Email | Email | User email for notifications |
| Date | Date | Date of submission |
💬 Email Notification Example
Subject: Possible Match Found for Your Lost Item!
Body:
Hi {{Name}},
Someone has reported a “{{Found Item}}” that matches your lost “{{Lost Item}}” near {{Location}}.
Please check your dashboard or contact {{Other User Email}} for more details.
– Lost & Found App (Automated via Zapier)
🚀 Deployment
Frontend hosted on Netlify or the Glide App.
Airtable serves as a backend database.
Zapier automates all triggers and workflows.
Gmail is used for notification delivery.
🔮 Future Improvements
Integrate AI text similarity matching using OpenAI API in Zapier.
Add image upload + Cloudinary integration for visual matching.
Create an admin dashboard for verification.
Add Twilio SMS alerts for faster communication.
🏁 Conclusion
The Lost and Found App built with Zapier proves that powerful, practical applications can be created without writing code. Using smart integrations between Airtable, Gmail, and web forms, it demonstrates how no-code automation can replicate the functionality of full-stack systems with minimal effort.