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