Im working on a automation that can sort photos via tags and departments for eg. Clyde_main_Marketing_Yellow_1 (Name_Surname_Department_Color(Black or Yellow)_NO of photo, the problam i have is that when some one is changing some ones department i need their photos to be relabled and moved to the deartment it is labled as, bassed of the google sheet. Once its made the changes it should notify me on slack. i have that part down but im strugling with the beginging its not responding when i make changes to the google sheets
Here is a Json of the model
Scenario A - Department Change + Move 5 Photos + Slack Alert.blueprint (2).json (23.6 KB)
Hey there,
What do you mean by some one changing department? How are photos linked to the person? How do you know they changed their department?
A custom webhook will not automatically detect changes in Google Sheets, you would need something that actually sends the request to trigger it.
The most common approach to this is to either change to a native Google Sheets “Watch Changes” as your trigger, eliminating the need to use a Webhook. If you need to use the Webhook, you could also use Google Apps Script in your Sheet that will trigger on an edit, this can send a request to your Webhook URL. Personally I prefer the Sheets trigger as it is all in one place and need less parsing and scripting, but if you need to use Apps script that is fine too.
You write an app script that detects changes and have it call the custom webhook sending whatever data you need. The cell, the row, the entire sheet, whatever the flow requires.
So a custom webhook is exactly the correct module to start the flow with and not the watch changes one. Since that one is a polling trigger and wont trigger on edit, but will waste operations running over and over looking for a change.