G Suite Developers Blog

Introducing the Data Studio Community Connector Codelab

May 31, 2018

Cross-posted from the Google Developer blog Posted by Minhaz Kazi, Developer Advocate, Google Data Studio

Data StudioCommunity ConnectorsData Studio Community Connector Codelab Use the Community Connector Codelab Community Connector Codelab Why create your own Community Connector

If you provide a web based service to customers, you can create template dashboards or even let your users create their own visualization based on the users’ data from your service.

Within an enterprise, you can create serverless and highly scalable reporting solutions where you have complete control over your data and sharing features.

You can create an aggregate view of all your metrics across different commercial platforms and service providers while providing drill down capabilities.

You can create connectors to public and open datasets. Sharing these connectors will enable other users to quickly gain access to these datasets and dive into analysis directly without writing any code.

Stack Overflow

GitHub

Twitter

Community Connector galleryPartner ConnectorsCommunity Connector documentationsample code on the Data Studio open source repository

Make progress (bars) in presentations with Slides Add-ons

March 5, 2018

Posted by Wesley Chun (@wescpy), Developer Advocate and Grant Timmerman, Developer Programs Engineer, G Suiterecently introducedHere are examplesadd functionalityGmailG Suite Dev ShowGoogle Apps ScriptcreateBars()var BAR_ID = 'PROGRESS_BAR_ID'; var BAR_HEIGHT = 10; // px var presentation = SlidesApp.getActivePresentation(); function createBars() { var slides = presentation.getSlides(); deleteBars(); for (var i = 0; i < slides.length; ++i) { var ratioComplete = (i / (slides.length - 1)); var x = 0; var y = presentation.getPageHeight() - BAR_HEIGHT; var barWidth = presentation.getPageWidth() * ratioComplete; if (barWidth > 0) { var bar = slides[i].insertShape(SlidesApp.ShapeType.RECTANGLE, x, y, barWidth, BAR_HEIGHT); bar.getBorder().setTransparent(); bar.setLinkUrl(BAR_ID); } } }the Google Slides Add-on Quickstarthere’s another examplevideo libraryherethis page

Develop bot integrations with the Hangouts Chat platform and API

February 28, 2018

Posted by Mike Sorvillo, Product Manager, Hangouts Chat and Wesley Chun (@wescpy), Developer Advocate, G Suitewe announcedG SuiteHangouts Chat,Hangouts Chat developer platform and APIbots

Create a bot that can complete simple tasks or query for information

Create a bot that can post asynchronous notifications in any room or DM

Use interactive UI cards to bring your message responses to life

Use Google Apps Script to create custom bots for your colleagues or organization

look it upGoogle Maps APIthis page

