Best answer

How to add information from HubSpot into different columns in a Google Sheets Row?

  • 24 February 2021
  • 2 replies

Hello, I am new to Zapier - This is probably very simple but I just can’t figure this out yet: 

I have a zap set up:

However, all the client registration fields are going into the same row.  What is the next step for us to add each piece of information to a separate column?  Is there a mapping setting I am missing? 


Thank you!



Best answer by PaulKortman 24 February 2021, 22:58

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.

2 replies

Userlevel 7
Badge +14

Hi @The_School_160 

Can you please provide screenshots of how your Zap step is configured?

Make sure to check out these help articles:

Userlevel 7
Badge +10

@The_School_160 welcome to the community, and there is a slight learning curve that once you figure this out it will become easier and you will be able to understand. 

Ideally sharing a screenshot of the “Set up Action” part of your Google Sheets would help, but I’ll try to share a screenshot of how I would set it up, and see if that helps. 


 I’m putting both the firstname and the lastname in the field with the name “Product Name”


One of the things to note about working with Google Sheets in Zapier is that you need to have a “Header Row” which is the first row of a spreadsheet… you’ll notice in the example above cell A1 in my spreadsheet (the Header Row for the first column) is called “Product Name” and the cell B1 (the header row for the second column) is SKU, and then QTY Ordered, QTY Shipped, etc. 

So now like you said it’s just mapping the correct values into the correct columns, take a look at this screenshot to compare to the above screenshot, you’ll see that the field values will appear in different columns


Now I have the fields in different columns.

Hopefully that helps… if not, please send a screenshot of this portion of your Google Sheets Action and someone will be able to assist you better.