Skip to main content

Hi everyone,

 

I’m running into an issue with a Zap I set up between Google Sheets and another app. The Zap is supposed to pull data from a Google Sheet, including an email column, but while all the other fields (like name, phone, etc.) come through fine, the email field keeps coming through as blank.

 

Here’s what I’ve checked so far:

 

  • The Google Sheet email column is named clearly (no special characters, just “Email”).

  • The cells in the email column are formatted as plain text.

  • The first few rows contain valid sample email addresses (so Zapier has something to pull in tests).

  • I’ve tried refreshing the fields in Zapier and reselecting the spreadsheet/worksheet.

  • I also tried copying the emails to a new column and mapping that instead, but it didn’t help.

 

Has anyone run into this issue before? Any suggestions on what else I can try?

 

Thanks a lot!

 

here is a screenshot:


 

Hi ​@wim.h 

Check the data in the Email column for Row ID/Number 101 as shown in your screenshot example.

 


Hi ​@wim.h 

Check the data in the Email column for Row ID/Number 101 as shown in your screenshot example.

 

Hey ​@Troy Tessalone thank you for your answer in ROW 101 there is an email in sheets.

here is and image. Is that what you meant?

 


@wim.h 

For us to have more info, post these screenshots:

  • how your Zap steps are outlined
  • how your Zap steps are configured in EDIT mode with the field mappings visible
  • how your GSheet header row is configured

Hey ​@Troy Tessalone, thank you for your answer!

I just played around and i noticed it randomly started working. maybe it needed some time to synch or something. 

Thank you for your help its running as intended now.

All the best,

Wim


Wow! Thank you for confirming that Troy’s resolution got the Zap running. This will significantly help our Community members to have as a reference for the same issue.


Reply