通过 Aident Loadout 使用 Gigasheet Tools 的 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…
col必填stringColumn 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
handle必填stringUnique identifier (handle) of the source Gigasheet dataset where the new lookup column will be added. Example: '749ff5b7_878c_41cc_9cd0_5092d345cd46'
referenceFile必填objectConfiguration object specifying the reference file and columns to use for the lookup operation
matchConditionsobjectConfiguration for matching behavior when performing cross-file lookups.
returnAllMatchesbooleanIf true, returns all matching rows from the reference file. If false or omitted, returns only the first match
data必填Data from the action execution
errorstringError if any occurred during the execution of the action
successful必填booleanWhether or not the action execution was successful or not
API 密钥连接。风险等级 2/5。
免费操作
目前没有已发布技能明确引用此操作。