Databox and Gigasheet Integration
Connect Databox and Gigasheet to automate analytics 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 Databox and Gigasheet
Detailed info you need to know about Databox and Gigasheet integrations in WEXTL. Explore which modules apps support and how you connect them.
How to connect Databox to Gigasheet
Set up your Databox and Gigasheet integration in 3 simple steps[2]. No coding required. Up to 10 minutes setup.
STEP 1
Connect Databox and Gigasheet
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 Databox and Gigasheet 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 Databox and Gigasheet. Use filters or a JS custom code step in between. Everything is on the canvas.
How does the integration between Databox and Gigasheet work in WEXTL?
WEXTL exposes actions and triggers for Databox and Gigasheet 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.
Databox triggersGigasheet actions
Databox modules
- Create a Data Source Opens a data source for custom data. Leave Time Zone empty for UTC, or use Account to create it under a specific account.
- Create a Dataset Defines a dataset inside a data source with a Schema of typed columns. Use Primary Key so rows with the same key replace each other.
- Create a Metric Builds a metric on a dataset from a Measure Column and a Date Column. Choose an Aggregation, split by Dimensions and limit rows through Filters.
- Create a User Adds a person by Email with a chosen Role. The owner role cannot be assigned.
- Create an Account Adds an account to your Databox organization. Give it a Website URL and use Managed By to assign the user who runs it.
- Delete a Connection Removes a saved link to an outside service from Databox.
- Delete a Data Source Deletes a data source, the container that holds datasets, from your Databox organization.
- Delete a Dataset Removes a dataset from its data source in Databox.
- Delete a Dataset Modification Removes the modification from a dataset, which brings back its original columns.
- Delete a Metric Removes a metric that was defined on a dataset in Databox.
- Delete a User Deletes a member of your Databox organization.
- Delete an Account Deletes an account from your Databox organization.
- Duplicate a Dataset Copies a dataset into a new one. Use Name to title the copy.
- Get a Connection Looks up a connection, showing its Integration Key, Status Info and Data Sources Count.
- Get a Data Source Returns a data source with its Integration Key, Timezone and Status Info.
- Get a Dataset Reads a dataset with its Type, Timezone and Verification Info.
- Get a Dataset Ingestion Looks up one data load into a dataset, with its Status, Duration, Summary and Errors.
- Get a Dataset Lineage Maps a dataset to its Parents and Children, so you see what feeds it and what depends on it.
- Get a Dataset Modification Reads the modification currently applied to a dataset, covering Filters, Formulas, Display Names, Order and Visibility.
- Get a Dataset Schema Lists the column Items of a dataset and its Primary Key.
- Get a Dataset Verification Tells whether a dataset Is Verified, and when and by whom through Verified At and Verified By.
- Get a Metric Fetches a metric with its Description, Dimensions and whether it Supports Drilldown.
- Get a Metric Lineage Shows the Parents and Children of a metric, meaning what it is built from and what it feeds.
- Get a Metric Verification Checks whether a metric Is Verified, with Verified At and Verified By.
- Get a Profile Returns the signed-in user with Email, Role and Organization.
- Get a User Fetches a user with Email, Role and whether the Is Email Verified flag is set.
- Get an Account Fetches an account with its Company Name, Website URL and who it is Managed By.
- Get an Integration Pulls an integration with its Key, Description and whether it Supports Datasets.
- Get Billing Details Reads the Plan Name, Plan Status and Billing Period of the subscription, with its Billing Email.
- Get Connection Permissions Shows who may use a connection through Access Level and Access List, and whether it is Shared With Accounts.
- Get Data Source Permissions Shows the Access Level of a data source and the Access List of users allowed in.
- Get Dataset Column Metadata Reads the descriptive metadata attached to each column of a dataset, as a list of Items.
- Get Dataset Ingestion Statistics Summarizes loads into a dataset with the Success Rate, Avg Success Duration and Daily Statistics.
- Get Dataset Metadata Returns the Description, Synonyms and Default Time Dimension of a dataset.
- Get Dataset Permissions Shows the Access Level of a dataset and the Access List of users with access.
- Get Dataset Sync Statistics Reports the Last Successful Update At time, Success Rate and Daily Statistics of dataset syncs.
- Get Metric Data Reads values of a metric between Date From and Date To, grouped by Granularity. Split with Dimensions or limit rows with Filters, and add Source ID when the metric ID lacks one.
- Get Metric Drilldown Data Pulls the underlying rows of a metric between Period From and Period To, using the Source ID of the metric. Sort with Sort By and Sort Order, and stop at Limit rows.
- Get Organization Usage Counts what the organization uses, with Users, Data Sources, Accounts and Ai Credits.
- Get the Organization Fetches the organization profile with Company Name, Address and Tax Number.
- List Accounts Pages through the accounts of your organization. Use Search to match a name, Sort By and Sort Order to arrange them, and Limit to stop early.
- List Activity Log Gives log entries listing the Action, User and Resource Type of each change. Narrow with Date From, Date To or Search, and stop at Limit.
- List Connections Lists saved links to outside services, with Integration Key and whether each is Shared With Accounts. Use Search to match names.
- List Countries Lists the countries Databox knows, each by its Name and Code.
- List Dashboard Metrics Collects the Datablocks of one dashboard, showing which metrics it displays.
- List Dashboards Retrieves dashboards with their Tags and Integration Keys. Use Search to find one by name.
- List Data Source Sync Frequencies Offers the Sync Interval choices of a data source, marking which Is Default and which Is Selected.
- List Data Sources Retrieves data sources. Filter with Connection or Search, order with Sort By and Sort Order, and use Limit to stop early.
- List Dataset Ingestions Lists the data loads into a dataset with Initiated At, Status and Initiated By, up to a Limit.
- List Dataset Modification Functions Lists formula functions usable in dataset modifications, with their Signature, Parameters and Example.
Gigasheet modules
- Add a Geolocation Looks up the geolocation of each IP address in a column. Uses one API call. Drawn from your plan.
- Add an Iterator Column Numbers the rows in a new column called Column Name. Use Filter Model to number only matching rows and Sort Model to number them in a chosen order. Takes one API call. Billed to your plan.
- Add Conditional Labels Builds a new column whose labels come from the Cases, written as a JSON list. Use Output Column to name it and Default Label for rows that match no case. Costs one API call. Deducted from your plan.
- Append Rows Adds rows to the bottom of a sheet from the Body (JSON). Use Append Rows by Column Name when your rows are keyed by column name. Uses one API call. Taken off your plan.
- Append Rows by Column Name Adds rows to the bottom of a sheet from the Body (JSON), keyed by column name. Bills one API call. Deducted from your plan.
- Append Rows from Another Sheet Copies every row of a Source Sheet onto the end of a Target Sheet. Turn on Add Unmatched Columns to keep columns only the source has, and Trim Column Names to ignore extra spaces in headings. Spends one API call. Drawn from your plan.
- Apply HTTP Enrichment Runs a custom HTTP enrichment over a sheet with the Request Settings. Follow the task with Get HTTP Enrichment Status. Draws one API call. Counted on your plan.
- Build an AI Formula Turns a plain-language Prompt into a Gigasheet formula for a sheet and returns the Formula text. Charges one API call. Drawn from your plan.
- Cancel an HTTP Enrichment Stops a custom HTTP enrichment that is still running. One API call each. Charged to your plan.
- Change Case Use Case to turn every value of a column into upper case, lower case, capitalized or proper case text. Takes one API call. Counted on your plan.
- Change Column Type Converts a column to the new Cast Type. Use Cast Format to add the format that goes with that type. Costs one API call. Billed to your plan.
- Chat with Sheet Assistant Sends a Message to the AI assistant attached to a sheet and gets its answer about that data. Spends one API call. Taken off your plan.
- Check a Formula Tests whether a Formula is valid for the sheet before you run it. Takes one API call. Billed to your plan.
- Check Combine Files Dry-runs a combine of the Sheets and returns every error found, without creating anything. Costs one API call. Deducted from your plan.
- Check Combine Files by Name Dry-runs a combine of the Sheets by column name and returns every error found, without creating anything. One API call each. Taken off your plan.
- Check Email Format Tests whether each value of the Email Column is a correctly formed address. Spends one API call. Counted on your plan.
- Check Federated Table Tests whether the Members can form a federated table before you create one. Add a File Name and Parent Folder to try the exact target. Uses one API call. Charged to your plan.
- Check Source Availability Reports whether a chosen Connector source can be reached right now, returning Is Available. Bills one API call. Billed to your plan.
- Clean Company Names Standardizes the company names held in a column using the Gigasheet cleaner. Draws one API call. Drawn from your plan.
- Combine Columns Joins the values of several Columns, in order, under a new heading called Name. Put Separator text between the values. Charges one API call. Taken off your plan.
- Combine Files Merges the Sheets in order into a new sheet. Use Folder to place it, In Place to combine into the first sheet, and Add Input File Name to add the source sheet name as a column. One API call each. Deducted from your plan.
- Combine Files by Name Merges several Sheets by matching column names into a sheet called New Sheet Name. Turn on Case Insensitive and Trim Column Names to match headings more loosely. Costs one API call. Counted on your plan.
- Copy a File Duplicates a sheet or folder under File Name. Use Folder to place the copy, Recursive to copy the content of a folder too, and Copy State to copy a sheet state of your choosing. Takes one API call. Drawn from your plan.
- Count Activity Totals the activity entries on a sheet. Narrow them by Actions, Categories, Users or a Query, and bound them with Start and End. Spends one API call. Charged to your plan.
- Count Duplicate Rows Reports how many rows repeat across the chosen Columns. Run it ahead of Delete Duplicate Rows to see the impact. Uses one API call. Deducted from your plan.
- Count Groups Gives the number of groups formed by the Group Columns, limited to rows that pass a Filter Model. Bills one API call. Counted on your plan.
- Count Rows Returns how many rows a sheet holds, or only the ones that satisfy a Filter Model. Gigasheet bills one API call for each count.
- Create a Blank Sheet Makes an empty sheet called File Name with a set number of Columns and Rows. Turn on Upload to Team to add it to the team library. Draws one API call. Taken off your plan.
- Create a Connection Registers a data connection for a Connector from the Parameters it needs. Charges one API call. Charged to your plan.
- Create a Connector Source Adds a source such as hubspot to a connector from its Parameters, plus a Code, Org or User if the source asks for them. Uses one API call. Billed to your plan.
- Create a Federated Table Builds one federated table called File Name from several sheets. Use Members to list them and Parent Folder to store the table in a folder. Costs one API call. Drawn from your plan.
- Create a File Entry Adds an entry called File Name to the library. Turn on Skip Type Inference to keep every column as text and Skip Notification to stop the email. Takes one API call. Taken off your plan.
- Create a Folder Adds a folder called Name to your Gigasheet files, inside a Parent Folder when one is set. Its Handle is returned. Each run costs one API call on your Gigasheet plan.
- Create a Linked Sheet from a View Creates a linked sheet from a View, called Name and filed under Parent Folder. The Handle of the new sheet is returned. Spends one API call. Deducted from your plan.
- Create a View Saves a view of a sheet under Name, taking its layout from the client state with the Client State ID. Bills one API call. Drawn from your plan.
- Create an Export Starts exporting a sheet using the Grid State filters, sort and grouping. Use Row Limit to export only the first rows, Records per File to split the output, and Callback URL to be told when it finishes. One API call each. Billed to your plan.
- Delete a Column Deletes the chosen Column of a sheet. Charges one API call. Deducted from your plan.
- Delete a Connector Source Removes a data source that was attached to a Connector. Takes one API call. Charged to your plan.
- Delete a Saved Filter Deletes a filter template saved in your account. Charges one API call. Billed to your plan.
- Delete a Sheet Removes a sheet or folder from your library. Turn on Recursive to delete a folder together with its contents. This cannot be undone. This uses up one API call too.
- Delete a View Deletes the chosen View from a sheet. One API call each. Drawn from your plan.
- Delete Assistant History Deletes the chat log of the sheet assistant for one sheet. Draws one API call. Charged to your plan.
- Delete Columns Removes several Columns from a sheet in one request. One API call each. Counted on your plan.
- Delete Columns by Name Deletes every heading listed under Column Names from a sheet. Costs one API call. Taken off your plan.
- Delete Duplicate Rows Removes every duplicate row across the Columns, leaving one row per set. Use Filter Model to limit which rows are considered and Sort Model to choose which row stays. Spends one API call. Billed to your plan.
- Delete Rows Removes the listed Rows from a sheet. This cannot be undone. Uses one API call. Counted on your plan.
- Delete Rows Matching Filter Deletes all rows that satisfy a Filter Model. This cannot be undone. Bills one API call. Taken off your plan.
- Delete Rows Not Matching Filter Removes every row that fails a Filter Model, leaving only the matches. This cannot be undone. Draws one API call. Deducted from your plan.
- Describe a Sheet Reads the details of one sheet, including its File Name, Owner, Parent Directory and File Rows.
- Describe a Sheet Version Reads an earlier Version of a sheet, with its File Name, Status, Last Updated time and Headers.
Explore alternative integrations
There are other apps[9] supported by WEXTL that can be paired with Databox and Gigasheet integrations. Pick any from the list below if the current combination isn't the one you need.
Frequently asked questions
Common questions about connecting Databox and Gigasheet.
References
List of sources used to gather information about the Databox and Gigasheet integration.
- Databox and Gigasheet integration source code, module specs and credentials implementation.
- Our Databox and Gigasheet integration documentation, structured input and output parameters, scopes, and authentication methods.
- Official vendor API documentation for Databox and Gigasheet, 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.
- Databox integration information
- Gigasheet integration information
- WEXTL® Scheduling
- WEXTL® Pricing and Trial
- WEXTL® Apps Library
How we write our apps documentation
Explore how WEXTL® crafted Databox and Gigasheet integration page documentation. Used sources, the role of AI, and how the team validates the result.

