BROADCAST single "thread" to add a Google Sheet row

(Augusto Vera) #1

I am trying to trigger a google sheet new row once received a broadcast from an email, and I found that if you have for example 3 subscribed users in a Telegram Bot for them to receive a message that a new email has arrived, the broacast goes to the 3 subscribed users, but also the email data parsed gets entered 3 times in 3 different rows in the Google Sheet. So it is obvious that broadcast generates a thread of activities for every subscribed user. ¿What is the recommended way to receive that email to trigger the messages, add 1 row to the google spreadsheet and then continue the broadcast to send messages to all the bot subscribers?

Best Regards:

Augusto Vera

(John Jackson) #2

I suppose there’s a few ways to handle this. Probably the easiest would be to subscribe yourself to the broadcast and figure out your response path from the logs.

Then add a filter to the action that adds the row to the spreadsheet to only run the action if the response path matches yours. That way, it only gets added once? Would that work for you?

1 Like
(Augusto Vera) #3

I worked fine!, thanks!.

1 Like