01 / 16
Prepare the spreadsheet first
Open Google Sheets and create a new blank spreadsheet. Name it, then put your column headings in row 1 and nothing else.
Getting the headers in before you touch n8n matters: the Sheets node reads row 1 to build its field list. An empty sheet gives you an empty dropdown and a confusing five minutes.
Sheet name
Enquiries
Row 1 headers
Timestamp | Name | Email | Message
One heading per cell, left to right.
Checkpoint
Your spreadsheet has four headings across row 1 and no other data.