I am new to programming and know nothing more then what I have taught myself, so please forgive me if my question is to easy. I am not looking for a direct way to do this just information or places I need to start, and things I need to learn.
I am looking for a way that users can upload their CSV files to my site, and then a script would change the data they requested to be changed. Just simple price and date changes that this data would need, via an API to another site that has better capabilities then I could offer.
I have and can do this via google script, but it is limited to only google sheets and google drive. (this is currently the only way I know how to program) The data was stored on a google sheet then manipulated on sheet via google script then emailed to user.
I now want to make an actual web app that would take the file uploaded change the data that needs to be changed and then allow new file to be downloaded, or send new file to user.
My question is where do I start? Do I lean MySQL then how to change data via api with MySQL? What other langues are useful? Like I said I know nothing, and I know there are a lot of sources out there to lean programming, I just need to be pointed in the right direction. Anything would help, thanks.
What I have tried:
I have tried to use google scripts to do this. The problem is I don't know how to make it more efficient, using spreadsheets and not a database is not efficient.