search

PipedreamHQ / roadmap

Pipedream is an integration platform for developers. Have a feature request or bug to report? Add it here.
https://pipedream.com
30 stars 5 forks source link

[ACTION] Google Sheets: Find a Row #401

Closed dylburger closed 4 years ago

dylburger commented 4 years ago

Given a sheet, column name, and column value, return the row number(s) if a row with that value is found, else return undefined.

Similar action: return first row with a matching value in a column, instead of an array of rows.

sergioeliot2039 commented 4 years ago

For the first action, getting the row numbers if there's a match in value at the specified column workflow > https://pipedream.com/@sergio/google-drive-find-rows-p_5VCkmY/edit action> https://pipedream.com/actions/a_0Mio8a/edit

For the second action, getting the first row if there's a match in value at the specified column workflow> https://pipedream.com/@sergio/google-drive-find-row-p_6lC9Kx/edit action> https://pipedream.com/actions/a_8Ki7Ve/edit

All these actions look good when testing, if you find anything please let me know and I'll review. Thanks!