You can do this using Pipedrive automation or Make/Integromat.
Pipedrive enables you to do this by using the automations / workflows. If you need to go beyond the given abilities pipedrive has you can still do this with the API and for example the tool MAKE. We did go through this process with the help of @Bernd Auer and his team. You can also contact him directly here in the community. Best regards, Steffen