Google Sheets Integration: No error, but tableData.data is empty

What I Want
I'm just pulling data from my Google Sheet. Retool recognizes everything down to the sheet I want, and number of current entries (79). But for some reasons it isn't able to read any of the data itself. Very peculiar. Here's the tableData object;
Screen Shot 2021-03-03 at 12.49.49 PM

Maybe it's because...

  • Retool doesn't have read permissions?
  • The spreadsheet has an odd offset? ( it has a typical title row followed by actual data)

But I don't think its either because

  • I can write to the sheet easy peasy
  • It recognizes the number of rows in my sheet, even with the offset.

Can anyone shine some light on this?

Update: I skipped the instructions and went straight to building :woman_facepalming:

Your Sheet needs to follow a specific format

https://docs.retool.com/docs/google-sheets#spreadsheet-requirements

2 Likes

@tony glad you were able to figure it out :slight_smile: