HubSpot · Google Sheets
Log new HubSpot contacts in Google Sheets
Log each new HubSpot contact in a Google Sheets worksheet. Connect HubSpot and Google Sheets, then browse to your spreadsheet and worksheet. Append Values writes five columns in this order: A Contact ID, B HubSpot record URL, C Event time (Unix milliseconds), D Event ID, E Portal ID. An empty worksheet works; optional headers can be added in row 1 before activation. Values are written as RAW data and new rows are inserted after the existing table. Only contact.creation events received after activation are processed. Existing contacts and later edits, merges or deletions are not synchronized. HubSpot creation webhooks contain record IDs, not names or email addresses, so contact profile fields are not included. The CRM link requires existing HubSpot access. Includes its own fictional event sample. Test with one fictional contact first.
- 1. HubSpot · Contact Creation
- 2. Google Sheets · Log the new HubSpot contact
View template →Use templateGoogle Sheets · HubSpot
Create HubSpot contacts from new Google Sheets rows
Turn new spreadsheet leads into HubSpot contacts. Use Email, FirstName, LastName and Company headers in row 1, then append one complete contact per row. Connect Google Sheets and HubSpot, select the spreadsheet and worksheet, and keep the prepared property mappings. Use a valid, unique email for each new contact. This template creates contacts; it does not update existing contacts or merge duplicate emails. HubSpot may reject a contact whose email already exists. Activate and let the first poll establish a baseline before appending rows. Existing rows and later edits are not imported; avoid deleting or reordering rows while active. Includes a fictional English example with German characters. No marketing subscription or email campaign is configured by this template. Contact data is copied to the connected HubSpot account.
- 1. Google Sheets · New Row Added
- 2. HubSpot · Create CRM contact
View template →Use template
