Sync HubSpot contacts to Google Sheets on schedule
Workflow Description
This automation syncs contact data from HubSpot to a Google Sheets spreadsheet on a recurring schedule. It processes records in batches and logs all operations to a Postgres database for tracking changes and execution history.
How it works
- 1.Trigger sync at scheduled intervals automatically
- 2.Retrieve contacts from HubSpot and process in batches
- 3.Update Google Sheets and record operations in database
Use cases
- Keep sales teams updated with current contact information
- Maintain automated backups of your customer database
- Generate accessible reports in Google Sheets for management review
Requirements
- Active HubSpot account with API access key
- Google Workspace account with Sheets permissions
- Postgres database server for operation logging
Service Value
Ready-made workflow template for automation delivery and service execution.
Apps Used
Details
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (23)
EXTRACT CAMPAIGN DATA
HTTP Request
FETCH ALL CAMPAIGNS
HTTP Request
Loop Over Items
Split In Batches
UPDATE CAMPAIGN
Postgres
Merge
Merge
Code
Code
Loop Over Items1
Split In Batches
HubSpot
Hubspot
If
If
Schedule Trigger
Schedule Trigger
UPSERT CAMPAIGN ACTIVITY
Postgres
HUBSPOT TABLE
Postgres
SEARCH
Postgres
Postgres1
Postgres
UPDATE HUBSPOT ACTIVITY TABLE
Postgres
Sticky Note
Sticky Note
Sticky Note1
Sticky Note
SET SMARTLEAD API KEY
Set
Sticky Note2
Sticky Note
Postgres
Postgres
Sticky Note3
Sticky Note
Sticky Note4
Sticky Note
Google Sheets
Google Sheets