Zapier Integration

Modified on Thu, 25 Apr 2024 at 05:13 PM

Introduction

By integrating with Gigasheet, Zapier allows users to automate various tasks and streamline their workflows. This integration enables data synchronization and seamless transfer of information between different apps and services. Whether it's updating spreadsheets with new data from other applications, creating new rows based on specific triggers, or extracting data from Gigasheet to trigger actions in other apps, Zapier's connection to Gigasheet offers users the flexibility to automate processes and enhance productivity.

See Gigasheet connections on Zapier

How to get there

Step 1: Login to Zapier > Create a new Zaps/automated workflow

Step 2: Select your Trigger. There are many triggers to choose from and will be dependent on your use case. Select Continue.

Step 3: Connect your Trigger Account. In this example, we are using Google sheets. There are many options to use as triggers.

Step 4: Select your Actions/Events. Refer to the documentation below on Events and Actions available.

Step 5: Connect your Action Account. In this example, we are using Gigasheet.

Step 6: File out the fields unique to your action and select Connect.

Events Available

Action	Description	Inputs	Outputs
Upload From URL	This Zapier action is designed to upload or append a file to Gigasheet using the Gigasheet API. The action takes the provided inputs, including the file's URL, and name and sends a POST request to the Gigasheet API. If the operation is successful, it returns the sheet handle as an output.	`bundle.inputData.url`: URL of the file to be uploaded. `bundle.inputData.name`: Name of the file.	`sheetHandle`: Handle or identifier of the uploaded/appended file in Gigasheet.
Upload and Combine to an Existing Sheet Action	This action in Zapier for the Gigasheet app can be used to automate the process of uploading or appending files to a Gigasheet. It takes the URL of the file and the handle of the target sheet as inputs. When the action is triggered, it sends a request to the Gigasheet API to append the file. If the operation is successful, it retrieves the sheet handle from the response and logs a success message. The sheet handle is then returned as the output.	`url`: The URL of the file to be uploaded or appended. `handle`: The handle of the target sheet where the file will be uploaded or appended.	`sheetHandle`: The handle of the sheet where the file was uploaded or appended.
Append From Sheet	Append rows from a source sheet to a target sheet.
Append New Record to a Sheet	This action in Zapier for the Gigasheet app can be used to append data to a dataset in the Gigasheet app. The `handle` input is used to specify the dataset to which the data should be appended. The `data` input contains the actual data that will be added to the dataset. The ‘data’ is in JSON format, which allows users to easily create dictionaries of information to be added to their Gigasheets.	`handle`: A string representing the handle of the dataset in the Gigasheet app. `data`: An object containing the data to be appended to the dataset.	`text`: The response received from the API request in JSON format.
List Saved Filters Action	The list saved filters action in the Zapier integration for the Gigasheet app can be used to retrieve filter templates from the Gigasheet API. By providing the desired page number through the `bundle.inputData.page` input, the action sends a GET request to the API endpoint `https://api.gigasheet.com/filter-templates` with the specified page number. The retrieved filter templates are then parsed if necessary, and the resulting data is returned as the `issue` output.	`bundle.inputData.page`: This input specifies the page number for the filter templates to be fetched from the Gigasheet API.	`issue`: This output contains the fetched filter templates as a response from the Gigasheet API.
Filter by Saved Filter Action	This action in the Zapier integration for the Gigasheet app allows users to retrieve the filtered state of a sheet based on a specified filter template. The filterId input specifies the ID of the desired filter template, while the sheetHandle input identifies the target sheet. The action sends a GET request to the Gigasheet API endpoint, including the necessary authentication token and headers. The API response is parsed to extract the filterModel, which represents the filter settings applied to the sheet. The action then returns the filteredState, a JSON object containing the filter model. This action can be useful in scenarios where users need to retrieve and analyze filtered data from their Gigasheet sheets programmatically, allowing for automated data processing or integration with other tools and applications.	filterId: The ID of the filter template to be applied. sheetHandle: The handle or identifier of the sheet where the filter will be applied.	filteredState: A JSON object representing the filtered state of the sheet, including the filter model.
Filter Action	The filter action in the Zapier for Gigasheet can be used to apply a filter to a specific range of rows in a Gigasheet file. It takes inputs such as the starting and ending row numbers, the column ID to filter on, the values to filter for, the filter type, case sensitivity, and the filter operation type. By configuring these inputs, users can dynamically apply filters to their Gigasheet data.	startRow: The starting row number for the filter. endRow: The ending row number for the filter. colID: The column ID for the filter. filter: A comma-separated string of values to filter on. ftype: The type of filter to apply. case: A boolean value indicating whether the filter is case-sensitive. type: The type of filter operation to perform.	responseBody: The response body from the API call, parsed as JSON.
Get Columns Action	This action in the Zapier for the Gigasheet app can be used to retrieve the columns of a dataset in Gigasheet. By providing the appropriate dataset handle, the action makes a GET request to the Gigasheet API and fetches the column information. The retrieved data can then be used in subsequent steps of the Zap to perform various tasks.	`handle`: The handle of the target sheet where the file will be uploaded or appended.	`responseBody`: This variable contains the response body received from the API call. It is a JSON object that represents the columns of a dataset in the Gigasheet app.
Trim a Column's Whitespace	This action in the Zapier integration for the Gigasheet app is used to trim whitespace from a specified column in a sheet. The action makes a POST request to the Gigasheet API endpoint, passing the handle and column as input data. It requires authentication using the 'X-GIGASHEET-TOKEN' header from the Zapier bundle. The response body is parsed from JSON and returned as the output of the action.	handle: This is a string that represents the handle or identifier of a specific sheet in the Gigasheet app. column: This is a string that represents the name or identifier of a specific column in the sheet specified by the handle.	responseBody: This is the response body returned by the API call. It is parsed from JSON format and contains the result of the operation.
Split Column	The action in the Zapier integration for the Gigasheet app allows users to split a column in their Gigasheet using a specified separator. By providing the authentication token, column, and separator as inputs, the action sends a POST request to the Gigasheet API. The API responds with the split column data, which is returned as `responseBody`.	`bundle.inputData.column`: The column to be split in the Gigasheet. `bundle.inputData.separator`: The separator used to split the column values.	`responseBody`: The response body received from the API call, parsed as JSON.
Rename Columns	This event will rename columns in a sheet by name. It will not affect the data in the sheet.
Rename Columns to Unique	Renames the columns in the sheet. If needed, ensures that all columns have unique names. Preserves original names of columns when possible if they are already unique.
Select Columns by Name	Makes the sheets have only the provided columns, in the specific order. Deletes all other columns. This action will always keep the row count column.
Delete Rows Action	This code snippet is an action in Zapier for the Gigasheet app, which allows users to delete rows from a dataset. By providing the `bundle.inputData.rows` input with a list of rows to be deleted, this action sends a DELETE request to the Gigasheet API. The code constructs the necessary headers, including the authentication token (`bundle.authData['X-GIGASHEET-TOKEN']`), and the body of the request contains the list of rows to be deleted (`Rows: rowsList`).	`bundle.inputData.rows`: It represents the input data for the rows to be deleted. It can be a string of comma-separated values, where each value corresponds to a row in the Gigasheet app.	`responseBody`: It represents the response body received from the API after deleting the specified rows. The response body is parsed from the JSON content of the API response.
Export Sheet (to URL)	This Zapier action is used to export data from the Gigasheet app. It takes inputs such as the dataset handle, and file name. The action sends a request to the Gigasheet API to initiate the export process. It then waits for the export to be ready by checking the status of the export at regular intervals. Once the export is ready, it retrieves the presigned URL for downloading the export.	bundle.inputData.handle: A string representing the handle of the dataset for exporting. bundle.inputData.file_name: A string representing the desired filename for the export.	exportResult.export_handle: A string representing the handle of the export. presignedURL: A string representing the presigned URL for downloading the export.
Cross File Vlookup	This Zapier action is used to Cross File Vlookup from the Gigasheet app. It takes Source Sheet and a specific Source Column, and conducts a lookup on a second Source Sheet and Column. Then the user can choose to add existing values or a true/false column.

Search Events

Action	Description	Inputs	Outputs
Find Column	Search for a column within a Sheet	`
Find Folder	Search for a Folder by owner and name within Gigasheet
Find Sheet	Search for a sheet by owner, name, column headers, and description. This will not search through values of a dataset/sheet.
Get Filtered Rows	Get filtered rows from a sheet
Get Filtered Rows Count	Return the count of rows matching the filter.