Connect Google BigQuery to Front

Both apps 42Google BigQuery 14Front 28

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

  Adds an internal comment to a Front conversation.

• Action
  Add Contact Handle

  Adds a new handle (email, phone, social id, etc.) to an existing Front contact.

• Action
  Add Conversation Links

  Adds one or more links to a Front conversation, either existing links by id or external URLs (links are created as needed).

• Action
  Add Conversation Tags

  Adds one or more tags to a Front conversation.

• Action
  Assign or Unassign Conversation

  Assign or unassign a conversation to a teammate.

• Action
  Create Account

  Create a new account (company) in Front.

• Action
  Create Contact

  Creates a new contact in Front at the company level.

• Action
  Create Draft

  Creates a draft message that starts a new conversation in a Front channel.

• Action
  Create Draft Reply

  Creates a new draft as a reply to the last message in a Front conversation.

• Action
  Create Link

  Creates a new Link

• Action
  Find Account

  Finds a Front account by one of its domains or by its external ID.

• Action
  Find Contact

  Finds a Front contact by one of its handles (email address, phone number, social handle, etc.) and returns the matching contact.

• Action
  Find Conversation

  Returns up to 100 conversations matching a Front search query, most recently active first.

• Action
  Get Conversation

  Fetches a conversation by ID, with its status, assignee, tags, links and custom fields. An error occurs if the conversation is not found.

• Action
  Get Conversation Last Message

  Returns the most recent message in a Front conversation.

• Action
  Get Link

  Fetches a link by ID, with its name, type and external URL. An error occurs if the link is not found.

• Action
  Import Message

  Imports a message into a Front inbox without sending it through a channel, e.g. historical conversations or web form submissions.

• Action
  List Conversation Comments

  Returns the internal comments teammates have posted on a conversation, with each comment's body, author and time posted.

• Action
  List Link Conversations

  List the conversations linked to a specific Front link.

• Action
  Remove Contact Handle

  Removes a handle (email, phone, etc) from a Contact

• Action
  Remove Conversation Links

  Remove Links from a conversation.

• Action
  Remove Conversation Tags

  Remove Tags from a Conversation

• Action
  Send Message

  Sends a new message from a Front channel, starting a new conversation.

• Action
  Send Reply

  Replies to a conversation. This action is best used with a Front trigger. For example, auto-reply behavior could be setup by combining a "New Inbound Message" Front trigger with this action.

• Action
  Update Account

  Updates an existing account in Front.

• Action
  Update Contact

  Updates an existing Front contact's name, description, links, contact lists and custom fields. Fields left blank are not changed.

• Action
  Update Conversation

  Update the conversation status, assignee, inbox or tags.

• Action
  Update Link

  Update the name of a Link.

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