Connect Google BigQuery to TutorBird

Both apps 34Google BigQuery 14TutorBird 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.

• Action
  Add event

  Creates a calendar event (lesson) in TutorBird for a teacher and optional students, optionally repeating.

• Action
  Add parent

  Creates a parent contact in TutorBird, optionally attached to an existing family, and returns the new parent's ID.

• Action
  Add Payment

  Records a payment on a family's account in TutorBird.

• Action
  Add Student

  Creates a new student in TutorBird, optionally adding them to an existing family, and returns the new student's id.

• Action
  Add transaction

  Adds a payment, charge, discount or refund to a family's account in TutorBird.

• Action
  Delete event

  Deletes a calendar event in TutorBird, optionally including its future or all recurrences, and can notify the people attending.

• Action
  Delete student

  Deletes a student from TutorBird.

• Action
  Find All Parents

  Returns the parents that match a name search, email address, parent IDs or family IDs.

• Action
  Find Attendance Records

  Finds attendance records matching criteria such as date range, students, teachers, events or attendance status.

• Action
  Find Event

  Finds calendar events in TutorBird matching dates, times, teachers, students, categories, locations or attendance statuses.

• Action
  Find Parent

  Finds parents matching a name, email address, parent IDs or family IDs.

• Action
  Find Student

  Finds students in TutorBird matching a name, email, free-text search, status, teacher, family or tag.

• Action
  Find teachers

  Finds teachers in TutorBird matching a name or text search, ids, tags, and active/teacher/administrator status.

• Action
  Get family

  Returns a single family, including its name, balance, auto-invoice status and optionally its parents and students.

• Action
  Get student

  Returns the details of a single student by ID, including contact information, status and family.

• Action
  Get Transaction

  Returns a single TutorBird transaction (charge, payment, discount or refund) with its amounts, taxes, family and student details.

• Action
  Update attendance

  Updates a student's attendance record in TutorBird: status, teacher/parent/student notes, and price override.

• Action
  Update event

  Updates an existing calendar event (lesson) in TutorBird — its time, teacher, students, location, category, pricing and repeat settings.

• Action
  Update parent

  Updates an existing parent's name, contact details, phone numbers and reminder preferences in TutorBird.

• Action
  Update Student

  Updates an existing student's details in TutorBird, such as name, contact information, status and tags.

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