Spreadsheet formula on CloudSQL

[rommel]

Hi I want to Geocode an address field from my dataset, and this thread proposes an interesting solution using AppScript. Is there any way that I’d be able to use the Spreadsheet formula functionality if my data is living on a MySQL db?

Thanks!

[Steve]

Not easily. Your AppScript would have to connect to your database.

[Marc_Dillon]

Steve:

Your AppScript would have to connect to your database.

Hmm, not necessarily. I think a GAS could GET Appsheet’s API, do the calculation, then POST back.

As far as connecting a GAS to SQL, see here:

Google Developers

JDBC  |  Apps Script  |  Google Developers

Or you could look into Google Cloud Functions if your database is on Google Cloud.