Connect Google BigQuery to Strava

Both apps 27Google BigQuery 14Strava 13

• Trigger
  New Job Completed

  Triggers when a BigQuery job in the project finishes, whether it succeeded or failed.

• Trigger
  New Row

  Triggers when a new row is added to a table. New rows are detected by a column you name that increases for newer rows, such as a creation time or a sequential ID.

• Trigger
  Query Job Completed (With Row Data)

  Triggers when a SELECT query job in the project finishes successfully, and includes its result rows.

• Trigger
  Updated Row

  Triggers when a row in a table is added or changed, detected by a last-updated timestamp column you name.

• Action
  Create Row

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

• Action
  Create Rows

  Creates new rows of data in a table (accepts line items). Note: Does not create a job.

• Action
  Delete Rows

  Deletes every row in a table whose match column equals the value you give.

• Action
  Find One Row

  Finds the first row in a table whose column equals the value you give.

• Action
  Get Rows for Job Completed

  Returns the result rows of a finished query job.

• Action
  Import Data

  Imports a JSON, CSV, Avro or Parquet file from Cloud Storage into a table. Waits up to about 40 seconds for the import to finish; larger imports keep running in BigQuery and return state RUNNING.

• Action
  List Datasets

  Returns the datasets in a Google Cloud project.

• Action
  List Tables

  Returns the tables in a BigQuery dataset.

• Action
  Run a Query

  Runs a SQL query against a table in BigQuery.

• Action
  Update Row(s)

  Updates every row in a table whose match column equals the value you give, setting the columns you choose.

• Action
  Get activity

  Returns the full details of one of the authenticated athlete's Strava activities, including distance, times, elevation, laps, splits and segment efforts.

• Action
  Get athlete

  Returns the profile of the Strava athlete whose account is connected, including name, location, follower counts, clubs, bikes and shoes.

• Action
  Get athlete stats

  Returns an athlete's activity totals — recent (last 4 weeks), year-to-date and all-time ride, run and swim stats, plus their longest ride and biggest climb. Only activities visible to Everyone are counted.

• Action
  Get club

  Returns the full details of a Strava club, including its name, location, sport type, member count and your membership status.

• Action
  Get gear

  Returns a piece of the athlete's equipment (a bike or pair of shoes) by its id, including brand, model, description and total distance.

• Action
  Get route

  Returns a Strava route by its id, including its name, distance, elevation gain, map and segments. Private routes require read_all access.

• Action
  Get segment

  Returns a Strava segment's details, including distance, grade, elevation, location, and the athlete's own stats on it.

• Action
  List activities

  Returns the connected athlete's activities, newest first, optionally limited to a time window.

• Action
  List activity comments

  Returns the comments posted on a Strava activity, including each comment's text, author and posting time.

• Action
  List activity kudoers

  Returns the athletes who gave kudos to a Strava activity.

• Action
  List clubs

  Returns the clubs the connected Strava athlete is a member of.

• Action
  List routes

  Returns the routes created by the authenticated Strava athlete. Private routes are included only when the connection has read_all access.

• Action
  List starred segments

  Returns the segments the connected Strava athlete has starred. Private segments are included only when the connection has the read_all scope.

No trigger or action matches that. Ask your agent to add it: it reads the API documentation and builds what you describe.