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
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
Early access
Next Gen Zaps
Build and deploy automations from AI tools you already use. With Agentic Management, if anything breaks, the agent diagnoses the issue and proposes a fix.