Skip to docs navigation

Gigasheet integration guide

Verified

How to connect Gigasheet to WEXTL and use its 1 trigger and 149 actions in your workflows. About Gigasheet: Upload, clean, query and export large spreadsheets in Gigasheet.

  • 1 trigger
  • 68 searches
  • 81 actions
  • Instant (webhooks)
  • Auth: API key

AI-assisted documentation25 min read

This documentation is compiled from our integration source code, internal specs for Gigasheet, its official API documentation and anonymized requests logs we collect from our support team[2].

Open Gigasheet on WEXTL →
  • Gigasheet
  • WEXTL
  • Faraday
  • Metabase
  • Grafana
  • Chameleon
  • Feedly
  • Userflow
  • GoSquared
  • Mixpanel
  • Klipfolio
  • Databox
  • Playvox
  • WhatConverts
  • ProfitWell
  • ActivTrak
  • SegMetrics
  • The Official Board
  • Tableau
  • Microsoft Power BI
  • Monitask
  • Ignition Reporting
  • Microsoft Reports
  • API KeypasswordRequired

    Create it in Gigasheet under Settings, then API, and paste it here.[1]

  1. Log in to your WEXTL account, add the Gigasheet node module to your workflow, and click Create new credential.Instant triggers use webhooks. Click Create a webhook first when adding one, then create the credential.
  2. Optional: In the Credential name field, enter a name for the credential.
  3. Enter the authentication credentials you copied from your Gigasheet account, or follow the on-screen instructions to create the credential.
  4. If prompted, authenticate your account and confirm access.
  5. If you want to make changes to your credential in the future, follow the steps in Manage credentials →

Watch Callbacks

TriggerInstant trigger for finished uploads and exports.
Output fields[3]
FieldType
Successboolean
Handletext
Messagetext

Check a Formula

SearchSyntax check ahead of running a formula.
Input fields[3]
FieldType
SheetRequired
choice
FormulaRequired
text
Body (JSON)text
Output fields[3]
FieldType
Successboolean
Messagetext

Check Combine Files

SearchValidation pass for a plain combine.
Input fields[3]
FieldType
SheetsRequired
array
File Nametext
Folderchoice
In Placeboolean
Add Input File Nameboolean
Body (JSON)text
Output fields[3]
FieldType
Successboolean
Messagetext

Check Combine Files by Name

SearchValidation pass for a combine by name.
Input fields[3]
FieldType
SheetsRequired
array
New Sheet Nametext
Add Input File Nameboolean
Add Unmatched Columnsboolean
Case Insensitiveboolean
Trim Column Namesboolean
Output fields[3]
FieldType
Successboolean
Messagetext

Check Federated Table

SearchDry run for a federated table.
Input fields[3]
FieldType
MembersRequired
array
File Nametext
Parent Folderchoice
Output fields[3]
FieldType
Successboolean
Messagetext

Check Source Availability

SearchTells if a connector source is reachable.
Input fields[3]
FieldType
ConnectorRequired
text
Output fields[3]
FieldType
Is Availableboolean
Successboolean

Count Activity

SearchNumber of activity entries for a sheet.
Input fields[3]
FieldType
SheetRequired
choice
Actionsarray
Categoriesarray
Usersarray
Querytext
Startdate
Enddate
Output fields[3]
FieldType
Countnumber

Count Duplicate Rows

SearchDuplicate total for a sheet.
Input fields[3]
FieldType
SheetRequired
choice
ColumnsRequired
array
Filter Modeltext
Sort Modeltext
Output fields[3]
FieldType
Successboolean
Messagetext

Count Groups

SearchNumber of groups in a sheet.
Input fields[3]
FieldType
SheetRequired
choice
Filter Modeltext
Group Columnstext
Output fields[3]
FieldType
Successboolean
Messagetext

Count Rows

SearchRow total for a sheet or a filter.
Input fields[3]
FieldType
SheetRequired
choice
Filter Modeltext
Output fields[3]
FieldType
Successboolean
Messagetext

Describe a Sheet

SearchName, owner and row count of a sheet.
Input fields[3]
FieldType
SheetRequired
choice
Output fields[3]
FieldType
File Nametext
File Uuidtext
Is Directoryboolean
Ownertext
Parent Directorytext
File Rowsnumber
File Sizenumber
Statustext

3other output fields

Describe a Sheet Version

SearchProperties of one saved revision.
Input fields[3]
FieldType
SheetRequired
choice
VersionRequired
text
Output fields[3]
FieldType
File Nametext
File Uuidtext
Is Directoryboolean
Ownertext
Parent Directorytext
File Rowsnumber
File Sizenumber
Statustext

3other output fields

Estimate HTTP Enrichment Credits

