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

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.

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

1 Like

These search results should provide some direction.

1 Like

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!

1 Like