Skip to main content

Hi, i am getting some really wierd formatting on Nordic Letter when extracting text from Gmail and then putting it in Google Sheets. 

 

Example: 

How it should look: 

Vi bestämde oss för en sittning på tisdag. Lycka till

 

How do i solve this bug?

When testing in Zapier it does not look like this. 

Hi @Ratkiff!

It would be really helpful to know more about what you’re seeing. Is your screenshot what the Zap put into the Google Sheet? And when you say it worked in the test, do you mean that the letters were correct in the Google Sheet then? 

Also, something that would be really helpful is to check the data in and data out for the Google Sheets step as that can tell you what bit of the Zap is causing the issue.  If you go to the Zap history and click on a Zap run it will show you what happened in each step of the Zap as it ran. Look at the Google sheets step and click on the Data in and Data Out tabs (you can learn more about the Data in/Data out tabs in this help guide). The Data In is what Zapier sent to Google sheets and the Data Out is what Google Sheets sends to tell us what’s been added to the sheet. If the Data In is wrong, then we know it’s something from a previous step. If the Data in is right, but the Data Out is wrong, then something is happening when it reaches Google Sheets. 

 

Let us know what you find and we’ll see if we can help!


Reply