Google Developers Blog: apis

Formatting cells with the Google Sheets API

Wednesday, November 16, 2016

Originally posted on G Suite Developers BlogPosted by Wesley Chun (@wescpy), Developer Advocate, G Suitelaunched a new Google Sheets APIhereprevious Sheets API video Formatting spreadsheets is accomplished by creating a set of request commands in the form of JSON payloads, and sending them to the API. Here is a sample JavaScript Object made up of an array of requests (only one this time) to bold the first row of the default Sheet automatically created for you (whose ID is 0): {"requests": [ {"repeatCell": { "range": { "sheetId": 0, "startRowIndex": 0, "endRowIndex": 1 }, "cell": { "userEnteredFormat": { "textFormat": { "bold": true } } }, "fields": "userEnteredFormat.textFormat.bold" }} ]} requestsSHEET_IDhttps://sheets.googleapis.com/v4/spreadsheets/{SHEET_ID}:batchUpdateSHEETS.spreadsheets().batchUpdate(spreadsheetId=SHEET_ID, body=requests).execute() For more details on the code in the video, check out the deepdive blog post. As you can probably guess, the key challenge is in constructing the JSON payload to send to API calls—the common operations samples can really help you with this. You can also check out our JavaScript codelab where we guide you through writing a Node.js app that manages customer orders for a toy company, featuring the toy orders data we looked at today but in a relational database. While the resulting equivalent Sheet is featured prominently in today's video, we will revisit it again in an upcoming episode showing you how to generate slides with spreadsheet data using the new Google Slides API, so stay tuned for that! We hope all these resources help developers enhance their next app using G Suite APIs! Please subscribe to our channel and tell us what topics you would like to see in other episodes of the G Suite Dev Show!

Introducing the Google Sheets API v4: Transferring data from a SQL database to a Sheet

Thursday, June 16, 2016

Posted by Wesley Chun (@wescpy), Developer Advocate, Google Apps

At Google I/O 2016, we launched a new Google Sheets API—click here to watch the entire announcement. The updated API includes many new features that weren’t available in previous versions, including access to functionality found in the Sheets desktop and mobile user interfaces. My latest DevByte video shows developers how to get data into and out of a Google Sheet programmatically, walking through a simple script that reads rows out of a relational database and transferring the data to a brand new Google Sheet.Let’s take a sneak peek of the code covered in the video. Assuming that SHEETS has been established as the API service endpoint, SHEET_ID is the ID of the Sheet to write to, and data is an array with all the database rows, this is the only call developers need to make to write that raw data into the Sheet:SHEETS.spreadsheets().values().update(spreadsheetId=SHEET_ID, range='A1', body=data, valueInputOption='RAW').execute()SHEETSSHEET_IDrows = SHEETS.spreadsheets().values().get(spreadsheetId=SHEET_ID, range='Sheet1').execute().get('values', []) for row in rows: print(row) If you’re ready to get started, take a look at the Python or other quickstarts in a variety of languages before checking out the DevByte. If you want a deeper dive into the code covered in the video, check out the post at my Python blog. Once you get going with the API, one of the challenges developers face is in constructing the JSON payload to send in API calls—the common operations samples can really help you with this. Finally, if you’re ready to get going with a meatier example, check out our JavaScript codelab where you’ll write a sample Node.js app that manages customer orders for a toy company, the database of which is used in this DevByte, preparing you for the codelab. We hope all these resources help developers create amazing applications and awesome tools with the new Google Sheets API! Please subscribe to our channel, give us your feedback below, and tell us what topics you would like to see in future episodes!

Introducing the Google API Console

Thursday, March 24, 2016

Posted by Israel Shalom, Product ManagerEvery day, hundreds of thousands of developers send millions of requests to Google APIs, from Maps to YouTube. Thousands of developers visit the console for credentials, quota, and more -- and we want to give them a better and more streamlined experience.Starting today, we’ll gradually roll out the API Console at console.developers.google.com focusing entirely on your Google API experience. There, you’ll find a significantly cleaner, simpler interface: instead of 20+ sections in the navigation bar, you’ll see API Manager, Billing and Permissions only:

Figure 1: API Console home page

