Problems updating existing rows in Google Sheets with data from Pipefy

Question

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!

Page 1 / 1

Hi @Pequeno Príncipe

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:

@Pequeno Príncipe
Just checking in to see if you still need help with this?

GetUWired · Accepted Answer

Hi @Pequeno PríncipeYou 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:

AndrewJDavison_Luhhu · Answer

@Pequeno PríncipeJust checking in to see if you still need help with this?

Useful links

Code of conduct

Using the Community

Community expectations

Useful links

Code of conduct

Using the Community

Community expectations

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded