Sync CRM Contacts Across Platforms

1. Create a Google Sheet with columns: Email, First Name, Last Name, Company, Phone, Lead Status, Last Updated. Share it with your service account email. 2. In HubSpot, go to Settings > Integrations > Webhooks. Create a webhook subscription for contact creation and contact property changes. 3. In your automation platform, create a workflow triggered by the HubSpot webhook event. 4. Add a Google Sheets lookup node that searches column A (Email) for the contact's email address. 5. Add a conditional branch: if a row is found, update that row with the latest HubSpot data; if not found, append a new row with all contact fields. 6. After either path, add a Slack node that posts to your #sales-updates channel with a formatted message showing what changed (new contact vs. updated fields). 7. Enable error handling to catch rate limit errors from Google Sheets API — add a 2-second delay and retry on 429 responses. 8. Test by creating a new contact in HubSpot and verify the sheet updates within 30 seconds and the Slack message appears.