Skip to main content
Best answer

How to you add information into different columns when creating a new row in Google Sheets?

  • July 17, 2021
  • 2 replies
  • 946 views

I am trying to create a step in my zap that will Create Spreadsheet (Google Sheets) with new headers in the columns. I added all my selections from a previous sheet in the zap. The problem is that it keeps creating the sheet with all the headers in the same cell. I cannot find any documentation on this Action or I would not have come here. 

 

Any thoughts?

Best answer by SamB

Just wanted to follow up here for anyone that’s also running into this issue, to add that this behaviour happens when the different header names are put into a single field in the Zap.

When manually setting the names for each header column they should be put into separate fields - as per column3 and column4 in the example below:
6a2578c84fa8b157957a0f52f8840fcb.png

If the header names are all added into a single field like column1,column2, they will be added to a single header cell in the spreadsheet that is created: 

ec5825c5824033a9cea311b6b23a15b1.png

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

Wemakefuture
Forum|alt.badge.img+8
  • Zapier Solution Partner
  • July 18, 2021

HI @KCEO ,

Can you elaborate your question a bit more with screenshots for example?

  • How does the spreadsheet look like now when the automation runs? 
  • How should the spreadsheet look?
  • How did you configure the zap flow?

This will help.

~Bjorn from Wemakefuture


SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • Answer
  • September 17, 2021

Just wanted to follow up here for anyone that’s also running into this issue, to add that this behaviour happens when the different header names are put into a single field in the Zap.

When manually setting the names for each header column they should be put into separate fields - as per column3 and column4 in the example below:
6a2578c84fa8b157957a0f52f8840fcb.png

If the header names are all added into a single field like column1,column2, they will be added to a single header cell in the spreadsheet that is created: 

ec5825c5824033a9cea311b6b23a15b1.png