Im having trouble with using google sheets in the data sources. i am able to connect it easily but there is some trouble when I need to update the columns. As I go through the design process I occasionally need to add a new field of data as a column. Unfourntaly when I go back to the blocks editor the blocks are not updated with the new column. The only workaround for this that I have found is to not only remove the data source from my project but from my entire account then re-add it later. Is there another way to update it in order to not have to continue to do this each time
If you go to your Projects page and click on the Data Sources tab, you can re-sync a data source which will update its columns.
i did notice that when the column update it stuck it at the end of the list rather then in its original place