DEVLOG #5 — messy sheets, finally cleaned
I got some real feedback after people poked OutreachOS. Many people loved the Tutorial feature :D
one stuck tho: import was too picky about column names. someone uploaded a normal lead sheet with Number instead of Phone Number, and we silently imported leads with empty phones. that’s the opposite of “we clean your messy list.”
so #5 is basically: a bug fix where we stop being precious about headers, and actually clean the sheet.
flexible headers
import now treats common scrapes / hand labels as the same field:
- phone: Number, Mob, Ph No, Contact, WhatsApp, Cell, Landline…
- name: Shop, Firm, Brand, Client, Restaurant, Company…
- maps: Gmaps, Maps Link, Place URL, Source URL, bare goo.gl…
- address bits: City / State / PIN / Zip get merged when the sheet splits them
house / plot / GST “number” columns stay ignored so we don’t invent fake phones.
cleaning that actually helps
- phones: scientific notation from Excel, leading
0/91, multi-value cells (a / b→ first good one) - maps:
HYPERLINK()formulas and scheme-less short links - junk cells:
N/A,NULL, blanks stripped - if a column still looks like phones but didn’t map, the import result warns instead of pretending everything’s fine
other polish since #4
- Premium email fallback when no mail app (“copy the draft”)
- admin can disable accounts with a reason
- OG preview image fixed + sized to 1200×630
try it- live: https://outreachos.techxtreme.me
- import guide: import-guide
- repo: github.com/its-techxtreme/OutreachOS
if your sheet still confuses the mapper, send me the header row — that’s how this list grows.
Comments 0
No comments yet. Be the first!
Sign in to join the conversation.