Update a Google fusion table from a Google Spreadsheet

Question

I have to be able to update a Google fusion table from a Google Spreadsheet.

This (https://gist.github.com/chrislkeller/3013360) is obsolete.

There is a new Google Fusion Tables API, but when I've looked at the official examples for connecting with Google OAuth 2.0, like so (https://developers.google.com/fusiontables/docs/samples/python), it involves working around oauth.

There has to be an easier way of doing this, like at least some sort of Google OAuth built into Google Apps Scripts.... Better yet, some existing library. What am I missing?

Answer 1

You can enable an Advanced Service within your Apps Script project to access Fusion Tables directly:

See:

https://developers.google.com/apps-script/advanced/fusion-tables https://developers.google.com/apps-script/guides/services/advanced#enabling_advanced_services