ProMonkey
Staffing & recruitment

KTR Freight: From Google Sheets to One Staffing and CRM Platform

KTR Freight is a 4PL freight forwarder that moves cargo from Asia to the United States, with one team owning the lane from the factory floor in Asia to the job site in America. Its staffing and CRM work used to run on Google Sheets. ProMonkey built KTR Freight's website, a CRM, recruiting tools, and a staffing and HR solution with WhatsApp follow ups, timesheets, pay and bill, and commissions, so that work now runs in one connected system.

India and United States
KTR Freight
Illustrative

Overview

What we built

  • Website Design and Development
  • Custom CRM Development
  • Recruiting Tools
  • Staffing and HR Platform

The story

From the old way to a system that runs itself.

We replaced a set of Google Sheets with one system: a CRM, recruiting tools, and a staffing and HR solution covering timesheets, pay and bill, and commissions, alongside a new public website at ktrfreight.com.

The Challenge

BeforeStaffing and CRM work spread across Go…

Staffing and CRM work spread across Google Sheets

KTR Freight describes itself as deliberately narrow and operationally heavy. According to its website, it runs Asia to US lanes for energy infrastructure and the equipment that powers it: transformers, beams, coils, insulators, solar modules, semiconductors and data center equipment. Its desks in Gurugram and Mumbai work while US ports are closed, and it has a US office in Naperville, Illinois.

Before ProMonkey, KTR Freight ran its staffing and CRM work on Google Sheets. Spreadsheets are a sensible way to start, but they strain as the work grows:

  • Records live in separate tabs and files, so there is no single, current view of candidates, contacts and the pipeline.

  • The same details get typed into more than one sheet, and copies drift out of date.

  • Follow ups depend on someone remembering to send them, and conversations on WhatsApp are not tied to the record they belong to.

  • Timesheets, pay and bill, and commissions are worked out by hand from rows and formulas, where one wrong cell can carry through.

  • There is little history of who changed what, and sharing a sheet means sharing all of it.

KTR Freight needed one system that matched how its team already worked, without the copy and paste.

What We Built

The buildOne CRM for the people side of the bus…

One CRM for the people side of the business, plus a new website

A CRM. One place for KTR Freight's records and pipeline, replacing the separate sheets and built around how the team actually works rather than a rented product's default layout.

Recruiting tools. Applicants come into one pipeline, so the team can review, follow up and move candidates forward without retyping records.

WhatsApp and email follow ups. The team follows up on WhatsApp and email from the same system, and each follow up is logged against the record it belongs to.

A staffing and HR solution. Temp and contract modules for timesheets, pay and bill, and commissions, built into the same system as the CRM and recruiting tools, so hours, billing and commissions are worked out from the same records instead of separate spreadsheets.

The website. A public site at ktrfreight.com that explains the lane end to end, walks shippers through each handoff from origin to final mile, presents the services, industries, expertise and network pages, and offers a lane quote request that asks for origin, commodity, dimensions, weight, destination and the date the cargo has to be on site.

The buildHow it works

How it works

Records in one place, with people deciding the steps that matter:

  1. Records are created once. Candidates, contacts and pipeline records live in the CRM instead of across several sheets.

  2. Applicants move through one pipeline. Candidates are tracked through the stages the team defines.

  3. Follow ups go out on the right channel. The team sends follow ups on WhatsApp or email from the CRM, and every follow up stays on the record.

  4. Temp and contract work is tracked end to end. Timesheets feed pay and bill, and commissions are calculated in the same system rather than rebuilt by hand in a spreadsheet.

  5. People stay in control. Hiring decisions, pay and client conversations stay with the KTR Freight team. The system keeps the records and the history so those decisions are faster and easier to check.

The Impact

The buildWhat the build gives KTR Freight

What the build gives KTR Freight

  • Staffing and CRM work in one system instead of Google Sheets.

  • One recruiting pipeline, with each candidate recorded once.

  • WhatsApp and email follow ups sent from the CRM and logged against each record.

  • Timesheets, pay and bill, and commissions handled in the same system as the people records they depend on.

  • A website that presents a specialist Asia to US 4PL offer page by page, with one consistent way for shippers to request a lane quote.

Still running hiring, timesheets and pay in spreadsheets? Book a discovery call.

Frequently asked questions

The things people ask most about this project.

Still curious?

Ask us anything about how we built it.

Ask a question
  • A CRM, recruiting tools, and a staffing and HR solution with WhatsApp follow ups, timesheets, pay and bill, and commissions, plus the public website at ktrfreight.com.

Want resultslike these?

Tell us what's slow in your business. We'll show you what to automate first, with a fixed price and no surprises.