Connect Gigasheet integrations
VerifiedUpload, clean, query and export large spreadsheets in Gigasheet, connected to WEXTL workflows and AI agents. Turn Gigasheet numbers into actions in the tools your team uses. Start from Watch Callbacks, then use Check a Formula to notify people, update records or start the next step.
- 3-day trial
- Cancel anytime
- Up to 10 minutes quick set up
- GDPR
- Data Encryption
- 2FA
- Local Data Region
Supported triggers and actions for Gigasheet integration
Triggers can detect changes in Gigasheet and run actions that can create, search or modify data inside Gigasheet automatically[3], exactly how you set them.
- Watch Callbacks Starts a workflow when Gigasheet calls its callback address after an upload or export finishes. Each call brings its Handle and Message.
- 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 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.
- 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.
- 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.
- Estimate HTTP Enrichment Credits Estimates the credits an HTTP enrichment would spend on the Column IDs it reads, optionally limited by a Filter Model. Draws one API call. Billed to your plan.
- Filter Rows Returns up to Limit rows that match a Filter Model, ordered by a Sort Model with a Column and Direction. Each row is its own result. A run spends one API call out of the plan.
- Filter Rows by Column Name Returns up to Limit rows that match a Filter Model, with the filter written against column names. Spends one API call. Drawn from your plan.
- Find and Replace Swaps the Find text for the Replace text in the chosen Columns. Turn on Case Sensitive or Whole Cell Match to narrow what counts as a hit. Uses one API call. Taken off your plan.
- Get a Connection Fetches one saved connector setup, giving its Connection ID and Connection Name.
- Get a File Path Returns the folder Path that leads to a sheet in your library.
- Get a New Handle Asks Gigasheet for an unused Handle, which Save a Filter takes as its Filter Handle.
- Get a Row Number in a Filter Finds where the row with a Sheet Row Number lands once a Filter Model is applied. Takes one API call. Counted on your plan.
- Get a Saved Filter Reads a saved filter template and returns its ID, Name, Template and Version.
- Get a Saved Filter Model for a Sheet Converts a saved filter template into a ready Filter Model that fits the columns of the chosen sheet.
- Get a Sheet Note Reads the Note stored on a sheet, which Set a Sheet Note writes.
- Get a View Reads one view of a sheet and returns its ID and Name.
- Get Activity Lists the activity entries of a sheet, each with its Action, User and Timestamp. Use Limit to bound the list.
- Get Aggregations Computes the aggregations listed in the grid payload Body (JSON) over a sheet. Charges one API call. Drawn from your plan.
- Get an Export Download Link Returns the URL for downloading a finished Export. The link is short-lived, so fetch the file in the next step.
- Get Assistant History Lists the chat messages exchanged with the sheet assistant on one sheet. Use Limit to cap the number of messages.
- Get Columns Fetches the headings of a sheet with their Column ID, Name and Type. Use Type to keep one kind and Show Hidden to include hidden ones.
- Get Connection Headers Fetches the column headers of a stream. Add a Stream ID, User or Obfuscated User to point at the right one. One API call each. Charged to your plan.
- Get Connection Parameters Looks up which Params a Connector asks for when you create a connection.
- Get Enrichment Credits Shows how many enrichment Credits are left on the account.
- Get Export Parameters Looks up the Params a Connector needs for an export.
- Get Export Parameters with Input Sends the answers gathered so far as the Body (JSON) and returns the export Params a Connector still needs. Costs one API call. Billed to your plan.
- Get Home Sheets Lists the entries on your Gigasheet home screen, up to a Limit. Every entry has Metadata, Permissions and a Within Quota flag.
- Get HTTP Enrichment Status Checks the Status of an HTTP enrichment started earlier with Apply HTTP Enrichment.
- Get Import Parameters Looks up the import Params a Connector needs, adjusted to the Body (JSON) passed in. Expect one API call to be charged.
- Get Operation Status Reports the Status of the job running on a sheet.
- Get Organization Permissions Reads which Permissions your organization holds on one sheet or folder in your library.
- Get Source Parameters Looks up which Params a Connector asks for when a source is added.
- Get Source Parameters with Input Posts the Body (JSON) entered so far and reads back the next Params to fill for adding a source. Spends one API call. Taken off your plan.
- Get Source Status Checks the Status of a data source attached to a Connector.
- Get the Current User Shows which account the API key belongs to, by Username and whether it is Authenticated.
- Get the Sheet State Version Returns the current Version number of the client state kept for a sheet.
- Get the Space Used Shows how much storage the account uses.
- Get User Details Reads the Email address and Name that Gigasheet keeps for the account.
- Get User Metadata Reads the account flags Feature Preanalysis and Onboarding.
- List Connected Sources Shows the data sources attached to your account along with the Source name. Use Limit to bound the list.
- List Connections Lists your saved connector setups, up to a Limit, with each Connection ID and Connection Name.
- List Exports Pulls the exports in your library, up to a Limit. Each entry has Metadata, Permissions, whether it is Shared and Within Quota.
- List Files in a Folder Returns the entries of one Folder. Use Types to keep only files or only directories.
- List Files Shared with Me Shows every file other people have shared with you in Gigasheet. Use Limit to trim a long list.
- List Folder Contents Fetches the sheets and subfolders inside a Folder, with Metadata and Permissions on each. Set Limit to trim a long folder.
- List Formula Functions Gathers the functions Gigasheet formulas can use, each with its Title, Documentation and Examples. Use Dialect to read the functions of one formula flavor.
- List HTTP Enrichment Tasks Shows each custom HTTP enrichment Task with its Status, up to a Limit. Use Sheet to see only the tasks of that sheet.
- List Plans Returns the Gigasheet billing plans, up to a Limit, with each Name and Price.
- List Root Files Fetches the files at the root of the library. Use Types to keep only one entry type and Limit to cut the length.
- List Root Sheets Reads the sheets and folders sitting at the root of the library. Use Limit to set the number of results.
- List Saved Filters Lists the filter templates saved in your account with their ID, Name, Owner and Version. Use Limit to shorten the list.
- List Shared Files in a Folder Gathers what was shared with you inside one Folder. Set Limit to restrict the results.
- List Sharing Contacts Suggests people to share with, giving an Email for each. Turn on Include Team Members or Include Share Recipients to widen who appears, and use Limit to shorten the list.
- List Team Files Returns the files in the library of your team. Use Limit to restrict how many are returned.
- List Team Files in a Folder Reads the entries that your team keeps inside one Folder. Use Limit to restrict the count.
- List Views Lists the views stored for a sheet along with their ID and Name. Use Limit to set the length of the list.
- Preview a Formula Runs the Formula on a sample of the sheet and shows results before a column is added. Costs one API call. Counted on your plan.
- Preview HTTP Enrichment Tries the Request Settings of a custom HTTP enrichment on a sample of the rows. Takes one API call. Drawn from your plan.
- Query a Sheet with GigaScript Runs a GigaScript Query, which must end with one DISPLAY, and returns the Rows with a Permalink. Turn on Count to add row and group counts, or Omit Rows to get only the schema and link. Spends one API call. Charged to your plan.
- Search Activity Looks through the activity history of a sheet. Filter it with Actions, Categories, Users or a Query, bound it with Start and End, and set Limit for the page size. Billing counts one API call per request.
- Search the Library Finds library entries that match a Search Term. Use Fields to choose where to look. Charges one API call. Deducted from your plan.
- 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 Email Format Tests whether each value of the Email Column is a correctly formed address. Spends one API call. Counted on 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.
- 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.
- Edit a Formula Column Replaces the Formula of an existing formula column. Use Body (JSON) to send a request body of your own instead of the fields. Costs one API call. Charged to your plan.
- Enrich on Demand Runs the named Enrichment on a column. Set End Row to stop at a row, and Filter Model or Sort Model to choose which rows are enriched and in what order. Bills one API call. Charged to your plan.
- Explode Column into Rows Splits each cell of a column at the Split By text and puts every piece on its own row. Use Skip at Start to ignore leading characters and Skip at End for trailing ones. Charges one API call. Counted on your plan.
- Explode JSON Column Spreads a column of JSON into new columns. Name the Keys or Indices to turn into columns. One API call each. Taken off your plan.
- Export a Sheet to a Connector Sends a sheet to the chosen Connector, with the filters, sort and grouping from Grid State. Add Parameters for connector settings and turn on As Live View to export it as a live view. Costs one API call. Deducted from your plan.
- Extract Domain Pulls the domain out of each web address in a column. Takes one API call. Billed to your plan.
- Generate a Sheet Description Asks Gigasheet to write a description of what a sheet contains. Bills one API call. Deducted from your plan.
- Generate Analysis Tips Asks the sheet assistant for suggestions on how to analyze the data in a sheet. Draws one API call. Counted on your plan.
- Insert Blank Rows Inserts blank rows at a chosen row position of a sheet. Raise Number of Rows to insert more than the default of one. Uses one API call. Charged to your plan.
- Keep Columns by Name Keeps the headings listed under Column Names. Turn on Delete All Others to remove every column not listed. One API call each. Counted on your plan.
- Leave a Shared File Removes a file that someone shared with you from your own library. Charges one API call. Taken off your plan.
- Look Up Values from Another Sheet Fills a column by matching rows against a Reference Sheet using the Match Conditions. Turn on Return All Matches to get every match and not only the first. Bills one API call. Billed to your plan.
- Make an API Call Runs a free-form request against the Gigasheet REST API using your saved credential.
- Make Column Names Unique Renames duplicate headings in a sheet so each column name appears once. Draws one API call. Taken off your plan.
- Move a File Moves a sheet or folder to the Destination Folder of your library. Draws one API call. Drawn from your plan.
- Pause a Connection Pauses a scheduled data connection until you resume it. One API call each. Deducted from your plan.
- Refresh Linked Sheets Updates every linked sheet that was created from a view of this sheet. Uses one API call. Deducted from your plan.
- Rename a File Gives a sheet or folder the New Name. Charges one API call. Charged to your plan.
- Rename Columns by Name Gives columns new headings from a list of Renames, each holding an Old Name and a New Name. Bills one API call. Counted on your plan.
- Request File Access Asks the owner of a file to give you access, with an optional Message. One API call each. Billed to your plan.
- Reset a Connector Resets one Connection of a Connector of the chosen Type. Costs one API call. Drawn from your plan.
- Resume a Connection Starts a paused data connection running again. Charges one API call. Billed to your plan.
- Run a Formula Evaluates a Formula and adds the result as a new column called Column Name. Use Body (JSON) to send a custom request body. Spends one API call. Deducted from your plan.
- Run or Schedule a Connection Runs a Connector job. Pass Parameters to build a new setup under Connection Name, or a Connection to reuse one, then set Schedule for repeats or Run Now to go straight away. Takes one API call. Taken off your plan.
- Save a Filter Saves a Filter Model as a filter called Name. Reuse the Filter Handle of an existing filter to update it, or take a fresh one from Get a New Handle. Draws one API call. Charged to your plan.
- Save Exported State Stores the exported state of a sheet. Bills one API call. Drawn from your plan.
- Save the Current View as a Sheet Saves the view on screen as a new sheet called File Name inside a Parent Folder. Turn on Keep Share Settings to copy the sharing of the original. Uses one API call. Billed to your plan.
- Set a Column Currency Formats a column as money using the Currency Code, such as USD. Costs one API call. Taken off your plan.
- Set a Sheet Note Writes the Note text onto a sheet, up to 20,000 characters. Spends one API call. Billed to your plan.
- Set Organization Permissions Sets what your organization may do with a file, from the Body (JSON) permissions. Takes one API call. Charged to your plan.
- Share a File Shares a sheet with the Emails listed, at the Permissions levels given. Gigasheet sends an invitation, with an optional Message, unless Skip Notification is on. Uses one API call. Counted on your plan.
- Split a Column Splits the values of a column at the Separator into several new columns. Bills one API call. Taken off your plan.
- Trim Whitespace Removes the spaces around the values of a column. Draws one API call. Deducted from your plan.
- Unset a Column Currency Clears the currency format from a column. One API call each. Drawn from your plan.
- Update a Cell Writes a new Value into the cell at a Row of a column. Leave Value blank to empty the cell. Costs one API call. Charged to your plan.
- Update a Cell by Column Name Writes a new Value into the cell at a Row of the column whose heading is the Column Name. Takes one API call. Deducted from your plan.
- Update a View Renames a saved view with Name and sets another client state through Client State ID. Leave either blank to keep its current value. Uses one API call. Drawn from your plan.
- Update User Metadata Changes account flags, switching Feature Preanalysis on or off and storing an Onboarding state. Spends one API call. Counted on your plan.
- Upload from a URL Imports the file at a URL into a new sheet called Name. Use Append to Sheet to add the rows to an existing sheet and Callback URL to get a call when the job finishes. Bills one API call. Charged to your plan.
- Upload Raw Data Creates a sheet called Name from pasted Contents such as CSV text, up to 128 MB. Use Skip Type Inference to keep every column as text. Draws one API call. Billed to your plan.
- Upsert Rows Writes the Cells, a JSON list of rows, into a sheet starting at the Start Column and Start Row. Cells that overlap existing ones are overwritten. Charges one API call. Counted on your plan.
- Validate Emails with Abstract API Validates every email address of a column through Abstract API. Takes one API call. Deducted from your plan.
How to integrate Gigasheet in automation workflow?
Gigasheet in three steps: start with "Watch Callbacks", connect one credential, then add your next step.
STEP 1
Select Gigasheet in workflow
Add the "Watch Callbacks" trigger from Gigasheet to the canvas[4].
STEP 2
Connect Gigasheet
Fill in the Gigasheet credential once. All 149 Gigasheet modules use it[3].
STEP 3
Build a workflow
Add "Check a Formula" or "Check Combine Files" after it, then connect any app[5] or the HTTP node.
How Gigasheet connects and integrates with WEXTL
Save and approve your credentials once. WEXTL® stores authorization information encrypted and reuses the authentication whenever Gigasheet app is called in workflows. That allows your analytics automations to run without your attention, per defined schedule[7]. See the integration guide[6] for a detailed list of fields that Gigasheet supports.
Full Gigasheet API documentationThe following table illustrates what fields Gigasheet integration require during authorization flow inside our workflow builder[4].
Connect Gigasheet
API Key*Text
••••••••
| Field | Type | Help |
|---|---|---|
API KeyRequired | password | Create it in Gigasheet under Settings, then API, and paste it here. |
Connect Gigasheet to popular apps on WEXTL
Enter a name of the other app you want to sync with Gigasheet below. Click on selected app to explore integration options with Gigasheet. If the app you search for is not available in WEXTL yet, you can use HTTP node[10] instead to integrate it directly.
Example automation with Gigasheet integration
Select Watch Callbacks trigger from Gigasheet - this will be a starting point in your automation. Whenever event happens in Gigasheet, workflow will start[7] from Watch Callbacks node.
Search for Add a Geolocation, connect it as the next step of integration sequence. You can use filters between Watch Callbacks and Add a Geolocation, so only important data pass from Watch Callbacks to the next step. WEXTL gives you full control over the process of Gigasheet automation. All parts of workflow are visible on the canvas[4].
Gigasheet on WEXTL has 150 modules for combining analytics automations. Explore Gigasheet documentation for more.
- GigasheetWatch Callbacks
- ChameleonPerforms action
OR
- ChameleonTriggers
- GigasheetAdd a Geolocation
Frequently asked questions
Common questions about automating Gigasheet in your workflows.
What triggers does Gigasheet support?
Gigasheet has 1 trigger, including "Watch Callbacks". Triggers are start points of the workflow, and automations may start from them.
What actions can I run in Gigasheet?
Integration has 149 actions, including "Check a Formula", "Check Combine Files", and "Check Combine Files by Name", and more. Refer to our Gigasheet Documentation for detailed inputs and outputs.
Do I need to write code to build automations?
No. The 149 Gigasheet modules, like "Check a Formula", are forms on the canvas: pick a field, map data from an earlier step. Code is optional[4].
Is the integration secure?
Yes. You fill in the Gigasheet credential once. WEXTL encrypts it at rest, and only your team can use it.
How does WEXTL integrate with Gigasheet?
Through the official Gigasheet API: 149 modules, plus "Make an API Call" for any endpoint they don't cover[3].
Can I use webhooks with Gigasheet?
Yes. "Watch Callbacks" is instant: Gigasheet pushes each event, so there is no polling delay.
Why use WEXTL platform for Gigasheet automation?
WEXTL is an AI-first visual canvas: describe the Gigasheet flow in plain words and AI wires the nodes[4].
References
List of sources used to gather information about the Gigasheet integration.
- Gigasheet integration source code, module specs and credentials implementation.
- Internal Gigasheet integration documentation, structured input and output parameters, scopes, and authentication methods.
- Official Gigasheet vendor API documentation, 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.
- WEXTL® Apps Library
- WEXTL® Gigasheet App Documentation
- WEXTL® Workflow Scheduler
- WEXTL® HTTP node documentation
How we write and maintain Gigasheet app documentation
Explore how WEXTL® crafted Gigasheet integration page documentation. Used sources, the role of AI, and how the team validates the result.





















