Connect Google BigQuery and Moneybird

Both apps 43Google BigQuery 14Moneybird 29

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

  Triggers when a new contact is created.

• Trigger
  New Quote

  Triggers when a new quote is created.

• Trigger
  New Sales Invoice

  Triggers when a new sales invoice is created.

• Action
  Add Attachment to New Document

  Creates a new document in the Moneybird inbox and attaches a file to it, ready to be classified as a purchase invoice or receipt.

• Action
  Add external sales invoice

  Imports an invoice created in another system (webshop, marketplace, POS) into Moneybird as an external sales invoice.

• Action
  Add payment to sales invoice

  Registers a payment against an existing Moneybird sales invoice.

• Action
  Add product

  /api/v2/{administration_id}/products.json - create a product.

• Action
  Add project

  /api/v2/{administration_id}/projects.json - create a project.

• Action
  Add time entry

  Records a time entry (time spent by a user, optionally on a project and for a contact) in a Moneybird administration.

• Action
  Create Contact

  Creates a contact (customer, supplier or other business relation) in a Moneybird administration, including any contact custom fields.

• Action
  Create Document

  Creates a new typeless document (a document whose type is not yet known, such as an uploaded receipt or bill) in a Moneybird administration.

• Action
  Create Quote

  Create a new quote

• Action
  Create Sales Invoice

  Create a new sales invoice

• Action
  Delete contact

  Deletes a contact from a Moneybird administration.

• Action
  Find Contact

  Returns the Moneybird contacts that match a free-text search (name, contact people, email, phone, customer id, tax number, chamber of commerce number, IBAN or address), optionally narrowed by filters.

• Action
  Find ledger accounts

  Returns the ledger accounts in a Moneybird administration whose name or account code contains the search text, optionally limited to one account type.

• Action
  Find products by criteria

  Returns the products in a Moneybird administration that match the search text and optional filters.

• Action
  Find sales invoices by criteria

  Returns up to 100 sales invoices that match the specified state, period, reference, contact, recurring invoice, workflow or created/updated time.

• Action
  Find Tax Rate

  Returns up to 100 tax rates in a Moneybird administration that match the specified name, partial name, percentage or other criteria.

• Action
  Get contact

  Returns all information about a Moneybird contact, including its contact people, notes, custom field values and event history.

• Action
  Get external sales invoice

  Returns one external sales invoice in a Moneybird administration, including its reference, contact, lines and totals.

• Action
  Get project

  Returns one project in a Moneybird administration, including its name, state and budget.

• Action
  Get Quote

  Returns one quote (estimate) in a Moneybird administration, including its reference, contact, texts, lines and totals.

• Action
  Get sales invoice

  Fetches a sales invoice by ID. An error occurs if the sales invoice is not found.

• Action
  Get time entry

  Returns one time entry in a Moneybird administration, including its description, times, project and contact.

• Action
  Get typeless document

  Returns one typeless document in a Moneybird administration, including its reference, contact and attachments.

• Action
  Send Sales Invoice

  Send a sales invoice

• Action
  Update contact

  Updates an existing Moneybird contact. Only the fields you fill in are changed; blank fields keep their current value.

• Action
  Update sales invoice

  /api/v2/{administration_id}/sales_invoices/{id}.json - update a sales invoice.

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