My team and I are curious about trying to sort out a problem related to creating new rows on Sheets through Pipefy.
It happens that when the trigger “Move a card (Pipefy) → Create a new row (Sheets)” is set, Zapier creates new rows for every card moved. What I mean is that it doesn’t just fill the blank spaces with information, but rather creates new rows (wich means new content) all the time.
The problem itself shows whenever you try to set links and references between a new second sheet and contents within the sheet that data from Zapier are put, and this is causing me tremendous problems.
Would anyone know if (and how) it is possible to create reliable references to the sheets data from Zapier is put? More specifically, considering Zapier adds new rows, every reference would change to be one cell below what used to be, and this is the major (but not only) problem I am dealing with.
Thanks in advance!
Best answer by GetUWiredView original
You are correct, the create row action will always create a new row. You could try replacing it with a find then an update row action if you need to just update rows that are already there.
Otherwise, you can create dynamic formulas as referenced here:
Just checking in to see if you still need help with this?