Overview
For sites with a basic 'contact us' form that does not need a full lead pipeline, this template is deliberately minimal. Five workflow columns, a Status column, and a starred-priority checkbox.
Column layout
Copy this column order into a blank Google Sheet, or let SheetLink Forms create the headers for you on first submission.
| Column | Notes |
|---|---|
| Submission ID | Unique ID |
| Timestamp | When submitted |
| Name | |
| Subject | If your form captures it |
| Message | Body |
| Source (UTM) | Marketing attribution |
| Read? | Boolean - flip to TRUE as you review |
| Priority? | Boolean - star rows that need action |
| Responded? | Boolean - flip once you reply |
| Notes | Freeform |
Useful formulas
Paste these into a top-of-sheet summary row or a separate dashboard tab.
Unread count
=COUNTIF(H:H,FALSE)Put at top of sheet.
Starred unresolved
=COUNTIFS(I:I,TRUE,J:J,FALSE)Conditional formatting
- Priority column: bright yellow background when TRUE.
- Read column: rows dimmed when TRUE - keeps the sheet visually fresh on unread items.
Pivot table guidance
Not needed for a sheet this small - a simple filter view on 'not responded' is usually sufficient.