So don't collate it - just publish
You collect when councillors turn up for meetings, in order to pay them attendance allowance, you collect how they voted on issues, you already put it all in a spreadsheet.
At the moment you then spend money on protecting it, keeping it firewalled, having access controls to stop unauthrorized staff from seeing it - and then spend more money fighting FoI requests when somebody submits one.
So everything that there isn't a law demanding it be keep secret (like medical reports on the children being abused in your council's care homes) goes on a public sharepoint site.
The only reason to keep everything secret by default is to hide cockups or criminal conspiracies,