Skip to main content
Question

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


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...

Did this topic help you find an answer to your question?

5 replies

Troy Tessalone
Forum|alt.badge.img+14

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
  • 2 replies
  • August 17, 2023
Troy Tessalone wrote:

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
Forum|alt.badge.img+14

@gravitygone 

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


gravitygone
  • Author
  • Beginner
  • 2 replies
  • August 17, 2023
Troy Tessalone wrote:

@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
  • 7733 replies
  • 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! 🙂


Reply