Connect Aplos and Google BigQuery

Both apps 30Aplos 16Google BigQuery 14

• Trigger
  New contact

  Triggers when a new contact (a donor, individual or company) is added in Aplos.

• Trigger
  New contribution

  Triggers when a new contribution (a donation batch) is recorded in Aplos. Use Get contribution with its ID to read the donors, purposes and amounts.

• Trigger
  New or updated contact

  Triggers when a contact (a donor, individual or company) is added or changed in Aplos.

• Action
  Add contribution

  Records a contribution (donation record) in Aplos, with one or more lines each crediting a contact and a purpose.

• Action
  Add payable

  Creates an accounts payable bill in Aplos, split across one or more expense lines by account and fund.

• Action
  Add transaction

  Creates an accounting transaction (journal entry) in Aplos. The transaction lines must balance by amount and fund.

• Action
  Find contacts

  Returns the contacts that match the specified name, email, type or last-updated time.

• Action
  Find contributions

  Returns contributions (donation records) that match the specified contact, name and date criteria.

• Action
  Find transactions

  Returns accounting transactions that match the criteria you supply (contact, fund, account, amount, date range, memo, note, tags, reconciled status).

• Action
  Get contact

  Retrieve a single Aplos contact (individual or company) by its ID, including emails, phones and addresses.

• Action
  Get contribution

  Retrieve a single Aplos contribution record by its ID.

• Action
  Get payable

  Retrieves a single payable (bill) by its id.

• Action
  Get transaction

  Retrieves a single accounting transaction, including its lines (account, fund, amount) and contact.

• Action
  List accounts

  Lists the accounts in the organization's chart of accounts, optionally filtered by enabled status, name or account type.

• Action
  List funds

  Lists the funds in the Aplos organization, optionally narrowed by name or fund balance account number.

• Action
  List purposes

  Lists the donation purposes in the Aplos organization, optionally filtered by name or enabled status.

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