See llms.txt for all machine-readable content.

Google BigQuery and Studio by AI21 Labs integration

Save yourself the work of writing custom integrations for Google BigQuery and Studio by AI21 Labs and use n8n instead. Build adaptable and scalable Data & Storage, Development, workflows that work with your technology stack. All within a building experience you will love.

How to connect Google BigQuery and Studio by AI21 Labs

Create a new workflow and add the first step

In n8n, click the "Add workflow" button in the Workflows tab to create a new workflow. Add the starting point – a trigger on when your workflow should run: an app event, a schedule, a webhook call, another workflow, an AI chat, or a manual trigger. Sometimes, the HTTP Request node might already serve as your starting point.

Google BigQuery and Studio by AI21 Labs integration: Create a new workflow and add the first step

Generate BigQuery SQL from natural language queries using GPT-4o chat

Give business users a chat box; get back valid BigQuery SQL and live query results. The workflow: Captures a plain-language question from a chat widget or internal portal. Fetches the current table + column schema from your BigQuery dataset (via INFORMATION_SCHEMA). Feeds both the schema and the question to GPT-4o so it can craft a syntactically correct SQL query using only fields that truly exist. Executes the AI-generated SQL in BigQuery and returns the results. Stores a short-term memory by session, enabling natural follow-up questions. Perfect for analysts, customer-success teams, or any stakeholder who needs data without writing SQL. ⚙️ Setup Instructions Import the workflow n8n → Workflows → Import from File (or Paste JSON) → Save Add credentials | Service | Where to create credentials | Node(s) to update | |---------|----------------------------|-------------------| | OpenAI | <https://platform.openai.com> → Create API key | OpenAI Chat Model | | Google BigQuery | Google Cloud Console → IAM & Admin → Service Account JSON key | Google BigQuery (schema + query) | Point the schema fetcher to your dataset In Google BigQuery1 you’ll see: SELECT table_name, column_name, data_type FROM n8nautomation-453001.email_leads_schema.INFORMATION_SCHEMA.COLUMNS Replace n8nautomation-453001.email_leads_schema with YOUR_PROJECT.YOUR_DATASET. Keep the rest of the query the same—BigQuery’s INFORMATION_SCHEMA always surfaces table_name, column_name, and data_type. Update the execution node Open Google BigQuery (the second BigQuery node). In Project ID select your project. The SQL Query field is already {{ $json.output.query }} so it will run whatever the AI returns. (Optional)Embed the chat interface Test end-to-end Open the embedded chat widget. Ask: “How many distinct email leads were created last week?” After a few seconds the workflow will return a table of results—or an error if the schema lacks the requested fields. As specific questions about your data Activate Toggle Active so the chat assistant is available 24/7. 🧩 Customization Ideas Row-limit safeguard: automatically append LIMIT 1000 to every query. Chart rendering: send query results to Google Sheets + Looker Studio for instant visuals. Slack bot: forward both the question and the SQL result to a Slack channel for team visibility. Schema caching: store the INFORMATION_SCHEMA result for 24 hours to cut BigQuery costs. Contact Email: [email protected] Website: https://ynteractive.com YouTube: https://www.youtube.com/@ynteractivetraining LinkedIn: https://www.linkedin.com/in/robertbreen

Build your own Google BigQuery and Studio by AI21 Labs integration

Create custom Google BigQuery and Studio by AI21 Labs workflows by choosing triggers and actions. Nodes come with global operations and settings, as well as app-specific parameters that can be configured. You can also use the HTTP Request node to query data from any app or service with a REST API.

Google BigQuery supported actions

Supported API Endpoints for Studio by AI21 Labs

To set up Studio by AI21 Labs integration, add the HTTP Request node to your workflow canvas and authenticate it using a generic authentication method. The HTTP Request node makes custom API calls to Studio by AI21 Labs to query the data you need using the API endpoint URLs you provide.

See the example here

These API endpoints were generated using n8n

n8n AI workflow transforms web scraping into an intelligent, AI-powered knowledge extraction system that uses vector embeddings to semantically analyze, chunk, store, and retrieve the most relevant API documentation from web pages. Remember to check the Studio by AI21 Labs official documentation to get a full list of all API endpoints and verify the scraped ones!

Google BigQuery and Studio by AI21 Labs integration details

Google BigQuery

Google BigQuery

Many businesses use the Google Cloud service BigQuery for data reporting. BigQuery is categorized as an Advanced Data Connector. The amount of data that needs to be processed could be quite large (up to 10,000 columns and tens of millions of rows).

Studio by AI21 Labs

Studio by AI21 Labs

Studio by AI21 Labs is an innovative platform where AI-powered tools are developed to enhance creativity in writing. It provides various writing utilities and models that assist users in generating high-quality content by using the power of artificial intelligence, allowing for improved productivity and efficiency.

Other integrations with Google BigQuery and Studio by AI21 Labs

Save engineering resources

Reduce time spent on customer integrations, engineer faster POCs, keep your customer-specific functionality separate from product all without having to code.

Learn more

FAQ about Google BigQuery integrations

Looking to integrate Slack and VirusTotal in your company?

Three colleagues talking around laptops at a shared desk

Trusted by teams building smarter workflows.

Why

Why use n8n to integrate Google BigQuery with Studio by AI21 Labs

Handle branching, merging and iteration easily. Pause your workflow to wait for external events.

Re-run single steps to test changes in no time. And pin your data to avoid generating trigger events every time you execute.

Your data is displayed alongside your settings, making edge cases easy to track down.

Use 1000+ workflow templates available from our core team and our community.

Copy and paste, easily import and export workflows.

Simple enough to 
understand + sophisticated 
enough to ship

Man in a brown jacket working at his desk by a window