Use 'Insert from URL' Script to Sync Google Spreadsheet to FMP12 Table

[reiersga]

Hello everyone,

 

I am new to FM and the FM forums. 

 

I am working for an academic program that is in the process of digitizing all of its student/alumni records.  Some of those records include an alumni questionnaire that is filled out on Google Forms, all the responses for which are then automatically recorded into a Google Spreadsheet.  

 

We want those data to regularly get pushed from the online spreadsheet into a FMP12Adv Table -- in other words, we want to sync that spreadsheet with a table in FMP12Adv.  

 

So far, I have found two ways of doing this:  (1) Stop trying to pull data directly from the web and just download the spreadsheet so I can manually import it into FMP.  Not a satisfactory method.  (2) Use a technique called webscraping, as demonstrated in this video by Daniel Shanahan:  

[Lee Smith]

Automatic message

This topic has been moved from "FileMaker Pro 12" to "Importing & Exporting".

[Joe_Schmo]

reiersga,

 

I know this is an old thread but did you ever find a solution? I'd like to be able to do this as well and the web scraping option seems viable.

 

The Google spreadsheet itself won't work though. That's not an HTML table like in the video. But if you go to File>Publish to the web, and import from that URL then you will get the data you need to start with. At first glance, I don't see timestamps included in the data though so you may need another column to use as a unique ID. I guess those values are stored somewhere else and imported as it's being displayed in the webpage, as opposed to being part of the HTML like the rest of the data. 

[comment]

Have you examined the options offered by Google's API - for example: https://developers.google.com/apps-script/guides/content