It used to be so easy, but after the update I simply cant figure it out….
I am pulling data in from active campaign and into a google sheet via google drive, but all data from active campaign (name, email, etc) ends up in the same column. I have tried building it and then edit it several time, but I see no option for how to put the data into different columns in a row. (examle: row 1 column a (email), column b (first name) column c (lastname) etc.
How can this be done?! I have done this many, many times before the very “smart” update.
Question
How to separate data into different columns in Google Sheets
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+3Could you please share how the data is coming in from the Active Campaign, whether it is comma separated or something else. Is the data coming for a single row or multiple rows
Also please make sure your Google Sheet contain headers properly in the top row.
+6- Zapier Staff
Wow! Thank you for confirming the resolution that got the Zap running. This will significantly help our Community members to have as a reference for the same issue.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.