Skip to main content
Best answer

Google Sheets column headers all appearing in one field


Hi all, hopefully the screens will demonstrate the issue. everything was super smooth up to this stage. Whether all headers having a ‘1’ in front of them is creating the issue, I’m not sure. There seems no way to get rid of the numbering if this is the issue. I simply want each header to occupy its own field on the spreadsheet as it should do. Thanks

Best answer by Troy Tessalone

@gandalftheking

You need to enter 1 variable per line instead of all the variables in 1 field.

 

It would look more like this:

 

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

Troy Tessalone
Forum|alt.badge.img+14

Hi @gandalftheking 

Good question.

The 1 indicates the Zap step the variable relates to.

You need to put 1 Header per field, not all together in 1 field.

In the screenshot below notice the “Enter text or insert data” where each variable should be input.

 


Troy Tessalone wrote:

Hi @gandalftheking 

Good question.

The 1 indicates the Zap step the variable relates to.

You need to put 1 Header per field, not all together in 1 field.

In the screenshot below notice the “Enter text or insert data” where each variable should be input.

 

Sorry, but I’ve done what you are suggesting as per the screen shot (see my screen shots). How exactly do I enter the data? I have also tried it manually using ; ; , with no success. Thanks


Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 31341 replies
  • Answer
  • March 20, 2022

@gandalftheking

You need to enter 1 variable per line instead of all the variables in 1 field.

 

It would look more like this: