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