Gigasheet Create Lookup

Creates a cross-file lookup to enrich data by matching values between two sheets. Use when you need to pull related data from a reference sheet into your source sheet based on matching column values. This is similar to VLOOKUP in Excel. Before using this tool: 1. Obtain valid ha…

Write ActionRisk level 2 of 5API key connectionFree Action

Use Gigasheet Create Lookup

Owner App

Gigasheet ToolsApp

Required inputs

Product

Aident Loadout Aident Playbook Editor Open-CUAK

About

Apps Skills Docs Blog Pricing Downloads Privacy Policy Terms of Service

Alternatives

vs Composio vs Zapier

llms.txtGet an AI summary of Aident Loadout

colRequiredstring

Column ID in the source file to search for matching data (e.g., 'A', 'B', 'C'). Values in this column are matched against the reference file's column

handleRequiredstring

Unique identifier (handle) of the source Gigasheet dataset where the new lookup column will be added. Example: '749ff5b7_878c_41cc_9cd0_5092d345cd46'

referenceFileRequiredobject

Configuration object specifying the reference file and columns to use for the lookup operation

matchConditionsobject

Configuration for matching behavior when performing cross-file lookups.

returnAllMatchesboolean

If true, returns all matching rows from the reference file. If false or omitted, returns only the first match

Observable output

dataRequired
Data from the action execution
errorstring
Error if any occurred during the execution of the action
successfulRequiredboolean
Whether or not the action execution was successful or not

Setup and approval

API key connection. Risk level 2 of 5.

Pricing and limits

Free Action

Unified payment: Not currently supported

Skills that use this Action

No published Skills explicitly reference this Action yet.

Official source

Provider source