Topic: Datatables importing data from Google Sheets

sonictrip free asked 4 years ago

I want to import data from google spreadsheet using snippet ( to sorting datatable (

Data load correctly after connection, but first row of the table displays "No data available in table" and sorting/searching options does not work as table did not see any data after connection.

enter image description here

Grzegorz Bujański staff commented 4 years ago

Please create snippet here: I will look at this.

sonictrip free commented 4 years ago

Thank you in advance. Snippet here:

Grzegorz Bujański staff commented 4 years ago

Try this:

sonictrip free commented 4 years ago

Perfectly, everything works as intended. Thank you so much for your help, I'm closing post.

sonictrip free answered 1 year ago

Would you kindly update your snippet? The old way of importing data from Google Sheets to sorting datatable doesn’t work anymore after Google updated the Sheets API to new version. I want as previous the columns to continue to be considered as variables, because I would like to use them in the next step - if at all possible.

I can't figure it out by referring to the updated version of the snippet:

Thank you in advance for your help.

Grzegorz Bujański staff commented 1 year ago

Here you will find tutorial: Everything is described in detail in it. If you have done everything as in the tutorial and it still doesn't work for you, please send us a snippet. I'll check what's going on

Please insert min. 20 characters.


Hire our experts to build a dedicated project. We'll analyze your business requirements, for free.



Specification of the issue

  • ForumUser: Free
  • Premium support: No
  • Technology: MDB jQuery
  • MDB Version: 4.13.0
  • Device: PC
  • Browser: Chrome
  • OS: Windows 10 Pro
  • Provided sample code: No
  • Provided link: Yes