Connect Google BigQuery and US Global Mail

Both apps 31Google BigQuery 14US Global Mail 17

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

  Triggers when a new mail item arrives in your US Global Mail mailbox.

• Action
  Add address

  Adds a new shipping or check-deposit address to your US Global Mail account.

• Action
  Add folder

  Creates a new mail folder with a name and an optional color.

• Action
  Add scan request

  Requests a scan of a mail item, or has it opened and its contents scanned. This is a billable action on the US Global Mail account.

• Action
  Archive mail item

  Moves a mail item out of the active inbox into the archive and returns the updated mail item.

• Action
  Delete folder

  Deletes a folder. Mail in the folder is not deleted; it simply becomes unfiled.

• Action
  Discard mail item

  Asks the mailroom to discard a physical mail item. It can be undone with Undiscard within 7 days; after that the item is permanently shredded.

• Action
  Get account

  Returns your US Global Mail account profile, including name, email, phone number, status and mailbox (PMB) number.

• Action
  Get mail item

  Returns full detail for one mail item in your US Global Mail mailbox, including its status, sender, dimensions, weight, scan and folder.

• Action
  Get shipment

  Returns the details of one shipment, including its status, tracking number, destination and packed mail items.

• Action
  List addresses

  Returns the shipping and deposit addresses on your US Global Mail account, optionally filtered by type.

• Action
  List folders

  Returns all of your US Global Mail folders, with each folder's name and color.

• Action
  List mail items

  Returns the mail items in your mailbox, with optional filters for status, type, folder, scan state, arrival period, read state and search text.

• Action
  List scans

  Returns your scan and open-and-scan requests, optionally filtered by status, type, mail item, search text or scan date.

• Action
  List shipments

  Returns your shipment requests (shipments, returns to sender, check deposits and pickups), optionally filtered by type and status.

• Action
  Update folder

  Renames a mail folder or changes its color.

• Action
  Update mail item

  Marks a mail item as read or unread and/or moves it into a folder, and returns the updated mail item.

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