Published on November 16, 2016 by Google

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: goo.gl/MYJnoc

Formatting & other sample JSON payloads: goo.gl/S9gwJF

Date, time, and number formatting guide: goo.gl/MbMQ1N

Deeper dive of code used in this video: goo.gl/LiY8AB

Migrating SQL data to Google Sheets blogpost & video: goo.gl/meB9GI

Sheets API GridRange documentation page: goo.gl/GAr8Vl

Sheets API formatting field masks: goo.gl/gFws5F

General information on field masks: goo.gl/8vjgOU

Common operations & API sample usage: goo.gl/EYKhq9

Google Sheets API Node.js codelab: build a customized reporting tool: goo.gl/Bnxigy

Formatting examples from the Sheets API codelab: goo.gl/AnfeVs

“Setting up new Google API projects” video: goo.gl/grggHA

Google APIs Client Libraries: goo.gl/hwVkpx

“Common Python code walkthrough” video: goo.gl/1KFUif

Google Sheets API v4 launch announcement: goo.gl/KZPJby

Google Sheets API Python Quickstart: goo.gl/8utPJV

Watch more videos from The G Suite Dev Show: goo.gl/lmuovb

Subscribe to the Google Developers Channel for new episodes of the G Suite Dev Show: goo.gl/mQyv5L

Leave a Reply

5 Comments on "Formatting cells with the Google Sheets API (The G Suite Dev Show)"

Notify of
avatar

variancytphul
Guest
variancytphul
20 days 6 hours ago

I have done some fairly heavy sheets/survey api programming however considering I had no idea how to when I first started. I would love to see some of this use. Or some cross-interaction sheets! Stack exchange only goes so far.

Robert Shaver
Guest
Robert Shaver
20 days 8 hours ago

Creating spreadsheets with formulas IS programming. When they get complex you run into the same kind of issues any other software program can have. AND you should test your spreadsheet to make sure it works correctly.

MR Start
Guest
MR Start
20 days 9 hours ago

use excel and get rid of programing

Joyce Garza
Guest
Joyce Garza
15 days 4 hours ago

MR Start

asdfasdfasdf
Guest
asdfasdfasdf
20 days 15 hours ago

first

wpDiscuz