Google BigQuery + Strava

Google BigQuery + Strava integrations

Track new or updated Strava club activities by creating rows in Google BigQuery

Stay on top of your club's activities with this convenient workflow. Whenever there's a new or updated club activity in Strava, a row will be created in Google BigQuery to help you analyze and track the data efficiently. This automation saves you time and ensures you have the latest information about your club's performance in one organized place.

When this happens...
New or Updated Club ActivityTriggers when any member of your selected club posts or updates an activity. NOTE: This trigger only checks for new activities every 15 minutes.
TriggerPolling
automatically do this!
Create RowCreates a new row of data in a table. Note: Does not create a job.
ActionWrite

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

More things you can do with Strava and Google BigQuery

Discover other triggers and actions you can use with Strava and Google BigQuery

Transfer Athlete Activities
This trigger is for use in Transfer. If not using Transfer, use the new "New Athlete Activity" instant trigger instead.
Trigger
Polling
Try It
New Athlete Activity
Triggers when you post a new activity.
Trigger
Instant
Try It
Create Totals and Stats Report
Creates report that includes recent (last 4 weeks), year to date and all time stats of your activities.
Action
Write
- Help_text
- Activity_id
- Activity_name
Action
Search
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Sort By Column
  Required
- Unique Column
  Required
Trigger
Polling
Try It

- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Unique Column
  Required
- IS Operator
Trigger
Polling
Try It
- Project
  Required
- Dataset
  Required
- Table
  Required
Action
Write

- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Rows
  Required
- Skip Invalid Rows
- Ignore Unknown Values
Action
Write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Where Column
  Required
- Where Value
  Required
- Update Columns
  Required
Action
Write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Sort By Column
- Sort Direction
- Where Clause
  Required
Action
Search
- Project
  Required
- Dataset
  Required
- Table
  Required
- Sort By Column
- Sort Direction
- Where Clause
  Required
Action
Search or write

- Clubs
  Required
Trigger
Polling
Try It
- Activity_name
  Required
- Activity_type
  Required
- Activity Start Date/Time
  Required
- Activity Elapsed Time (in seconds)
  Required
- Activity_description
- Activity Distance (in meters)
- Trainer
- Commute
Action
Write
- Api_docs_info
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Project
  Required
- Dataset
- Table
Trigger
Polling
Try It
- Project ID
  Required
- Job ID
  Required
- Location
  Required
Trigger
Polling
Try It
- Project
  Required
- Dataset
  Required
- Table
  Required
Action
Write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Where Column
  Required
- Where Value
  Required
Action
Write
- Project ID
  Required
- SQL Query
  Required
- Location
Action
Write
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Project ID
  Required
- Job ID
  Required
- Location
  Required
Action
Search

About Google BigQuery

BigQuery is Google's serverless and highly scalable enterprise data warehouse, designed to make all your data analysts productive.

Learn moreLearn moreHelpHelp

Related categories

Databases

Google

Premium

About Strava

Strava is a fitness tracking application.

Learn moreLearn moreHelpHelp

Related categories

Fitness

Similar apps

Runkeeper

Fitness

Exercise.com

Fitness