Formatting cells with the Google Sheets API

Channel:
United States Google for Developers
Subscribers:
2,510,000
Published on ● Video Link: https://www.youtube.com/watch?v=86q5TMzvRqo


Category:
Guide
Duration: 8:32
77,922 views
343

The latest versions of the Google Sheets API let developers do something they weren’t able to do before: format spreadsheets cells. This new feature uses requests to effect the changes desired, and in this video, Google engineer Wesley Chun demonstrates how to put together the correct JSON payloads forming those requests. By the end of the video, you will have learned how to create a variety of formatting commands and send them to the API to help enhance your applications!

Related links for this episode:
Google Sheets API concepts & guides: https://goo.gl/MYJnoc
Formatting & other sample JSON payloads: https://goo.gl/S9gwJF
Date, time, and number formatting guide: https://goo.gl/MbMQ1N
Deeper dive of code used in this video: https://goo.gl/LiY8AB
Migrating SQL data to Google Sheets blogpost & video: https://goo.gl/meB9GI
Sheets API GridRange documentation page: https://goo.gl/GAr8Vl
Sheets API formatting field masks: https://goo.gl/gFws5F
General information on field masks: https://goo.gl/8vjgOU
Common operations & API sample usage: https://goo.gl/EYKhq9
Google Sheets API Node.js codelab: build a customized reporting tool: https://goo.gl/Bnxigy
Formatting examples from the Sheets API codelab: https://goo.gl/AnfeVs
“Setting up new Google API projects” video: https://goo.gl/grggHA
Google APIs Client Libraries: https://goo.gl/hwVkpx
“Common Python code walkthrough” video: https://goo.gl/1KFUif
Google Sheets API v4 launch announcement: https://goo.gl/KZPJby
Google Sheets API Python Quickstart: https://goo.gl/8utPJV

Watch more videos from The Google Workspace Dev Show: https://goo.gl/lmuovb
Subscribe to the Google Developers Channel for new episodes of the G Suite Dev Show: http://goo.gl/mQyv5L

#GoogleWorkspaceDevShow



Other Videos By Google for Developers


2016-12-072016 Google Developer Day - Beijing
2016-12-072016 Google Developer Day - Beijing (CN)
2016-12-07Modifying email signatures with the Gmail API
2016-12-06Orchestrate Google Maps
2016-12-02The Developer Show (TL;DR 050)
2016-12-02An update on Augmented Reality in Project Tango -- Coffee with Justin Quimby
2016-11-30Generating slides from spreadsheet data
2016-11-23The Developer Show (TL;DR 049)
2016-11-22Integrate Google Maps
2016-11-21Firebase in a Weekend: Coffee with Shanea King-Roberson
2016-11-16Formatting cells with the Google Sheets API
2016-11-15A.I. Experiments: A.I. Duet
2016-11-15A.I. Experiments: The Infinite Drum Machine
2016-11-15A.I. Experiments: Visualizing High-Dimensional Space
2016-11-15A.I. Experiments: Quick, Draw!
2016-11-15A.I. Experiments: Thing Translator
2016-11-15A.I. Experiments: Giorgio Cam
2016-11-15A.I. Experiments: Making it easier for anyone to explore A.I.
2016-11-15A.I. Experiments: Bird Sounds
2016-11-11The Developer Show (TL;DR 048)
2016-11-09The Developer Show (Google Cloud Platform Podcast: Google Cloud ML)


Tags:
Google
developers
Google Sheets
JavaScript
Python
Sheets
spreadsheets
Google Apps
Apps
API
APIs
JSON
cell
cells
format
formatting
validation
currency
currencies
video
videos
tool
tools
tutorials
web
desktop
mobile
developer
series
Google Developers
Wesley Chun
JS
Google APIs
Google APIs Client Library
Client Library
fullname: Wesley Chun
GDS: full production
location: MTV
Team: scalable advocacy
product: apps
type: greenscreen