ETL HubSpot data to Google BigQuery

Represents individual people in HubSpot, storing personal and engagement data such as names, email addresses, lifecycle stages, and interaction history.

Contains information about organizations or businesses, including company name, domain, industry, and associated contacts or deals.

Tracks sales opportunities and pipeline stages, capturing details like deal amount, stage, close date, and associations with contacts and companies.

Manages customer support requests or issues, recording ticket status, priority, source, and related contact or company associations.

Logs various interactions such as emails, calls, meetings, and notes, providing a timeline of activities linked to contacts, companies, or deals.

Stores catalog information for goods or services offered, including product name, price, SKU, and description, often used in association with deals.

Represents HubSpot users or team members, containing user details and ownership assignments for contacts, companies, deals, and tickets.

Captures data about marketing activities such as webinars, events, or campaigns, including event names, dates, and participant engagement metrics.