SearchCredit forecast before running an enrichment.
Input fields[3]
FieldType
SheetRequired
choice
Column IDsRequired
array
Filter Modeltext
Output fields[3]
FieldType
Successboolean
Messagetext

Filter Rows

SearchRows of a sheet that pass a filter.
Input fields[3]
FieldType
SheetRequired
choice
LimitRequired
number
Filter Modeltext
Sort Modelarray
Sortobject
Output fields[3]
FieldType
Atext
Btext

Filter Rows by Column Name

SearchFiltered rows by heading names.
Input fields[3]
FieldType
SheetRequired
choice
LimitRequired
number
Filter Modeltext
Output fields[3]
FieldType
Atext
Btext

Find and Replace

ActionBulk text replacement in columns.
Input fields[3]
FieldType
SheetRequired
choice
ColumnsRequired
array
FindRequired
text
ReplaceRequired
text
Case Sensitiveboolean
Whole Cell Matchboolean
Languagetext
Output fields[3]
FieldType
Successboolean
Messagetext

Get a Connection

SearchName and ID of one connector setup.
Input fields[3]
FieldType
ConnectionRequired
choice
Output fields[3]
FieldType
Connection IDtext
Connection Nametext

Get a File Path

SearchLibrary path of one sheet.
Input fields[3]
FieldType
SheetRequired
choice
Output fields[3]
FieldType
Patharray

Get a New Handle

SearchFresh unique identifier from Gigasheet.
Output fields[3]
FieldType
Handletext

Get a Row Number in a Filter

SearchRow position inside a filtered view.
Input fields[3]
FieldType
SheetRequired
choice
Sheet Row NumberRequired
text
Filter Modeltext
Output fields[3]
FieldType
Successboolean
Messagetext

Get a Saved Filter

SearchTemplate and version of a stored filter.
Input fields[3]
FieldType
Saved FilterRequired
choice
Output fields[3]
FieldType
IDtext
Nametext
Templateobject
Versionnumber

Get a Saved Filter Model for a Sheet

SearchSaved filter template adapted to a sheet.
Input fields[3]
FieldType
Saved FilterRequired
choice
SheetRequired
choice
Output fields[3]
FieldType
Filter Modelobject
Cnfarray

Get a Sheet Note

SearchFree text stored with a sheet.
Input fields[3]
FieldType
SheetRequired
choice
Output fields[3]
FieldType
Notetext

Get a View

SearchStored layout of a sheet.
Input fields[3]
FieldType
SheetRequired
choice
ViewRequired
choice
Output fields[3]
FieldType
IDtext
Nametext

Get Activity

SearchRecent actions taken on a sheet.
Input fields[3]
FieldType
LimitRequired
number
SheetRequired
choice
Output fields[3]
FieldType
IDtext
Actiontext
Usertext
Timestampdate
File Uuidtext

Get Aggregations

SearchAggregate figures for a sheet.
Input fields[3]
FieldType
SheetRequired
choice
Body (JSON)Required
text
Output fields[3]
FieldType
Successboolean
Messagetext

Get an Export Download Link

SearchTemporary link to an export file.
Input fields[3]
FieldType
ExportRequired
text
Output fields[3]
FieldType
URLtext

Get Assistant History

SearchPast assistant conversation for a sheet.
Input fields[3]
FieldType
LimitRequired
number
SheetRequired
choice
Output fields[3]
FieldType
Messagetext

Get Columns

SearchColumn headings and types of a sheet.
Input fields[3]
FieldType
LimitRequired
number
SheetRequired
choice
Show Hiddenchoice
Typetext
Output fields[3]
FieldType
Column IDtext
Nametext
Typetext

Get Connection Headers

SearchStream headers for a connector setup.
Input fields[3]
FieldType
ConnectionRequired
choice
Stream IDtext
Usertext
Obfuscated Usertext
Output fields[3]
FieldType
Headersarray
Successboolean

Get Connection Parameters

SearchSettings needed to connect a connector.
Input fields[3]
FieldType
ConnectorRequired
text
Output fields[3]
FieldType
Paramsarray

Get Enrichment Credits

SearchRemaining balance for enrichments.
Output fields[3]
FieldType
Creditsnumber

Get Export Parameters

SearchExport settings of a connector.
Input fields[3]
FieldType
ConnectorRequired
text
Output fields[3]
FieldType
Paramsarray

Get Export Parameters with Input

SearchFollow-up export questions for a connector.
Input fields[3]
FieldType
ConnectorRequired
text
Body (JSON)text
Output fields[3]
FieldType
Paramsarray

Get Home Sheets

SearchItems shown on the home screen.
Input fields[3]
FieldType
LimitRequired
number
Output fields[3]
FieldType
Metadataobject
File Nametext
File Uuidtext
Is Directoryboolean
Ownertext
Parent Directorytext
File Rowsnumber
File Sizenumber
Statustext
Created Atdate
Last Updateddate
Permissionsarray
Sharedboolean
Within Quotaboolean

