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

[ontimeyes]

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.

[anne-petteroe]

Hello Lucas,

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with https://community.sap.com/resources/questions-and-answers, as it provides tips for preparing questions that draw responses from our members.

Feel free to take our Q&A tutorial at https://developers.sap.com/tutorials/community-qa.html as well, as that will also help you when preparing questions for the community.

Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a picture to your profile you encourage your readers to respond.

Kind regards,
Anne

[Ulrich_Schmidt]

Hi Lucas,

you need to provide more details. There are probably hundreds of SAP transactions, which generate an Excel file. Some of these may have an HTTP or RFC interface, others may not.

Also, if there are to be "automatic checks" to be performed on this data, it may even be better to get this data into GCP in a different format, e.g. a text-based format or an RFC table. The Excel format is not exactly "easy to process" by automatic tools...!

[Dan_Wroblewski]

I agree that we need more information, but all that you talk about is the bread and butter of SAP Build Process Automation automations.

There is an SDK for Excel: https://hub.sap.com/package/d4c960f930ba4f20b6417de878f6f5d5/overview

There is an SDK for Google Workspace: https://hub.sap.com/package/f9a77a7a82d14cc781888e5ec74771bd and https://hub.sap.com/package/cd968c0074a34df3ae8c27e7f726bb0f

I would start with a tutorial or learning journey just to understand the basics of automations, and then load these content packages -- it is pretty easy to get started from them

[Stephen_Ward]

Hi Lucas,

Could you please provide more details on which app that you are reffering to so that we can help direct you to the correct experts.

Kind Regards,
Stephen