Figure 2: Navigation section for API Consoleconsole.cloud.google.com will remain unchanged. It’ll point to Cloud console, which includes the entire suite of Google Cloud Platform services, just like before. And while the two are different destinations, your underlying resources remain the same: projects created on Cloud Console will still be accessible on API Console, and vice versa.The purpose of the new API Console is to let you complete common API-related tasks quickly. For instance, we know that once you enable an API in a new project, the next step is usually to create credentials. That’s why we’ve built the credentials wizard: a quick and convenient way for you to figure out what kind of credentials you need, and add them right after enabling an API:

Figure 3: After enabling an API, you’re prompted to go to Credentials

Figure 4: Credentials wizardOver time, we will continue to tailor the API Console experience for the many developers out there who use Google’s APIs. So if you’re one of these users, we encourage you to try out API Console and use the feedback button to let us know what you think!

Run Apps Script code from anywhere using the Execution API

Friday, September 25, 2015

Originally posted to the Google Apps Developer blogPosted by Edward Jones, Software Engineer, Google Apps Script and Wesley Chun, Developer Advocate, Google AppsHave you ever wanted a server API that modifies cells in a Google Sheet, to execute a Google Apps Script app from outside of Google Apps, or a way to use Apps Script as an API platform? Today, we’re excited to announce you can do all that and more with the Google Apps Script Execution API.The Execution API allows developers to execute scripts from any client (browser, server, mobile, or any device). You provide the authorization, and the Execution API will run your script. If you’re new to Apps Script, it’s simply JavaScript code hosted in the cloud that can access authorized Google Apps data using the same technology that powers add-ons. The Execution API extends the ability to execute Apps Script code and unlocks the power of Docs, Sheets, Forms, and other supported services for developers.One of our launch partners, Pear Deck, used the new API to create an interactive presentation tool that connects students to teachers by converting slide decks into interactive experiences. Their app calls the Execution API to automatically generate a Google Doc customized for each student, so everyone gets a personalized set of notes from the presentation. Without the use of Apps Script, their app would be limited to using PDFs and other static file types. Check out the video below to see how it works.Bruce McPherson, a Google Developer Expert (GDE) for Google Apps, says: “The Execution API is a great tool for enabling what I call ‘incremental transition’ from Microsoft Office (and VBA) to Apps (and Apps Script). A mature Office workflow may involve a number of processes currently orchestrated by VBA, with data in various formats and locations. It can be a challenge to move an entire workload in one step, especially an automated process with many moving parts. This new capability enables the migration of data and process in manageable chunks.” You can find some of Bruce’s sample migration code using the Execution API here.The Google Apps Script Execution API is live and ready for you to use today. To get started, check out the developer documentation and quickstarts. We invite you to show us what you build with the Execution API!

Improving the Google Calendar API

Wednesday, March 19, 2014

By Lucia Fedorova, Google Calendar API TeamChoose your own event IDsbase32hexSet up notifications for changes in your calendar

EventsCalendarListLucia Fedorova is a Tech Lead of the Google Calendar API team. The team focuses on providing great experience to Google Calendar developers and enabling new and exciting integrations.Posted by Louis Gray, Googler

GA Release for Google APIs Client Library for .NET

Monday, March 17, 2014

By Dan Ciruli, Google Cloud Platform TeamNuGetOAuth 2.0uploadsdownloadsbatchingfifty Google APIsGetting StartedhereDan Ciruli is a Product Manager in the Cloud Platform Team intent on making developers' lives easier.Posted by Louis Gray, Googler

Changes to “all-following” behavior in Google Calendar

Thursday, December 5, 2013

By Gregory Yakushev, Software EngineerGrisha Yakushev ensures Calendar servers keep your data consistent and safe. He enjoys travelling the world, preferably by hitchhiking.Posted by Scott Knaster, Editor

Civic Information API: now connecting US users with their representatives

Tuesday, November 19, 2013

By Jonathan Tomer, Software EngineerCross-posted from the Google Politics & Elections BlogGoogle Civic Information APIcreate apps for US electionsOpen Civic Data Identifiershistorical election resultsOpen Electionshead over to the documentation"Map Your Reps"

Change.org has implemented a new Decision Makers feature which allows users to direct a petition to their elected representative and lists that petition publicly on the representative's profile page. As a result, the leader has better insight into the issues being discussed in their district, and a new channel to respond to constituents.

