Multiple Webhooks for the same spreadsheet

[Reymond_Rojas]

Hello,

Am fairly new to automation, I’ll do my best to explain what am trying to accomplish:
Am scraping transcripts from youtube, Tiktok and other sources and I need to generate googlemaps data based on the information scraped from the transcripts. Here is the setup:

Scenario 1 (youtubeScraper) will watch changes (using a webhook) from Sheet 1 and pick the url from it based on a filter, then it will generate a transcript and use a Chat completion to extract information from the transcript and then update some fields on Sheet 2.
> this was all working just fine.

Scenario 2 (Map generator) will also watch changes (using a different webhook) from Sheet 2, then it will grab information from sheet 2 to generate a Map URL.
>this is where am having the problem.

I tried duplicating the Script in google sheets and changing the webhook url on each one and the Sheet, Range they reference to with no luck.

Clarifications:

• I need to do this on two separate scenarios for various reasons, for example I need to manually inspect the output generated from scenario 1, not all entries require a map, another reason is sheet 2 will receive data from other scenarios in future just to mention a couple of reasons.
• The Webhook script in the spreadsheet is watching for changes on a specific sheet, range this is why I found the need to create to different webhooks.
• Scenario 1 was working until I duplicated the script in the Spreadsheet now it will only what for changes in the second Sheet
• aside from the sheet and range I made no other changes to the script when I duplicated it
• I did not upload the blueprints cuz I didn’t think will offer any value

Any help will be very much appreciated!

[Daniel_Muller]

To clarify:

1. You manually change the status via dropdown in the YoutubeScraper (Run)?
2. On the NotionSheet you manually change the state too over the dropdown (Map done)?

I am not sure if you can run two scripts in the same spread sheet, even when you clarify the sheet you want to watch.
Have you tried to generate an extra spread-sheet, only for the ToNotion execution?
You can still collect all data in your existent spread-sheet on the wished site but decouple the execution for notion.
After the execution in the separate notion-spread-sheet, you can update your existing spread-sheet, so all data is in the same place.

I hope this makes sense

[Reymond_Rojas]

Thank you Daniel,

In answer to your questions:

1. Yes for now I am, while am building the automation but am planning on a full automated process in the future.
2. “Map done” is set by scenario #2 once the map has been generated. This will be running automatically without my intervention, “Map Done” is also a filter on Scenario 2 to skip maps already created. That allows me as well to add map locations manually or from other processes when needed.

Am avoiding using separate spreadsheets so I don’t have to worry about complications on referencing multiple spreadsheets in the future when the process is fully automated. (Is hard to explain) Another reason for that is Scenario 1 adds the data that Scenario 2 uses to generate the map locations, also, Scenario 2 triggers when Scenario 1 makes changes to the spreadsheet.

…As you said, I hope this makes sense