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.

Best answer

Google Sheets to Hubspot - not all columns found

S

Hi,

I’m creating a Zap to import from Google Sheets into Hubspot.

It’s all fine, except Zapir only seems to find 5 columns in the sheet - I have 6 (and maybe need more infuture).

Is this a hard limit or has something gone wrong for me?

Thanks!

Best answer by Matt_Boyden

Hi @Siama like Troy said, the Google Sheet needs to be structured a certain way to work with Zapier (Row 1 needs to be headers, and the data is in the rows below). The maximum number of columns a Google Sheet can have is 18,278. 

 

Additionally, Zapier traditionally isn’t built for import/export of existing data, it’s more for moving new data as it enters one app, and sending that data to another app. I.e. when you add a new row to your Google Sheet, the Zap sends that data to Hubspot. More on this here: https://zapier.com/help/create/basics/bulk-import-data-into-zaps

 

That said, we do have a beta version of a tool called “Transfer” that is built for import/export - here’s the link if you wanted to try that: https://transfer.zapier.com/

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

Check out these help articles for how to structure your GSheet to work with Zaps: https://zapier.com/help/doc/how-to-set-up-your-google-spreadsheet-to-work-with-zapier

And make sure you’ve selected a trigger example that has data for all the fields: https://zapier.com/help/create/basics/change-the-test-data-in-your-zap-trigger

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Matt_Boyden
Forum|alt.badge.img
  • Matt_BoydenZapier Staff
  • Zapier Staff
  • 38 replies
  • Answer
  • June 10, 2021

Hi @Siama like Troy said, the Google Sheet needs to be structured a certain way to work with Zapier (Row 1 needs to be headers, and the data is in the rows below). The maximum number of columns a Google Sheet can have is 18,278. 

 

Additionally, Zapier traditionally isn’t built for import/export of existing data, it’s more for moving new data as it enters one app, and sending that data to another app. I.e. when you add a new row to your Google Sheet, the Zap sends that data to Hubspot. More on this here: https://zapier.com/help/create/basics/bulk-import-data-into-zaps

 

That said, we do have a beta version of a tool called “Transfer” that is built for import/export - here’s the link if you wanted to try that: https://transfer.zapier.com/

william
Forum|alt.badge.img+6
  • williamZapier Staff
  • Zapier Staff
  • 177 replies
  • July 12, 2021

Hey @Siama, hope you’re well!

I just wanted to check in and see if you were able to get things working with the information from Troy and Matt, or can we still help out here?

Terms & Conditions