A method of making a multifunctional catalyst for upgrading pyrolysis oil includes contacting a hierarchical mesoporous zeolite support with a solution including at least a first metal catalyst precursor and a second metal catalyst precursor, each or both of which may include a heteropolyacid. The hierarchical mesoporous zeolite support may have an average pore size of from 2 nm to 40 nm. Contacting the hierarchical mesoporous zeolite support with the solution deposits or adsorbs the first metal catalyst precursor and the second catalyst precursor onto outer surfaces and pore surfaces of the hierarchical mesoporous zeolite support to produce a multifunctional catalyst precursor. The method further includes removing excess solution and calcining the multifunctional catalyst precursor to produce the multifunctional catalyst comprising at least a first metal catalyst and a second metal catalyst deposited on the outer surfaces and pore surfaces of the hierarchical mesoporous zeolite support.