onMessage() openLinkfunction onMessage(e) { var bot = e.message.annotations[0].userMention.user.displayName; var loc = encodeURI(e.message.text.substring(bot.length+2)); var mapClick = { "openLink": { "url": "https://google.com/maps/search/?api=1&query=" + loc } }; return { // see JSON payload in the documentation link above }; }cardthis is the entire botsynchronousasynchronousLearn more

Google Apps Script (JavaScript)

Google Cloud Functions (JavaScript)

Google App Engine (Python, Java, PHP, Go, and more)

Google Compute Engine (your language, your stack, your instance)

Other public or private cloud

Hangouts Chat platform and API

Introducing the Gmail Developer Preview of AMP in Email

February 13, 2018

Posted by Raymond Wainman, Software Engineer, Gmail
Accelerated Mobile Pages

Design interactive components for email using a large library of supported AMP components like amp-carousel, amp-form, amp-bind, amp-list and more

Help your content stay up-to-date and interactive for your users.

Create more engaging and actionable email experiences

Browse and save your favorite items on Pinterest

<!doctype html> <html ⚡4email> <head> <meta charset="utf-8"> <script async src="https://cdn.ampproject.org/v0.js">&lt'/script>  <style amp4email-boilerplate>body{visibility:hidden}</style> <script async custom-element="amp-carousel" src="https://cdn.ampproject.org/v0/amp-carousel-0.1.js"></script> <script async custom-element="amp-selector" src="https://cdn.ampproject.org/v0/amp-selector-0.1.js"></script> <script async custom-element="amp-bind" src="https://cdn.ampproject.org/v0/amp-bind-0.1.js"></script> <script async custom-element="amp-form" src="https://cdn.ampproject.org/v0/amp-form-0.1.js"></script> <script async custom-template="amp-mustache" src="https://cdn.ampproject.org/v0/amp-mustache-0.1.js"></script> <style amp-custom> html{font-family: 'Roboto';} ... </style> </head> <body> <h2>Hello dear user,</h2> <div class="photo-gallery"> <div class="text">Photos from your latest trips: <span [text]="+selectedSlide + 1">1</span>/4</div> <amp-selector layout="container" name="carousel-selector"...> <amp-carousel controls width="430" height="80"> <amp-img ...></amp-img> ... </amp-carousel> </amp-selector> <amp-carousel ...> <amp-img ...></amp-img> ... </amp-carousel> <div class="trip-location">Please rate your trip location:</div> <form id="rating" class="p2" method="post" ...> <fieldset class="rating"> <input name="rating" type="radio" id="rating1" value="1" .../> <label for="rating1" title="1 stars">★</label> ... </fieldset> <div submit-success> <template type="amp-mustache"> <div class="text">Thanks for rating {{rating}} star(s)!</div> </template> </div> </form> </div> </body> </html> [Full example in AmpByExample’s Playground]AMP for Email spechere

Publish Gmail Add-ons to your domain

January 25, 2018

Posted by Bikin Chiu, Software Engineer, Gmail
extended the Gmail Add-on previewbusiness appsdomain-wide

Publish Gmail Add-ons to users in your G Suite domain. This lets you build and deploy custom add-ons for workflows or processes that are unique to your company.

Install Gmail Add-ons for G Suite accounts before they’re published. This way, you can test your add-on before releasing widely in the workplace.

Plus, G Suite admins can install add-ons for their domains. This helps G Suite users perform domain-wide installs for any add-on you build, so more people have the chance to try your add-on (or experiment with add-ons domain-wide).

this videocodelabalready-built add-onsG Suite Marketplacesubmit your add-on idea

3 new tools to help improve your Apps Script development and management experience

January 11, 2018

Posted by Ted Bradley, Product Manager, G Suite Developer Platform, Paul McReynolds, Product Manager, G Suite Developer Platform and Grant Timmerman, Developer Programs Engineer, G Suite Developer Relationshostintegration with Stackdriver

Apps Script dashboard, to help you manage, debug and monitor all of your projects in one place.

Apps Script API, so you can programmatically manage Apps Script source files, versions and deployments.

Apps Script Command Line Interface, for easy access to Apps Script API functionality from your terminal and shell scripts.

Apps Script dashboard

script.google.com

View and search all of your projects.

Monitor the health and usage of projects you care about.

View details about individual projects.

View a log of project executions and terminate long-running executions.

documentationfile a bug Apps Script API Execution APIApps Script API

Create, read, update and delete script projects, source files and versions.

Manage project deployments and entry points (web app, add-on, execution).

Obtain project execution metrics and process data.

Run script functions.

documentationStack Overflowfile a bug Apps Script Command Line Interface claspCLASPclaspopen-source project on GitHub

clasp claspclasp codelabclasp project GitHub page

Hangouts Meet now available in the Google Calendar API

December 13, 2017

Posted by Ernesta Orlovaitė, Product Manager, Google Calendar API and Wesley Chun (@wescpy), Developer Advocate, G SuiteGoogle Calendar APIGoogle CalendarWe introducedG Suite EnterpriseGoogle Calendar API

Read conference data associated with events

Copy conference data from one event to another

Request new conference generation for an event

Reading conference data eventconferenceDataconferenceData"conferenceData": { "entryPoints": [ { "entryPointType": "video", "uri": "https://meet.google.com/wix-pvpt-njj", "label": "meet.google.com/wix-pvpt-njj" }, { "entryPointType": "more", "uri": "https://tel.meet/wix-pvpt-njj?pin=1701789652855", "pin": "1701789652855" }, { "entryPointType": "phone", "uri": "tel:+44-20-3873-7654", "label": "+44 20 3873 7654", "pin": "6054226" } ], "conferenceSolution": { "key": { "type": "hangoutsMeet" }, "name": "Hangouts Meet", "iconUri": "https://blogger.googleusercontent.com/img/proxy/AVvXsEiaSY9_YfMdiWryFlVhzIs3jdKPPiVuvOTO4I2Roz_qnNGdmlz30rPKsRQpH_zL9sBemoQxmsA-Djl4q_jhz1-as83Gq-49NjORxptsEGxLEp4stip8yhdVitDBWRjGoECBYqs7fbAaINxFem2mwR8pCQXsn1dvNRegYieao0vH5kxDUWsI20mcOka_r5ha_zusG4YlXHa2mzRjZOc=" }, "conferenceId": "wix-pvpt-njj", "signature": "ADwwud9tLfjGQPpT7bdP8f3bq3DS" }var solution = event.conferenceData.conferenceSolution; var content = document.getElementById("content"); var text = document.createTextNode("Join " + solution.name); var icon = document.createElement("img"); icon.src = solution.iconUri; content.appendChild(icon); content.appendChild(text);

Copying conferences across events Creating a new conference for an event var eventPatch = { conferenceData: { createRequest: {requestId: "7qxalsvy0e"} } }; gapi.client.calendar.events.patch({ calendarId: "primary", eventId: "7cbh8rpc10lrc0ckih9tafss99", resource: eventPatch, sendNotifications: true, conferenceDataVersion: 1 }).execute(function(event) { console.log("Conference created for event: %s", event.htmlLink); });"conferenceData": { "createRequest": { "requestId": "7qxalsvy0e", "conferenceSolutionKey": { "type": "hangoutsMeet" }, "status": { "statusCode": "pending" } } }statusCodeallowedConferenceSolutionTypescalendarconferencePropertiesdocumentation page

Hello dear user,