Edit value in a cell

[akgshanmuga]

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

 

[Pabblymember11]

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.

Thanks!

 

[akgshanmuga]

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

 

[Pabblymember11]

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.

 

[akgshanmuga]

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

 

[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.

Sir,

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.

Name	Email id	Mobile No	Passport Expiry date
Ravi	[email protected]	9000030000	12.10.2021
Kumar	[email protected]	6300063000	30.12.2021

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

 

[Pabblymember11]

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!!

 

[onifaie]

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

 

[akgshanmuga]

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

Sir, can't understand your reply. Can you please do the spellcheck. Thanks for your concern.