Formatting cells with the Google Sheets API

Опубликовано 16 ноября 2016, 18:24

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 Google Workspace Dev Show: goo.gl/lmuovb
Subscribe to the Google Developers Channel for new episodes of the G Suite Dev Show: goo.gl/mQyv5L

#GoogleWorkspaceDevShow