Google Sheets template
Delivery log template for Google Sheets
Scan each parcel as it is handed over and record the outcome. Timestamped rows give you proof and a daily summary.
Download CSV template
Opens in Google Sheets via File → Import
Columns and suggested data types
Row 1 of the sheet holds the column names. In the app, give each column one of these types and the scan form fills itself in.
| Column | App data type | Use |
|---|---|---|
| Time | Timestamp | Recorded on scan. |
| Tracking code | QR / Barcode | The parcel barcode or QR code. |
| Recipient | Text | Name on the parcel. |
| Address | Text | Optional. |
| Status | Select | For example Delivered or Failed attempt. |
| Note | Text | Delivery instructions or issues. |
Tip
Give drivers access to the delivery sheet only. With team access you can limit each person to specific tabs.
Use it in four steps
- 1
Import
File → Import → Upload the CSV into Google Sheets.
- 2
Connect
Add the sheet in the app from Google Drive or as a private sheet.
- 3
Set types
Choose a data type for each column and mark required fields.
- 4
Scan
Scan and send. Rows land in the worksheet.
FAQ
Questions, answered.
How do I import the delivery log into Google Sheets?
Download the CSV, open Google Sheets, choose File → Import → Upload and select the file. Delete the example rows when you are ready to start.
How do I scan into it?
Open the setup guide to connect the spreadsheet, then pick a data type for each column in Scan to Google Sheets and start scanning.
Can I change the columns?
Yes. Edit row 1 in Google Sheets, then tap Refresh columns in the app. The app reads column names from the first row and never changes your spreadsheet.
Start scanning into your new sheet.
Download the app and connect your spreadsheet in minutes.