Hello Zoho community!

I am facing an automation issue, I understand that once leads are converted, they disappear from the front end of Zoho. I can still access them through the report module.

Here is what I am trying to do:

I am building some analytics chart on google sheet, through Zapier I am able to automatically feed Leads and Deals data to said google sheets. However I did not find a way to automatically tell google sheet that a lead has been converted to deal.

I could manually pull the leads every month but It will much easier to populate a lead id field in a deal.

Is there a way to do that?