Get HTTP Enrichment Status

SearchProgress of an HTTP enrichment task.
Input fields[3]
FieldType
TaskRequired
text
Output fields[3]
FieldType
Statustext

Get Import Parameters

SearchImport questions for a connector.
Input fields[3]
FieldType
ConnectorRequired
text
Body (JSON)text
Output fields[3]
FieldType
Paramsarray

Get Operation Status

SearchState of a running sheet operation.
Input fields[3]
FieldType
SheetRequired
choice
Output fields[3]
FieldType
Statustext

Get Organization Permissions

SearchAccess rights of an organization on a file.
Input fields[3]
FieldType
SheetRequired
choice
Output fields[3]
FieldType
Permissionsnumber

Get Source Parameters

SearchSettings needed to add a source.
Input fields[3]
FieldType
ConnectorRequired
text
Output fields[3]
FieldType
Paramsarray

Get Source Parameters with Input

SearchNext source fields for a connector.
Input fields[3]
FieldType
ConnectorRequired
text
Body (JSON)text
Output fields[3]
FieldType
Paramsarray

Get Source Status

SearchHealth state of a connector source.
Input fields[3]
FieldType
ConnectorRequired
text
Output fields[3]
FieldType
Statustext

Get the Current User

SearchIdentity behind the API key.
Output fields[3]
FieldType
Usernametext
Authenticatedboolean

Get the Sheet State Version

SearchRevision counter for a sheet layout.
Input fields[3]
FieldType
SheetRequired
choice
Output fields[3]
FieldType
Versiontext

Get the Space Used

SearchStorage consumed by the account.
Output fields[3]
FieldType
Usednumber

Get User Details

SearchEmail and name of the account.
Output fields[3]
FieldType
Emailtext
Nametext

Get User Metadata

SearchStored account metadata flags.
Output fields[3]
FieldType
Feature Preanalysistext
Onboardingobject

List Connected Sources

SearchData sources linked to the account.
Input fields[3]
FieldType
LimitRequired
number
Output fields[3]
FieldType
Sourcetext

List Connections

SearchSaved connector setups of the account.
Input fields[3]
FieldType
LimitRequired
number
Output fields[3]
FieldType
Connection IDtext
Connection Nametext

List Exports

SearchExports kept in your library.
Input fields[3]
FieldType
LimitRequired
number
Output fields[3]
FieldType
Metadataobject
File Nametext
File Uuidtext
Is Directoryboolean
Ownertext
Parent Directorytext
File Rowsnumber
File Sizenumber
Statustext
Created Atdate
Last Updateddate
Permissionsarray
Sharedboolean
Within Quotaboolean

List Files in a Folder

SearchEntries of a folder, filtered by type.
Input fields[3]
FieldType
LimitRequired
number
FolderRequired
choice
Typestext
Output fields[3]
FieldType
Metadataobject
File Nametext
File Uuidtext
Is Directoryboolean
Ownertext
Parent Directorytext
File Rowsnumber
File Sizenumber
Statustext
Created Atdate
Last Updateddate
Permissionsarray
Sharedboolean
Within Quotaboolean

List Files Shared with Me

SearchFiles others have shared with the account.
Input fields[3]
FieldType
LimitRequired
number
Output fields[3]
FieldType
Metadataobject
File Nametext
File Uuidtext
Is Directoryboolean
Ownertext
Parent Directorytext
File Rowsnumber
File Sizenumber
Statustext
Created Atdate
Last Updateddate
Permissionsarray
Sharedboolean
Within Quotaboolean

List Folder Contents

SearchEverything stored in a folder.
Input fields[3]
FieldType
LimitRequired
number
FolderRequired
choice
Output fields[3]
FieldType
Metadataobject
File Nametext
File Uuidtext
Is Directoryboolean
Ownertext
Parent Directorytext
File Rowsnumber
File Sizenumber
Statustext
Created Atdate
Last Updateddate
Permissionsarray
Sharedboolean
Within Quotaboolean

List Formula Functions

SearchReference catalog of formula syntax.
Input fields[3]
FieldType
LimitRequired
number
Dialecttext
Output fields[3]
FieldType
Titletext
Documentationtext
Examplesarray

List HTTP Enrichment Tasks

SearchCustom HTTP enrichment jobs with their status.
Input fields[3]
FieldType
LimitRequired
number
Sheetchoice
Output fields[3]
FieldType
Tasktext
Statustext

List Plans

SearchBilling plans on offer.
Input fields[3]
FieldType
LimitRequired
number
Output fields[3]
FieldType
Nametext
Pricenumber

List Root Files

