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:
Formatting & other sample JSON payloads:
Date, time, and number formatting guide:
Deeper dive of code used in this video:
Migrating SQL data to Google Sheets blogpost & video:
Sheets API GridRange documentation page:
Sheets API formatting field masks:
General information on field masks:
Common operations & API sample usage:
Google Sheets API Node.js codelab: build a customized reporting tool:
Formatting examples from the Sheets API codelab:
“Setting up new Google API projects” video:
Google APIs Client Libraries:
“Common Python code walkthrough” video:
Google Sheets API v4 launch announcement:
Google Sheets API Python Quickstart:
Watch more videos from The G Suite Dev Show:
Subscribe to the Google Developers Channel for new episodes of the G Suite Dev Show: