I followed your code exactly to connect google sheets to a wix table. The headers showed up but the rest of table showed all blanks. I changed the headers reference to rows [1] to see if I was actually getting the data and the second row showed up as headers so it looks like I am getting all of the data. I don't get errors but the data just doesn't show up.
Here is the backend code:
Here is the front end code:
Here is the result:
Here is a screenshot of the Google sheet:
Hi,
Can you please add a few console logs to log the interim values of rows and formatted rows? Thanks,
Eitan