How to edit a row in google sheet?
Status: Open · Asked by rajeswernaidu on · 0 views
Is there a way to use the data entered in google form, retrieve existing data from google sheet, edit/store new data in the same existing row (not to add a new row)?
You can set up your workflow in this manner to achieve this use case:
- Use the Google Forms trigger step to capture form responses.
- Then, use the 'Lookup Spreadsheet Rows' action step to retrieve the data.
- Finally, use the 'Update Row' action step to update the data in that row.

Thank you. Will create the flow as explained