G Suite Developers Blog: tutorials

G Suite Developers Blog

Information for G Suite Developers

Formatting cells with the Google Sheets API

November 16, 2016

Posted 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!

Google

Labels: API , APIs , Apps , Developers , G Suite , Google , Google Apps , Google sheets , Google Sheets API , GSuite , python , Sheets API , spreadsheets , tools , tutorials , video

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

June 15, 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!

Google

Labels: API , APIs , Developers , Google , Google sheets , Google Spreadsheets API , python , Sheets API , tool , tools , tutorials , video , videos

Free Trial

Labels

.NET 3
#io15 1
#io16 1
Admin SDK 10
Administrative APIs 31
AdSense 1
analytics 5
Android 8
API 3
APIs 3
App Engine 5
Apps 1
Apps Script 118
Audit 2
Auth 5
billing 4
Charts 2
Chrome OS 1
classroom 3
Cloud Storage API 1
Community 1
decks 1
Design 1
Developers 12
Directory API 3
Drive 4
Drive SDK 41
execution API 2
Firebase 1
Forms 1
Freemium 1
Fusion Tables 2
G Suite 24
Gadgets 5
Gmail 7
Gmail APIs 23
Google 3
Google APIs 36
Google Apps 33
Google Apps Marketplace 7
Google Calendar API 25
Google Classroom 4
Google Cloud Directory 1
Google Contacts API 4
Google Data Protocol 8
google docs 5
Google Docs API 22
Google Drive 8
Google Drive SDK 7
Google Forms 8
Google I/O 3
Google Prediction API 3
Google Profiles API 2
Google sheets 11
Google Sheets API 7
Google Sites API 5
Google Slides API 10
Google Spreadsheets API 5
Google Talk 1
Google Tasks API 8
Google+ 3
googlenew 1
Groups 2
GSuite 3
Guest Post 43
Hangouts Chat API 1
I 1
Inbox 1
iOS 2
issue tracker 1
ISVs 2
java 1
JavaScript 6
marketing 3
Marketplace 47
Marketplace ISV Guest 21
Migration 2
Mobile 5
mpstaffpick 1
oauth 16
OpenID 8
PHP 1
presentations 1
python 7
realtime API 2
Resellers 2
Ruby 1
SaaS 1
security 5
Sheets API 3
spreadsheets 3
Staff Picks 2
tool 1
tools 2
tutorials 2
video 4
videos 1
webinar 2

Feed

Googleon

Company-wide

Official Google Blog
Public Policy Blog
Student Blog

Products

Android Blog
Chrome Blog
Lat Long Blog

Developers

Developers Blog
Ads Developer Blog
Android Developers Blog

Google
Privacy
Terms