Excel Bayo's Work | Contra
Work by Excel Bayo
Sign Up
Post a job
Sign Up
Log In
Excel Bayo
AI & Automation Specialist | Make.com Expert
Message
Follow
New to Contra
Excel is building their profile!
Followed by
GALLERY L
Lagos, Nigeria
Work
About
Lagos, Nigeria
0
I built this Make.com (http://Make.com) automation to streamline the process of collecting, checking, and organizing Google Forms submissions in Google Sheets. The workflow automatically captures new form responses, searches the spreadsheet for existing records, and uses a Text Parser to identify and match relevant information. A Router then determines whether the submission is a new record or an existing one. For new submissions, the automation automatically adds a new row to Google Sheets. If the record already exists, it updates the existing row instead of creating a duplicate. This automation helps reduce manual data entry, prevent duplicate records, improve data accuracy, and keep spreadsheet information organized and up to date. Tools used: Make.com (http://Make.com), Google Forms, Google Sheets, Text Parser, and Router. Key features: Automated form response collection Spreadsheet record searching Text/data matching Duplicate detection Conditional routing Automatic row creation Automatic existing-row updates Reduced manual data processing
0
6
1
I designed and built an AI-powered lead management automation using Make.com (http://Make.com) to streamline the process of receiving, analyzing, organizing, and communicating lead information. The workflow starts with a custom webhook that receives incoming data, then searches Google Sheets to check existing records. OpenAI analyzes and classifies the information, while JSON parsing converts the AI response into structured data for reliable processing. Using conditional logic, the system automatically determines whether a lead is new or already existing. New leads are added to Google Sheets, while existing records are updated. Automated Gmail notifications are then triggered, and the results are merged and sent to Slack for team visibility. Key Features Webhook-based lead capture AI-powered data analysis and classification JSON data parsing Google Sheets database management Conditional lead routing Automated Gmail notifications Slack team notifications End-to-end workflow automation Tools: Make.com (http://Make.com), OpenAI, Google Sheets, Gmail, Slack, Webhooks & JSON.
1
21