Align calendars, import records, verify file transfers. Every one is ready to run, and you can adjust it in plain language.
Apply import rules to incoming entries and catch duplicate keys.
Turn emailed entry requests into database rows, with a reply that confirms the ID or tells the sender what to fix.
Validate incoming Excel records and report fixes to the owner.
Get valid Excel rows into PostgreSQL and a chat report showing how many went in and what needs fixing.
Keep duplicate and incomplete roster rows out of shared CSVs.
You get a clean CSV from revised Excel rosters, plus a matching list of rows to correct in your shared handoff folder.
Check monthly exports before placing them in the shared folder.
Get a dated CSV and row count in your shared folder every month, or an error note explaining why the export stopped.
Import each incoming CSV once and record its result.
Keep your PostgreSQL table current as CSV files arrive, with a row count or a clear reason when an import needs attention.
Import valid business records and file errors beside each batch.
Get valid records into your document collection, plus an import count and a CSV showing which entries need correction.
Import customer files and surface records that need review.
See new and changed customers in your list, plus a report of entries needing your review after a JSON export.