Google BigQuery + Strava

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.

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.

  1. When this happens...
    StravaStrava
    New or Updated Club Activity

    Triggers when any member of your selected club posts or updates an activity. NOTE: This trigger only checks for new activities every 15 minutes.

    TriggerScheduled
  2. automatically do this!
    Google BigQueryGoogle BigQuery
    Create Row

    Creates a new row of data in a table. Note: Does not create a job.

    ActionWrite
Start free with email
Start free with email
  • Free forever for core features
  • 14 day trial for premium features & apps

Supported triggers and actions

  • Strava triggers, actions, and search

    Transfer Athlete Activities

    This trigger is for use in Transfer. If not using Transfer, use the new "New Athlete Activity" instant trigger instead.

    Trigger
    Scheduled
    Try It
  • Strava triggers, actions, and search

    New Athlete Activity

    Triggers when you post a new activity.

    Trigger
    Instant
    Try It
  • Strava triggers, actions, and search

    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
    • ClubsRequired

    Trigger
    Scheduled
    Try It
    • Activity NameRequired

    • Activity TypeRequired

    • Activity Start Date/TimeRequired

    • Activity Elapsed Time (in seconds)Required

    • Activity Description

    • Activity Distance (in meters)

    • Trainer

    • Commute

    Action
    Write
    • Api Docs Info

    • HTTP MethodRequired

    • URLRequired

    • Query String Parameters

    • Headers

    • Additional Request Headers

    • Body

    Action
    Write
    • ProjectRequired

    • Dataset

    • Table

    Trigger
    Scheduled
    Try It
google-bigquery logo
google-bigquery logo

About Google BigQuery

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

Related categories

  • Databases
  • Google
strava logo
strava logo

About Strava

Strava is a fitness tracking application.
Learn more

Related categories

  • Fitness

Similar apps

MapMyFitness integrationsMapMyFitness integrations

MapMyFitness

Fitness
Runkeeper integrationsRunkeeper integrations

Runkeeper

Fitness
Exercise.com integrationsExercise.com integrations

Exercise.com

Fitness