How to Append All Forwarded Telegram Messages to Google Sheets in n8n?

[kaneightn]

I’ve been trying to append multiple forwarded messages on Telegram to Google Sheets, but when that happens, the one row the information gets appended to keeps getting overwritten by the next entry it takes in rather than starting a updating the next row.

As an example, I would forward 3 messages in this order at the same time: Hi, there, John. It would append “Hi” to the first row, but it would then quickly replace the “Hi” with “there”, then “John” despite the action being Append.

Why is this happening? How can I get the next message to append to the next row?

Thank you in advance!

[jabbson]

Hey @kaneightn hope all is good. Welcome.

Could you attach your workflow to show us how you are doing this right now?

[jabbson]

Technically this words just fine: takes forwarded messages and writes them to the sheet at on each line.

[kaneightn]

Hey @jabbson thanks for getting back to me!

So I’ve shortened my workflow just to figure out this part out:

The following are the inputs. I forwarded the 3 messages at the same time:

But when it appends, the row it appends the first entry to keeps getting overwritten by the other messages (in the example below, the text went from There → John → Hi):

For the Google Sheet node, I haven’t adjusted much. Only added the values to send:

[jabbson]

well it sounds like a race condition. you send multiple messages at the same time to the same node, which at the same time checks the next available cell and since it happens at the same time, it is the same cell, so all three writes happen in the same row.

[jabbson]

Try to minimize API calls option in the append node:

It’s in the options. Try and see if that makes appending better.

[kaneightn]

This worked! Thank you so much for your help