Google Sheet Update Row Index

[KaifShaikh]

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

 

[KaifShaikh]

Please help me , i am stuck with this

 

[ArshilAhmad]

Hi @KaifShaikh,

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

 

[KaifShaikh]

Figured it Out, by using Text Spliter

 

[KaifShaikh]

Hi @KaifShaikh,

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

But, How to Extract it after adding row?
i am using text extractor and using M and second as Segment Index
which gives mes me last last number which is Index
How to do this ExtractNumber

 

[ArshilAhmad]

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.

 

[KaifShaikh]

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

 

[KaifShaikh]

@arshilahmad.9001

 

[ArshilAhmad]

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<br>
SMTP Error: data not accepted.

 

[KaifShaikh]

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

 

[ArshilAhmad]

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