Skip to main content
Best answer

Formatter: Extract Google Review's original language text before sending to ChatGPT

  • September 8, 2023
  • 3 replies
  • 72 views

Petri

Google review comments come in with the Google translated versions (in English) and original versions in the same field. I’ve been trying to use Zapier Formatter in the middle before sending the comments to ChatGPT in order to only send the original language version. Can’t get any kind of results, maybe because of lacking Python skills, does anyone else have the same issue/can help?

Best answer by Petri

Found a solution using Split Text instead.

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

3 replies

Petri
  • Author
  • Beginner
  • September 8, 2023

The comment field looks like this, and I would need to have only the text after (Original):

(Translated by Google) This is the review comment.

(Original) This is the review comment in the original language.


Petri
  • Author
  • Beginner
  • Answer
  • September 8, 2023

Found a solution using Split Text instead.


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

Glad to hear a Formatter (Text > Split Text) action did the trick here @Petri! 😁🎉

Really appreciate you taking the time to circle back here to share how you solved this. I’m sure there will be plenty of folks in the Community here that could benefit from your solution! 🤗