Google Apps Script: How to get Spreadsheet

[@RichardHeck-w5n]

The added insight about the infrastructure of the apps and how that affects the code makes all the difference between typing exactly as the example and being able to construct what I actually need. Thank you for thinking through what you are doing and what underlying information is needed by those just learning this tech.

[@saperis]

Thank you for the feedback. And yes, my videos are about handing you the tools so you can build your own awesome solutions.

[@RichardHeck-w5n]

@@saperis That is a common goal (I hope), I have found so few on-line classes and tutorials that come close to reaching it. Yours is one of them. I appreciate the answer back and what you are doing.

[@AlberichRheinmann]

very very well done madame ..... i love this video ....many thanks 🌺 especially your correctness , spreadsheet versus sheet, i have searched for hours to get the only and one declaration, and how to work with it ....💐

[@saperis]

Most welcome 😊

[@martinreining2807]

Hello! Thanks for the great videos. I love the videos for their clarity and structure. I am stuck on a problem, maybe you can help me. I want to use a Google Forms query to ultimately get a properly (according to CI) formatted Google Sheet (Word) document. The data from Google Forms comes in in the active 1st sheet, but would then need to be formatted (second sheet) - So from DD.MM.YYYY to e.g. "Thursday, May 5". Which line do I have to rewrite to get the data not from the first (form responses) but from the 2nd sheet. (ARRAYFORMULAR I have used there) Thanks for your Answer!

[@saperis]

If the date is the only thing that needs formatting, how about applying a different date format to the original data? Otherwise I would suggest using the IMPORTRANGE Sheets formula and applying the necessary formatting on the second sheet. support.google.com/docs/answer/3093340?hl=en

[@gencodewanghin6685]

Thank you so much. I have learnt a lot from your vdos. By the way, what if I want to get access to the 2nd sheet in this example, i.e, 'The second' sheet? How to write the script?

[@saperis]

You have a couple of options: getSheetByName(name), getSheetById(), getSheets(). Check these methods in the documentation to see which one suits your needs best: developers.google.com/apps-script/reference/spreadsheet/spreadsheet

[@AlberichRheinmann]

Hy madame Chanel No. 1 ❤ the video is very good .... bbbbbbuuuuuut i have waited to the end to see how to open a standalone spreadsheet ... and not the first sheet, but the second or third ... 😢

[@saperis]

Thanks for watching 😃 You might want to try out the getSheetByName method: developers.google.com/apps-script/reference/spreadsheet/spreadsheet#getsheetbynamename

[@AlberichRheinmann]

@@saperis I have 1000 reasons to love you 🌺 and this is one ... merci madame .... buttttttt 😵‍💫 this is the method when i am in the spreadsheet opened. I need the whole method ... for STANDALONE Open a spreadsheet ById and then Open a special sheet ByName .... in this spreadsheet i have to do this in my app i think a thousand times ... thanks a lot for your patience .... from now on ... i will collect roses for you 😍

[@lholhofox]

holy moly!! I love you!! 🤣🤣🤣🤣 Thank you!!

[@saperis]

Happy you like the video 😃

[@arpitchokhani2549]

Hi. This is the first of your videos I've watched. It's great how you explain stuff. I am a person with non coding background. Can you show me how to export Google Spreadsheet as a XLSX file at a specific location in Google Drive, or better off at a particular location on my computer. Thanks.

[@saperis]

You can only download a Google Sheets as an Excel file to your browsers "Download" folder: File > Download > Microsoft Excel.

[@arpitchokhani9903]

@@saperis That I know. But I need to do this via an Apps Script because of certain follow-ups involved wrt location and further actionable. Can you please help.

[@saperis]

@@arpitchokhani9903 Check this blog post to see how you can export a Sheet as an Excel file. Please note that with Apps Script you can only write documents to Google Drive. There is currently no way of accessing any location or folder on your computer.

[@Snap0ut]

Hello, you are making an amyzing tutorials with the best explanations I've found so far! I would like to ask you if u can make a video that explains how to make grafs from sheets to web(html document)? That's would be awesome!

[@saperis]

Thank you for watching our videos. I usually make videos on how to extend Sheets, Docs, etc. and don't touch on the subject of generating HTML. But you never know.

[@karlbradshaw4642]

I’m trying to copy and paste in app script but for some reason it won’t let me paste what I have copied back into the ide on scripts

[@saperis]

Hi Karl. Make sure to use Chrome browser when working with the Google Apps Script IDE (Script Editor). Some browsers, like IE11, are known for not allowing copy & pasting code in the IDE.

[@ConsulthinkProgrammer]

Nice. May this relate with apps script discussion kzbin.info/www/bejne/anPQmImwpcinea8

[@TheKirbyn]

I have 3 different sheets but I only want to run the script on one specific sheet. How do I do that?

[@saperis]

So, the question leaves many options open as it's not quite clear to me what you are trying to achieve. I'm guessing you have one spreadsheet and want to access the others sheets from that one. Correct? In that case check out the method openByUrl: developers.google.com/apps-script/reference/spreadsheet/spreadsheet-app#openbyurlurl

[@samirbensaci7983]

Thank you for this video, How to access data on different Google Spreadsheet through Google Apps Script?

[@saperis]

There are multiple ways to open up another spreadsheet. One way would be by using the openById method (developers.google.com/apps-script/reference/spreadsheet/spreadsheet-app#openbyidid). Check the official documentation to find the best method for your script.

[@rt-uh6mt]

@@saperis Such a simple thing but I found it really difficult to find this info as an app script noob. So either the script will be bound to that sheet or you can use openById. Great tutorial.

[@TheDervMan]

You explain these things so well. I've been working with Google App Script for a year and tend to copy and paste working code rather than understand what it's doing!! On a different note I'm trying to pull a couple of cells from a sheet via Slack but sending via a DM rather than a generic channel, any chance we can have a tuition video on that? :-)

[@saperis]

Happy you like the videos! And yes, it goes a long way to understand what all these different methods and functions actually do. 😀 I try to make videos that will benefit as many as possible. That's why I try to explain basic concepts you will be using often. Your request is quite specific for your need and probably not something I will make a tutorial about.

[@TheDervMan]

@@saperis Fair point about being very specific, I can't find any examples out there which does back that up!! I'll keep looking, thanks for the reply :-)

[@saperis]

I just stumbled over a blog post that might be useful: pulse.appsscript.info/p/2021/02/google-apps-scripts-libraries%e2%80%8a-%e2%80%8ahow-to-set-them-up-and-turn-slack-into-a-real-time-logging-platform/

[@TheDervMan]

@@saperis And here's me thinking I've seen every Google result for GAS and Slack ;-) Not seen this one, thanks so much for sharing. :-)

[@saperis]

It was a lucky coincidence that I was looking at the GAS examples on Apps Script Pulse and remembered your request. They offer some cool tutorials there.

[@gunnarmundt956]

Great video but you made a typo with the timers, standalone scripts are at 8:54 not 0:54. Great content though

[@saperis]

Thanks for mentioning it. Sadly, once a video is up you can't change it anymore.

[@caof2005]

How can I create a New Spreadsheet ? (not a sheet)

[@saperis]

There's a create() method on the SpreadsheetApp. You can read about it here: developers.google.com/apps-script/reference/spreadsheet/spreadsheet-app#createname

[@tootricks]

nice

[@saperis]

Thanks!

[@mohamed.montaser]

how you don't have the new google apps script IDE

[@saperis]

Sadly, I have no way of speeding the rollout process up. Google has announced that the rollout will take longer than previously planned and will be finished in January 2021. 😒