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

Question

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: https://zapier.com/shared/f70287c3a393c53da1ed4583453a91ec274878c0

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!

icon

Best answer by PaulKortman 24 February 2021, 22:58

View original

PaulKortman · Accepted Answer

@The_School_160welcome 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 columnsNow 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.

Troy Tessalone · Answer

Hi @The_School_160Can you please provide screenshots of how your Zap step is configured?Make sure to check out these help articles:https://zapier.com/apps/google-sheets/helphttps://zapier.com/help/create/basics/set-up-your-zap-action

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded