Gigasheet and Metabase Integration
Keep Gigasheet and Metabase matched by integrating their events and actions. When analytics events happen in Gigasheet, update the Metabase automatically - without any line of code in visual workflow builder.
- 3-day trial
- Cancel anytime
- Up to 10 minutes quick set up
- GDPR
- Data Encryption
- 2FA
- Local Data Region
Learn about Gigasheet and Metabase
Detailed info you need to know about Gigasheet and Metabase integrations in WEXTL. Explore which modules apps support and how you connect them.
How to connect Gigasheet to Metabase
Set up your Gigasheet and Metabase integration in 3 simple steps[2]. No coding required. Up to 10 minutes setup.
STEP 1
Connect Gigasheet and Metabase
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 Gigasheet and Metabase 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 Gigasheet and Metabase. Use filters or a JS custom code step in between. Everything is on the canvas.
How does the integration between Gigasheet and Metabase work in WEXTL?
WEXTL exposes actions and triggers for Gigasheet and Metabase 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.
Gigasheet triggersMetabase actions
Gigasheet modules
- Watch Callbacks Starts a workflow when Gigasheet calls its callback address after an upload or export finishes. Each call brings its Handle and Message.
- 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.
Metabase modules
- Add a User to a Permission Group Makes a user a member of a permission group in Metabase. Use Body to send the membership fields.
- Append CSV to a Table Adds the rows of a CSV file to an existing Metabase table. Use Body to pass the request fields for the upload.
- Archive a Segment Archives a segment stored in Metabase.
- Create a Bookmark Bookmarks an item in Metabase for the connected user.
- Create a Card Saves a card that holds a query and its chart settings. Use Type to make it a question, metric or model, and Collection to file it.
- Create a Collection Starts a collection in Metabase. Use Parent Collection to nest it inside another, or Authority to mark it official.
- Create a Comment Posts a comment on an object in Metabase, attached through its Target Type and Target ID.
- Create a Dashboard Builds a dashboard in Metabase. Use Collection to place it among your collections and Parameters to add dashboard parameters.
- Create a Dashboard Subscription Creates a dashboard subscription, called a pulse in the Metabase API. Use Cards to list its cards and Channels to set where it goes.
- Create a Database Connects a database to Metabase. Use Details to pass the connection settings.
- Create a Document Writes a document into Metabase, with its content coming from Document.
- Create a Glossary Entry Records a glossary entry that pairs a Term with its Definition.
- Create a Notification Builds a notification in Metabase out of a Payload Type and Payload. Use Handlers to add a Channel and Channel Type for each place it is sent.
- Create a Permission Group Registers a new permission group in Metabase for controlling access. Use Body to describe the group.
- Create a Segment Defines a segment in Metabase. Use Body to write out the segment definition.
- Create a Snippet Saves a native query snippet in Metabase. Use Body to hand over the snippet content.
- Create a Timeline Starts a timeline in Metabase, with its fields passed through Body.
- Create a Timeline Event Records an event on a Metabase timeline, with the event fields supplied through Body.
- Create a User Adds a user to Metabase from an Email address. Use First Name and Last Name to record who they are, and Group Memberships to place them in permission groups.
- Create an Action Defines an action in Metabase. Use Model to attach it to one of your cards.
- Create an API Key Generates an API key in Metabase. Use Group to place the key in a permission group.
- Delete a Bookmark Removes a bookmark that points at an item in Metabase.
- Delete a Card Deletes a saved card that lives in Metabase.
- Delete a Collection Removes a collection from the Metabase instance.
- Delete a Comment Deletes a comment attached to an object in Metabase.
- Delete a Dashboard Deletes a dashboard stored on your Metabase instance.
- Delete a Database Removes a connected database from Metabase.
- Delete a Document Deletes a stored document on your Metabase instance.
- Delete a Permission Group Deletes a permission group on your Metabase instance.
- Delete a Timeline Removes a timeline of events from Metabase.
- Delete a Timeline Event Deletes one event off a Metabase timeline.
- Delete an Action Removes a saved action that Metabase stores.
- Delete an API Key Revokes a stored API key in Metabase by deleting it.
- Delete the Cache Configuration Removes the cache configuration stored in Metabase.
- Disable a User Deactivates a user account on your Metabase instance.
- Duplicate a Card Copies an existing card into a new one. Use Body to supply the details for the copy.
- Duplicate a Dashboard Copies a dashboard into a new one, with the details of the copy coming from Body.
- Execute a Dashboard Action Runs the action behind a card on a dashboard. Use Parameters to hand it the input values.
- Execute an Action Runs an action in Metabase, handing it the values from Body.
- Export Ad Hoc Query Results Runs a query that was never saved and exports the rows in the chosen Export Format. Use Body to describe the query.
- Export Card Query Results Runs the query behind a card and exports its rows in the chosen Export Format. Use Body to add the request details.
- Export Dashboard Card Query Results Exports the result of a card shown on a dashboard, in an Export Format such as csv, json or xlsx. Use Parameters for filter values.
- Get a Card Returns one saved card from Metabase with its query and display options.
- Get a Channel Opens one notification channel in Metabase to see how it is set up.
- Get a Collection Shows a single collection of your Metabase instance.
- Get a Dashboard Loads one dashboard from Metabase together with what it contains.
- Get a Dashboard Subscription Reads one dashboard subscription. The Metabase API calls these pulses.
- Get a Database Fetches one connected database, showing the details Metabase holds for it.
- Get a Document Opens one stored document from your Metabase instance.
- Get a Field Returns one table field known to Metabase.
Explore alternative integrations
There are other apps[9] supported by WEXTL that can be paired with Gigasheet and Metabase integrations. Pick any from the list below if the current combination isn't the one you need.
Frequently asked questions
Common questions about connecting Gigasheet and Metabase.
References
List of sources used to gather information about the Gigasheet and Metabase integration.
- Gigasheet and Metabase integration source code, module specs and credentials implementation.
- Our Gigasheet and Metabase integration documentation, structured input and output parameters, scopes, and authentication methods.
- Official vendor API documentation for Gigasheet and Metabase, 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.
- Gigasheet integration information
- Metabase integration information
- WEXTL® Scheduling
- WEXTL® Pricing and Trial
- WEXTL® Apps Library
How we write our apps documentation
Explore how WEXTL® crafted Gigasheet and Metabase integration page documentation. Used sources, the role of AI, and how the team validates the result.

