Integrate Google Bigquery with Insightly to automate workflows, sync data between apps, and eliminate repetitive tasks with AI-powered automation.
Delete Rows from Google BigQuery when New or Updated Contact in Insightly
Run SQL Query in Google BigQuery when New or Updated Contact in Insightly
Insert Rows into Google BigQuery when New or Updated Contact in Insightly
Update Rows in Google BigQuery when New or Updated Contact in Insightly
Create Table in Google BigQuery when New or Updated Contact in Insightly
Start from a real workflow other teams are already running.
Google Bigquery
When this happens...
Insightly
Automatically do this!
Create Record
Update Record
List Contact
List Emails
List Events
List Leads
List Lead Sources
List Lead Statuses
List Milestones
List Notes
List Opportunities
List Organisations
List Pipelines
List Pipeline Stages
List Projects
List Relationships
List Tasks
List Team Members
List Teams
List Users
Delete Rows from Google BigQuery when New or Updated Contact in Insightly
Use this flowRun SQL Query in Google BigQuery when New or Updated Contact in Insightly
Use this flowInsert Rows into Google BigQuery when New or Updated Contact in Insightly
Use this flowUpdate Rows in Google BigQuery when New or Updated Contact in Insightly
Use this flowCreate Table in Google BigQuery when New or Updated Contact in Insightly
Use this flowList BigQuery Projects in Google BigQuery when New or Updated Contact in Insightly
Use this flowList Datasets in Project in Google BigQuery when New or Updated Contact in Insightly
Use this flowList Tables In Dataset in Google BigQuery when New or Updated Contact in Insightly
Use this flowDelete Rows from Google BigQuery when New Document Template in Insightly
Use this flowRun SQL Query in Google BigQuery when New Document Template in Insightly
Use this flowEverything you can automate between Google Bigquery and Insightly.
When this happensTriggers
A trigger is an event that starts a workflow.
Triggers when a new contact is created or updated.
Triggers when new document template is created.
Triggers when new email is send.
Trigger when a event is created or updated.
Triggers when new lead is created or updated.
Triggers when new opportunity is created or updated.
Action is the task that follows automatically within your Google Bigquery integrations.
Deletes rows in a Google BigQuery table that match the condition you provide.
Run a SQL query on Google BigQuery and return the results.
Adds one or more rows to a BigQuery table.
Change specific fields for rows in a BigQuery table that match the rules you provide.
Creates a new, empty table in a BigQuery dataset.
Lists the BigQuery projects you have access to.

Follow a simple walkthrough to create, test, and launch your first automation.
Connect your apps
Link the apps you want to automate.
Configure your workflow
Set up triggers, actions, and map your data.
Test & publish
Test your workflow and publish it.
Recognized by leading review platforms and trusted by 10,000+ businesses worldwide.
Just describe the task in plain English. viaSocket AI selects the right apps, builds the workflow, maps the fields, and prepares everything for review before you publish.

Discover viaSocket, an AI-powered workflow automation platform with 2,000+ integrations. Learn what it is, how it works, and how to set up no-code automated workflows.

Five practical automation hacks to cut repetitive tasks and boost productivity using viaSocket, covering lead generation, onboarding, accounting, support, and HR.

Explore workflow automation: its definition, benefits, how it works, real-world examples, and how to automate with viaSocket.

Discover what webhooks are, how they work, and when to use them. Compare push-based webhooks with APIs and polling, with practical examples and ViaSocket integration.
viaSocket Support
We're here to help
Instant answers
AI assistant available 24/7
Expert support
Connect with our specialists
Trusted & secure
Your data is safe with us
No credit card required. Set up your first workflow in minutes.
BigQuery is Google's serverless and highly scalable enterprise data warehouse, designed to make all your data analysts productive.
Learn moreInsightly is a powerful CRM and project management tool designed to help businesses manage customer relationships, track sales, and streamline project workflows. With Insightly, you can easily organize and manage your contacts, leads, and opportunities, as well as collaborate with your team on projects and tasks.
Learn moreSign up for a free viaSocket account, then authorize both your Google Bigquery and Insightly accounts. From there, pick a trigger in one app and an action in the other. Your first workflow can be live in under five minutes.
Yes. viaSocket uses instant triggers where available, so data moves between Google Bigquery and Insightly as soon as the event happens. Scheduled polling triggers run at a maximum interval of 15 minutes.
Yes. You can map specific fields, apply filters to skip records that do not match your conditions, and transform values before they reach Insightly. No coding required.
Yes. You can set up a workflow where Google Bigquery triggers actions in Insightly, and a separate workflow where Insightly triggers actions in Google Bigquery. Both run independently and in real time.
viaSocket logs every run so you can see exactly what succeeded and what failed. Failed tasks can be retried from the dashboard without re-configuring the workflow.
Yes, there is a free plan that covers basic workflows between Google Bigquery and Insightly. Paid plans unlock higher task limits, faster polling, and advanced features like multi-step workflows and conditional logic.
No. The entire Google Bigquery and Insightly integration is built through a visual, point-and-click interface. Code blocks are available if you want them, but they are never required.