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。
無料 Action
この Action を明示的に参照する公開 Skills はまだありません。