Enhancing the Google Apps Script Developer Experience (Cloud Next '18)
Yeah. I don't. Know I. Have. Multiple. Yeah. This. Is. One. Of the types of, situations, you dream. Let's. Continue on I mean yeah I have a lot to talk about and. Who. Needs, actual. Live demos even though they're really cool, because. I love them. Hello, world, Docs, add-ons. Okay. I'm going to show the sheets Mac recorder. So. I don't know if don't, know but with. Google sheets you're, able to record. The actions that you do as a user and, you're. Able to record it into what's called the macro, which. Is basically a. Little, function that, you create and you, can duplicate, that across, spreadsheets, across. Different tabs and, you can assign it to a hockey, so. For example you'd have control. Apple, one, to. Be a hockey. That. Automatically. Formats. Your, spreadsheet, add, a header, maybe. Add. Zebra, stripes to. The spreadsheet formats, a couple numbers and. Once. You do that you, can do it you. Can save it as, an add-on and it. Can be used. Without with, all of your spreadsheets, or kids, binders just to that spreadsheet. So. At Dreamforce. Last, year I built a Salesforce, add-on that allows, you to import your self force opportunities, data. Into. Google. Sheets and, so. You, might have like, an ORM, or some. Other data. Service and you want to just get your data into Google sheets well. It's really, not that hard using, app scripts I want to library. And. I'm running a couple lines of code lines. Of code you can. Connect. With that API and then. Import. Your data into. A. Spreadsheet. I think. I. Actually. Have a Jeff of this. So. Yeah, there's. A little bit so. Yeah from. Your CRM you, can, take. Your data and, load. It into Google, sheets and. You. Can even manipulate, that data and. Return. It back into Salesforce, CRM. And. Then. And. Also since. Google, sheets is integrated. With. Google. Slides and the rest of Google products it's really easy to just, transfer. Like. For example charts, between. Gears spreadsheet, and here in Google Sites. Okay. Here we are at the start so, here this, is a Google, sheets out on you, allow Salesforce, to access your data and then, it'll. Allow. You to import your opportunities. Table from Salesforce, and, I'll load the data here. We're loading it at a slower speed but, in reality, it, could be faster it'll automatically, sorted, and, then from there you, can create a chart, because you're in Google sheets so. Awesome. You have a chart, you, can customize. It maybe tilt backsies or. Make. A bit bigger and. Then you can just copy with. Fancy. And then paste then. You have two options you can link the chart. So. That the data will. Be reflected. In this, chart or you can do, a static image of, just this chart itself. This. Question. I think we had a. The. Product manager Ted and that's a bit more about he goes an external, designer. But. You could, do. Nothing. Stopping, you from there yet in Africa.
Only Show. Bars. That are non zero. Then. We'll just insert the shape which, is a rectangle, at the X Y and the, width, and height and. Then, like add some borders, and, set. Like a link URL, as. A custom. ID. So. Let's see this in action. So. Here. Thank. You refresh. I just, double-check. Pick. Out as I can. I. Should. Add some menu, items to. This. Presentation. Not. Seeing the correct ones. Yeah. That's, kind of refresh there but. Well. Yeah. Yes. I think it. Exactly. Sure why. It. Should prompt you for authentification. But. We can skip. Yeah. The. Trigger should just be on open so. That's. Fine you can. Slide. Great. So Gmail. Add-ons just came out. Last. Fall and they, allow. You to extend, Gmail. The. Native app from, Android. IOS and, web so. This is pretty unique in terms of batch script and. It. Allows you to. Customize. Your. Emails. So. So. Write once run. Anywhere on, web. Or mobile present. Below sign of a QuickBooks control etc how. About add-ons, that. Work. Across these devices. That. All structure. Is a bit like this, you. Have a header and. You have card, sections and. Section. Headers, etc. It. Works great this is the structured, UI, data format that. Works well across devices. Here's. Some example add-ons so, if, you use github at all you, can write an add-on that, touches. Metadata. From github Cydia and provides. Things like, data. On. Who. Reported, an issue when. It was last updated etc. Another, one that's useful if you, schedule all a lot. Of meetings is. The. Meeting assistant, you, can find. A, time, that works. For example if you want to schedule a meeting with four, clients. Jane. Bob, Mary and Sam for, 30 minutes and. Start. After. 8. O'clock and, and before 6 o'clock it'll. Provide, you. Ways. Example. Times that'll work and you can scope you, can schedule, a. Calendar. Event right there and. You can try these demos. Out on. Github.com. /g. Suite devs /. Gmail, add-on samples. So. I don't have, a. YouTube. API sample. So. For example I, play. The saxophone and. I. I've. Been looking at YouTube. Videos, for the saxophone, recently. And, so. I've. Got a little demo that shows just. How, you can use. Some. Google technologies, for example using, the YouTube API and the. Google slides II yeah to. Query. YouTube and, see. To. Query specific. Songs and then. Put, all those songs into a slide, presentation. So. This really features, Google. Advanced services, so you'll see under, resources, advanced services.
You'll. Have, all these different types of advanced services, which. You can they enable. Right. Now I'm going to enable the YouTube data API, that. Allows you to query YouTube. Like. YouTube data. So, here. We're. Just in the Google cloud platform in, console this. Is the standard way you can. Enable a Google API. And. We just got there through this little link. Right. Napkin. So. I will say okay. Cool. We have no data usage, now. Let's go and create some slides so, now if we can just press the Run button and this. Will be running on Google servers they'll. Say. Hey wait. Who. Are you. We. Need to go and. Allow. You to view and manage your Google slide presentations, and, even be, your YouTube account or view, a YouTube, account so. This. Will run in the background and. While. We, wait I can explain a little bit of the code yeah. Two. Methods one is get youtube videos. Jason the, second is create slides, the. First one will just query the YouTube API, for, an ID the, second will get. The YouTube videos and, create a presentation. And. Here. We'll. See fresh. Stock. And. Voila. We. Have a, lot, of saxophone, tutorials. So. This. Is a little a, little, demo of how. You can just make, something that's interesting. For yourself. Hope. You enjoyed that I. Am. Running out of time so I'm. So sorry but. I have. To just talk mostly about these next. Few, things so there's a lot of Africa tools that you. Can utilize. What. Is the cloud IDE that I just showed the. Dashboard, I could I briefly, mentioned stock, driver logs allows you to have, persistent, logs all. You have to do is write. Console, dot log and, then, in, your project, you can go do you stock. Driver logs and see, logs lastly. Is the apse, lie so. The, API. And, CLI were just announced, earlier this year and they allow you to manage scripts from the command line. The. Dashboard, allows you to manage executions. Sack. Driver logs allow you to see persistent, logs. Hey. Conscripts. Eli so, this allows you to create app scripts from, the command line so let's say you don't want to use, script. Google.com, you just want to use like I term or your simple, clean line tool, well now you can using. Class. Just. Npm install Google. Clasp. And you're. Able to create pole. Punch clone deploy, and even be logs built, off the bat scripts Eli here's, a little timeline of, the, off stream CLI an API res announced, so. Is released early this year I said. Internally. Cost, was, built, upgraded. To typescript, in March. Then. Later, in May, you. Were able to list, projects these dr. Borlaug's auto sync ask your files even, have custom root directories, with, your, command. Line project and, today I'm really. Happy, to announce that there's, going to be typed script support, in the app scripts II a lot so. This is really huge especially, if you're an ass Tripta belapur and you, really, want modern technologies, in modern ruling. Like. Ted trip so. So. Allow, you to facilitate, my combining. Code and use. Your personal IDs I. Really. Don't have time unfortunately, but. There's, good quotes, you'll. Have to believe me. And. So. Again, there's, tech script support this, is new, I literally. Just made. The commit like. Two. Days ago it. Allows for local, auto completion optional, typing, typing, prints etc. Don't. Have time for the demos but here's. Some the benefits. Have. Optional, typing. Access, to es6, and some features support. And. Then lastly, I, just want to talk a little bit about github and open source so, I'm, scrip has an amazing, community people. Who. Contribute. On Google+. As well as contribute, to our app your samples so here we have over. 1200 stars on our app script sample repo alone, and. This shows you how to do everything from use the admin SDK calendar, classroom, Docs drive form, sheets gmail, slides, tasks and, a bunch more it's. Also open to pull requests. So. In, summary. There. Are a lot of tools, that are helping, target. Professional. Developers, of the Apps Script team and, art. That. I'm working on and. So. With. The. API class, the, new dashboard and, open. Source we really, hope that there's. More, that you, can leverage when, you're building your app projects. This. Is what we talked about I. Guess. Turns out Google, comm you'll. Be able to find these slides later, on. My personal. Grant. Slash talks. Thank. You.