Solved

start a work space as soon as a record is added to google sheet

  • 25 September 2019
  • 3 replies
  • 0 views

Badge +10

Hello there

is there a way we could trigger a workspace as soon as a record is added to google sheet

Thanks

icon

Best answer by david_r 25 September 2019, 11:48

View original

3 replies

Userlevel 5

Have a look at the Google Sheet API and see if there are any REST triggers that can be configured. You could then look into having those notify an FME Server topic which is connected to a workspace.

A simpler (but less efficient) solution would be to poll the google sheet every x minutes and check for changes.

Badge +16

If the API doesnt provide the solution you should check https://zapier.com/app/dashboard

for possible integration, I am using Zapier it to trigger a topic on FME Cloud and it works like a charm.

Badge +10

@itay

yes the Zapier work well, but we were looking for another way to do it , using the google sheet trigger

for a ref : https://developers.google.com/apps-script/guides/triggers/installable

Thanks again guys for your help

 

 

Reply