Manual Process automation (Excel, website, Firebase)

Hi,
I would like to find the best way to automate manual processes. Currently, I have a excel spreadsheet with data (i.e.: vendors informations, products informations) + some images (i.e.: Vendors logo, products picture) that I manually upload into the Firebase portal (Google App storage environment).

Currently the manual upload works as follow:
1) upload an image (i.e.: product) onto the Firebase portal
2) Get the URL of that image on the Portal and store it aside its product into the excel spreadsheet.
3) Run a Macro to generate a JSON file
4) Get the data of that JSON and insert it into the Firebase database

It is very cumbersome and I need to automate that process, however, I dont know which tool/method could handle that?

Additional requirements:
- Currently the data is in Excel spreadsheet but tomorrow it will be a web-based portal for vendors to insert their data. So the tool/method must not only work for excel.
- The tool/method must be FREE or have a FREE version (i.e.: open-source)

That is why I am counting on you to suggest some tools/methods to automate that process.
About the recuiter
Member since May 20, 2018
Erman Putranto
from Chhattisgarh, India

---

---

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions