Тёмный

How to pull data from Google Sheets to HTML table 

bpwebs
Подписаться 3,6 тыс.
Просмотров 85 тыс.
50% 1

This video is a demonstration video on "How to pull data from Google Sheets to HTML table". Visit the following link to see the complete blog post at bpwebs.com.
www.bpwebs.com/pull-data-from...
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.
HTML Table: bit.ly/3vjQ7AB
Data Sheet (Google Sheet): bit.ly/3fIPnP4
Apps Script file: bit.ly/2SoejmT

Опубликовано:

 

24 май 2021

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 88   
@pieterstephanus6563
@pieterstephanus6563 3 года назад
thank you so much for this video and resources!
@alexanderantonov1636
@alexanderantonov1636 2 года назад
Short and exelent! 👍
@stevrgrs
@stevrgrs 8 месяцев назад
Excellent video. VERY helpful ! :)
@mailforbijay
@mailforbijay Год назад
Thanks a lot from bottom of my heart
@1raskumar
@1raskumar Год назад
Works great.thank you
@MK-jn9uu
@MK-jn9uu 2 года назад
Wow it totally works thank you
@palashchakrabarty2364
@palashchakrabarty2364 28 дней назад
Nice Sir Thank you!
@narendrathapa1279
@narendrathapa1279 3 года назад
Nice video sir. Thank you. Can we resize table column?
@WikarsoFahri
@WikarsoFahri 2 года назад
Great. Thanks you
@ytdavide
@ytdavide 2 года назад
💯 thanks a lot 😉
@anhtranngoc3863
@anhtranngoc3863 2 года назад
Thanks so much for your video! Could you help me? How i create charts from search results on this webapp?
@pedrotomasdominguezcardena9206
MUCHAS GRACIAS!
@abelinogomez1224
@abelinogomez1224 3 года назад
How do I create a footer to add the total of a column? Thanks in advance for your answer
@emskillzllc8637
@emskillzllc8637 2 года назад
Is there any way to make the values of a given column dynamic hyperlinks?
@nirutsoncha6763
@nirutsoncha6763 2 года назад
Thank you.
@douglasteixeiradeabreu
@douglasteixeiradeabreu 2 года назад
Muito bom. Obrigado por compartilhar.
@jeanpaulboies4133
@jeanpaulboies4133 Год назад
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: (the word total is a variable here) but how to transcribe it on a web page, THAT is the question
@RajeesRatnam
@RajeesRatnam Месяц назад
Thank you! can you show us pull the data row but search only on order numbers? and search by hitting a button
@Vacar13
@Vacar13 3 года назад
Nice 👍
@zaccoza
@zaccoza 2 года назад
I've solved the problem. This is a very useful post. I am grateful 👏🙏
@SulakkhanaChamara
@SulakkhanaChamara 2 года назад
Whats is the solution
@zaccoza
@zaccoza 2 года назад
@@SulakkhanaChamara If you watch carefully after the 1:48th second of the video, you will see it.
@perrysantos
@perrysantos 2 года назад
@@zaccoza will you please tell me the solution? i really cant find the solution :) thank you brother
@ibeleno1
@ibeleno1 2 года назад
@@perrysantos i found the solution, we must define a Sheet API in the Services section.
@perrysantos
@perrysantos 2 года назад
@@ibeleno1 thanks bro, i will check it out :)
@carlobarbadillo7586
@carlobarbadillo7586 2 года назад
hi wonder if how to do it if where to get data from multiple sheets?
@Edward20100
@Edward20100 5 месяцев назад
Thanks sir
@PixelPiratesMusic
@PixelPiratesMusic 10 месяцев назад
God bless you
@taichinh-taman5516
@taichinh-taman5516 10 месяцев назад
Can we emberded the link into a website? If Yes, how to do please?
@GhostRecon_PT
@GhostRecon_PT 2 года назад
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
@akshagandhi8578
@akshagandhi8578 5 месяцев назад
Is it possible to make a search with specific field
@chonthichatungtondee169
@chonthichatungtondee169 2 года назад
thank for good video ,, but i need your help, i want it to show as in the exel but in html it arrange by a-z .. please help ,, thanks
@hdquemada
@hdquemada Год назад
Great video. One question: I can’t figure out how to change to color of the buttons. Can you give me advice on that? Thanks
@M.Sharil
@M.Sharil 2 месяца назад
You may add styles.css for dedicated button
@getkenindia7005
@getkenindia7005 9 месяцев назад
Thanks
@Cleuton1234
@Cleuton1234 3 года назад
How to pass columns to rows ?
@masbuku5128
@masbuku5128 2 года назад
How to script download data at view html to excel or convert to pdf..? Thanks
@vulong8505
@vulong8505 3 года назад
I got it running but now I want a button to Reload new data without having to reload the web page please help me.
@media1981
@media1981 2 года назад
WHat if sheet has merged cells? How do you write cell title in brackets?
@raymondtrangia3235
@raymondtrangia3235 Год назад
how to make it sync realtime to excel to webpage?
@MonikaSembiring
@MonikaSembiring 7 месяцев назад
Hi, do you have any idea if I already follow everything but my web page is empty after I click the deployment web app URL?
@MrZeeroAkh
@MrZeeroAkh Год назад
Wonder how to make link that has prefilled search entry
@siowxsen8821
@siowxsen8821 3 года назад
how about to search data from multiple sheet?
@motivasitv7480
@motivasitv7480 2 года назад
There are links from my spreadsheet that can't be clicked after it changed to html table. Need help to solve it please..
@jordanfelipe4804
@jordanfelipe4804 2 года назад
Hi there, is it possible to show pictures?
@gregt8262
@gregt8262 2 месяца назад
This won't return image in cell results. Is there a way to do that?
@PengadilanAgamaPariamanKelasIB
@PengadilanAgamaPariamanKelasIB 2 года назад
how to display url as url in the HTML?
@manjularoshan
@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.
@zaccoza
@zaccoza 2 года назад
Hello there, great work. it will be very useful for me. appscript I entered all the commands correctly. I saved it, and it didn't give any error. When I share on the web; A blank page comes up. What is the reason?
@alexispablojoseescobar4675
@alexispablojoseescobar4675 2 года назад
Hola, lograste solucionarlo ? me pasa lo mismo
@GodKarm
@GodKarm 2 года назад
@@alexispablojoseescobar4675 tienes que compartir tu hoja de calculo google y permitir a Cualquier usuario de Internet que tenga el vínculo puede ver los elementos (lector) y listo
@wakahmad3312
@wakahmad3312 2 года назад
How to add data edit tool?
@imtiyaz2110
@imtiyaz2110 Год назад
How to displays specific columns only (say columns A,,C, E,)
@GJLomba
@GJLomba 2 месяца назад
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
@halith2004
@halith2004 2 года назад
How to convert app script to html ?
@thelma2084
@thelma2084 2 года назад
HERO
@bestleads5831
@bestleads5831 6 месяцев назад
Can I download the data ? Search result
@hamidiputra8759
@hamidiputra8759 3 года назад
Pls tutorial edit data
@bijaysahoo2686
@bijaysahoo2686 Год назад
SIr, Table does not load after deployment. Its showing "This application was created by another user, not by Google"...Sir please help me.
@mdmasumbillah4858
@mdmasumbillah4858 2 года назад
i done but a massage arrive "This application was created by another user, not by Google." and dosn't work
@MrAtom-ii4tl
@MrAtom-ii4tl Год назад
How to add in local html file?
@ferdausalamsyah1600
@ferdausalamsyah1600 2 года назад
can we put some clickable link in table ?
@bpwebs
@bpwebs 2 года назад
Yes, you can. Pls read the following section of the blog post. www.bpwebs.com/pull-data-from-google-sheets-to-html-table/#display-urls-as-hyperlinks
@user-qr9ly3tu1c
@user-qr9ly3tu1c 9 месяцев назад
Work on desktop but Not working on mobile phone, how to fix this error ?
@April2023-fb6pf
@April2023-fb6pf 6 месяцев назад
How to autorefresh this page
@Ogisha
@Ogisha 2 года назад
Not working.
@Generalknowledge-yq9pq
@Generalknowledge-yq9pq Год назад
How to solve this error data table warnings table I'd data table requested unknown.......
@pavanathraya
@pavanathraya Год назад
Hi, code executed but not shows the table
@SOUVIKKUMAR-vj6wm
@SOUVIKKUMAR-vj6wm 2 месяца назад
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
@bpwebs
@bpwebs 2 месяца назад
Read the following section of the blog post pls. www.bpwebs.com/pull-data-from-google-sheets-to-html-table/#display-ur-ls-as-hyperlinks
@imronnesia5170
@imronnesia5170 3 года назад
ReferenceError: Sheets is not defined at getData(Code:15:15)
@jefersontamiozzo3875
@jefersontamiozzo3875 2 года назад
Olá, obrigado por seus ensinamentos. Há alguma forma que eu possa deixar essa tabela html acessível somente para os usuários que possuem acesso à minha planilha ?
@bijaysahoo2686
@bijaysahoo2686 Год назад
eu não entendi seu ponto
@ogidarmatena
@ogidarmatena 6 месяцев назад
not working for me
@user-xe5xj3rw9c
@user-xe5xj3rw9c Год назад
IS IT LIVE?
@RajaGiri_tvpm
@RajaGiri_tvpm 10 месяцев назад
how to pull image from google sheet to html page
@1stMoonLover
@1stMoonLover 9 месяцев назад
Not showing data on web page
@K0n5tatin
@K0n5tatin 2 года назад
no more working ?
@shaitaan0666
@shaitaan0666 2 года назад
not working sheet and error is sheets not define
@bpwebs
@bpwebs 2 года назад
You have to enable Google Sheets API Service for your project. To enable Google Sheets Service, Click the + icon in the Services tab, Select Google Sheets API from the list in the Add a service popup box. Then, click Add.
@shaitaan0666
@shaitaan0666 2 года назад
@@bpwebs wait i will check
@shaitaan0666
@shaitaan0666 2 года назад
@@bpwebs thank you so much its working now .. i like you
@engkusnadi3302
@engkusnadi3302 Год назад
Header judul
@AbulKalam-hm2xs
@AbulKalam-hm2xs 3 года назад
Eidt table
@1stMoonLover
@1stMoonLover 9 месяцев назад
Plz help
@OkaSel
@OkaSel Год назад
THis didnt work for me. Wasted time
Далее
Советы на всё лето 4 @postworkllc
00:23
Просмотров 964 тыс.
能听懂这段,你的英语听力差不了
6:28
Просмотров 1,1 тыс.
WEB APP Google Sheets | Search Data | Print Result
6:18