I am new in using Retool. I was looking to create a simple app that allowed me to access a Google sheets spreadsheet. I was able to download the content of my spreadsheet without an issue. However, when I try to add a new record, I would get continual error messages. See the screenshot.
Hi @Biff - based on the error message, I am thinking the 'Values to append' text box is expecting key value pairs? Can you try:
[
{ ID: 6, FirstName: "John", LastName: "Doe", Email: "johndoe@example.com", Age: 40 }
]
Hi Isaacjm,
I think you're onto something. I finally got it working, and it successfully added a record to the spreadsheet I was using. I tried your code right away and encountered the same error message initially.
My solution ended up working when I changed the names of the columns in my spreadsheet to PascalCase. That change, combined with your code, seemed to do the trick! Not sure what I overlooked initially, but now I know!
Thank you!
Biff
1 Like