Connect Google BigQuery and Willo

Both apps 34Google BigQuery 14Willo 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
  List Users

  Triggers when a new user is added to your Willo account.

• Action
  Accept Candidate

  Marks a participant in a Willo interview as Accepted and returns the updated participant. Can also update the participant's name, phone number and custom ID in the same step.

• Action
  Add department

  Creates a new department in your Willo organisation and returns the department, including its key and branding.

• Action
  Add interview from template

  Creates a new interview in Willo from one of your interview templates and returns the new interview.

• Action
  Create Company

  Creates a new company as a child organisation under your Willo organisation, with the owner you name.

• Action
  Create Interview

  Creates a new video interview in Willo with its questions, department, message templates and settings.

• Action
  Delete interview

  Deletes an interview from your Willo account.

• Action
  Delete participant

  Deletes a participant from Willo. Returns whether the deletion was confirmed.

• Action
  Get interview

  Returns a Willo interview by its key, including its questions, owner, department, reviewers, message templates and settings. An error occurs if the interview is not found.

• Action
  Get participant

  Returns a Willo participant (candidate) with their contact details, status, interview, department, scores and answers.

• Action
  Get user

  Returns a Willo user's details, including email, full name, phone, role and status.

• Action
  Invite Someone

  Invites a person to a Willo interview as a participant and returns the new participant with their invite link.

• Action
  List departments

  Returns the departments in your Willo organisation, optionally filtered by name, owner email or owner.

• Action
  List interviews

  Returns the interviews in your Willo account, optionally narrowed by department, owner or a search term, and sorted the way you choose.

• Action
  List message templates

  Returns the message templates (email and SMS) in your Willo account, optionally filtered by title, type or trigger.

• Action
  List participants

  Returns the participants in your Willo account, optionally narrowed to an interview, department or owner, or by a text search.

• Action
  List users

  Returns the users in your Willo account with their key, email and full name.

• Action
  Reject Candidate

  Rejects a candidate by setting the participant's status to Rejected, optionally updating their name, phone or custom ID.

• Action
  Update interview

  Updates an existing interview's details, questions, reviewers, message templates and settings, changing only the values you provide. Returns the updated interview.

• Action
  Update participant

  Updates a participant's name, phone, status (Accepted or Rejected) or your own reference ID.

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