Skip to main content
Question

Zapier Utilities formatter Line-Item to Text & Text to Line-Item not working for Google Sheets search.

  • August 17, 2023
  • 5 replies
  • 143 views

gravitygone

Hi,

So it seems that the output for Zapier Utilities formatter Line-Item to Text & Text to Line-Item is not giving me the appropriate response needed to to do a line-item Google Sheet Search. I’m using both Utilities’ type because I read in two other Community Support Threads that the value being formatted is already an array or something other than a comma separated list.

 

Below are some screenshots:

 

I am attempting to use the Nouns value from ChatGPT response.
Line-Item-to Text
the response from Utilities
Utilities Text-To Line Items
The response from Text-To Line-Items
Searching using the response

:(

 

I am not sure what is going...the data is there:

Any insight would help...

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

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • August 17, 2023

Hi @gravitygone 

Good question.

The GSheet Lookup Value field doesn’t work with line items, but will return line items (aka 0+ rows) for the matching lookup value.

 


gravitygone
  • Author
  • Beginner
  • August 17, 2023

Hi @gravitygone 

Good question.

The GSheet Lookup Value field doesn’t work with line items, but will return line items (aka 0+ rows) for the matching lookup value.

 

Gotcha...What would be the best way to iterate through the values and search each row? By JS code? or is there a zap tool that can do this?


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • August 17, 2023

@gravitygone 

You can use the Looping app: https://zapier.com/apps/looping/help


gravitygone
  • Author
  • Beginner
  • August 17, 2023

@gravitygone

You can use the Looping app: https://zapier.com/apps/looping/help

This one is new to me. Thanks!


SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • August 21, 2023

Hey there, @gravitygone! 👋 Have you had a chance to try out Troy’s idea of adding Looping by Zapier action to the Zap yet? If you're running into any snags on that, do let us know. Always happy to lend a hand! 🙂