Google Sheets New Action Type – Lookup Multiple Spreadsheet Row(s)

Google Sheets action now supports looking up multiple rows based on conditions, allowing users to extract rows that match the search criteria. Steps include selecting account, drive, spreadsheet, starting search position, choosing search column and value, specifying output row count, enabling case-sensitive lookup, and creating new spreadsheet if value not found. Use cases are data extraction by categories, finding leads based on criteria, and working on data with specific values.