Buttons in Email

Is there a way to add a button in the email query that if you click a certain button it changes a column in one of the rows of a spreadsheet attached. My case I would use an email to send a summary of the data inputted for a product order, I have put this into an email query successfully but was wondering if there was a way to add a button to the email that says approve and one that says deny that would change the approval column of that product order to say approved or denied.

@productsTPI what you can do is add a HTML button which opens an appsmith app with a query param of the id of the row to approve. You can then run logic on page load to approve that row using that query param.