I have the data from a Google sheet being displayed in a table. I set one of the fields to be editable. When I go in and make a change to that one value in the table, I want it to write to the Google sheet. The closest I've gotten is for it to write the new value to all the records in the table. I'm not really sure what I am doing wrong.
Hey @tomm! Happy to help here. Would you mind sharing a screenshot of your current query? You should be able to do both single and bulk updates in Google Sheets!
https://docs.retool.com/docs/google-sheets#updating-a-row
https://docs.retool.com/docs/google-sheets#bulk-updating-rows
is this still possible? those links seem to be broken and i don't see anything about writing back to a google sheet in the docs
Ah apologies! We've changed the layout of some pages. You should be able to follow the guide here! https://docs.retool.com/queries/guides/resources/google-sheets
Let me know if you run into any issues!