The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
Python CSV Data Cleaning Automation
Description:
I built a Python command-line automation tool that cleans CSV data, standardizes text fields, removes duplicates, handles missing or invalid values, and generates a processing report. The project includes sample input data, cleaned output, a JSON summary report, source code, and simple run instructions. All data is synthetic and created specifically for this portfolio demo.
Skills:
Python · Data Processing · CSV · Automation · Data Cleaning
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Related posts
3 mistakes I see every GoHighLevel user making that creates 100s of duplicate leads:
No deduplication logic between Facebook Lead Ads → GHL
No AI check for same phone/email with different name
No Google Sheets backup before pushing to GHL
I fixed this last week for a client with a simple n8n + AI workflow:
→ Facebook Lead → AI checks duplicate → If clean → GHL + Sheets → Telegram alert
Result: 0 duplicates in 7 days, 6 hours/week saved.
Want the n8n template? Comment "TEMPLATE" and I'll DM you.
#gohighlevel #n8n #leadmanagement #automation
Clean flow. The part I'd watch is the "maybe" pile: couples often share one email or one phone, so a strict duplicate check can silently drop a real second lead. I'd send those to a review tab in the Sheet instead of skipping them. What does yours do with a likely-but-not-certain match?
AI Email Automation with n8n and Google Gemini
An AI workflow that reads every incoming email, sorts it into 6 categories, and takes the right action automatically.
The problem: businesses lose time and leads because customer emails are mixed with promotions, job alerts, and security emails.
What I built:
Gmail Trigger that picks up each new email
AI Text Classifier (Google Gemini) with 6 categories: Security Alert, Promotions, Jobs, Personal, Payments, and Client Inquiries
Automatic Gmail labels for every category
Google Sheets log for jobs, leads, and payments
AI information extraction for client emails (name, phone, service, budget)
AI-written reply drafts for client emails, saved as drafts so a person approves every reply
Instant Discord alerts for security, payment, and client emails
Tools: n8n, Google Gemini, Gmail, Google Sheets, Discord
This project is a working demo built on my own inbox. The same system can be adapted to any business email, such as travel agencies, event venues, stores, recruiters, and consultants.
Impressive workflow! I especially like the human approval step for AI-written replies. Automation with the right oversight makes a real difference. 🙌
How I Built an End-to-End Sales Analytics Dashboard in Excel for an E-commerce Company
I recently completed an end-to-end sales analytics project using Microsoft Excel, transforming raw e-commerce sales data into an interactive dashboard that provides meaningful business insights.
In this project, I explored the data, performed analysis, identified key sales trends, and built an interactive dashboard to help businesses make data-driven decisions.
I documented the entire process, including the approach, tools, analysis, and dashboard development.
Read the full project walkthrough on Medium: https://medium.com/@Refino/how-i-built-an-end-to-end-sales-analytics-dashboard-in-excel-for-an-e-commerce-company-e8692d81f354
Excellent work! Turning raw data into actionable business insights is a valuable skill.