Update a Google Sheet from Changes in Retool Table

I am building a basic application to update a Google Sheet.

The updates that need to be made are, when the user changes the retool table cells, it needs to update the google sheet accordingly.

Please view what the app looks like below:

I am specifically looking to update "Order Ready For Collection" and "Order Successfully Delivered".

I have written a query to update the spread sheet, as outlined in the documentation, but it is not working for me.

I have set all columns as editable.

This is the error I get when I run it and I cannot seem to figure it out, please help?

This is what the Google Sheet looks like:

Your Retool table needs to have the Primary Key set to Phone:
Screenshot 2023-08-21 at 8.42.02 AM

1 Like

Thanks a lot, not sure I missed that - late nights and fuzzy brains!

1 Like