Description
I have set up a multi-step scenario that involves extracting data from a Google Sheet, processing it, and then updating the Google Sheet based on certain conditions. However, I am facing an issue where the second part of the scenario, which is supposed to be triggered by a webhook from Google Sheets, is not executing as expected.
Text Parser: Parses the fetched data to extract specific content.
Tools Module: Aggregates the parsed text.
OpenAI Module Summarizes the aggregated text using ChatGPT.
Google Sheets Module: Adds the summarized text to a Google Sheet.
This part of the scenario works flawlessly and adds a new row to the Google Sheet with the summarized content.
Second Part of the Scenario:
Google Sheets (Watch Changes): This module is set up to watch for changes in the Google Sheet.
Router Module: Routes the data based on the “Approval Status” column in the Google Sheet.
Path 1 (Yes): If “Approval Status” is “Yes”, it posts the content to X, Facebook, and LinkedIn.
Path 2 (No): If “Approval Status” is “No”, it sends the content to ChatGPT for further summarization and then updates the Google Sheet with the new summary.
Problem Encountered
When I change the “Approval Status” in the Google Sheet to “No”, the webhook is supposed to trigger the second part of the scenario. However, this is not happening. Here are the specific steps I have taken and the configurations I have set up:
Webhook Configuration:
I have created a webhook in the Google Sheets add-on in Make.
The webhook is correctly linked to the Google Sheet and set to trigger on changes.
Here the link to it Edelman content - Google Sheets
Google Sheets Watch Changes Module:
This module is set as the first module in the second part of the scenario.
The webhook URL is configured correctly.
The trigger event is set to “On change”.
Router Configuration:
Path 1 is configured to filter where “Approval Status” equals “Yes”.
Path 2 is configured to filter where “Approval Status” equals “No”.
Could you please help me identify why the webhook is not triggering the second part of my scenario? Any insights or suggestions to resolve this issue would be greatly appreciated.
The “Watch Changes” (second part of the scenario), actually has to be in a new separate scenario, or it will never be triggered.
A trigger module will have the “Clock” (or Lightning) icon on it (like your RSS module). This indicates that it is triggered on a schedule (or immediately).
1. If anyone has a new question in the future, please start a new thread. This makes it easier for others with the same problem to search for the answers to specific questions, and you are more likely to receive help since newer questions are monitored closely.
2. The Make Community guidelines encourages users to try to mark helpful replies as solutions to help keep the Community organized.
This marks the topic as solved, so that:
others can save time when catching up with the latest activity here, and
allows others to quickly jump to the solution if they come across the same problem
To do this, simply click the checkbox at the bottom of the post that answers your question:
3. Don’t forget to like and bookmark this topic so you can get back to it easily in future!
4. Do join the unofficial Make Discord server for live chat and video assistance
