Connect Google BigQuery and Harvest

Both apps 42Google BigQuery 14Harvest 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.

• Trigger
  Invoice Paid

  Triggers when an invoice is fully paid.

• Trigger
  Invoice Sent

  Triggers when an invoice is sent or marked as sent.

• Trigger
  New Client

  Triggers when a new client is added.

• Trigger
  New Contact

  Triggers when new contact is added.

• Trigger
  New Expense

  Triggers when a new expense is added.

• Trigger
  New Invoice

  Triggers when an invoice is created.

• Trigger
  New Project

  Triggers when a project is created.

• Trigger
  New Task

  Triggers when a new task is added.

• Trigger
  New Time Entry

  Triggers when a time entry is created.

• Trigger
  New User

  Triggers when a new User is added.

• Trigger
  New User Assignment

  Triggers when a user is assigned to a project.

• Trigger
  Timer Started

  Triggers when a timer is started.

• Trigger
  Timer Stopped

  Triggers when a timer is stopped.

• Trigger
  Updated Client

  Triggers when a client is updated.

• Trigger
  Updated Invoice

  Triggers when an invoice is updated.

• Trigger
  Updated Time Entry

  Triggers when a time entry is updated.

• Action
  Create Client

  Creates a Client

• Action
  Create Contact

  Creates a Contact

• Action
  Create Project

  Creates a Project

• Action
  Create Task

  Creates a Task and optionally assigns it to a project

• Action
  Create Time Entry

  Creates a Time Entry with duration

• Action
  Create Time Entry (Start & End Times)

  Creates a Time Entry with start and end times

• Action
  Find Client

  Finds a client by name or ID

• Action
  Find Invoice

  Finds an invoice by ID

• Action
  Find Project

  Finds a project by name

• Action
  Find Task

  Finds a task by name

• Action
  Start Timer

  Creates and starts a timer for a given date

• Action
  Stop Timer

  Stops any running timers

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