Retrieve Rows from Google Sheets with Google Apps Script

Подписаться 3,9 тыс.

Просмотров 42 тыс.

50% 1

In this video we look at some common ways to get data from a Google Sheet using Google Apps Script and process them using JavaScript array methods. You can get the code or the sample sheet/script project here: jeffreyeverhart.com/2019/03/0...

Наука

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

5 авг 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 32

@JJGilbert 4 года назад

Finally, a Google Apps Script Tutorial I can follow, and that actually covered exactly what I wanted to do with my sheets! Very nice job on this. Thank you.

@jeffeverhart 3 года назад

Thanks for watching!

@sandeephanda7453 2 года назад

Very good explanation Jeff. Explanations are crisp and yet detailed.

@mohammedabas3377 3 года назад

I really want to thank you for your help! that exactly what I wanted to do with my scrpit! you helped a noob programer to help all his collage friends! thank you very match

@jeffeverhart 3 года назад

Thanks for watching. I'm glad it was useful to you!

@emziemz 2 года назад

Excellent guide! Thank you so much.

@zakpak6691 3 года назад

Very good Information...good work ... and Thank you

@jeffeverhart 3 года назад

Thanks for the kind words! Cheers, JE

@rayvera4720 2 года назад

You saved me so much time, thank you!

@jeffeverhart 2 года назад

You're welcome!

@teukurama3569 2 года назад

Firstly, thank you so much for the tutorial. May I ask you how to make the trigger event is not "submit click" but certain multiple choices are chosen on the form? Thank you

@poojajain9833 2 года назад

Hey, thanks for your help. Can you please suggest me How can use the already made script with minor changes in another spread sheet

@alexandergonzalojimenezcas3984 3 года назад

Excelent, how cam I do to get a specific result acording ID and putting into anycell

@bumpersmith 3 года назад

Very good explanations. I do wish you would have applied these to real practical applications that could be used in the real world.

@jeffeverhart 3 года назад

Thanks for the feedback

@mohauaugustinemaimela7029 2 года назад

how can i read all the values google sheet values and print them out on the google docs

@smartsolution8244 2 года назад

How to get all selected rows and do each loop?

@chervindavasol4704 3 года назад

more videos like this, thank you keep it up

@jeffeverhart 3 года назад

Thanks, will do!

@alexandervendrov7654 3 года назад

I have google sheets table, each row will have its unique ID, and each row has about 15 columns. I need to print out the information from the row and give it to a worker. How to transfer the information from the row into readable information for a person?

@jeffeverhart 3 года назад

This should help you use the data in the sheet to generate Google Docs based on a template: jeffreyeverhart.com/2020/09/29/auto-fill-a-google-doc-template-from-google-sheet-data/

@senju31 4 года назад

Great video. However, do you have any tutorials and or suggestions on how to use this with triggers? I've been trying to use what you have with onOpen simple trigger and it never shows any values in the log. It only shows values when I run your function directly.

@jeffeverhart 4 года назад

Check out this article and look at the section about the stackdriver logger, as that will show executions of script functions outside of the development environment: jeffreyeverhart.com/2020/01/24/debugging-in-google-apps-script/

@senju31 4 года назад

@@jeffeverhart Thank you.

@jeffeverhart 4 года назад

@@senju31 Sure thing. Sorry I took so long to comment back. RU-vid doesn't do a good job of sending notifications.

@hananjaqilan 3 года назад

I have a google sheet: I created functions using google script, and I am trying to read this data from an excel file, but it gives me "#NAME" for the columns that call the google script function, how can I fix this?

@jeffeverhart 3 года назад

Good question, you might try using getDisplayValues instead of getValues on the data range. This method will include additional data formatting options, so it might process the formula: developers.google.com/apps-script/reference/spreadsheet/range#getDisplayValues()

@singhalmonica 4 года назад

Pls help me to know vlookup function by scripts, dynamically....

@jeffeverhart 4 года назад

I'm not sure what you mean. Could you give me an example of what you want to do with vlookup so that I can suggest how it might be done in apps script. Thanks for watching.

@singhalmonica 4 года назад

@@jeffeverhart sir, i have my two sheets, 1 and 2. In sheet1 i have raw data, in sheet2, i use drop down and getting all data as per the bill no. From sheet1.now i want to input CHECKED against perticular bill and want to update same value in sheet1, against same bill no. Lastly i want to CLEAR that column when drop down refresh. I hope u understand it, and provide me solution for same.

@jeffeverhart 4 года назад

@@singhalmonica I'm less familiar with Google Sheets native functionality than Google App Script, so I'd suggest taking a look at the resources from Ben Collins as he does an awesome job of going through spreadsheet fundamentals: www.benlcollins.com/spreadsheets/vlookup-wildcard/