Integration · Spreadsheets
PRACHSO and Google Sheets
Many fleets already keep their papers in a Google Sheet. PRACHSO imports vehicle and driver numbers from it, then reads the real dates from the registry. It can also write a read-only expiry sheet that updates daily, for the partner or principal who still wants a spreadsheet.
- Vehicle numbers and licence numbers (import)Into PRACHSO
- Daily expiry sheet: every truck, every date, every statusOut of PRACHSO
What moves
What is read or written, and which way.
Available on: All plans.
| Data | Direction |
|---|---|
| Vehicle numbers and licence numbers (import) | Into PRACHSO |
| Daily expiry sheet: every truck, every date, every status | Out of PRACHSO |
Setup
3 steps to connect.
PRACHSO's onboarding team does the first import and the mapping with you during the 14-day trial.
- 1
Step 1
Share the sheet with PRACHSO or paste its link. Pick the columns with vehicle and licence numbers. - 2
Step 2
PRACHSO reads each record from the registry. Dates in the sheet are compared, and differences are listed for you. - 3
Step 3
Optional: turn on the daily expiry sheet and share it with whoever needs it.
Field mapping
Where each field lands.
| Google Sheets | PRACHSO |
|---|---|
| Column: Vehicle No. | Vehicle number |
| Column: DL No. | Licence number |
| Column: Branch | Branch |
| PRACHSO: next expiry | Sheet column: Next expiry |
| PRACHSO: status | Sheet column: Status |
How access works
Google OAuth limited to the sheets you pick. The export sheet is written by PRACHSO and overwritten daily, so edits there do not flow back.
Questions about Google Sheets
Do the dates in our sheet get used?
Only as a comparison. The registry record is the source. Where the sheet and the record differ, you see both.
Can the export sheet be filtered by branch?
Yes. Create one export per branch and share each with that branch's team.
Know every expiry before the checkpoint does.
Send us your vehicle list. We load your fleet and show you every date and every pending challan on the call.