Support me with collecting bugs in sheets

I want help to do root cause analysis for bugs. Collect data in google sheets, reach out to developers to find the root cause of issue and note down the data. Analysis of automation test cases etc