Move CSV data into HubSpot with clear checks and simple mapping. Upload a file, match columns to real HubSpot properties, and send clean records to the right object. Great for teams importing contacts, companies, deals, leads, or tickets.

A web form collects your CSV and the object type. The header row is read and compared to a live property list stored in Google Sheets. That list is kept up to date by pulling properties from HubSpot for each object. If a column name does not match, a mapping form appears so you can pick the correct property. Internal HubSpot fields are filtered out, records are split for scale, and data is sent to HubSpot using secure OAuth.

Setup is simple. Connect HubSpot and Google Sheets, replace the Google Sheet ID in the nodes, then run the property sync once. Expect faster imports, fewer errors, and cleaner CRM data. Use it for migrations, list uploads, or bulk updates across multiple HubSpot objects.

• File upload form collects the CSV and the HubSpot object type you want to import
• Header extraction reads the first line of the file to identify column names
• Live property sync pulls object properties from HubSpot and stores them in Google Sheets
• Validation step checks every CSV header against the approved property list
• Mapping form appears only when a column does not match, so users can set the correct property
• Automatic filter removes hidden and hs_ internal HubSpot fields
• Record splitter processes large files by sending items in smaller chunks
• Secure HubSpot upload uses OAuth credentials to create or update records

• Reduce manual imports from hours to minutes with guided mapping
• Improve data quality by up to 90 percent with property checks before upload
• Connect HubSpot and Google Sheets to keep a live list of valid properties
• Handle thousands of rows by splitting records into smaller batches
• Cut rework by blocking internal and hidden fields from being used
• Faster onboarding for new lists and migrations across HubSpot objects

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with HubSpot and Google Sheets. See the Tools Required section above for links to create accounts with these services.
3. In the n8n credentials manager or by double clicking the HubSpot nodes, create a HubSpot OAuth credential. On the 'Credential to connect with' dropdown, click 'Create new credential' and follow the on screen steps to sign in and approve CRM scopes.
4. Double click any Google Sheets node and create a Google Sheets OAuth credential. Click 'Create new credential' and sign in to your Google account.
5. Create a new Google Sheet in your Drive. Copy the document ID from the URL.
6. Open the nodes named Erase Google sheet, Append to Google sheet, and Get the fields from the sheet. Replace the documentId and sheetName with your own Sheet and tab name.
7. Populate the property catalog: select the node Start here to update your field list and execute it. Confirm that the Google Sheet fills with properties for contacts, companies, deals, leads, and tickets.
8. Open the File upload form node and copy the Production webhook URL. Visit it in your browser.
9. Prepare a CSV encoded in UTF8 with commas and a header row. Upload it in the form and choose the correct HubSpot object.
10. If a mapping form appears, select the matching HubSpot property for each CSV column and submit. If no form appears, your headers already match.
11. Watch the run in n8n. When done, check HubSpot to confirm new or updated records. If you see 401 or 403 errors, reauthorize the HubSpot credential. If the sheet is empty, rerun the property sync. If the CSV fails to parse, check the delimiter and encoding.