STEP 1
Connect Google BigQuery and Kintone
Save credentials in WEXTL once. We store them encrypted and reuse the authorization across every workflow [3]. No coding or API skills required.
Google BigQuery and Kintone Integration
Build database workflows between Google BigQuery and Kintone on a visual canvas — set up data fields sync between apps once and let data flow when events come automatically. Integration will work without code and your team will see the workflow inside WEXTL® builder.
3-day trialCancel anytimeUp to 10 minutes quick set up
- GDPR
- Data Encryption
- 2FA
- Local Data Region
Learn about Google BigQuery and Kintone
Detailed info you need to know about Google BigQuery and Kintone integrations in WEXTL. Explore which modules apps support and how you connect them.
Google BigQuery
Query and manage Google BigQuery datasets, tables, jobs, and routines — run SQL and stream rows. [5]
How to connect Google BigQuery to Kintone
Set up your Google BigQuery and Kintone integration in 3 simple steps [2] — no coding required. Up to 10 minutes setup.
STEP 2
Build a workflow
Paste selected Google BigQuery and Kintone 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 Google BigQuery and Kintone. Use filters or leverage a JS custom code step in between — everything is on the canvas.
How does the integration between Google BigQuery and Kintone work in WEXTL?
WEXTL exposes actions and triggers for Google BigQuery and Kintone that help you connect apps and automate repetitive tasks [1]. A trigger is an event that happens, an action — a step that performs when the event has occurred.
Google BigQuery triggersKintone actions
Google BigQuery modules
- Cancel JobCancels a running job.
- Create DatasetCreates a new dataset.
- Create JobCreates a query, load, copy, or extract job.
- Create RoutineCreates a new routine.
- Create Row Access PolicyCreates a row access policy.
- Create TableCreates a new table.
- Delete DatasetDeletes a dataset.
- Delete JobDeletes the metadata of a completed job.
- Delete ModelDeletes a model.
- Delete RoutineDeletes a routine.
- Delete Row Access Policies in BatchDeletes several row access policies.
- Delete Row Access PolicyDeletes a row access policy.
- Delete TableDeletes a table.
- Edit DatasetUpdates selected fields on a dataset.
- Edit ModelUpdates selected fields on a model.
- Edit TableUpdates selected fields on a table.
- Execute QueryRuns a SQL query.
- Get DatasetReturns a single dataset.
- Get JobReturns a single job.
- Get ModelReturns a single model.
- Get Query ResultsReturns results for a query job.
- Get RoutineReturns a single routine.
- Get Routine IAM PolicyReturns the IAM policy for a routine.
- Get Row Access PolicyReturns a single row access policy.
- Get Row Access Policy IAM PolicyReturns the IAM policy for a row access policy.
- Get Service AccountReturns the project's BigQuery service account.
- Get TableReturns a single table.
- Get Table IAM PolicyReturns the IAM policy for a table.
- Insert RowsInserts rows into a table.
- List DatasetsRetrieves datasets in a project.
- List JobsRetrieves jobs in a project.
- List ModelsRetrieves models in a dataset.
- List ProjectsRetrieves projects the user can access.
- List RoutinesRetrieves routines in a dataset.
- List Row Access PoliciesRetrieves row access policies on a table.
- List Table DataRetrieves rows from a table.
- List TablesRetrieves tables in a dataset.
- Make an API CallPerforms an arbitrary authorized API call.
- Set Routine IAM PolicySets the IAM policy for a routine.
- Set Table IAM PolicySets the IAM policy for a table.
- Test Routine IAM PermissionsTests IAM permissions on a routine.
- Test Row Access Policy IAM PermissionsTests IAM permissions on a row access policy.
- Test Table IAM PermissionsTests IAM permissions on a table.
- Undelete DatasetRestores a recently deleted dataset.
- Update DatasetReplaces an existing dataset.
- Update RoutineReplaces an existing routine.
- Update Row Access PolicyReplaces a row access policy.
- Update TableReplaces an existing table.
- Watch JobsTriggers when a new BigQuery job is created.
Kintone modules
- Add a CommentAdds a comment to a record.
- Add a CursorOpens a cursor over a set of records.
- Add a Preview AppCreates a new app in the preview environment.
- Add a RecordCreates a new record.
- Add a Space from a TemplateCreates a space from a template.
- Add a ThreadCreates a thread in a space.
- Add a Thread CommentAdds a comment to a space thread.
- Add Form FieldsAdds fields to the preview form.
- Add GuestsInvites guest users to the domain.
- Add Plug-insAdds plug-ins to the preview app.
- Add RecordsCreates up to one hundred records.
- Delete a CommentDeletes one comment from a record.
- Delete a CursorCloses a cursor.
- Delete a SpaceDeletes a space.
- Delete Form FieldsRemoves fields from the preview form.
- Delete GuestsRemoves guest users from the domain.
- Delete RecordsDeletes up to one hundred records.
- Deploy App SettingsPublishes preview changes to the live app.
- Download a FileDownloads a file from Kintone.
- Evaluate Record PermissionsReturns what the current user may do with each record.
- Get Action SettingsReturns the action settings of an app.
- Get a CursorReturns the next batch of records from a cursor.
- Get an AppReturns the name, description, and revision of one app.
- Get API ListRetrieves the list of REST APIs on this Kintone domain.
- Get API SchemaRetrieves the request and response schema for one REST API.
- Get App Admin NotesReturns the admin notes stored on an app.
- Get App Deploy StatusReturns whether a deploy is still running.
- Get App PermissionsReturns the app-level permission settings.
- Get App Plug-insReturns the plug-ins added to an app.
- Get AppsRetrieves apps the signed-in user can open.
- Get App UsageRetrieves usage figures for each app.
- Get a RecordReturns one record.
- Get a SpaceReturns one space.
- Get CommentsRetrieves comments on one record.
- Get CustomizationReturns the JavaScript and CSS customization of an app.
- Get Field PermissionsReturns the field permission settings of an app.
- Get FormReturns the form definition for an app.
- Get Form FieldsReturns the fields on an app's form.
- Get Form LayoutReturns the layout of an app's form.
- Get General Notification SettingsReturns the general notification settings of an app.
- Get General SettingsReturns the general settings of an app.
- Get Graph SettingsReturns the graphs configured on an app.
- Get Installed Plug-insRetrieves plug-ins installed on the domain.
- Get Per Record Notification SettingsReturns the per-record notification settings of an app.
- Get Plug-in AppsRetrieves the apps that use one plug-in.
- Get Process Management SettingsReturns the process management settings of an app.
- Get Record PermissionsReturns the record permission settings of an app.
- Get RecordsRetrieves records that match a query.
- Get Reminder Notification SettingsReturns the reminder notification settings of an app.
- Get Required Plug-insRetrieves plug-ins that installed apps still require.
Explore alternative integrations
There are other apps [9] supported by WEXTL that can be paired with Google BigQuery and Kintone integrations. Pick any from the list below if the current combination isn't the one you need.
Frequently asked questions
Common questions about connecting Google BigQuery and Kintone.
Connect your Google BigQuery and Kintone accounts once, pick a trigger in one app and an action in the other, then map the fields so data flows automatically between them. [3]
Example: when Google BigQuery's "Watch Jobs" fires, WEXTL can "Add a Comment" in Kintone. Google BigQuery has 1 trigger (including Watch Jobs); Kintone has 85 actions (including Add a Comment, Add a Cursor, and Add a Preview App). Add filters and transforms between steps when you need them. [1]
Yes — the integration works in both directions. Use each app's triggers to start a workflow and the other app's actions to update it. [2]
No. Google BigQuery-to-Kintone automations are built visually on the canvas. You can optionally add custom JavaScript with Functions when you need advanced logic. [4]
Yes. Trigger-based automations start the moment Google BigQuery (or Kintone) fires a new event — webhook-backed apps run within seconds, and polling-only apps re-check on a schedule you control. [7]
A first automation typically takes 5–10 minutes: connect each app's credential once, drop a trigger + action onto the canvas, map the fields, and turn the workflow on.
You can build your Google BigQuery + Kintone automation on a 3-day trial with every feature unlocked. Cancel anytime. For your protection, a small deposit is charged to your card when your trial starts. It counts toward your first payment and is non-refundable. [8]
References
List of sources used to gather information about the Google BigQuery and Kintone integration.
- Google BigQuery and Kintone integration source code, module specs and credentials implementation.
- Our Google BigQuery and Kintone integration documentation, structured input and output parameters, scopes, and authentication methods.
- Official vendor API documentation for Google BigQuery and Kintone — 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.
- Google BigQuery integration information
- Kintone integration information
- WEXTL® Scheduling
- WEXTL® Pricing and Trial
- WEXTL® Apps Library