Connect Digital Practice and Google BigQuery

Both apps 44Digital Practice 30Google BigQuery 14

• Trigger
  New Account

  Triggers when a new account is added to your company's chart of accounts.

• Trigger
  New Client

  Triggers when a new client is added to your Digital Practice company.

• Trigger
  New Contact

  Triggers when a new contact is added to your Digital Practice CRM.

• Trigger
  New Invoice

  Triggers when a new invoice is created in Digital Practice, including its client and line items.

• Trigger
  New Lead

  Triggers when a new lead is added to your Digital Practice CRM.

• Trigger
  New Product

  Triggers when a new product or service is added in Digital Practice.

• Trigger
  New Project

  Triggers when a new project is added to your Digital Practice company.

• Trigger
  New Quote

  Triggers when a new quote is created in Digital Practice.

• Trigger
  New Vendor

  Triggers when a new vendor is added to your Digital Practice company.

• Action
  Create Account

  Creates a new account in your Digital Practice chart of accounts.

• Action
  Create Client

  Creates a new client company in Digital Practice accounting.

• Action
  Create Contact

  Creates a new contact in your Digital Practice CRM.

• Action
  Create Expense

  Creates an expense against an account, optionally linked to a vendor. An existing account or vendor is matched by name; supplying extra details creates a new one.

• Action
  Create Invoice

  Creates an invoice for an existing or new client. Add line items afterwards with Create Invoice Items.

• Action
  Create Invoice Items

  Adds one or more line items to an existing Digital Practice invoice.

• Action
  Create Lead

  Creates a new lead in Digital Practice CRM with its company details, status and priority.

• Action
  Create Product

  Creates a new product or service in Digital Practice.

• Action
  Create Project

  Creates a project in Digital Practice, linked to an existing client by name or to a new client created from the details supplied.

• Action
  Create Quote

  Creates a quote for an existing client, or for a new client created from the details you supply.

• Action
  Create Quote Items

  Adds one or more line items (title, price, quantity) to an existing quote.

• Action
  Create Vendor

  Creates a new vendor record in Digital Practice accounting.

• Action
  List accounts

  Returns the list of accounts in your company's chart of accounts.

• Action
  List clients

  Returns the list of clients for your Digital Practice company.

• Action
  List contacts

  Returns the contacts in your Digital Practice company.

• Action
  List invoices

  Returns the invoices in your company, each with its client and line items.

• Action
  List leads

  Returns the leads in your Digital Practice company.

• Action
  List products

  Returns the products and services set up in your Digital Practice company.

• Action
  List projects

  Returns the projects in your Digital Practice company, each with its associated client.

• Action
  List quotes

  Returns the quotes in your company, each with its client and line items.

• Action
  List vendors

  Returns the vendors in your Digital Practice company.

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

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