PopVox helps users share their opinions on bills with their Congressional Representatives in a meaningful format. PopVox uses the API to connect the user to the correct Congressional District. Because PopVox verifies that users are real constituents, the opinions shared with elected officials have more impact on the political process.

Developer ForumJonathan Klabunde Tomer is a software engineer in Google's Washington, DC office. He enjoys bicycling, good food, good wine, and open data.Posted by Scott Knaster, Editor

A new look for managing your APIs

Tuesday, October 29, 2013

By Akshay Kannan, Product Manager, Google Cloud Platformlaunched the Google APIs Console

Akshay Kannan is a Product Manager on the Google Cloud Console team. His focus is on providing an integrated, beautiful developer experience for all Google Developers.Posted by Scott Knaster, Editor

New AdSense data in the Analytics Core Reporting API

Monday, October 28, 2013

By Nick Mihailovksi, Product Manager, Google Analytics API TeamCross-posted from the Google Analytics BlogGoogle AdSense is a free, simple way for website publishers to earn money by displaying targeted Google ads on their websites. Today, we’ve added the ability to access AdSense data from the Google Analytics Core Reporting API. The AdSense and Analytics integration allows publishers to gain richer data and insights, leading to better optimized ad space and a higher return on investment.
In the past, accessing AdSense data using the Analytics Core Reporting API has been a top feature request. We’ve now added 8 new AdSense metrics to the Analytics Core Reporting API, enabling publishers to streamline their analysis.

Answering Business Questions
You can now answer the following business questions using these API queries:

Which pages on your site contribute most to your AdSense revenue?

dimensions=ga:pagePath

&metrics=ga:adsenseCTR,ga:adsenseRevenue,ga:adsenseECPM &sort=-ga:adsenseRevenue

Test in query explorer

Which pages generate a high number of pageviews but aren't monetizing as well as other pages?

dimensions=ga:pagePath

&metrics=ga:pageviews,ga:adsenseCTR

&sort=-ga:pageviews

Test in query explorer

Which traffic sources contribute to your revenue?

dimensions=ga:sourceMedium

&metrics=ga:adsenseCTR,ga:adsenseRevenue,ga:adsenseECPM

&sort=-ga:adsenseRevenue

Test in query explorer

Reporting Automation

By accessing this data through the API, you can now automate reporting and spend more time doing analysis. You can also use the API to integrate data from multiple sites into a single dashboard, build corporate dashboards to share across the team, and use the API to integrate data into CRM tools that display AdSense Ads.

Getting Started

To learn more about the new AdSense data, take a look at our Google Analytics Dimensions and Metrics Explorer. You can also test the API with your data by building queries in the Google Analytics Query Explorer.

Busy? In that case, now’s a great time to try these Analytics API productivity tools:

Magic Script: A Google Spreadsheets script to automate importing Analytics data into Spreadsheets, allowing for easy data manipulation. No coding required!
Google Analytics superProxy: An App Engine application that reduces all the complexity of authorization.

We hope this new data will be useful, and we're looking forward to seeing what new reports developers build.

Nick Mihailovski oversees the Google Analytics APIs. In his spare time, he likes to travel around the world.Posted by Scott Knaster, Editor

New Analytics APIs for large companies

Thursday, October 3, 2013

By Nick Mihailovski, Product Manager, Google Analytics

Many large companies have unique needs, with dozens of websites and many users. In the past, configuring Google Analytics for these companies was time-consuming and required too many clicks.

We're thrilled to announce a new set of APIs that will make it even easier for large companies to manage multiple websites. These APIs will streamline the Google Analytics setup process, allowing IT teams to programmatically manage and configure Google Analytics, so teams can focus their efforts on analysis and gaining insights.

Account Setup and Configuration APIs

To simplify account setup, we’ve added new APIs to manage Properties, Profiles, and Goals. This reduces the time it takes to build new account structures, and allows you to enable new features across all your existing accounts.

Note: These APIs are currently available in closed beta. Please sign up here to request access.

User Permissions APIs

To reduce the overhead in managing user access, we’ve also added APIs to manage user permissions across all your accounts. With these APIs, you can quickly list which users have access to your accounts. You can also now write programs to sync Google Analytics users with corporate directory services such as LDAP.

The User Permissions APIs are public and can be used today.

Getting Started

