Best answer

Google Sheets to Hubspot - not all columns found

  • 6 June 2021
  • 3 replies
  • 146 views

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!

icon

Best answer by Matt_Boyden 10 June 2021, 21:28

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.

3 replies

Userlevel 7
Badge +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

Userlevel 2
Badge

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/

Userlevel 3
Badge +6

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?