How to make automatically adding a row to another table with a condition?

Question

Google Sheets

Hello. I have table 1, it has some names in cell A, the table is filled from the WP Forminator plugin, I need to check the condition "In cell A = variable1?" if yes, then copy the entire row to table 2, if not, then condition 2 "In cell A = variable2?", if yes, then copy the entire row to table 3, if not, do nothing. Actually, somehow it should work automatically and trigger from a new row in table 1, please point where it’s better to look, the better to use Zapier (I didn’t find conditions there), ImportRange (it’s almost not clear how to interact with it in this history) or Google App Script? I would like more examples, because I am a beginner, thanks in advance to everyone for the answers

Answer 1

You have a Google spreadsheet A, into which the initial data “falls” onto a sheet, for example, data.
Create another sheet in this Google spreadsheet with the name, say, filter1.
On this sheet, in cell A1 , put the formula:
=FILTER(data!A:Z;data!A:A="x")where
A:Z- the desired range of columns
x- the condition you need.
Create (if not created) another Google spreadsheet B with a sheet, for example,
afterfilter1, to which the filtered rows (records) will be copied .
Now in Zapier.com (or its analogues, see alternativeto.net) you create a post that, when a new line appears on the filter1 sheetGoogle Spreadsheet A will copy it to the afterfilter1 sheet of Google Spreadsheet B. Filter2...filter# needs its own sheets and entries (or one entry with conditions, although such, EMNIP, require a subscription). Changed. Corrected the formula.

Answer 2

Use FILTER () to form filtering conditions and IMPORTRANGE () if copying goes to other tables.