Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

  • Home
  • Get Help
  • How Do I
  • How to add information from HubSpot into different columns in a Google Sheets Row?

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!

 

Hi @The_School_160 

Can 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/help

https://zapier.com/help/create/basics/set-up-your-zap-action

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

Terms & Conditions