Update the cell after sending email

Hi all,

I would like to change the cell value from "No" to "Yes" after doing their job (Ex. Creating a pdf file or sending a mail ).

How to do it ?

Thanks!

quizhyo can you let me know the wider context? Why do you need the cell to say yes?

Hi Bobby,

Ex.:

I have a list of items that I already sent an email to whom may be concerned. The status is "Yes"

Now, I have added one more item. So, the status is "No. -> so, Sheetgo will help me filter and send the email as the previous item'.

After sending an email, the status must be updated to "Yes."

Tmr, another item will be added ……

I need an record after one action is permed .

quizhyo understand the use case now, thanks. Can you temporarily share your workflow with me (robert@sheetgo.com) so I can work on a solution?

quizhyo After sending an email, the status must be updated to "Yes."

Tmr, another item will be added ……

Thanks quizhyo! I have had a look at your workflow.

Basically this is already the default behaviour of Sheetgo.

It's processing the existing rows and then adds those three columns:

SG_generated_time SG_generated_document SG_generated_pdf

If you add new rows, the existing ones should be skipped because they already contain data in those columns.

Or am I misunderstanding you?

Hi Bobby,

Sorry for my late reply; I shared my workflow with you

I want to share another workflow performed by myself in Power Automate. So, I want to use the same concept for my file in google sheet and Sheetgo

Best regards,

Hi Booby,

This is just my temporary solution.

I hope Sheetgo can have the feature to do this instead of using the function in google sheet

In the complicated case, If one row has to modify (not add a new row), I need to send an email to notify to the user about this.

Best regards,

quizhyo fully understand, marking as feature request and giving you an upvote! :)