Automated referral tracking system in HubSpot and Google Sheets

• Capture and track referrals automatically
• Generate unique referral codes for each user
• Store referral information in HubSpot for CRM purposes
• Maintain a ledger of referrals in Google Sheets
• Notify team members of new referrals via Slack

Webhook captures referral data from incoming requests Function generates a unique referral code based on the user's email Contact information is upserted into HubSpot for CRM management Referral details are appended to a Google Sheets ledger Slack notification is sent to inform the team of new referrals

1. 1
   Import the workflow template into n8n
2. 2
   Configure the webhook URL to receive referral data
3. 3
   Set up HubSpot credentials for contact management
4. 4
   Connect Google Sheets with the appropriate ledger ID
5. 5
   Adjust Slack channel settings for notifications