To get started, you can find all the API resources on our Google Analytics APIs for Large Companies page. This launch brings new opportunities to developers, IT Teams, and Google Analytics users. Let us know what you think!

Nick Mihailovski oversees the Google Analytics APIs. In his spare time, he likes to travel around the world.Posted by Scott Knaster, Editor

Google+ iOS SDK 1.4.0: in-app share box and ID token support

Thursday, October 3, 2013

By Ranjith Jayaram, Product Manager, Google+ iOS PlatformCross-posted with the Google+ Developers BlogGoogle+ iOS SDK

In-app share box. Now your users can share with their Google+ circles, directly from your iOS app! In addition, the native in-app share box supports image and video attachments. If you've already implemented browser-based sharing, you can switch to the native in-app share box with a single line change:

[[GPPShare sharedInstance] shareDialog] [[GPPShare sharedInstance] nativeShareDialog]

The native iOS in-app share box
ID token support.Google+ Developers site.Ranjith Jayaram is a Product Manager on the Google+ Platform team. While he's not working, he enjoys reading and occasionally writing fiction.Posted by +Scott Knaster, Editor

Google APIs Console picks up the Picker API

Friday, September 6, 2013

By Kuntal Loya, Software EngineerAPIs Consoleregister<script type="text/javascript"> // The API developer key obtained from the Google APIs Console. var developerKey = 'ABC123 ... '; // Use the API Loader script to load google.picker. function loadPicker() { gapi.load('picker', {'callback': createPicker}); } // Create and render a Picker object for searching images. function createPicker() { var picker = new google.picker.PickerBuilder(). addView(google.picker.ViewId.IMAGE_SEARCH). setDeveloperKey(developerKey). setCallback(pickerCallback). build(); picker.setVisible(true); } </script> <script type="text/javascript" src="https://apis.google.com/js/api.js?onload=loadPicker"> </script> Developer’s GuideKuntal Loya has been making the Google Picker smarter while enjoying Bangalore’s weather and the food at the Google Café. Meanwhile, she’s nearing the end of Mahasamar, Narendra Kohli’s 8-volume re-telling of the Mahabharata.Posted by Scott Knaster, Editor

Introducing the new Google Analytics Metadata API

Wednesday, August 21, 2013

By Nick Mihailovski, Google Analytics API teamCross-posted from the Google Analytics BlogGoogle Analytics users can use the Core Reporting API to save time by building dashboards and automating complex reporting tasks. This API exposes over 250 data points (dimensions and metrics), and new data is added every few months. For many developers, it can be difficult to keep their applications up to date with all the latest data.To make things easier, today we are launching the new Google Analytics Metadata API to simplify data discovery. The Metadata API contains all the queryable dimensions and metrics included in the Core Reporting API. We’ve also added attributes for each dimension and metric, such as the web or app name, full text description, grouping, metric calculations, deprecation status, and whether the data is queryable in segments. You can check out at a live Metadata API response here.You now have programmatic access to generate the same list of dimensions and metrics we use to generate our public documentation.

You can now create this list using the Metadata API. Saving developers timeWhen you create tools to query the Core Reporting API, you can use the Metadata API to automatically update your user interfaces. For example, Analytics Canvas, a popular third-party Google Analytics data extraction tool, uses the Metadata API to keep its query building interface up to date.

Analytics Canvas uses the Metadata API to power its query builder.According to James Standen, founder of Analytics Canvas, "In the past, keeping Analytics Canvas up to date with the Google Analytics API dimensions and metrics required a lot of manual updating to our application. The new Metadata API automates this process, saving us time, and giving our users direct access to all the great new data the instant it's available. Users love it!"New deprecation policyTo increase data transparency, we’ve also published a new data deprecation policy for dimensions and metrics. New data we release will be announced on our changelogs and automatically added to the Metadata API. Data we decide to remove will be marked as deprecated in the Metadata API, allowing developers to gracefully remove these values from their tools.Get started todayOur goal was to make this API super easy to use. To get started, take a look at our resources:

Read the Metadata API Reference guide to learn how to use the API data in your application.

Read the Metadata API Developer guide to learn how the API can be used to solve common use cases.

Join us for our Google Developers Live show on the Metadata API, Thursday August 29th at 10am PDT / 5pm UTC.

