Data Engineering
Marketing data pipeline: Google Business Profile to BigQuery to Airtable
Scheduled Cloud Functions pull Google Ads, Analytics and Business Profile data into BigQuery and sync it to Airtable, filling gaps where no native connectors exist.
- Client
- Drinks retail marketing team
- Industry
- Retail
- Status
- In production
The problem
No native connectors existed between Google Business Profile, BigQuery and Airtable.
What we built
- Cloud Scheduler + Cloud Functions extraction
- Structured BigQuery tables
- Automated BigQuery-to-Airtable sync
Challenges we solved
- Building connectors from scratch
- Duplicate-free scheduled refreshes
- API rate limits
Results
- Runs on schedule; client analyses all three sources in Airtable
Technology stack
- Google Cloud Functions
- Cloud Scheduler
- BigQuery
- Airtable
- Google Business Profile API
Need something similar?
Free 30-minute scoping call. We reply within 24 hours.
Talk to us about Data Engineering