Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.

Automate the download of an Excel file present on SAP in Google Cloud Platform

Hello,

I was recently recruited as a data analyst intern in a luxury company and I need to automate certain fairly repetitive tasks from my internship supervisor.

Every day she goes to SAP and downloads an Excel file containing data associated with the items: item code, price, etc. She will then use this file to carry out a set of checks, but the automation of these checks will be done in a second step.

Our company is gradually migrating data to Google Cloud Platform and I was wondering if there is a SAP API or something else that I can use to grab this Excel file and store it directly in Google Cloud on a daily basis (every morning ) in Google Cloud.

If you have any advice on best practice for doing this task, I'm interested.
I went to programming school, but I am completely new to using SAP and Google Cloud.

Thanks in advance !

1 REPLY 1