Questions? Comments? Simply want to share in the excitement? Join the analytics developer community in our Reporting API Developer forum.Nick Mihailovski oversees the Google Analytics APIs. In his spare time, he likes to travel around the world.Posted by Scott Knaster, Editor

Google Calendar API Push notifications: don’t call us, we’ll call you

Wednesday, July 24, 2013

By Piotr Stanczyk, Tech Lead, Google Calendar APIsGoogle API client librariesmy_calendar@my-host.commy-host.comhttps://my-host.com/notificationMap<String, String> params = new HashMap<String, String>(); Channel request = new Channel() .setId("unique_subscription_ID") .setType("web_hook") .setAddress(String.format("https://my-host.com/notification")) .setParams(params); service.events().watch("my_calendar@my-host.com", request).execute(); my_calendar@my-host.comhttps://my-host.com/notificationchanges = service.events().list("my_calendar@my-host.com") .setUpdatedMin(lastSynchonizationTime).execute(); Google API v3 documentation for PushPiotr Stanczyk is a Tech Lead for Google Calendar APIs. His current focus is to provide the next generation Calendar API which makes lives of developers easier.Posted by Scott Knaster, Editor

40 new data points in Google Analytics API

Tuesday, July 9, 2013

By Srinivasan Kannan, Google Analytics API TeamCross-posted from the Google Analytics BlogOver the past year we’ve added many new features to Google Analytics. Today we are releasing all of this data in the Core Reporting API.

Custom Dimensions and MetricsWe're most excited about the ability to query for custom dimensions and metrics using the API.Developers can use custom dimensions to send unique IDs into Google Analytics, and then use the core reporting API to retrieve these IDs along with other Google Analytics data.For example, your content management system can pass a content ID as a custom dimension using the Google Analytics tracking code. Developers can then use the API to get a list of the most popular content by ID and display the list of most popular content on their website.Mobile Dimensions and MetricsWe've added more mobile dimensions and metrics, including those found in the Mobile App Analytics reports:

ga:appId

ga:appVersion

ga:appName

ga:appInstallerId

ga:landingScreenName

ga:screenDepth

ga:screenName

ga:exitScreenName

ga:timeOnScreen

ga:avgScreenviewDuration

ga:deviceCategory

ga:isTablet

ga:mobileDeviceMarketingName

ga:exceptionDescription

ga:exceptionsPerScreenview

ga:fatalExceptionsPerScreenview

Some examples of questions this new data can answer are:

What is the behavior (e.g. avg time on site) of tablet vs. non-tablet visits?

Which versions of my app are getting the most usage?

Which screens are generating the most exceptions, and for which app version and OS combination?

Local Currency MetricsIf you are sending Google Analytics multiple currencies, you now have the ability to access the local currency of the transactions with this new data:

ga:currencyCode

ga:localItemRevenue

ga:localTransactionRevenue

ga:localTransactionShipping

ga:localTransactionTax

Time DimensionsWe added new time-based dimensions to simplify working with reporting data:

ga:dayOfWeekName

ga:dateHour

ga:isoWeek

ga:yearMonth

ga:yearWeek

Sample queries:

Visits by day of the week

Visits and pageviews by ISO week

Traffic Source DimensionsFinally, we've added two new traffic source dimensions, including one to return the full URL of the referral.

ga:fullReferrer

ga:sourceMedium

Sample query: the top 10 referrers based on visits (using full referrer).For a complete list of the new data, take a look at the Core Reporting API changelog.
For all the data definitions, check the Core Reporting API Dimensions and Metrics explorer.
As always, you can check out this new data directly within our Query Explorer tool.
Writen by Srinivasan Kannan, Google Analytics API TeamPosted by Scott Knaster, Editor

Making Google’s CalDAV and CardDAV APIs available for everyone

Wednesday, June 5, 2013

By Piotr Stanczyk, Tech LeadCalDAVkeeping the CalDAV API publicCardDAVavailable to everyone

Integration with the Google APIs Console. To start using CalDAV or CardDAV in your project, just enable it in the Console.

OAuth 2.0 authentication.

Piotr Stanczyk is the Tech Lead of the Google Calendar APIs group. His current focus is to provide next generation Calendar APIs which make developers’ lives easier. He also participates in CalConnect consortium.Posted by Scott Knaster, Editor

Find the hidden patterns with YouTube’s new Analytics API

Saturday, May 11, 2013

