Google Sheets quotation marks being dropped

  • 30 September 2021
  • 2 replies

Userlevel 1

The Google Sheets webhook will give me the data of all the columns in a row, but the problem comes when the column contains a quotation mark. “ blabla’blabla “ gets automatically translated to “ blabla “. Is there any way to keep the quotation mark. For example, use `` or “” for JSON.

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

2 replies

Userlevel 6
Badge +6

Hi @ZoBro23 , Can you show me the screenshot of data in Google Sheet and the test data on Zapier?

Userlevel 1

Okay, I fixed it now. Thanks, but I don’t really need your help any more!