my use case. I want to send Pipedrive deal details using the filter to a sheet based on the owner’s name. For example: Deal Owner = Jane Smith. Write a row of deal name and value to sheet called “Jane Smith”. If Deal Owner = John Smith, write the deal name and value to sheet called “John Smith”.
Please advise.