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.

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!

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

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/

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