How to pull data from Google Sheets to HTML table

Post Summary
With Google Apps Script, Bootstrap and, DataTables jQuery Plugin you can build beautiful HTML tables to show your Google Sheets Data. The DataTables plugin lets you add search, sort, and filter functions to the HTML table. Using Bootstrap you can add styles to your table. This way you can show your data to others without giving access to your Google Sheet.

You can see the live example and the Data Sheet from the following links.

[Darshanam-Jatra]

BRILLIANT - SHORT AND CRISP -EASY FOR ALL AND HIGHLY USEFUL TO SHARE GOOGLE SHEET DATA WTHOUT EDIT AND DOWNLOAD RIGHTS AND STILL SEARCHABLE ON ALL COLUMNS
THANKS A LOT TEAM BPWEBS - 👋👋👋🌹

[GhostRecon_PT]

I have a problem with the table, apparently it only works on Microsoft Edge Browser, on Chrome and Firefox is not working, any idea how to fix? Thanks

[SOUVIKKUMAR-vjwm]

Sir if i want to show any hyperlink or weblink which is in Google sheet, what changes have to do?
Because hyperlink or weblink is not working in html table, it shows fix value.

Please help

[raymondtrangia]

how to make it sync realtime to excel to webpage?

[jeanpaulboies]

Thank you for your video, it is very well done but....
If you want to write a cell contains (from a Google spreadsheet) on a web page , I understand that you have to use Scriptlets using: <?!=total ?> (the word total is a variable here) but how to transcribe it on a web page, THAT is the question

[GJLomba]

It's working fine for me but not on mobile. When showing the page on my phone, receiving the message "Impossible to open this file".
Any idea anyone please?

Thanks

[anhtranngoc]

Thanks so much for your video! Could you help me? How i create charts from search results on this webapp?

[taichinh-taman]

Can we emberded the link into a website? If Yes, how to do please?

[siowxsen]

how about to search data from multiple sheet?

[abelinogomez]

How do I create a footer to add the total of a column? Thanks in advance for your answer

[ferdausalamsyah]

can we put some clickable link in table ?

[emskillzllc]

Is there any way to make the values of a given column dynamic hyperlinks?

[RajeesRatnam]

Thank you! can you show us pull the data row but search only on order numbers? and search by hitting a button

[Generalknowledge-yqpq]

How to solve this error data table warnings table I'd data table requested

[bijaysahoo]

SIr, Table does not load after deployment. Its showing "This application was created by another user, not by Google"...Sir please help me.

[mdmasumbillah]

i done but a massage arrive "This application was created by another user, not by Google." and dosn't work

[gregt]

This won't return image in cell results. Is there a way to do that?

[manjularoshan]

Why this HTML table can not see on mobile browsers? The same link is working on the computer browser but it is not working on mobile.

[imtiyaz]

How to displays specific columns only (say columns A, , C, E, )

[IanLim-jr]

Work on desktop but Not working on mobile phone, how to fix this error ?