SearchLibrary files with no parent folder.
Input fields[3]
FieldType
LimitRequired
number
Typestext
Output fields[3]
FieldType
Metadataobject
File Nametext
File Uuidtext
Is Directoryboolean
Ownertext
Parent Directorytext
File Rowsnumber
File Sizenumber
Statustext
Created Atdate
Last Updateddate
Permissionsarray
Sharedboolean
Within Quotaboolean

List Root Sheets

SearchSheets and folders at the library root.
Input fields[3]
FieldType
LimitRequired
number
Output fields[3]
FieldType
Metadataobject
File Nametext
File Uuidtext
Is Directoryboolean
Ownertext
Parent Directorytext
File Rowsnumber
File Sizenumber
Statustext
Created Atdate
Last Updateddate
Permissionsarray
Sharedboolean
Within Quotaboolean

List Saved Filters

SearchSaved filter templates of the account.
Input fields[3]
FieldType
LimitRequired
number
Output fields[3]
FieldType
IDtext
Nametext
Ownertext
Versionnumber

List Shared Files in a Folder

SearchItems others shared, from one folder.
Input fields[3]
FieldType
LimitRequired
number
FolderRequired
text
Output fields[3]
FieldType
Metadataobject
File Nametext
File Uuidtext
Is Directoryboolean
Ownertext
Parent Directorytext
File Rowsnumber
File Sizenumber
Statustext
Created Atdate
Last Updateddate
Permissionsarray
Sharedboolean
Within Quotaboolean

List Sharing Contacts

SearchAddresses offered when sharing a file.
Input fields[3]
FieldType
LimitRequired
number
Include Team Memberschoice
Include Share Recipientschoice
Output fields[3]
FieldType
Emailtext

List Team Files

SearchFiles shared with the team library.
Input fields[3]
FieldType
LimitRequired
number
Output fields[3]
FieldType
Metadataobject
File Nametext
File Uuidtext
Is Directoryboolean
Ownertext
Parent Directorytext
File Rowsnumber
File Sizenumber
Statustext
Created Atdate
Last Updateddate
Permissionsarray
Sharedboolean
Within Quotaboolean

List Team Files in a Folder

SearchEntries your team keeps in a folder.
Input fields[3]
FieldType
LimitRequired
number
FolderRequired
text
Output fields[3]
FieldType
Metadataobject
File Nametext
File Uuidtext
Is Directoryboolean
Ownertext
Parent Directorytext
File Rowsnumber
File Sizenumber
Statustext
Created Atdate
Last Updateddate
Permissionsarray
Sharedboolean
Within Quotaboolean

List Views

SearchSaved layouts of a sheet.
Input fields[3]
FieldType
LimitRequired
number
SheetRequired
choice
Output fields[3]
FieldType
IDtext
Nametext

Preview a Formula

SearchSample results for a formula.
Input fields[3]
FieldType
SheetRequired
choice
FormulaRequired
text
Body (JSON)text
Output fields[3]
FieldType
Successboolean
Messagetext

Preview HTTP Enrichment

SearchTest run of an HTTP enrichment.
Input fields[3]
FieldType
SheetRequired
choice
Request SettingsRequired
text
Output fields[3]
FieldType
Successboolean
Messagetext

Query a Sheet with GigaScript

SearchRuns a GigaScript program on a sheet.
Input fields[3]
FieldType
SheetRequired
choice
QueryRequired
text
Omit Rowschoice
Countchoice
Output fields[3]
FieldType
Rowsarray
Permalinktext

Search Activity

SearchFiltered change log of a sheet.
Input fields[3]
FieldType
SheetRequired
choice
LimitRequired
number
Actionsarray
Categoriesarray
Usersarray
Querytext
Startdate
Enddate
Output fields[3]
FieldType
IDtext
Actiontext
Usertext
Timestampdate
File Uuidtext

Search the Library

SearchLibrary entries matching some text.
Input fields[3]
FieldType
LimitRequired
number
Search TermRequired
text
Fieldsarray
Output fields[3]
FieldType
Metadataobject
File Nametext
File Uuidtext
Is Directoryboolean
Ownertext
Parent Directorytext
File Rowsnumber
File Sizenumber
Statustext
Created Atdate
Last Updateddate
Permissionsarray
Sharedboolean
Within Quotaboolean

Add a Geolocation

ActionGeolocation data from an IP column.
Input fields[3]
FieldType
SheetRequired
choice
IP ColumnRequired
choice
Body (JSON)text
Output fields[3]
FieldType
Successboolean
Messagetext

Add an Iterator Column

ActionRow-number column, optionally filtered and sorted.
Input fields[3]
FieldType
SheetRequired
choice
Column NameRequired
text
Filter Modeltext
Sort Modeltext
Output fields[3]
FieldType
Successboolean
Messagetext

Add Conditional Labels

