Algolia and Google BigQuery Integration
Demonstration of how apps are integrated in WEXTL workflow builder[4]
Connect Algolia and Google BigQuery to automate database workflows. Trigger events from one app, run actions in the other and use AI to make smart decisions. Integrate apps in 3 simple steps - no code required.
- 3-day trial
- Cancel anytime
- Up to 10 minutes quick set up
- GDPR
- Data Encryption
- 2FA
- Local Data Region
Learn about Algolia and Google BigQuery
Detailed info you need to know about Algolia and Google BigQuery integrations in WEXTL. Explore which modules apps support and how you connect them.
Algolia

Hosted search with indexes, records, settings, rules, synonyms, analytics, A/B tests and data pipelines.[5]
Google BigQuery

Query and manage Google BigQuery datasets, tables, jobs and routines. Run SQL and stream rows.[6]
How to connect Algolia to Google BigQuery
Set up your Algolia and Google BigQuery integration in 3 simple steps[2]. No coding required. Up to 10 minutes setup.
STEP 1
Connect Algolia and Google BigQuery
Save credentials in WEXTL once. We store them encrypted and reuse the authorization across every workflow[3]. No coding or API skills required.
STEP 2
Build a workflow
Paste selected Algolia and Google BigQuery nodes onto the canvas[4], or describe what you want and WEXTL wires the flow together with AI Builder.
STEP 3
Map your data
Choose which fields need to sync between Algolia and Google BigQuery. Use filters or a JS custom code step in between. Everything is on the canvas.
How does the integration between Algolia and Google BigQuery work in WEXTL?
WEXTL exposes actions and triggers for Algolia and Google BigQuery that help you connect apps and automate repetitive tasks[1]. A trigger is an event that happens, and an action is a step that performs when the event has occurred.
Google BigQuery triggersAlgolia actions
Google BigQuery modules
- Cancel a Job Stops a BigQuery job that is still running, found by its Job ID in a project. Use Location when the job is in a single region or outside the us and eu multi-regions. Output includes the job Status and Statistics.
- Create a Dataset Creates a dataset named by Dataset ID. Use Location to choose where its data lives and Default Table Expiration Ms to set an expiry for new tables.
- Create a Job Kicks off a BigQuery job of any kind (query, load, copy or extract) from a Configuration without waiting for it to finish. Follow the new job with Get a Job or Watch Jobs.
- Create a Routine Adds a stored function or procedure to a dataset, defined by a Routine ID and Routine Type. Use Definition Body for its code and Arguments to declare its inputs.
- Create a Row Access Policy Restricts which rows of a table certain people can read. Use Filter Predicate for the condition rows must meet and Grantees for who may see them, under a new Policy ID.
- Create a Table Registers a table under a Table ID inside a dataset. Use Schema to define its columns, View to base it on a query, or Time Partitioning and Clustering to organise how rows are stored.
- Delete a Dataset Deletes a dataset from your project. Turn on Delete Contents to remove the tables inside it too, otherwise a dataset that still has tables cannot be deleted.
- Delete a Job Deletes one BigQuery job by its Job ID. Use Location to name the region the job ran in.
- Delete a Model Removes a BigQuery ML model from a dataset by Model ID.
- Delete a Routine Removes a user-defined function or procedure using its Routine ID.
- Delete a Row Access Policy Lifts a row-level restriction on a table by deleting one policy.
- Delete a Table Deletes the table identified by Table ID.
- Delete Row Access Policies in Batch Clears several row access policies from one table in a single call. Use Policy IDs to name them all, and Force to delete a policy even when it is the last one on the table.
- Edit a Dataset Updates the Description, Labels and Default Partition Expiration Ms of a dataset. Use Access to adjust who can reach it.
- Edit a Model Updates the Description, Friendly Name or Labels of a BigQuery ML model.
- Edit a Table Applies a partial change to a table, such as a new Friendly Name, Description, Schema or Labels. Use View to change the query of a saved view.
- Execute a Query Runs a SQL statement and waits for the answer. Turn on Dry Run to validate it without running it, set Use Legacy SQL for old syntax, and pass Query Parameters for parameterised SQL.
- Get a Dataset Shows the settings of one dataset by Dataset ID, including its Access list and default expiry values.
- Get a Job Looks up one job by Job ID to see its Configuration, Status and Statistics. Add Location when the job ran in a specific region.
- Get a Model Opens a BigQuery ML model by Model ID to read its Description, Encryptionconfiguration and the trial it chose as best.
- Get a Routine Reads one stored function or procedure by Routine ID, including its Definitionbody, Arguments and Determinismlevel.
- Get a Routine IAM Policy Shows who holds which roles on a routine, with an Etag and Version. Use Options to request a specific policy version.
- Get a Row Access Policy Fetches the policy behind a Policy ID, showing the Filterpredicate and Grantees it applies.
- Get a Row Access Policy IAM Policy Reads the IAM bindings of a row access policy, with Auditconfigs and an Etag.
- Get a Table Returns the Schema, Clustering and Creationtime of a table via its Table ID.
- Get a Table IAM Policy Lists the roles granted on a table, with Auditconfigs. Use Options to read a specific policy Version.
- Get Query Results Fetches the answer of a query that already ran, using its Job ID. Output includes Rows, Schema and Cachehit, plus a Pagetoken for further pages.
- Get the Service Account Finds the service account BigQuery uses for a project, returned as its Email.
- Insert Rows Streams new rows into a table from Rows in one call. Turn on Skip Invalid Rows to keep going past bad ones. Output includes any Inserterrors.
- List Datasets Lists the datasets in a project. Use Filter to match labels, All to include hidden datasets, and Limit to cut the result short.
- List Jobs Pages through BigQuery jobs, one item per job. Narrow them with State Filter, Min Creation Time, Max Creation Time or Parent Job ID, and include jobs owned by other people through All Users.
- List Models Lists every BigQuery ML model inside a dataset, each as a separate item with its Creationtime and Description. Use Limit to read only a few of them.
- List Projects Finds the Google Cloud projects your credential can open, each with its ID, Friendly Name and Numeric ID.
- List Routines Lists the functions and procedures stored in a dataset, one item each. Use Filter with routineType to show only one kind, and Read Mask to limit which fields are included.
- List Row Access Policies Shows every row access policy attached to a table as separate items with Filterpredicate and Grantees. Use Limit to receive fewer policies.
- List Table Data Reads rows straight from a table without running a query. Use Selected Fields to return only some columns and Limit to take a smaller slice. Output has the row values under F.
- List Tables Finds the tables and views in a dataset, giving the Schema and Creationtime of each. Use Limit to stop after the first few.
- Make an API Call Makes an authorized free-form request to the Google BigQuery REST API with your saved credential.
- Set a Routine IAM Policy Replaces the access policy of a routine from Policy. Add an Update Mask to limit which parts are written.
- Set a Table IAM Policy Writes a new access policy onto a table from Policy. Narrow the change with Update Mask.
- Test IAM Permissions on a Routine Checks which of the listed Permissions the current user holds on a routine. The granted ones are echoed back.
- Test IAM Permissions on a Row Access Policy Tests a list of Permissions against one row access policy. The ones the caller actually holds are returned.
- Test IAM Permissions on a Table Asks BigQuery which of the named Permissions apply to the caller on a table.
- Undelete a Dataset Brings back a dataset that was deleted recently. Set Deletion Time to pick a particular deleted version, otherwise the latest one is restored.
- Update a Dataset Overwrites a dataset with a fresh Friendly Name, Description, Location and Labels. Edit a Dataset covers more settings, including Access.
- Update a Routine Changes a stored routine by its Routine ID. Use Definition Body, Language and Arguments to change its code and inputs, and Return Type to change what it returns.
- Update a Row Access Policy Rewrites a row access policy with a new Filter Predicate and Grantees.
- Update a Table Replaces a table definition: Friendly Name, Description, Schema, View and Labels. Use Edit a Table for a partial change.
- Watch Jobs Checks a project on your schedule and starts the workflow once for each newly created BigQuery job. Use Limit to read fewer jobs on every poll.
Algolia modules
- Add a Record Puts a new record into an index and lets Algolia generate its object ID. Returns the Object ID along with the Task ID and Created At.
- Add an Allowed Source Adds an IP address range to the sources allowed to call your Algolia application. Use Description to note what the range is for.
- Add or Replace a Record Stores a whole record in an index under a given Object ID, overwriting any record already saved with that ID. Returns the Task ID, Updated At and Object ID.
- Apply A/B Test Variant Settings Applies the settings of one variant from an A/B test to your index, using the Variant ID of the variant you want to adopt.
- Batch Records in an Index Runs a list of write requests against one index in a single call. Returns a Task ID along with the Object IDs of the affected records.
- Batch Records in Multiple Indexes Sends a list of write requests that can each target a different index, all in one call. Returns the Task ID and Object IDs.
- Browse Records Reads every record of an index in pages of 100, stopping at the Limit. Add Query, Filters or Attributes To Retrieve to narrow what is read.
- Copy or Move an Index Copies or renames an index to a new target, depending on the Operation. Use Scope to copy only parts such as settings, rules or synonyms.
- Create a Destination Defines where ingested data lands, from a Type, a Name and the Input JSON. Add an Authentication ID or Transformation IDs to wire in credentials and clean-up steps.
- Create a Query Suggestions Config Builds a Query Suggestions index out of the popular searches in your Source Indices. Use Index Name to name it and Languages, Exclude or Enable Personalization to tune the suggestions.
- Create a Rule Saves one rule under an Object ID, built from its Consequence. Add Conditions to say when it fires, Validity for a time window and Enabled to switch it on or off.
- Create a Synonym Saves one synonym under an Object ID, in the form set by its Type. Fill the matching fields for that Type, such as Synonyms for a regular synonym or Word and Corrections for a typo entry.
- Create a Task Links a Source ID to a Destination ID and an Action to run on the Algolia index. Use Cron for a schedule and Failure Threshold to set when runs count as failed.
- Create a Transformation Saves a named code step that reshapes records during ingestion. Use Code to hold the script and Description to explain it, and the new Transformation ID is returned.
- Create an A/B Test Sets up an A/B test with a Name, Variants, Metrics and an End At date. Add a Hypothesis to record what you expect, and the new Ab Test ID is returned.
- Create an API Key Creates a key limited by its Acl permissions. Restrict where and for how long it works with Indexes, Referers and Validity, and cap response size with Max Hits Per Query.
- Create an Authentication Saves login details that a source or destination can reuse, from a Type, a Name and the Input JSON. Returns the Authentication ID.
- Create an Ingestion Source Registers a data source from its Type and Name, with optional Input and an Authentication ID for access. Returns the new Source ID.
- Create Multiple Rules Saves a long list of rules to an index in one call. Turn on Clear Existing Rules to start from an empty rule set, and Forward To Replicas to copy them to replicas.
- Create Multiple Synonyms Writes many synonyms to an index in one call. Turn on Replace Existing Synonyms to discard the current ones first.
- Delete a Destination Removes an ingestion destination from your Algolia application.
- Delete a Personalization Profile Removes the profile built for a User Token.
- Delete a Query Suggestions Config Deletes the Query Suggestions configuration of an index.
- Delete a Recommend Rule Deletes a rule from one Recommend model of an index.
- Delete a Record Deletes the record with a given Object ID.
- Delete a Rule Deletes a query rule from its index. Use Forward To Replicas to apply the removal to replicas as well.
- Delete a Synonym Removes a synonym with a given Object ID. Turn on Forward To Replicas to remove it on replicas too.
- Delete a Task Deletes an ingestion task from your Algolia application.
- Delete a Transformation Deletes a transformation script from your account.
- Delete All Records Removes every record in an index.
- Delete All Rules Clears every rule from an index. Turn on Forward To Replicas to clear the replicas too.
- Delete All Synonyms Clears every synonym saved on an index. Use Forward To Replicas to repeat that on the replicas.
- Delete an A/B Test Removes an A/B test from your analytics, and returns its Ab Test ID.
- Delete an Allowed Source Removes an IP address or CIDR block from the sources allowed to call your application.
- Delete an API Key Revokes an API key from your Algolia application.
- Delete an Authentication Removes a saved authentication used by ingestion sources and destinations.
- Delete an Index Deletes an index together with all the records it holds.
- Delete an Ingestion Source Deletes an Ingestion Source that feeds your ingestion tasks.
- Delete Records by Filter Deletes every record that matches the Filters, Facet Filters, Numeric Filters, Tag Filters or a geographic area such as Around Lat Lng.
- Delete User Token Events Removes every Insights event stored for a User Token.
- Disable a Task Turns an ingestion task off. Returns its Task ID and Updated At.
- Enable a Task Turns a disabled ingestion task back on. Returns its Task ID and Updated At.
- Estimate an A/B Test Estimates the sample size and duration an A/B test needs, from its Configuration and Variants. Run it before creating the test to plan how long to leave it running.
- Get a Destination Reads the Type, Name and Input of one ingestion destination in your account.
- Get a Personalization Profile Reads the profile built for one User Token, with its Scores and the time of the Last Event At.
- Get a Query Suggestions Config Reads the setup of one Query Suggestions index, including the Source Indices it draws from, its Languages and its Exclude list.
- Get a Recommend Rule Reads a rule defined for a Recommend Model, showing its Condition and Consequence.
- Get a Recommend Task Checks the Status of a write on a Recommend Model of an Index, using the Task ID returned when it was sent.
- Get a Record Retrieves a record held in an Index using its Object ID. Use Attributes To Retrieve to limit the fields that are returned.
- Get a Rule Retrieves a rule through its Object ID, showing its Conditions, Consequence and whether it is Enabled.
Explore alternative integrations
There are other apps[9] supported by WEXTL that can be paired with Algolia and Google BigQuery integrations. Pick any from the list below if the current combination isn't the one you need.
Frequently asked questions
Common questions about connecting Algolia and Google BigQuery.
References
List of sources used to gather information about the Algolia and Google BigQuery integration.
- Algolia and Google BigQuery integration source code, module specs and credentials implementation.
- Our Algolia and Google BigQuery integration documentation, structured input and output parameters, scopes, and authentication methods.
- Official vendor API documentation for Algolia and Google BigQuery, used to verify field meanings, authentication flows, and anything our own specs don't fully capture.
- WEXTL® visual workflow builder, anonymized data from our technical support team.
- Algolia integration information
- Google BigQuery integration information
- WEXTL® Scheduling
- WEXTL® Pricing and Trial
- WEXTL® Apps Library
How we write our apps documentation
Explore how WEXTL® crafted Algolia and Google BigQuery integration page documentation. Used sources, the role of AI, and how the team validates the result.