I have a zap set up where I want a new row put in a spreadsheet makes an update (new row) in another sheet. The zap works fine, I don’t get an error, after I set up the zap.
But there is no update in the target sheet.
It is from Excel to an excel file.
Best answer by steph.n
Hi @JanBons - Thanks for being patient and chatting with Fran from Zapier Support. We wanted to share your answer with the rest of the community:
So I think what you are looking for here is a "find row" step for Excel
That might look like this -
You see the step for finding a row allows the option to create one if none are found, and then, the update step will update any row found or created in that second step :) that is done by using a custom field to add the row ID into that 3rd update step
I know that's alot but give it a try and let me know how you get on :) we can work on it from there if you have any questions
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
It looks like you’ve contacted our Support team and they sent you a response with some instructions :) Please respond to that message, since our Support team will have more access to your Zaps, our logs, etc.
Hi @JanBons - Thanks for being patient and chatting with Fran from Zapier Support. We wanted to share your answer with the rest of the community:
So I think what you are looking for here is a "find row" step for Excel
That might look like this -
You see the step for finding a row allows the option to create one if none are found, and then, the update step will update any row found or created in that second step :) that is done by using a custom field to add the row ID into that 3rd update step
I know that's alot but give it a try and let me know how you get on :) we can work on it from there if you have any questions