ActionLabel column filled by condition rules.
Input fields[3]
FieldType
SheetRequired
choice
Output ColumnRequired
text
CasesRequired
text
Default Labeltext
Output fields[3]
FieldType
Successboolean
Messagetext

Append Rows

ActionRows written after the last row of a sheet.
Input fields[3]
FieldType
SheetRequired
choice
Body (JSON)Required
text
Output fields[3]
FieldType
Successboolean
Messagetext

Append Rows by Column Name

ActionRows added to a sheet, matched on column names.
Input fields[3]
FieldType
SheetRequired
choice
Body (JSON)Required
text
Output fields[3]
FieldType
Successboolean
Messagetext

Append Rows from Another Sheet

ActionStacks one sheet under another by column name.
Input fields[3]
FieldType
Target SheetRequired
choice
Source SheetRequired
choice
Add Unmatched Columnsboolean
Case Insensitiveboolean
Trim Column Namesboolean
Output fields[3]
FieldType
Successboolean
Messagetext

Apply HTTP Enrichment

ActionStarts a custom HTTP enrichment on a sheet.
Input fields[3]
FieldType
SheetRequired
choice
Request SettingsRequired
text
Output fields[3]
FieldType
Successboolean
Messagetext

Build an AI Formula

ActionAI-written formula from a text description.
Input fields[3]
FieldType
SheetRequired
choice
PromptRequired
text
Output fields[3]
FieldType
Formulatext

Cancel an HTTP Enrichment

ActionHalts a running HTTP enrichment task.
Input fields[3]
FieldType
TaskRequired
text
Output fields[3]
FieldType
Successboolean
Messagetext

Change Case

ActionReformats letter case across a column.
Input fields[3]
FieldType
SheetRequired
choice
ColumnRequired
choice
CaseRequired
choice
Output fields[3]
FieldType
Successboolean
Messagetext

Change Column Type

ActionGives a column a different data type.
Input fields[3]
FieldType
SheetRequired
choice
ColumnRequired
choice
Cast TypeRequired
choice
Cast FormatRequired
choice
Output fields[3]
FieldType
Successboolean
Messagetext

Chat with Sheet Assistant

ActionAsks the sheet AI assistant a question.
Input fields[3]
FieldType
SheetRequired
choice
MessageRequired
text
Output fields[3]
FieldType
Successboolean
Messagetext

Check Email Format

ActionEmail syntax check for a column.
Input fields[3]
FieldType
SheetRequired
choice
Email ColumnRequired
choice
Body (JSON)text
Output fields[3]
FieldType
Successboolean
Messagetext

Clean Company Names

ActionNormalizes a column of company names.
Input fields[3]
FieldType
SheetRequired
choice
ColumnRequired
choice
Output fields[3]
FieldType
Successboolean
Messagetext

Combine Columns

ActionMerges a group of headings into a fresh column.
Input fields[3]
FieldType
SheetRequired
choice
ColumnsRequired
array
NameRequired
text
SeparatorRequired
text
Output fields[3]
FieldType
Successboolean
Messagetext

Combine Files

ActionMerges several sheets into one.
Input fields[3]
FieldType
SheetsRequired
array
File Nametext
Folderchoice
In Placeboolean
Add Input File Nameboolean
Body (JSON)text
Output fields[3]
FieldType
Successboolean
Messagetext

Combine Files by Name

ActionMerges sheets matching columns on name.
Input fields[3]
FieldType
SheetsRequired
array
New Sheet Nametext
Add Input File Nameboolean
Add Unmatched Columnsboolean
Case Insensitiveboolean
Trim Column Namesboolean
Output fields[3]
FieldType
Successboolean
Messagetext

Copy a File

ActionMakes a duplicate in the library.
Input fields[3]
FieldType
SheetRequired
choice
File Nametext
Folderchoice
Recursiveboolean
Copy Statetext
Output fields[3]
FieldType
Successboolean
Messagetext

Create a Blank Sheet

ActionNew empty sheet of a chosen size.
Input fields[3]
FieldType
File NameRequired
text
Folderchoice
Columnsnumber
Rowsnumber
Upload to Teamboolean
Output fields[3]
FieldType
Successboolean
Messagetext

Create a Connection

ActionSaves a connector configuration.
Input fields[3]
FieldType
ConnectorRequired
text
ParametersRequired
text
Output fields[3]
FieldType
Successboolean
Messagetext

Create a Connector Source

ActionNew source for a data connector, with settings.
Input fields[3]
FieldType
SourceRequired
text
ParametersRequired
text
Codetext
Orgtext
Usertext
Output fields[3]
FieldType
Successboolean
Messagetext

Create a Federated Table

ActionJoins several sheets into one table.
Input fields[3]
FieldType
File NameRequired
text
MembersRequired
array
Parent Folderchoice
Output fields[3]
FieldType
Successboolean
Messagetext

Create a File Entry

