How to export data from Matomo to Google spreadsheets automatically

Hi,

I am wondering how to import data from Matomo for WordPress to Google Spreadsheets automatically once per month. Is it even possible?

I need these data to be able to use them later in Google DataStudio.

I tried to make it in a way how it is described in this video: https://www.youtube.com/watch?v=snSTWMBWFXQ&ab_channel=RonanChardonneau
For some reason, it is not working for me. Google Spreadsheet shows me this error: Could not fetch URL:.

Do you have any suggestions or experiences with this issue? Or is there any other way of importing data from Matomo to Google Spreadsheets?

Thanks a lot!

I don’t know much about Matomo for WP.
But I wonder: Is your database accessible from the outside of your network? Is there no firewall preventing Google accessing the database?