Aident Loadout के माध्यम से Google Sheets Tools के साथ Googlesheets Aggregate Column Data का उपयोग करें। चलाने से पहले इनपुट, आउटपुट, सेटअप, मूल्य और जोखिम देखें।
Searches for rows where a specific column matches a value and performs mathematical operations on data from another column.
operationआवश्यकstringThe mathematical operation to perform on the target column values.
sheet_nameआवश्यकstringThe name of the specific sheet within the spreadsheet. Matching is case-insensitive. If no exact match is found, partial matches will be attempted (e.g., 'overview' will match 'Overview 2025').
search_valuestringThe exact value to search for in the search column. Case-sensitive by default. If not provided (or if search_column is not provided), all rows in the target column will be aggregated without filtering.
search_columnstringThe column to search in for filtering rows. Can be a letter (e.g., 'A', 'B') or column name from header row (e.g., 'Region', 'Department'). If not provided, all rows in the target column will be aggregated without filtering.
target_columnआवश्यकstringThe column to aggregate data from. Can be a letter (e.g., 'C', 'D') or column name from header row (e.g., 'Sales', 'Revenue').
case_sensitivebooleanWhether the search should be case-sensitive.
has_header_rowbooleanWhether the first row contains column headers. If True, column names can be used for search_column and target_column.
spreadsheet_idआवश्यकstringThe unique identifier of the Google Sheets spreadsheet.
percentage_totalnumberFor percentage operation, the total value to calculate percentage against. If not provided, uses sum of all values in target column.
additional_filtersarrayExtra column=value conditions applied with AND logic on top of search_column/search_value. Use this to filter on multiple columns simultaneously. Example: [{"column": "Region", "value": "APAC"}] combined with search_column=Product/search_value=Beacon returns only rows where Prod…
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
OAuth कनेक्शन। जोखिम स्तर 2/5।
मुफ़्त Action
अभी कोई प्रकाशित Skills इस Action को स्पष्ट रूप से संदर्भित नहीं करती है।