Hi guys,
I did my research but didn’t find any solution, I hope the topic hasn’t already been discussed before.
I’m using a zap to update a Google Spreadsheet: every time I receive a specific email, it creates a new row in my Zapier spreadsheet. So far, that’s what I wanted.
However, Zapier creating a new row means “inserting a new row” and that’s a problem for me: I indeed have another spreadsheet (we’ll call it the “Dynamic spreadsheet”) that imports dynamically the content of each row of my Zapier spreadsheet. Consequently, in so far as Zapier inserts a new row In my Zapier Spreadhseet each time it triggers, my Dynamic spreadsheet doesn’t work anymore, “Zap!B6” becomes “Zap!B7” and so on…
Do you know how I could solve this issue? I would just need Zapier to update the next empty row in the spreadsheet instead of inserting a new row, but I don’t find how to do that.
Cheers to the community,
Pierre