By Ted Hamilton, YouTube AnalyticsCross-posted from the YouTube API Blogone billion monthly usersnew YouTube Analytics APIviewengagementInsight Data API

Watch metrics: Track estimated minutes watched across channel, content owner, or video, and dive into the video details with average view time and average view percentage.

Earning performance metrics: Track estimated earnings (net revenue) from select advertising sources across your content.

Ad performance metrics: Break down video performance with monetized playbacks, ad impressions, gross revenue, and cost per impression reports.

Annotation metrics: Optimize overlays/annotations with click through and close rate metrics.

Client libraries and code samplesclient librariesAPI Explorercode examplesJavaScript exerciseApp examples

Next Big Sound provides analytics and insights for the music industry by tracking billions of social signals including YouTube. This enables record labels, artists, and band managers to make better decisions on everything from promotion strategies to tour locations.

vidIQ is an audience development suite that works with global brands to organically grow their views and subscribers. Their features include cross-platform social analytics, advanced comment management, SEO tools, social syndication and influencer identification.

Wizdeo’s WizTracker provides in-depth analysis of YouTube channels to help with cross promotion and video comparisons during their initial launch. Users get access to detailed analytics about views, subscriber engagement, traffic sources and demographics.

Vidyard is a video marketing platform. With powerful analytics, built-in marketing tools, and integration with key marketing automation platforms, Vidyard helps marketers drive results with video content.

FullscreenLearn moredocumentationplaylistYouTube for Developers channelYouTubeDevTed Hamilton is the Product Manager for YouTube Analytics based out of Zurich, Switzerland. Prior to Google, Ted was a consultant at Bain and Company in London. Ted has a Computer Science degree from Northwestern University and holds an MBA from MIT Sloan. Posted by Scott Knaster, Editor

Clarifying the deprecation policy for Google APIs and services

Friday, May 10, 2013

By Adam Feldman, APIs Product Managerlist

Adam Feldman is a Product Manager, focusing on all of Google's APIs and making sure Google provides the best possible platform to developers.Posted by Scott Knaster, Editor

Google API infrastructure outage incident report

Friday, May 3, 2013

By the Google API Infrastructure TeamAs we described in a previous post, earlier this week we experienced an outage in our API infrastructure. Today we’re providing an incident report that details the nature of the outage and our response.Issue SummaryTimeline (all times Pacific Time)

6:19 PM: Configuration push begins

6:26 PM: Outage begins

6:26 PM: Pagers alerted teams

6:54 PM: Failed configuration change rollback

7:15 PM: Successful configuration change rollback

7:19 PM: Server restarts begin

7:58 PM: 100% of traffic back online

Root CauseResolution and recoveryCorrective and Preventative Measures

Disable the current configuration release mechanism until safer measures are implemented. (Completed.)

Change rollback process to be quicker and more robust.

Fix the underlying authentication libraries and monitoring to correctly timeout/interrupt on errors.

Programmatically enforce staged rollouts of all configuration changes.

Improve process for auditing all high-risk configuration options.

Add a faster rollback mechanism and improve the traffic ramp-up process, so any future problems of this type can be corrected quickly.

Develop better mechanism for quickly delivering status notifications during incidents.

Posted by Scott Knaster, Editor

Jun	JUL	Aug
	05
2016	2017	2018

Blog

Formatting cells with the Google Sheets API

Introducing the Google Sheets API v4: Transferring data from a SQL database to a Sheet

Introducing the Google API Console

Run Apps Script code from anywhere using the Execution API

Improving the Google Calendar API

GA Release for Google APIs Client Library for .NET

Changes to “all-following” behavior in Google Calendar

Civic Information API: now connecting US users with their representatives

A new look for managing your APIs

New AdSense data in the Analytics Core Reporting API

New Analytics APIs for large companies

Google+ iOS SDK 1.4.0: in-app share box and ID token support

Google APIs Console picks up the Picker API

Introducing the new Google Analytics Metadata API

Google Calendar API Push notifications: don’t call us, we’ll call you

40 new data points in Google Analytics API

Making Google’s CalDAV and CardDAV APIs available for everyone

Find the hidden patterns with YouTube’s new Analytics API

Clarifying the deprecation policy for Google APIs and services

Google API infrastructure outage incident report

Labels

Archive

Company-wide

Products

Developers