ActionLibrary entry with optional type inference.
Input fields[3]
FieldType
File NameRequired
text
Folderchoice
Callback URLtext
Skip Notificationboolean
Skip Type Inferenceboolean
Upload to Teamboolean
Output fields[3]
FieldType
Successboolean
Messagetext

Create a Folder

ActionNew folder in the library with its handle.
Input fields[3]
FieldType
NameRequired
text
Parent Folderchoice
Output fields[3]
FieldType
Handletext
Messagetext
Successboolean

Create a Linked Sheet from a View

ActionLinked sheet built on a saved view.
Input fields[3]
FieldType
SheetRequired
choice
ViewRequired
choice
Nametext
Parent Folderchoice
Output fields[3]
FieldType
Handletext

Create a View

ActionNamed view saved on a sheet.
Input fields[3]
FieldType
SheetRequired
choice
NameRequired
text
Client State IDtext
Output fields[3]
FieldType
Successboolean
Messagetext

Create an Export

ActionExport job started from a grid state.
Input fields[3]
FieldType
SheetRequired
choice
File Nametext
Folderchoice
Compression Typetext
Decompressboolean
Skip Notificationboolean
Use Client Stateboolean
Single Pivot Headerboolean

4other input fields

Output fields[3]
FieldType
Handletext
Successboolean

Delete a Column

ActionSingle column removal from a sheet.
Input fields[3]
FieldType
SheetRequired
choice
ColumnRequired
choice
Output fields[3]
FieldType
Successboolean
Messagetext

Delete a Connector Source

ActionDetaches one data source from its connector.
Input fields[3]
FieldType
ConnectorRequired
text
Output fields[3]
FieldType
Successboolean
Messagetext

Delete a Saved Filter

ActionRemoves a stored filter template.
Input fields[3]
FieldType
Saved FilterRequired
choice
Output fields[3]
FieldType
Successboolean
Messagetext

Delete a Sheet

ActionLibrary item deletion, folders included.
Input fields[3]
FieldType
SheetRequired
choice
Recursiveboolean
Output fields[3]
FieldType
Successboolean
Messagetext

Delete a View

ActionStored view deletion for a sheet.
Input fields[3]
FieldType
SheetRequired
choice
ViewRequired
choice
Output fields[3]
FieldType
Successboolean
Messagetext

Delete Assistant History

ActionClears the assistant conversation of a sheet.
Input fields[3]
FieldType
SheetRequired
choice
Output fields[3]
FieldType
Successboolean
Messagetext

Delete Columns

ActionSeveral columns dropped together.
Input fields[3]
FieldType
SheetRequired
choice
ColumnsRequired
array
Output fields[3]
FieldType
Successboolean
Messagetext

Delete Columns by Name

ActionColumn removal by heading text.
Input fields[3]
FieldType
SheetRequired
choice
Column NamesRequired
array
Output fields[3]
FieldType
Successboolean
Messagetext

Delete Duplicate Rows

ActionRemoves repeated rows from a sheet.
Input fields[3]
FieldType
SheetRequired
choice
ColumnsRequired
array
Filter Modeltext
Sort Modeltext
Output fields[3]
FieldType
Successboolean
Messagetext

Delete Rows

ActionRow deletion by row number.
Input fields[3]
FieldType
SheetRequired
choice
RowsRequired
array
Output fields[3]
FieldType
Successboolean
Messagetext

Delete Rows Matching Filter

ActionFilter-based row clean-up of a sheet.
Input fields[3]
FieldType
SheetRequired
choice
Filter ModelRequired
text
Output fields[3]
FieldType
Successboolean
Messagetext

Delete Rows Not Matching Filter

ActionKeeps only the rows that satisfy a filter.
Input fields[3]
FieldType
SheetRequired
choice
Filter ModelRequired
text
Output fields[3]
FieldType
Successboolean
Messagetext

Edit a Formula Column

ActionChanges the formula behind a column.
Input fields[3]
FieldType
SheetRequired
choice
ColumnRequired
choice
FormulaRequired
text
Body (JSON)text
Output fields[3]
FieldType
Successboolean
Messagetext

Enrich on Demand

ActionRuns a Gigasheet enrichment on one column.
Input fields[3]
FieldType
EnrichmentRequired
text
SheetRequired
choice
ColumnRequired
choice
Filter Modeltext
Sort Modeltext
End Rownumber
Output fields[3]
FieldType
Successboolean
Messagetext

Explode Column into Rows

ActionOne row per delimited value.
Input fields[3]
FieldType
SheetRequired
choice
ColumnRequired
choice
Split ByRequired
text
Skip at Startnumber
Skip at Endnumber
Output fields[3]
FieldType
Successboolean
Messagetext

Explode JSON Column

