We can use Core Reporting API to fetch top (Popular) URLs from Google Analytics. Using Google API PHP Client
let’s create a simple PHP page that pulls website’s top URLs from
Google Analytics and updates MySql table. Once you are familiar, I am
sure you can do lot more, I mean just checkout the information you can
retrieve in this Reporting API.

To read more about this article Click Here

For Demo Click Here

To download files Click Here