Edit value in a cell

Hi, i wish to create an integration wherein the process to edit a value in a particular cell is automated.
Can you please throw some light on this?
Thanks

Hey @akgshanmuga

If you are using Google Sheets, you can use the "Update Row" action step for your concern. Further, you can refer to our tutorial video for a better understanding.

youtube.com/watch?v=3Iuk0ZTEbb0

Thanks!

Thanks for your response.

But my query is still unresolved.

Let me explain with an example.

I have a google sheet wherein my customers input their passport expiry date.

Now i serve them by sending reminders before 30 days.

I have made integration with Pabbly connect and sending reminder email is automated now.

Everything works fine.

Here, I wish to do one more automation, ie to send a link along with the reminder to update their data.

So if a customer wishes to update his new passport renewal date, he can just click that link and update.

If you can assist me in this workflow, will be gratified.

Thanks

Hey @akgshanmuga

Could you please explain the term "So if a customer wishes to update his new passport renewal date, he can just click that link and update?" and how do you want to send the link.

Hi Sir,

When sending the reminder email or WA, I wish to include the link for updating the value too. So the workflow will include that automation too.

That would be an excellent automation and customer will have an excellent experience.

Can you please guide?

Thanks

Could you please explain the term "So if a customer wishes to update his new passport renewal date, he can just click that link and update?" and how do you want to send the link.

On the date of expiry of the passport, we send an email to remind about the same.

We have created workflow for this event and it works fine.

My query now is, in the same email, is it possible to attach a link, wherein if the customer clicks the link, he can directly edit the corresponding value in that particular cell.
[TABLE]
[TR]
[TD]Name[/TD]
[TD]Email id[/TD]
[TD]Mobile No[/TD]
[TD]Passport Expiry date[/TD]
[/TR]
[TR]
[TD]Ravi[/TD]
[TD][email hidden][/TD]
[TD]9000030000[/TD]
[TD]12.10.2021[/TD]
[/TR]
[TR]
[TD]Kumar[/TD]
[TD][email hidden][/TD]
[TD]6300063000[/TD]
[TD]30.12.2021[/TD]
[/TR]
[/TABLE]

Here Mr Ravi gets an email today saying him to renew his passport.

It will be great if a link is provided in the same email wherein if Ravi clicks that link, he can enter the new date of his passport expiry.

Can you help me with this integration?

Thanks

Hey @akgshanmuga

We are currently looking into it and will update you shortly.

Kindly do not erase any of your recently added test submissions from your workflow.

Thanks!!

i thank mybea can use sheackbox when you click to true the link update to renew or the date expire narery ( 10 days ) you can use if statment

i hope this helpfull

i thank mybea can use sheackbox when you click to true the link update to renew or the date expire narery ( 10 days ) you can use if statment

i hope this helpfull