So you want a timely sync between your Google Spreadsheet and Fusion Table...
…Here is a quick walkthrough of it. This is an experiment with tools in front of me, but I can’t say how this might scale or work, and I’d be sure to backup data…
And I have only tried this with a set number of rows and columns to update. I have not tried this method with a Spreadsheet that is changing in size.
- Create the Spreadsheet
- Create a Fusion Table from the Spreadsheet
- Add your update script to the Spreadsheet by going to Tools –> Script Editor. Be sure to add your Table ID as a variable at the beginning of the script.
- Run through updating the Range of Data to be Sent and Updating the table.
- Head back to the Script Editor and go to Resources –> Current script’s triggers.
- Add a new trigger for the updateFusion function. The event is Time-driven and you can then choose the increment.
You can also get email notification if a sync fails.
Again, I don’t know how well this will work or how long, only that it is possible to get this far and make some magic…
UPDATE: I received a question on the process, so here are the steps I take to manually update the Fusion Table. As noted in the comments, the time-driven update will eventually time out after 500 or so queries.
- Enter data
- Select everything (including headers, if the menu says "Change Range of Data to be Sent (Include Headers)"
- Confirm when the dialog box pops up
- Click Update Fusion Table
The test ss I used is here: https://docs.google.com/spreadsheet/ccc?key=0An8W63YKWOsxdGlLQkR5SzR6dWt0NFFN...
Have fun and…