# Google Sheets Webhook Not Triggering Second Part of Scenario

**URL:** <https://community.make.com/t/google-sheets-webhook-not-triggering-second-part-of-scenario/42642>\
**Category:** Questions\
**Tags:** functions, connections\
**Created:** [June 21, 2024, 4:45am UTC](https://community.make.com/t/google-sheets-webhook-not-triggering-second-part-of-scenario/42642 "2024-06-21T04:45:23Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Alficcimo](https://avatars.discourse-cdn.com/v4/letter/a/dfb087/32.png) [@Alficcimo](https://community.make.com/u/Alficcimo)\
**Post date:** [June 21, 2024, 4:45am UTC](https://community.make.com/t/google-sheets-webhook-not-triggering-second-part-of-scenario/42642/1 "2024-06-21T04:45:23Z")

</div>

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.

Scenario Details  
[blueprint.json](https://community.make.com/uploads/short-url/cecN2AnSCRRS3V9LShkCzpoY5A5.json) (128.0 KB)

First Part of the Scenario:

1. RSS Module: Watches for new RSS feed items.
2. HTTP Module: Makes a request to fetch data.
3. Text Parser: Parses the fetched data to extract specific content.
4. Tools Module: Aggregates the parsed text.
5. OpenAI Module Summarizes the aggregated text using ChatGPT.
6. 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:

1. Google Sheets (Watch Changes): This module is set up to watch for changes in the Google Sheet.
2. 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:

1. Webhook Configuration:

2. Google Sheets Watch Changes Module:

3. Router Configuration:

 ![Screenshot_4](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/0/a/0a6f3d804e8cc76b73a01d24551fdee51c39d5e6.jpeg)  
 ![Screenshot_5](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/b/2/b25dc5179dda066170478dc3f21b1f54fc94d099.jpeg)  
 ![Screenshot_6](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/e/3/e39be99c93be9949d66999b848778904ddd59220.jpeg)  
 ![Screenshot_7](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/f/a/fa7742902f78494d061b0b37bcac16c8838fcbe6.jpeg)

### Request for Assistance

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.

---

<div class="post-metadata">

**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\
**Post date:** [June 21, 2024, 4:53am UTC](https://community.make.com/t/google-sheets-webhook-not-triggering-second-part-of-scenario/42642/3 "2024-06-21T04:53:35Z")

</div>

> [@Alficcimo](#):
>
> webhook is supposed to trigger the second part of the scenario. However, this is not happening

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).

[samliew](https://samliew.com/services) – [request private consultation](https://samliew.com/request-quote?ServiceType=Automation%20Consultation&Referrer=Make)

> ### Join the [Make Fans](https://samliew.com/make-discord-invite) Discord server to [chat](https://samliew.com/make-discord-invite) with other makers!

---

<div class="post-metadata">

**Author:** ![Alficcimo](https://avatars.discourse-cdn.com/v4/letter/a/dfb087/32.png) [@Alficcimo](https://community.make.com/u/Alficcimo)\
**Post date:** [June 21, 2024, 7:23am UTC](https://community.make.com/t/google-sheets-webhook-not-triggering-second-part-of-scenario/42642/4 "2024-06-21T07:23:01Z")

</div>

got it  
I did and its worked

but I accrued small issue and want to ask please:

1.After this scenario is complete  
[blueprint (1).json](https://community.make.com/uploads/short-url/nPuXAQ3vhURXHOQ4DTdHsdZRUyC.json) (58.7 KB)

And I click no in my google sheet the path is properly working and doing what its should

but when I click yes in the google sheet the path not working and its not posting to LinkedIn new post  
[blueprint.json](https://community.make.com/uploads/short-url/mPlq8DGkyDXgtjvxVaEiobwlpUa.json) (59.0 KB)

1. Even if the first module is selected to be instant the scenario not start by itself and need to start it manually  
why is that and how to change?

Many thanks and appreciate your assistance

---

<div class="post-metadata">

**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\
**Post date:** [June 21, 2024, 8:02am UTC](https://community.make.com/t/google-sheets-webhook-not-triggering-second-part-of-scenario/42642/5 "2024-06-21T08:02:08Z")

</div>

You’ll need to provide additional **screenshots** , because the blueprint doesn’t explain what you are looking at.

If the trigger is instant, you need to turn on the scenario, otherwise the data/requests go into a queue.

Turn your scenario off and then on again. It will prompt you to delete all the data in the queue, or process all the older requests first.

![](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/2/b/2b0d77943b776d3ff08209abd896fc15ed4002c8.png)

[samliew](https://samliew.com/services) – [request private consultation](https://samliew.com/request-quote?ServiceType=Automation%20Consultation&Referrer=Make)

> ### Join the [Make Fans](https://samliew.com/make-discord-invite) Discord server to [chat](https://samliew.com/make-discord-invite) with other makers!

---

<div class="post-metadata">

**Author:** ![Alficcimo](https://avatars.discourse-cdn.com/v4/letter/a/dfb087/32.png) [@Alficcimo](https://community.make.com/u/Alficcimo)\
**Post date:** [June 21, 2024, 8:08am UTC](https://community.make.com/t/google-sheets-webhook-not-triggering-second-part-of-scenario/42642/6 "2024-06-21T08:08:09Z")

</div>

got it thanks

and regarding my first question about the LinkedIn post

 ![Screenshot_4](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/d/8/d8efbfe7f6a1624572f5a4d58f7f4dbacbf23f5b.jpeg)

> **[Edelman content](https://docs.google.com/spreadsheets/d/1zSLW6YinyrFbAOmNCGH-l06Ey-DObj9z79dsPLPLw7c/edit?usp=sharing)**
>
> Sheet1
> 
> Social media waiting approval ,Approval Status ,URL ,Details
> \*\*Headline:\*\* לא סוגרים בגלל המחיר? תחשבו שוב
> 
> \*\*Main Text:\*\* 
> מגיע אליכם מתכנת, ומציע לעבור על האתר שלכם ולשפר את יחס ההמרה בחינם. תסכימו? סוכן פיננסי מציע לבדוק את כל הנכסים שלכם...

[blueprint.json](https://community.make.com/uploads/short-url/mPlq8DGkyDXgtjvxVaEiobwlpUa.json) (59.0 KB)

---

<div class="post-metadata">

**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\
**Post date:** [June 21, 2024, 8:43am UTC](https://community.make.com/t/google-sheets-webhook-not-triggering-second-part-of-scenario/42642/7 "2024-06-21T08:43:59Z")

</div>

Looks like your filter is referencing **Column A** , when your Yes/No column is **Column B**.

![Screenshot_2024-06-21_160618](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/8/8/88611e0064073883584a6a248777fa49c5c3cfc1.png)

[samliew](https://samliew.com/services) – [request private consultation](https://samliew.com/request-quote?ServiceType=Automation%20Consultation&Referrer=Make)

> ### Join the [Make Fans](https://samliew.com/make-discord-invite) Discord server to [chat](https://samliew.com/make-discord-invite) with other makers!

---

<div class="post-metadata">

**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\
**Post date:** [June 21, 2024, 3:45pm UTC](https://community.make.com/t/google-sheets-webhook-not-triggering-second-part-of-scenario/42642/8 "2024-06-21T15:45:03Z")

</div>

No problem, glad I could help!

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](https://community.make.com/t/make-community-the-ultimate-topic/11682) 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:  
 ![Screenshot_2023-10-04_161049](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/5/d/5d9b26fbef0fd7385a34084f61cd5b9165786f42.png)

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](https://samliew.com/make-discord-invite) for live chat and video assistance

[samliew](https://samliew.com/services) – [request private consultation](https://samliew.com/request-quote?ServiceType=Automation%20Consultation&Referrer=Make)

> ### Join the [Make Fans](https://samliew.com/make-discord-invite) Discord server to [chat](https://samliew.com/make-discord-invite) with other makers!

---

<div class="post-metadata">

**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\
**Post date:** [July 5, 2024, 12:34pm UTC](https://community.make.com/t/google-sheets-webhook-not-triggering-second-part-of-scenario/42642/9 "2024-07-05T12:34:04Z")

</div>


