Best answer

Getting Sheets to split text to columns

  • 9 September 2020
  • 1 reply
  • 871 views

Userlevel 1

I want to get my data that comes into sheets from my zap to split into columns without me have to click split text into columns, 

Any tips?

icon

Best answer by AndrewJDavison_Luhhu 9 September 2020, 12:39

View original

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

1 reply

Userlevel 7
Badge +10

@LinKrl 

You’ll most likely be able to do this with a “Formatter->Text->Split” step.

You can break up the incoming string into multiple parts (using the “As separate fields” output type), which you can then map to different columns in your sheet.

https://zapier.com/blog/zapier-formatter-guide/