ActionJSON cells turned into columns.
Input fields[3]
FieldType
SheetRequired
choice
ColumnRequired
choice
Keysarray
Indicesarray
Output fields[3]
FieldType
Successboolean
Messagetext

Export a Sheet to a Connector

ActionSends sheet data to a connector.
Input fields[3]
FieldType
SheetRequired
choice
ConnectorRequired
choice
Grid StateRequired
text
File Nametext
Folderchoice
Compression Typetext
Records per Filenumber
Callback URLtext

5other input fields

Output fields[3]
FieldType
Successboolean
Messagetext

Extract Domain

ActionDomain names from a column of URLs.
Input fields[3]
FieldType
SheetRequired
choice
ColumnRequired
choice
Output fields[3]
FieldType
Successboolean
Messagetext

Generate a Sheet Description

ActionAI-written summary of a sheet.
Input fields[3]
FieldType
SheetRequired
choice
Output fields[3]
FieldType
Successboolean
Messagetext

Generate Analysis Tips

ActionAssistant ideas for exploring a sheet.
Input fields[3]
FieldType
SheetRequired
choice
Output fields[3]
FieldType
Successboolean
Messagetext

Insert Blank Rows

ActionEmpty rows added inside a sheet.
Input fields[3]
FieldType
SheetRequired
choice
IndexRequired
number
Number of Rowsnumber
Output fields[3]
FieldType
Successboolean
Messagetext

Keep Columns by Name

ActionNarrows a sheet to chosen columns.
Input fields[3]
FieldType
SheetRequired
choice
Column NamesRequired
array
Delete All Othersboolean
Output fields[3]
FieldType
Successboolean
Messagetext

Leave a Shared File

ActionStops a shared file from showing for you.
Input fields[3]
FieldType
SheetRequired
choice
Output fields[3]
FieldType
Successboolean
Messagetext

Look Up Values from Another Sheet

ActionCross-sheet value lookup into a column.
Input fields[3]
FieldType
SheetRequired
choice
ColumnRequired
choice
Reference SheetRequired
choice
Match ConditionsRequired
text
Return All Matchesboolean
Output fields[3]
FieldType
Successboolean
Messagetext

Make an API Call

universalCustom Gigasheet REST API request.
Input fields[3]
FieldType
URLRequired
text
MethodRequired
choice
Headersarray
Headerobject
Query Stringarray
Parameterobject
Bodytext
Output fields[3]
FieldType
Bodytext
Headersobject
Status codenumber

Make Column Names Unique

ActionDeduplicates repeated column headings.
Input fields[3]
FieldType
SheetRequired
choice
Output fields[3]
FieldType
Successboolean
Messagetext

Move a File

ActionRelocates a library item.
Input fields[3]
FieldType
SheetRequired
choice
Destination FolderRequired
choice
Output fields[3]
FieldType
Successboolean
Messagetext

Pause a Connection

ActionSuspends a scheduled connector run.
Input fields[3]
FieldType
ConnectionRequired
choice
Output fields[3]
FieldType
Successboolean
Messagetext

Refresh Linked Sheets

ActionUpdates the linked sheets made from this sheet.
Input fields[3]
FieldType
SheetRequired
choice
Output fields[3]
FieldType
Successboolean
Messagetext

Rename a File

ActionNew name for a library item.
Input fields[3]
FieldType
SheetRequired
choice
New NameRequired
text
Output fields[3]
FieldType
Successboolean
Messagetext

Rename Columns by Name

ActionBatch rename of column headings.
Input fields[3]
FieldType
SheetRequired
choice
RenamesRequired
array
Renameobject
Output fields[3]
FieldType
Successboolean
Messagetext

Request File Access

ActionAccess request sent to a file owner.
Input fields[3]
FieldType
SheetRequired
choice
Messagetext
Output fields[3]
FieldType
Successboolean
Messagetext

Reset a Connector

ActionResets the setup behind a connector connection.
Input fields[3]
FieldType
TypeRequired
text
ConnectorRequired
text
ConnectionRequired
choice
Output fields[3]
FieldType
Successboolean
Messagetext

Resume a Connection

ActionRestarts a suspended connector run.
Input fields[3]
FieldType
ConnectionRequired
choice
Output fields[3]
FieldType
Successboolean
Messagetext

Run a Formula

ActionFormula output written as a column.
Input fields[3]
FieldType
SheetRequired
choice
FormulaRequired
text
Column Nametext
Body (JSON)text
Output fields[3]
FieldType
Successboolean
Messagetext

Run or Schedule a Connection

ActionRuns or schedules a connector job.
Input fields[3]
FieldType
ConnectorRequired
text
Parameterstext
Connectionchoice
Connection Nametext
Scheduletext
Run Nowboolean
Skip Notificationboolean
Output fields[3]
FieldType
Successboolean
Messagetext

Save a Filter

