“watch Changes” on google sheet - not triggering on new data added by Google forms

How To
1

As we can see in the topic

“watch Changes” on google sheet - not triggering on new row added

I have a google sheet automatically implemented, and so the “watch changes” doesn’t work

I saw in the previous topic that it should be solved by “switching to a webhook trigger in Make (instead of Google sheets “Watch Changes”), and then adding a script to Google Apps around the onChange trigger, linked to the webhook URL.” but I don’t know how

For more details

  • the watch changes" trigger works when I manualy add some data in my google sheet
  • I use the google sheet to concatenate data from many google Forms
  • I have some formula and scripts that works when I have new data from the forms (but does’nt trigger the “watch changes”
  • I need to launch a scenario each time I have new form completed

thanks for your help

2

Hey @Nicolas_D2,
You should use the trigger Watch Responses for Google form. This record will include all the details you need then you can check for any further details on Google Sheet :wink:

3

Hey @DimitrisGoudis
Thank you for your answer.
I already saw it but I concatenate 15 google forms on my google sheet and I don’t really want to have 15 make senarios for the same purpose

4

@Nicolas_D2, you are right!!!
This is also my issue with make where we can’t have many triggers.

I solved this trouble with the following solution:
Create one scenario that triggers the google form and the next action is an HTTP action that sends a unique id field to a webhook URL to trigger the final scenario. The final scenario can be triggered from multiple triggers and then you can find the response raw form the sheet and continue the next actions.

5

@DimitrisGoudis OK so for this solution I have to do one scenario / form plus one scenario to regroup it
It’s still multiple scenarios for one purpose…
I think I’ll search an over way to do it without make.