Is it possible to use a action to add multiple rows of data to another table?

[Nick12]

Hello, I  trying  a feature where, assuming Table A has columns [item] and [type], executing the action will add all rows where [type] is "stationery" as new rows in another table.

I found the most similar feature is "add a new row to another table using values from this row," but it doesn't allow adding multiple rows at once.

 are there other methods?

Thanks in advance.

[AleksiAlkio]

You need to use "Execute an action on a set of rows" for this purpose.

[Steve · Accepted solution]

These search results should provide some direction.

[Nick12]

Your articles, https://www.googlecloudcommunity.com/gc/Tips-Tricks/FAQ-add-a-set-of-rows/m-p/258033, was a great help to me. Thank you!