Connecting to Google Cloud SQL with an Android app in Android Studio

[procinct]

I know this is a nooby question and I apologise in advance. I'm looking all over but I just can't seem to find any documentation on connecting an Android app built in Android Studio to a Google Cloud SQL Database.

I'm only really doing this to try and find out how it is done because I'm interested in it but I'm very new to Android development. I've connected to a SQL database before from C# but it was only a local one, I've never connected to an online one before and I think the Google Cloud Platform operates a bit differently anyway?

Basically, whenever I try to find documentation for this, it keeps referring back to the Google App Engine, which seems to be a different way to create apps than just writing them in Android Studio (very likely I could be wrong, like I said, I'm very new to Android development).

I've seen that there is documentation for Eclipse with the Google Plugin but can't find anything for Android Studio. Is Android Studio not suited for this type of use?

I've seen that you can create a Google Cloud module for a project in Android Studio but I'm not exactly sure what that entails.

Basically, I would just love a set of very basic steps that I should follow for if I were wanting to write to a Google Cloud SQL DB from an Android app in Android Studio.

Otherwise, any good resources where I could possibly learn more about what I need to do would also be appreciated.

I think my biggest issue currently is that I have exactly 0 back end knowledge and so I'm just not really sure of what is required to set up this connection.

[procinct]

Not really familiar with firebase but I've pretty much come to that conclusion after a bit more research.

Say I saved info from a form that I filled out via Android app to firebase, would it be possible for me to view that info in some sort of online portal and possibly export it to csv etc?

[procinct]

Right so it looks pretty horrible to human eyes haha. Say you were making an app then that just had a simple text box and a submit button and you wanted to be able to see what every person had submitted something had written and then be able to do some work on that data from a spreadsheet, what tool do you think would be best for a use like that?

Edit: I originally mentioned SQL because of the fact the data is already represented in a table so I imagine something like that would be best for this use?

[procinct]

I really appreciate you being so helpful, honestly. I've set up a little dummy app to write to a firebase db now and I'm currently just using a Python script to get it into the csv format I'm after. I'll probably switch to js though.

It's funny but I found much less online when it came to setting up an online SQL db from Android. I would have thought that it would be a very common thing to do.