Live analytics data linked to Googlesheets

Hi peeps,

I work in the UK and am currently working in the area of transformation. Our department is using Piwik as a way to measure the traffic to our site. I am responsible for identifying ways to remove inefficiencies.

The question I have is - how can a user pull the live analytics data shown in Piwik in an automatic way into Googlesheets (google’s excel)… the result i’m looking for is that as the live analytics data shown in Piwik changes consistently the live data in my template will be also updated… any ideas…

I’ve tried to use the import excel functions but I’m finding it very difficult and challenging using these functions, please kindly advise me…?

Best

Name: Damilola Adewuyi
Email: damiuk7@yahoo.com