ActionCreates or updates a saved filter.
Input fields[3]
FieldType
Filter HandleRequired
text
SheetRequired
choice
Filter ModelRequired
text
Nametext
Output fields[3]
FieldType
Successboolean
Messagetext

Save Exported State

ActionRecords the export state for a sheet.
Input fields[3]
FieldType
SheetRequired
choice
Output fields[3]
FieldType
Successboolean
Messagetext

Save the Current View as a Sheet

ActionCurrent view stored as its own sheet.
Input fields[3]
FieldType
SheetRequired
choice
File Nametext
Parent Folderchoice
Keep Share Settingsboolean
Grid Statetext
Client Statetext
Output fields[3]
FieldType
Successboolean
Messagetext

Set a Column Currency

ActionMoney formatting for a column.
Input fields[3]
FieldType
SheetRequired
choice
ColumnRequired
choice
Currency CodeRequired
text
Output fields[3]
FieldType
Successboolean
Messagetext

Set a Sheet Note

ActionSaves free text on a sheet.
Input fields[3]
FieldType
SheetRequired
choice
NoteRequired
text
Output fields[3]
FieldType
Successboolean
Messagetext

Set Organization Permissions

ActionUpdates organization access to a file.
Input fields[3]
FieldType
SheetRequired
choice
Body (JSON)Required
text
Output fields[3]
FieldType
Successboolean
Messagetext

Share a File

ActionInvites people to a file.
Input fields[3]
FieldType
SheetRequired
choice
EmailsRequired
array
PermissionsRequired
array
Messagetext
Skip Notificationboolean
Output fields[3]
FieldType
Successboolean
Messagetext

Split a Column

ActionOne column cut into many.
Input fields[3]
FieldType
SheetRequired
choice
ColumnRequired
choice
SeparatorRequired
text
Output fields[3]
FieldType
Successboolean
Messagetext

Trim Whitespace

ActionCleans padding around column values.
Input fields[3]
FieldType
SheetRequired
choice
ColumnRequired
choice
Output fields[3]
FieldType
Successboolean
Messagetext

Unset a Column Currency

ActionRemoves currency formatting from a column.
Input fields[3]
FieldType
SheetRequired
choice
ColumnRequired
choice
Output fields[3]
FieldType
Successboolean
Messagetext

Update a Cell

ActionEdits one cell by column.
Input fields[3]
FieldType
SheetRequired
choice
ColumnRequired
choice
RowRequired
text
Valuetext
Body (JSON)text
Output fields[3]
FieldType
Successboolean
Messagetext

Update a Cell by Column Name

ActionEdits one cell using its heading.
Input fields[3]
FieldType
SheetRequired
choice
Column NameRequired
text
RowRequired
text
Valuetext
Body (JSON)text
Output fields[3]
FieldType
Successboolean
Messagetext

Update a View

ActionEdits a saved view.
Input fields[3]
FieldType
SheetRequired
choice
ViewRequired
choice
Nametext
Client State IDtext
Output fields[3]
FieldType
Successboolean
Messagetext

Update User Metadata

ActionEdits the stored account flags.
Input fields[3]
FieldType
Feature Preanalysischoice
Onboardingtext
Output fields[3]
FieldType
Successboolean
Messagetext

Upload from a URL

ActionImports a remote file into a sheet.
Input fields[3]
FieldType
URLRequired
text
Nametext
Folderchoice
Append to Sheetchoice
Callback URLtext
Skip Notificationboolean
Skip Type Inferenceboolean
Output fields[3]
FieldType
Handletext
Successboolean

Upload Raw Data

ActionPasted text turned into a sheet.
Input fields[3]
FieldType
NameRequired
text
ContentsRequired
text
Folderchoice
Append to Sheetchoice
Callback URLtext
Skip Notificationboolean
Skip Type Inferenceboolean
Output fields[3]
FieldType
Handletext
Successboolean

Upsert Rows

ActionWrites a block of values from a start cell.
Input fields[3]
FieldType
SheetRequired
choice
Start ColumnRequired
choice
Start RowRequired
text
CellsRequired
text
Request AG Gridboolean
Output fields[3]
FieldType
Successboolean
Messagetext

Validate Emails with Abstract API

ActionEmail validation through Abstract API.
Input fields[3]
FieldType
SheetRequired
choice
Email ColumnRequired
choice
Body (JSON)text
Output fields[3]
FieldType
Successboolean
Messagetext

Look for Gigasheet templates in the WEXTL template library.

Browse templates →
  1. WEXTL® Gigasheet Source Code connector implementation.
  2. Our users use cases and automations.
  3. Official API Documentation for Gigasheet.
  4. WEXTL® visual workflow builder data.

Last updated: Nov 14, 2026 14:55

How we write our apps documentation

How we compile these docs: sources, the role of AI, and how we verify.