Integration
Connect Google BigQuery and Outlook
When New Job Completed fires in Google BigQuery, your agent runs Create Contact Folder in Outlook, or New Calendar Event in Outlook to Create Row in Google BigQuery. Describe the whole flow and it is built, tested on every scenario and kept running.
What the catalog holds today. Ask for anything missing and your agent reads the API documentation and adds it.
Build solutions, not workarounds.
What do you want Google BigQuery and Outlook to do together?
Ask the assistant
Connect your AI client
Give your AI client this address.
https://mcp.apiant.aiOne 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.aiStart Claude Code there, approve the server, and sign in in the browser page it opens.
Claude Code guide (opens in a new tab)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)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)Zed
Open Settings, then AI, then MCP Servers, then Add Server, then Add Remote Server.
Setup guide (opens in a new tab)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)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)Example flows
What Google BigQuery and Outlook can do together
From Google BigQuery to Outlook
When New Job Completed in Google BigQuery
then Create Contact Folder in Outlook
When New Row in Google BigQuery
then Create Email Rule in Outlook
From Outlook to Google BigQuery
When New Calendar Event in Outlook
then Create Row in Google BigQuery
When New Contact Added in Outlook
then Create Rows in Google BigQuery
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 Outlook
Triggers and actions 9 triggers · 53 actions
Trigger
New Job CompletedTriggers when a BigQuery job in the project finishes, whether it succeeded or failed.
Trigger
New RowTriggers 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 RowTriggers when a row in a table is added or changed, detected by a last-updated timestamp column you name.
Action
Create RowCreates a new row of data in a table. Note: Does not create a job.
Action
Create RowsCreates new rows of data in a table (accepts line items). Note: Does not create a job.
Action
Delete RowsDeletes every row in a table whose match column equals the value you give.
Action
Find One RowFinds the first row in a table whose column equals the value you give.
Action
Get Rows for Job CompletedReturns the result rows of a finished query job.
Action
Import DataImports 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 DatasetsReturns the datasets in a Google Cloud project.
Action
List TablesReturns the tables in a BigQuery dataset.
Action
Run a QueryRuns 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
Calendar Event ChangesTriggered when a new calendar event occurs (created, updated, or deleted) in the Outlook calendar.
Trigger
New Calendar EventTriggered when a new calendar event is created in the Outlook calendar.
Trigger
New Contact AddedTriggered when a new contact is added in the Outlook contacts.
Trigger
New Outlook MessageTriggered when a new message is received in the Outlook mailbox.
Trigger
New Sent MessageTriggered when a new message is sent from the Outlook mailbox.
Action
Add Mail AttachmentTool to add an attachment to an email message. use when you have a message id and need to attach a small (<3 mb) file or reference.
Action
Create CalendarTool to create a new calendar in the signed-in user's mailbox. use when organizing events into a separate calendar.
Action
Create Contact FolderTool to create a new contact folder in the user's mailbox. use when needing to organize contacts into custom folders.
Action
Create Email RuleCreate email rule filter with conditions and actions
Action
Create Mail FolderTool to create a new mail folder. use when you need to organize email into a new folder.
Action
Create Master CategoryTool to create a new category in the user's master category list. use after selecting a unique display name.
Action
Delete Mail FolderDelete a mail folder from the user's mailbox. use when you need to remove an existing mail folder.
Action
Download Outlook AttachmentDownloads a specific file attachment from an email message in a microsoft outlook mailbox; the attachment must contain 'contentbytes' (binary data) and not be a link or embedded item.
Action
Get Mailbox SettingsTool to retrieve mailbox settings. use when you need to view settings such as automatic replies, time zone, and working hours for the signed-in or specified user.
Action
Get Mail DeltaTool to retrieve incremental changes (delta) of messages in a mailbox. use when syncing mailbox updates since last checkpoint.
Action
Get Mail TipsTool to retrieve mail tips such as automatic replies and mailbox full status. use when you need to check recipient status before sending mail.
Action
Get Master CategoriesTool to retrieve the user's master category list. use when you need to get all categories defined for the user.
Action
Get Supported LanguagesTool to retrieve supported languages in the user's mailbox. use when you need to display or select from available mailbox languages.
Action
Get Supported Time ZonesTool to retrieve supported time zones in the user's mailbox. use when you need a list of time zones to display or choose from for event scheduling.
Action
List CalendarsTool to list calendars in the signed-in user's mailbox. use when you need to retrieve calendars with optional odata queries.
Action
List Event AttachmentsTool to list attachments for a specific outlook calendar event. use when you have an event id and need to view its attachments.
Action
List Outlook AttachmentsLists metadata (like name, size, and type, but not `contentbytes`) for all attachments of a specified outlook email message.
Action
List RemindersTool to retrieve reminders for events occurring within a specified time range. use when you need to see upcoming reminders between two datetimes.
Action
Outlook Add Event AttachmentAdds an attachment to a specific outlook calendar event. use when you need to attach a file or nested item to an existing event.
Action
Outlook Calendar Create EventCreates a new outlook calendar event, ensuring `start datetime` is chronologically before `end datetime`.
Action
Outlook Create ContactCreates a new contact in a microsoft outlook user's contacts folder.
Action
Outlook Create DraftCreates an outlook email draft with subject, body, recipients, and an optional attachment. supports creating drafts as part of existing conversation threads by specifying a conversationid; attachments require a name, mimetype, and content.
Action
Outlook Create Draft ReplyCreates a draft reply in the specified user's outlook mailbox to an existing message (identified by a valid `message id`), optionally including a `comment` and cc/bcc recipients.
Action
Outlook Delete ContactPermanently deletes an existing contact, using its `contact id` (obtainable via 'list user contacts' or 'get contact'), from the outlook contacts of the user specified by `user id`.
Action
Outlook Delete EventDeletes an existing calendar event, identified by its unique `event id`, from a specified user's microsoft outlook calendar, with an option to send cancellation notifications to attendees.
Action
Outlook Get ContactRetrieves a specific outlook contact by its `contact id` from the contacts of a specified `user id` (defaults to 'me' for the authenticated user).
Action
Outlook Get Contact FoldersTool to retrieve a list of contact folders in the signed-in user's mailbox. use after authentication when you need to browse or select among contact folders.
Action
Outlook Get EventRetrieves the full details of a specific calendar event by its id from a user's outlook calendar, provided the event exists.
Action
Outlook Get MessageRetrieves a specific email message by its id from the specified user's outlook mailbox. use the 'select' parameter to include specific fields like 'internetmessageheaders' for filtering automated emails.
Action
Outlook Get ProfileRetrieves the microsoft outlook profile for a specified user.
Action
Outlook Get ScheduleRetrieves free/busy schedule information for specified email addresses within a defined time window.
Action
Outlook List ContactsRetrieves a user's microsoft outlook contacts, from the default or a specified contact folder.
Action
Outlook List EventsRetrieves events from a user's outlook calendar via microsoft graph api, supporting pagination, filtering, property selection, sorting, and timezone specification.
Action
Outlook List Mail FoldersTool to list a user's top-level mail folders. use when you need folders like inbox, drafts, sent items; set include hidden folders=true to include hidden folders.
Action
Outlook List MessagesRetrieves a list of email messages from a specified mail folder in an outlook mailbox, with options for filtering (including by conversationid to get all messages in a thread), pagination, and sorting; ensure 'user id' and 'folder' are valid, and all date/time strings are in iso 8601 format.
Action
Outlook Move MessageMove a message to another folder within the specified user's mailbox. this creates a new copy of the message in the destination folder and removes the original message.
Action
Outlook Reply EmailSends a plain text reply to an outlook email message, identified by `message id`, allowing optional cc and bcc recipients.
Action
Outlook Search MessagesSearches messages in a microsoft 365 or enterprise outlook account mailbox, supporting filters for sender, subject, attachments, pagination, and sorting by relevance or date.
Action
Outlook Send EmailSends an email with subject, body, recipients, and an optional attachment via microsoft graph api; attachments require a non-empty file with valid name and mimetype.
Action
Outlook Update Calendar EventUpdates specified fields of an existing outlook calendar event.
Action
Outlook Update ContactUpdates an existing outlook contact, identified by `contact id` for the specified `user id`, requiring at least one other field to be modified.
Action
Outlook Update EmailUpdates specified properties of an existing email message; `message id` must identify a valid message within the specified `user id`'s mailbox.
Action
Update Mailbox SettingsTool to update mailbox settings for the signed-in user. use when you need to configure automatic replies, default time zone, language, or working hours. example: schedule automatic replies for vacation.
No trigger or action matches that. Ask your agent to add it: it reads the API documentation and builds what you describe.
Each app on its own
Reviews
What our customers say
More from Google BigQuery
Google BigQuery to HTML to ImageHTML to Image is a Powerful Image Generation API to convert HTML/CSS to Image and to take screenshots of...
Google BigQuery to PaperCleanClean document photos for printing, remove shadows, fix lighting
Google BigQuery to ResendResend is the email API for developers. It's designed for you to build, test, and send transactional and...
Google BigQuery to TypeSafeTypeSafe's Jev model answers typed questions about a piece of content and tells you how certain it is.
Google BigQuery to HubSpotHubSpot is your all-in-one stop for all of your marketing software needs.
Google BigQuery to SalesforceSalesforce is a leading enterprise customer relationship management (CRM) platform.
More into Outlook
HubSpot to OutlookHubSpot is your all-in-one stop for all of your marketing software needs.
Gmail to OutlookGmail is Google’s email service, featuring spam protection, search functions, and seamless integration with...
Pipedrive to OutlookPipedrive is a sales CRM and pipeline management tool.
Anchor to OutlookGet freedom from the burden of invoicing and collections.
Conversion Tools to OutlookConverting your documents between different formats (XML, Excel, CSV, PDF, etc). Fast and Simple.
DocuWriter.ai to OutlookAI-powered service that generates code documentation, tests, and optimizations from your source code files
Questions
Google BigQuery and Outlook, 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 Outlook when something happens in Google BigQuery?
Any of Outlook's 43 actions, including Create Calendar, Create Contact Folder, Create Email Rule and Create Mail Folder. Your agent maps the data both ways and tests every scenario before it ships.
Can it also run from Outlook to Google BigQuery?
Yes. When something happens in Outlook, your agent can act in Google BigQuery too. This page covers both directions: Outlook's triggers and Google BigQuery's actions are listed here as well.
Do I have to build a connector for Google BigQuery or Outlook?
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 Outlook 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.