• EN
Solved

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

  • 25 September 2019
  • 3 replies
  • 0 views
boubcher
Rank
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

david_r
Rank
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.

itay
Rank
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.

boubcher
Rank
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


Community Stats

28,867
Posts
109,983
Replies
36,671
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.