I have a SQL query running and I want to push the results of this to a google sheet document.
The columns are based on the current month and the values are the last known value for each company.
This is an example of the table.
Now if there is a new value for 10/23 I want Retool to overwrite the previous value.
I have tried the "Update spreadsheet" & "bulk update spreadsheet by primary key".
"Update spreadsheet" runs successfully in retool, but does not update the sheets and I cant even get Bulk update to start.
Can anyone give me some advice on how to get going with this?
I have added a screenshot of the "Update spreadsheet" taht I use now.
Hi @Marijn_Q What does your spreadsheet look like? Is the first screenshot from Sheets or SQL?
Here's an example spreadsheet:
If I want to update row 1, I'll filter for the row where id = 1. Then, in the update value, I can add any key value pairs that I want to change:
Does your spreadsheet have duplicate Names or dates where you need to filter by both of those columns?
Google sheets can also be tricky where the column name needs to match exactly in your 'Update value' section. If you have any trailing spaces or upper/lower case letters on the Google Sheets side, it needs to match in the update query