How to pull name and email from Google Sheets to send personalised emails?

Hi ​@Pinkmicconsulting 

Your spreadsheet doesn't have headers (like "Name" or "Email" in row 1), so Zapier just shows you those weird COL$A codes instead of friendly names .

Here's how to make it work:

Step 1 – Set up the trigger the right way
When you're in the Google Sheets trigger, pick a specific column to watch. Don't pick "Any column" or "Static" – that'll just confuse things . Pick the column that gets filled when a new lead comes in (like a timestamp or the first column with data).

Step 2 – Run a test
Click "Test trigger" to pull in one lead from your sheet. This is important - it shows Zapier what the actual data looks like .

Step 3 – Map the fields in your email
Now in your email action (like Gmail), here's the simple trick:

• For the "To" email field: pick COL$I from the dropdown (that's column I where your emails live)

• For personalizing the name in your message: pick COL$H (that's column H with the names)

When you pick them from the dropdown instead of typing them, Zapier automatically pulls the right info for each lead .

Quick tip: Add a header row to your sheet (row 1 with "Name" and "Email" in those columns). Then refresh your Zap and you'll see actual words instead of those COL$A codes.

Hope this helps!