Connect Google BigQuery and Returnless

Both apps 32Google BigQuery 14Returnless 18

• 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
  Request Created

  Triggers when a customer creates a new return request that needs approval.

• Trigger
  Return Created

  Triggers when a new return is created, including a request once it is approved.

• Action
  Add note

  Adds an internal note to a return or return request.

• Action
  Add Request

  Creates a return request in Returnless for items from an existing sales order.

• Action
  Approve a Request

  Approves a return request in Returnless so the customer can send the items back.

• Action
  Approve a Request Without Shipment

  Approves a pending return request without a return shipment, so the customer keeps the items.

• Action
  Find customers

  Returns the customers in your Returnless account that match an email address.

• Action
  Find products

  Returns the products in your Returnless account that match a SKU.

• Action
  Find Requests

  Finds a Request in your Returnless account.

• Action
  Find Returns

  Finds returns (return orders) in Returnless by return number.

• Action
  Find sales orders

  Finds sales orders in Returnless by order number.

• Action
  Get customer

  Returns a single Returnless customer by its id.

• Action
  Get Request (By Request ID)

  Returns a single return request (return order) from Returnless by its ID.

• Action
  Get Return (By Return ID)

  Returns a single return in Returnless, with all of its details, by its return ID.

• Action
  Get sales order

  Returns a single sales order by its ID, including its customer, address and order details.

• Action
  List return reasons

  Returns the return reasons configured in your Returnless account.

• Action
  Reject Request

  Rejects a pending return request in Returnless.

• Action
  Update return

  Changes the status of a return, such as Checked, Approved or Resolved.

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