Formatting cells with the Google Sheets API (The G Suite Dev Show)

Formatting cells with the Google Sheets API (The G Suite Dev Show)

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 G Suite 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

Original owner: Google Developers

Beto Garcia

Telecom consultant & sales engineer, Blogger contributor @Cisco & @TiTiApps. Mobile Apps business initiator. Experienced Engineer with more than 10 years on Service Providers Networks.

More Posts

Follow Me:
TwitterLinkedIn

Comment this article