Connect Google BigQuery and GymMaster

Both apps 34Google BigQuery 14GymMaster 20

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

• Trigger
  New Class Booking

  Triggers when a new upcoming class booking appears for the chosen member.

• Trigger
  New Member

  Triggers when a new current member appears in GymMaster. Requires the Staff API key.

• Trigger
  New Staff

  Triggers when a new staff member is set up as a sales rep in GymMaster.

• Action
  Create Measurement for a Member

  Records a new set of body measurements (and optional progress photos) for a logged-in member.

• Action
  Create Personal Booking for a Member

  Books a member into a service (personal) booking.

• Action
  Create Prospect Member

  Creates a prospect (or updates a matching one) and returns the prospect's member ID.

• Action
  Find Member by Email

  Looks up a member by email and returns their ID and whether they are a current member.

• Action
  Get Member Profile

  Returns the logged-in member's profile.

• Action
  List Class Schedule

  Returns the class schedule for a week.

• Action
  List Clubs

  Returns the clubs (companies) set up in your GymMaster account.

• Action
  List Members

  Returns all current members, optionally for one club. Requires the Staff API key.

• Action
  List Membership Types

  Returns the membership types available for purchase.

• Action
  List Member Upcoming Bookings

  Returns the member's upcoming class bookings.

• Action
  List Products

  Returns the products available for purchase.

• Action
  List Services

  Returns the bookable services (personal training, appointments, etc.).

• Action
  Log External Payment

  Records a payment taken outside GymMaster against the member's account.

• Action
  Log In Member

  Logs in as a member and returns a member token used by member-level actions.

• Action
  Send Feedback

  Sends a feedback message to the facility.

• Action
  Sign Up Member

  Signs up a new member with a membership and returns the new member and membership IDs.

• Action
  Update Member Profile

  Updates the logged-in member's profile details.

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