Hello there
is there a way we could trigger a workspace as soon as a record is added to google sheet
Thanks
Solved
start a work space as soon as a record is added to google sheet
+11- Contributor
Best answer by david_r
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.
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
- Best Answer
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.
+18- Supporter
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.
+11- Contributor
@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