Push HubSpot deal updates to a Google Sheets pipeline tracker

Quick summary

This demo shows how to build a Zapier automation that pushes HubSpot deal updates directly into a Google Sheets pipeline tracker without manual data entry. By connecting HubSpot as the trigger and Google Sheets as the action, sales teams can maintain a real-time, always-accurate deal pipeline in a spreadsheet.

Steps

1. Log in to Zapier, click "Create," and select "Zaps" to start a new automation.
2. Click "Trigger" to begin setting up the trigger step.
3. Select HubSpot as the trigger app.
4. Choose "New Deal" or "Deal Stage Changed" as the trigger event.
5. Connect your HubSpot account to Zapier to authorize the integration.
6. Click "Test trigger" to verify that HubSpot is returning deal data correctly.
7. Add Google Sheets as the Action App.
8. Choose "Create Spreadsheet Row" or "Update Spreadsheet Row" as the action event.
9. Connect your Google Sheets account to Zapier to authorize access.
10. Map HubSpot deal fields — such as deal name, amount, and stage — to the corresponding Google Sheets columns.
11. Run a test to confirm that HubSpot deal updates appear correctly in your Google Sheets pipeline tracker.
12. Click "Publish" to activate your Zap and enable live automation.