It's about linked two sheets together

What are you trying to achieve?

When in a cell of the GOOGLE sheet A document, the string “adrien” is written
I want 1 to create a new line in a Google Sheet B document
2. duplicate the values ​​of the line of the Google sheet A document in which the string adrine is written
3. update the line of the document A in which the string “adrien” to the new line created in the Google Sheet B document, each time there is a modification

How to do it?

Steps taken so far

Nothing yet

1 Like

Sample workflow:

First, set up a “Watch New Rows” module to monitor changes in Google Sheet A. This module will be triggered whenever a new row is added to Sheet .

Filter for rows containing “Adrien”:
Add a filter to check if the specific column contains the word “Adrien”. This ensures that only rows with this name are processed.

Add a new row to Sheet B:
Add a new row with the duplicated values from the row found in Sheet A

Update Sheet A with the new row number of data added to Sheet B:

If you want to watch for all changes in sheetA you can use the following module instead

Best regards,

Msquare Automation
Gold Partner of Make
@Msquare_Automation