AI agents, automations and apps for Google Bigquery

Set up an automation: when new or updated contact in HubSpot, delete rows in Google Bigquery

Build it

Google Bigquery works as a step: another app’s event or a schedule starts it.

What you can build on Google Bigquery

Automation

HubSpot to Google Bigquery, every time

When new or updated contact in HubSpot, delete rows in Google Bigquery, the same way every time.

AI agent

An AI agent that works in Google Bigquery

It uses “List BigQuery projects”, “List datasets in project” and “List tables in dataset” in Google Bigquery when your instructions call for it.

Browser agent

Pages on cloud.google.com

For Google Bigquery’s public pages on cloud.google.com that its triggers and actions don’t reach: it reads them on a schedule and reports what changed.

App

Your own rows app

Your Google Bigquery rows as records, with a board and a table, kept current with “Delete rows”.

Google Bigquery triggers and actions

A trigger starts the work; actions are the steps in Google Bigquery.

Actions

8
  • Delete rowsDeletes rows in a Google BigQuery table that match the condition you provide.
  • Run SQL queryRun a SQL query on Google BigQuery and return the results.
  • Insert rowsAdds one or more rows to a BigQuery table.
  • Update rowsChange specific fields for rows in a BigQuery table that match the rules you provide.
  • Create tableCreates a new, empty table in a BigQuery dataset.

Templates for Google Bigquery

Pick one and Captain builds it with you.

  • When new or updated contact in HubSpot, delete rows in Google Bigquery

    Build this
  • When new deals in Zoho CRM, delete rows in Google Bigquery

    Build this
  • When user logs in in Wordpress, run SQL query in Google Bigquery

    Build this
  • When a new post is published on a company page in LinkedIn, run SQL query in Google Bigquery

    Build this
  • When new or updated contact in HubSpot, run SQL query in Google Bigquery

    Build this
  • When user logs in in Wordpress, delete rows in Google Bigquery

    Build this

Apps that work best with Google Bigquery

Every app, A to Z

Questions about Google Bigquery in 50agents

What can 50agents do in Google Bigquery?

Its actions: “Delete rows”, “Run SQL query”, “Insert rows”, “Update rows”, “Create table”, “List BigQuery projects”, “List datasets in project” and “List tables in dataset”. Anything that reaches people outside asks you first.

Which apps is Google Bigquery most often paired with?

HubSpot, Zoho CRM, Wordpress, LinkedIn and My Hours, in viaSocket’s templates.

What do people build most with Google Bigquery?

The most used templates: when new or updated contact in HubSpot, delete rows in Google Bigquery; when new deals in Zoho CRM, delete rows in Google Bigquery; when user logs in in Wordpress, run SQL query in Google Bigquery.

Can an AI agent work in Google Bigquery?

Yes. Connect Google Bigquery and it can use “List BigQuery projects”, “List datasets in project” and “List tables in dataset” when its instructions call for it. It runs on a schedule or when you ask in its chat.

Does 50agents change my Google Bigquery data on its own?

Only through the actions you name, such as “Delete rows”. Changes made in Google Bigquery cannot be undone from 50agents, and anything that reaches people outside your business asks you first.

Build on Google Bigquery

One sentence to Captain. Free to start.

Build it with Captain
Google Bigquery in 50agentsBuild it