Skip to main content
Question

Data not appearing in Google Sheets row despite successful test results

  • June 7, 2025
  • 5 replies
  • 33 views

Hello, 

I have been trying to figure this out for last 4 hours.

I am pulling multiple rows from google sheet 

this is the outcome when i test:

Then i attach a formatter after it:

and it shows that rows have no data? 

but when i run test it, data is there:

?

and i am unable to tidy it up

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

5 replies

  • Author
  • New
  • 2 replies
  • June 7, 2025

Bump?


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • 34072 replies
  • June 7, 2025

Hi ​@Wizardofrice 

For us to have more info, post screenshots showing how your GSheets Zap step is configured in EDIT mode with the field mappings visible.


  • Author
  • New
  • 2 replies
  • June 7, 2025

Hi ​@Wizardofrice 

For us to have more info, post screenshots showing how your GSheets Zap step is configured in EDIT mode with the field mappings visible.

Hey thanks for reply, attaching more screenies
 

Zap setup
Google sheets setup

My goal is for this zap to look up given value from /8th zap of - (main tag, and second tag) - and give me a list of row information that match these tags together. so if i have input from 8th zap saying → Naturalistic + Scifi. This zap finds every asset name that has Naturalistic + SciFi tags together, and give me a list of all of them.

 

Thank you


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • 34072 replies
  • June 8, 2025

@Wizardofrice 

Try this change, so the data is not returned as nested line items.

Field: Select value for if multiple search results are found

Value: Return first search result. Step run status is “success”. (Default)

 


SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • 9736 replies
  • June 17, 2025

Hi there, ​@Wizardofrice 👋

Just wanted to check in to see how you got on with Troy’s suggestion here—did selecting the Return first search result option do the trick?

Keen to make sure everything’s now sorted, so please keep us posted on how it went!