which direction? filemaker to google? other way? both?
The answer makes a world of difference in the complexity. The only off-the-shelf sync to google i know of is for calendars and maps, not documents. It's definitely possible to do, but will almost certainly be a custom job since the field level match will need to be hardcoded.
It would be Filemaker > Google.
The easiest thing for you to do would be to just create a script that exports a static file from filemaker, and then manually import this to google sheets.
If you do want to go about a full on sync, you'll need to:
1. 1) Establish an API connection to the google sheets API.
2. 2) Write an API script that will select a google sheet, write a row to the sheet, and return the rowID to filemaker for later reference.
3. 3) Write an API script that will select a google sheet, delete a row in the sheet by rowID.
4. 4) Write an API script that will select a google sheet, update a row in the sheet by rowID.
5) Write the filemaker code to handle new records, updates, and deletions using actions 2-5.
Here's google's API details for sheets:
Take a look through that, you'll see it's pretty involved. It might be best to seek out a developer with experience.
Thanks, Mike! Do you know where I might find a developer to do this kind of work? Do you do this sort of thing?
Yes, we have a few developers (myself included) that do this sort of thing, you can contact us for a quote off our website:
I would also recommend googling "filemaker google sync" and contacting the companies that popup that way. Mostly once you clear the first hurdle (establishing a connection), the rest is easier. Thus, anyone with experience connecting to the google API would be ideal.
For a full auto-sync you will need to look into Google Sheets API and then use POST from FileMaker, provided you are on 14, although you might get away with "Insert from URL". It is doable, but unless someone already done it, it is not a five minute job. The problem with API is that Google changes them quite often and you will have to tweak you code every time it happens.
Edit: took me ages to post and Mike beat me to it.
Thanks, Nicolai! I'm on FM12. Would that be an issue? Also, it wouldn't necessary need to be a full auto-sync. If I needed to manually tell it to sync when I needed it done that would be fine. Perhaps I'm thinking about this wrong, but in the end what I'm wanting to accomplish is to trigger various transactional emails based on date and status fields in a fm database. In order to do that I need the database to be able to communicate with my email marketing platform (Campaign Monitor). What I had in mind here was to use Zapier and connect a Google Sheet with Campaign Monitor (which I've done before and it works great). There might be a much better way to go about this, though.
It might be easier to custom-create a zap for filemaker connecting via RESTfm. It's something I've toyed with doing but haven't gotten to due to other projects.
Yeah, if you think that's possible that's probably a better route to go! I submitted a quote request, but feel free to give a quote for this instead if it comes your way.
Thanks, I am not involved in the discovery or quoting process at all (much more competent people than myself). You should hear back within a few days though.
From a quick look, Campaign Monitor has its own API. I think it would be much better to talk to it directly instead of the spreadsheet.
It uses POST methods, support for this was introduced in FM13 so you're in bad luck but it can be solved by the free BaseElements Plugin. Won't work on iOS.
I am not sure. "Insert from URL" might be enough and it is available in 12. If you need POST you will have to use a plugin.