Google Sheet Update Row Index

While Adding a Row, it does the job
but for me i want to use that row later
but Add row returns Updates UpdatedRows as 1 always
but i want the index of a row it added
as i can later use it for update row
please update this

Attachments

Please help me , i am stuck with this

Hi @KaifShaikh,

Please try using the extracted number in your "Update Row" action step.

Figured it Out, by using Text Spliter

Hi @KaifShaikh,

Please try using the extracted number in your "Update Row" action step.

Attachments

If the row range in 'Add New Row' will always be from A to M, then you can extract the row index in the manner you showed above. However, if the range changes, then your method will not work. In that case, you will need to add a combination of 'Split Text' and 'Extract Number' to your workflow, as shown in the screenshot shared below.

Thanks that is cleared
but i need help in this
email is not going when google drive link is given
i know i have not connected the email because i am testing it with my email
removed and added smtp connection again
but it is not going
yesterday on my testing account where i was testing pabbly it went

Attachments

I had a discussion with the technical team, and they informed me that the issue is related to the content of your email. It appears that certain keywords in your email are being treated as spam content by the receiving server, which is why you are encountering this error.
SMTP ERROR: DATA END command failed: 550 5.7.1 Mail contain spam content E87A26007C

SMTP Error: data not accepted.

it is not going only when the link is add
i tried same smtp email on different workflow of different account
and it was working
only issue is while adding the link in the box

The receiving server is treating the URL as the spam content because of which you are getting the error.