Jump to Content
API Reference
v1.0
Log In
API Reference
Log In
Moon (Dark Mode)
Sun (Light Mode)
v1.0
API Reference
List available Gigasheet plans.
Search
JUMP TO
Developer Dashboard
Getting Started
Authentication
Gigasheet API
End to End Example
Filter Model Detail Guide
Billing and Costs
ai
Sheet Assistant
post
Formula Builder
post
Sheet Assistant History
get
Delete Sheet Assistant history
delete
billing
List available Gigasheet plans.
get
data
Change column data type
post
Changes a string's case based on payload
post
Clean company names.
post
Combine columns
post
Create a connection.
post
Get parameters for connection.
get
Get the relevant parameters to start an import.
post
Get connection.
get
Get headers.
post
Retrieve connection infos.
get
Run/schedule a connection.
post
Get parameters for export.
get
Get parameters for export given parameters provided by user.
post
Pause a connector.
patch
Reset a connector.
delete
Get connected data source information.
get
Create a source.
post
Get parameters for source.
get
Get parameters for source.
post
Delete a source.
delete
Check if source is available.
post
Get source status.
get
Unpause a connector.
patch
Initiate export of a dataset to the given connector.
post
Get sheet statistics.
post
Return the number of unique tuple values in a list of columns
post
Get column statistics.
post
Describe dataset
get
Append to a sheet
post
Append to a sheet
post
Append to a sheet data from another sheet
post
Generate tips
post
Get Columns
get
Set currency for a column
put
Unset currency for a column
delete
Add conditional labels to rows
post
Delete multiple columns in a sheet by name
post
Delete rows
delete
Delete rows matching a filter
delete
Delete rows not matching a filter
delete
Generate description
post
Find and replace values in a sheet
post
Run a given formula.
post
Edit a formula
post
Formula sample result.
post
Validate a given formula.
post
Add iterator column
post
Get operation status
get
Ensure column names are unique
post
Rename columns by name
post
Select columns by name
post
Updates a single cell
put
Update a single cell using column name and row number.
put
Upsert rows in a sheet
put
Describe dataset version
get
Insert a new row with empty/null values
post
Delete sheet
delete
Get all supported formulas functions.
get
Explode the column with JSON
post
Extract domain from URL column.
post
Get Aggregations
post
Delete column
delete
Delete multiple columns in a sheet
post
Cross file lookup
post
Split column
post
Trims a column's whitespace
post
Explode the column with an array into multiple rows
post
file
Set aggregate filter model
put
Set aggregations
put
Set column state
put
Get current sheet state version
get
Set filter model
put
Set group columns
put
Reset client state
put
Set sort model
put
Set visible columns
put
Set client state
put
Set client state by version id
put
Returns a file's note
get
Sets a file's note with a max length of 20K characters
put
Save current view
post
List views
get
Create view
post
Get view
get
Delete view
delete
Update view
patch
Create linked sheet
post
List files at the root directory.
get
List files in the given location.
get
Copy file
post
Move file or folder
put
Create an empty file
post
Combine files
post
Combine files by name
post
Validate combine by name request
post
Validate combine request
post
Create folder
post
Create folder
post
Get a new handle
get
Datasets at root
get
List exports
get
Get home page datasets
get
Get path
get
Search Library
post
Shared files at root
get
Shared files in dir
get
Shared with my team files at root
get
Shared with my team files in dir
get
Datasets in dir
get
Rename file
post
Get enrichment credits
get
Get space used
get
share
Delete a live share of a file
delete
Creates a Share ID for a sheet
post
Creates a string of CSV data representing a sheet
get
Lists all liveshares and their details for a provided sheet
get
Get organization permissions for file
get
Set organization permissions on file
put
Share a file with others
put
Opt out of file that has been shared with you
put
Request access to a file
post
comments
Get all comments
get
Add a column comment
post
Delete a column comment
delete
Get column comments
get
Add a cell comment
post
Delete a cell comment
delete
Get cell comments
get
filter
Get filtered group count
post
Get filtered data row count
post
Filter data
post
Filter data
post
Row number in filter result
post
List saved filters
get
Describe saved filter
get
Create or update saved filter
put
Delete saved filter
delete
Get filter model for saved filter
get
export
Download export
get
Create export
post
Creates and saves a file state so as to also contain any applied filters and grouping
post
audit
Get action history
get
Total activity count
post
Search action history
post
data_cleanup
Delete duplicated rows
delete
Count duplicated rows
post
enrich
Enrich data
post
Enrich data
post
Enrich data
post
Enrich data on demand
post
Lists active enrichment tasks.
get
Apply generic HTTP enrichment
post
Calculate expected credits used by the enrichment
post
Preview of a generic HTTP enrichment
post
Get status for the given generic enrichment task.
get
Cancels the given enrichment task.
post
user
Request access to Gigasheet API
post
Sends an email invitation to the list of email addresses to join the Gigasheet
post
Request account deletion.
post
Delete account.
delete
Revoke API keys
delete
Issue API key
post
Detailed user info
get
User metadata
get
Updates user metadata
patch
Remove user from the team
post
Trigger password reset for requestor.
post
User info
get
Get users autofill info
get
upload
Raw data direct upload
post
Upload from URL
post
Powered by
List available Gigasheet plans.
get
https://api.gigasheet.com/billing/plans
Language
Shell
Node
Ruby
PHP
Python
Credentials
Header
Header
RESPONSE
Click
Try It!
to start a request and see the response here!