Profile cover photo
Profile photo
Eric Koleda
4,629 followers -
Member of the Developer Relations team at Google.
Member of the Developer Relations team at Google.

4,629 followers
About
Eric's posts

Post has shared content
SlidesMerge Add-on is now available from the add-on store.
This allows you to create multiple sets of slides from a Spreadsheet and Slides Template.

There's a write up here
http://ramblings.mcpher.com/Home/excelquirks/addons/slidesmerge

A video demo here
https://youtu.be/rMXC86fV0Ek

As usual, it's open source so you can see how it's built.
https://github.com/brucemcpherson/SlidesMerge

#gde #googleappsscript #slides #sheets #add-on #blogpost

Post has shared content
Neat idea!
Welcome to the new Vodo

It amazes me that it has been three years, almost to the day, that I was last able to talk about something. But Vodo is alive again... with the same objectives as before, although a new platform for now and with new services.

If you use Google Home, the Vodo Drive action should be rolling out to you as we speak.

You can talk with Vodo Drive to access your files in Google Drive. In particular, you can open spreadsheets and say things like
"Add a new row"
"Set sales to 5"
"What is the value of total sales?"

In short - you'll be able to talk to your spreadsheets like you were asking an assistant to record and fetch values for you.

This is just the start - we have other plans for how we can work with spreadsheets and other files stored in Google Drive. And we would love to hear your thoughts about next steps as well, after you try it out.

Glass users are, rightfully, going to ask what happened to the Vodo they were so familiar with. Trust us - Glass is always on our minds as well! Glass was a new interface, and we learned a lot from Glass that we are bringing to this Google Home version, and we hope the changes will go in both directions.

Until then, you will need a Google Home. You can learn more about Vodo Drive, and connect it to your account, at https://vodo-drive.com/

And stay tuned for more news as we can... talk about it!
Photo

Post has shared content
A great mashup of Google technologies, allowing you to make conversational queries to data in a spreadsheet.
I wrote up a summary of how I used Google Sheets and Apps Script to provide data and an API for an action.

http://pipetree.com/qmacro/blog/2017/04/30/google-cloud-functions-sheets-apps-script-actions-on-google-win/

If the topics listed towards the end of the post strike a chord with you, please let me know!

cheers


Post has shared content
Is something broken in your classroom? Is your computer not working?

Learn how to create a quick and simple issues reporting system using Google Forms, Sheets, and of course, Apps Script.

As we work in a multilingual environment, it also allows issues to be reported in different languages and translated into the local language.

This includes:
*Use of the functions GOOGLETRANSLATE, DETECTLANGUAGE
*setFormulaR1C1 (adding formulas to your sheet via Apps Script)
*Utilities.formatDate (Formatting the timestamp to the way you want it)
*Improving the look of automatic emails using basic HTML formatting
*Adding options to your email, such as, htmlCode and replyTo


Post has shared content
Incredible work by +Ben Collins, using Apps Script to stitch Sheets and external sales data into a compelling dashboard.

Post has shared content
Woot!
Advanced Services for Slides and Sheets now available

We've just enabled Advanced Services for Google Slides and Google Sheets. The Slides advanced service lets you to access the Google Slides v1 API and the Sheets advanced service lets you access the Google Sheets v4 API. The Sheets v4 API provides a few features that aren't available in Apps Script's built-in Spreadsheet service.

You can also access these APIs with UrlFetch requests, but using the Advanced services will simply authorization and let you see autocomplete suggestions in the Apps Script editor.

https://developers.google.com/apps-script/advanced/slides
https://developers.google.com/apps-script/advanced/sheets


Post has shared content
I won't be able to make it to NEXT this year, but a lot of great G Suite content will be presented.
G Suite developer sessions at Google Cloud Next 2017

There are over 200 sessions happening next month at the Google Cloud NEXT conference (cloudnext.withgoogle.com) in San Francisco... so many choices! Along with the Google Cloud Platform (cloud.google.com), this year features the addition of G Suite so all 3 pillars of cloud computing (IaaS, PaaS, SaaS) are represented!

Sessions that may be of particular interest to G Suite developers:

- Using Google Apps Script to automate G Suite
- Building G Suite add-ons with Google Apps Script
- Using Drive APIs to customize Google Drive
- Automating internal processes using Apps Script and APIs for Docs editors
- Citizen developers building low-code apps with App Maker on G Suite

These talks and plenty more are waiting for you at Cloud NEXT, the best place to get your feet wet with developing for G Suite as well as the Google Cloud Platform. Meet and interact with your industry peers alongside representatives from all over Google to take advantage of this opportunity!

Learn more at:

https://goo.gl/13ZsIA #GoogleNext17 #GSuite

Post has attachment
+Matt Knoll using Apps Script and the Gmail API together to make something creative.

Post has shared content
The Classroom API now provides even more control over coursework and submissions.
Hundreds of education developers use the Classroom API to integrate their applications with Google Classroom. Today, we’re making the coursework endpoints more robust, with additional management capabilities. Applications can now: create and update questions, modify and delete coursework , add Drive items and YouTube videos to coursework and student submissions,

For more details on what you can build with coursework, check out today’s announcement (https://goo.gl/4yczXH), review the documentation, the FAQ, and ask questions on Stack Overflow using the “google-classroom” tag. As always, let us know what you’re building using the #withClassroom hashtag on Twitter or G+. We look forward to working together to make it even easier for teachers and students to use the tools they love with Classroom.


Post has shared content
Formatting text with the Google Slides API

One of the best practices for creating great slide decks is to minimize the amount of text. It means that if you do have text in a presentation, the (few) words that you do use must have higher impact and be visually appealing. This is even more true when the slides are generated by a software application rather than being crafted by hand, for example, when using the recently-launched (http://goo.gl/o6EFwk) Google Slides API.

In this DevByte video, Google engineer +wesley chun shows developers how to format text using the Slides API. The sample app in the video creates a slide with several text paragraphs then uses the API to format that text in a variety of ways. If you want to dig into the code, check out the deep dive post (http://goo.gl/YwUilm)

Find out more at https://goo.gl/zkbilV

#SlidesAPI #GSuite #GoogleSlides #SheetsAPI
Wait while more posts are being loaded