# Connect Google BigQuery to Lob When **New Job Completed** fires in [Google BigQuery](https://apiant.ai/connections/google-bigquery), your agent runs **Create Address** in [Lob](https://apiant.ai/connections/lob). Describe the whole flow and it is built, tested on every scenario and kept running. Google BigQuery **4** triggers Google BigQuery **10** actions Lob **40** actions What the catalog holds today. Ask for anything missing and your agent reads the API documentation and adds it. ## What do you want Google BigQuery and Lob to do together? Give your AI client this address. `https://mcp.apiant.ai` One connection does both: ask your client to act in an app once, or have it build an automation that keeps running. Any client that takes a remote MCP server. Nothing to install. Create your free account, then sign in once in your browser. ### Set it up in your client ### Claude Code Run this in the directory you want to work in. `claude mcp add --transport http -s project apiant-ai https://mcp.apiant.ai` Start Claude Code there, approve the server, and sign in in the browser page it opens. [Claude Code guide (opens in a new tab)](https://apiant.ai/docs/mcp/claude-code) ### Claude, web and desktop Open Customize, then Connectors, then Add custom connector, and paste the address. On Team and Enterprise an owner adds it first. [Setup guide (opens in a new tab)](https://apiant.ai/docs/mcp) ### Cursor Add the address to your MCP configuration as a server URL. Cursor signs you in in your browser. [Setup guide (opens in a new tab)](https://apiant.ai/docs/mcp) ### Zed Open Settings, then AI, then MCP Servers, then Add Server, then Add Remote Server. [Setup guide (opens in a new tab)](https://apiant.ai/docs/mcp) ### Codex and the ChatGPT desktop app Open Settings, then MCP servers, then Add server, and choose Streamable HTTP. From the terminal, Codex takes the address with its own add command and then signs you in. [Setup guide (opens in a new tab)](https://apiant.ai/docs/mcp) ### Any other MCP client Paste the address where the client asks for a remote MCP server URL, and name the server apiant-ai where it lets you. APIANT's skills reach the client over the same connection. [Setup guide (opens in a new tab)](https://apiant.ai/docs/mcp) Example flows ## What Google BigQuery can start in Lob - When **New Job Completed** in Google BigQuery then **Create Address** in Lob - When **New Row** in Google BigQuery then **Create Bank Account** in Lob Starting points drawn from the triggers and actions in the catalog today. Describe the flow you need, at any depth, and your agent builds it and tests every scenario before it ships. Everything your agent can do with Google BigQuery and Lob ## Triggers and actions 4 triggers · 50 actions - 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. - Action **Autocomplete US Address** Suggests complete US street addresses from the first part of one a person has typed, so an address field can autocomplete as they type. - Action **Bulk Verify International Addresses** Checks a batch of non-US addresses at once and returns each one standardized, with whether it is deliverable. - Action **Cancel Check** Cancels a check in Lob so it is not mailed. Only works while the check is still in the pre-print window. - Action **Cancel Letter** Cancels a letter in Lob so it is not mailed. Only works while the letter is still in the pre-print window. - Action **Cancel Postcard** Cancels a postcard in Lob so it is not mailed. Only works while the postcard is still in the pre-print window. - Action **Create Address** Saves an address in your Lob address book so you can reuse it as a sender or recipient on later mailings. - Action **Create Bank Account** Saves a bank account in Lob so you can send checks from it. Returns the new bank account's ID and whether it has been verified yet. - Action **Create Template** Saves a reusable HTML template in Lob that letters, postcards and checks can be built from. Returns the new template's ID and its published version. - Action **Delete Address** Deletes a saved address from Lob. Returns the deleted address's ID. - Action **Delete Bank Account** Deletes a saved bank account from Lob. Returns the deleted bank account's ID. - Action **Delete Template** Deletes an HTML template from Lob. Returns the deleted template's ID. - Action **Get Address** Returns one saved address from Lob by its ID, including the recipient details and any name/value pairs stored on it. - Action **Get Bank Account** Returns one saved bank account from Lob by its ID, including whether it has been verified. - Action **Get Check** Returns one check from Lob by its ID, including its amount, status and delivery tracking events. - Action **Get Letter** Returns one letter from Lob by its ID, including its status, addresses and delivery tracking events. - Action **Get Postcard** Returns one postcard from Lob by its ID, including its status, addresses and delivery tracking events. - Action **Get Template** Returns one HTML template from Lob by its ID, including its published version and version history. - Action **List Addresses** Returns the saved addresses in your Lob address book, newest first, with cursors for paging through more. - Action **List Bank Accounts** Returns the bank accounts saved in your Lob account, newest first, with cursors for paging through more. - Action **List Booklets** Returns the booklets you have created in Lob, newest first, with cursors for paging through more. - Action **List Campaigns** Returns the direct-mail campaigns in your Lob account, newest first, with cursors for paging through more. - Action **List Checks** Returns the checks you have sent through Lob, newest first, with cursors for paging through more. - Action **List Informed Delivery Campaigns** Returns the USPS Informed Delivery campaigns in your Lob account, newest first, with cursors for paging through more. - Action **List Letters** Returns the letters you have sent through Lob, newest first, with cursors for paging through more. - Action **List Postcards** Returns the postcards you have sent through Lob, newest first, with cursors for paging through more. - Action **List QR Code Analytics** Returns the QR code scans recorded on your Lob mailpieces — who scanned, when, and how many times — plus the overall scan total. - Action **List Snap Packs** Returns the snap packs you have sent through Lob, newest first, with cursors for paging through more. - Action **List Templates** Returns the saved HTML templates in your Lob account, newest first, with cursors for paging through more. - Action **List Uploads** Returns the recipient-list uploads in your Lob account, optionally narrowed to one campaign. - Action **Look Up ZIP Code** Looks up a US ZIP code and returns the cities, states and counties it covers, plus the USPS ZIP code type. - Action **Reverse Geocode Lookup** Takes a latitude and longitude and returns the nearest US ZIP codes with their city, state and distance from that point. - Action **Send Check** Prints and mails a physical check drawn on your Lob bank account to the recipient address you name. - Action **Send Letter** Prints and mails a letter to the recipient address you name, from a PDF, an HTML body, or a saved Lob template. - Action **Send Postcard** Prints and mails a postcard to the recipient address you name, using front and back artwork from a URL, HTML, or a saved Lob template. - Action **Update Template** Changes an existing Lob HTML template - its description, or which saved version is the live one. Anything you leave blank is left as it was. - Action **Validate Recipient Identity** Checks whether a person or company name is actually associated with a US address, and returns a confidence level and match score. - Action **Verify Bank Account** Confirms a Lob bank account by submitting the two micro-deposit amounts, so the account can be used to send checks. - Action **Verify International Address** Checks a non-US address, standardizes it, and tells you whether mail sent there is likely to be delivered. - Action **Verify Single Line US Address** Checks a US address given as one single line, standardizes it, and tells you whether mail sent there is deliverable. - Action **Verify US Address** Checks a US address, standardizes it to USPS format, and tells you whether mail sent there is deliverable. ## Each app on its own - [ **Google BigQuery** BigQuery is Google's serverless and highly scalable enterprise data warehouse, designed to make all your...](https://apiant.ai/connections/google-bigquery) - [ **Lob** Lob makes it easy to seamlessly print and mail letters, postcards, photos, posters and more via a web API.](https://apiant.ai/connections/lob) Reviews ## What our customers say ## More from Google BigQuery - [ **Google BigQuery to HTML to Image** HTML to Image is a Powerful Image Generation API to convert HTML/CSS to Image and to take screenshots of...](https://apiant.ai/connect/google-bigquery-to-html-to-image) - [ **Google BigQuery to PaperClean** Clean document photos for printing, remove shadows, fix lighting](https://apiant.ai/connect/google-bigquery-to-paperclean) - [ **Google BigQuery to Resend** Resend is the email API for developers. It's designed for you to build, test, and send transactional and...](https://apiant.ai/connect/google-bigquery-to-resend) - [ **Google BigQuery to TypeSafe** TypeSafe's Jev model answers typed questions about a piece of content and tells you how certain it is.](https://apiant.ai/connect/google-bigquery-to-typesafe) - [ **Google BigQuery to HubSpot** HubSpot is your all-in-one stop for all of your marketing software needs.](https://apiant.ai/connect/google-bigquery-to-hubspot) - [ **Google BigQuery to Salesforce** Salesforce is a leading enterprise customer relationship management (CRM) platform.](https://apiant.ai/connect/google-bigquery-to-salesforce) ## More into Lob - [ **HubSpot to Lob** HubSpot is your all-in-one stop for all of your marketing software needs.](https://apiant.ai/connect/hubspot-to-lob) - [ **Salesforce to Lob** Salesforce is a leading enterprise customer relationship management (CRM) platform.](https://apiant.ai/connect/salesforce-to-lob) - [ **Slack to Lob** Slack is a messaging platform for teams. Post messages, manage channels, users, reminders, and react to...](https://apiant.ai/connect/slack-to-lob) - [ **Google Sheets to Lob** Google Sheets](https://apiant.ai/connect/google-sheets-to-lob) - [ **Gmail to Lob** Gmail is Google’s email service, featuring spam protection, search functions, and seamless integration with...](https://apiant.ai/connect/gmail-to-lob) - [ **Google Calendar to Lob** Google Calendar is a time management tool providing scheduling features, event reminders, and integration...](https://apiant.ai/connect/google-calendar-to-lob) Questions ## Google BigQuery and Lob, answered ### ### What can start an automation from Google BigQuery? Any of Google BigQuery's 4 triggers in the catalog, including New Job Completed, New Row, Query Job Completed (With Row Data) and Updated Row. Describe the moment in plain language and your agent picks the right one. ### ### What can your agent do in Lob when something happens in Google BigQuery? Any of Lob's 40 actions, including Create Address, Create Bank Account, Create Template and Send Check. Your agent maps the data both ways and tests every scenario before it ships. ### ### Can it also run from Lob to Google BigQuery? Lob has no triggers in the catalog today, so automations start in Google BigQuery. If you need the other direction, ask: your agent reads Lob's API documentation and adds it. ### ### Do I have to build a connector for Google BigQuery or Lob? No. Both are in the catalog with their triggers and actions. You describe the automation; your agent builds it, tests every scenario and keeps it running. ### ### Can my AI client use Google BigQuery and Lob without building an automation? Yes. With your AI client connected to APIANT, ask it to do something in either app once and it runs that action on the spot. Ask for an automation and your agent builds it, tests every scenario and keeps it running. One connection covers both. ### ### What happens when something fails? Your agent works that out for you. It plans the failure paths along with the happy path, then tests every scenario before it ships. ### ### Is there a free plan? Yes. Every plan includes the agent, including free, and building from your own AI client spends no assistant credits.