Join to Start This Lab

Free

01:30:00

Google Sheets as a Reporting Tool - Sheets API

GSP236

Google Cloud Self-Paced Labs

Overview

In this lab, you will learn how to use Google Sheets as a custom reporting tool for your users. You will modify an order tracking application to export database records to a spreadsheet and also build data visualizations with the Google Sheets API. You will build the sample application using Node.js and the Express web framework, but the same basic principles are applicable to any architecture.

Join Qwiklabs to read the rest of this lab...and more!

Get temporary access to the Google Cloud Console.
Over 200 labs from beginner to advanced levels.
Bite-sized so you can learn at your own pace.

Join to Start This Lab

GSP236 Overview What You'll Learn Prerequisites Setup and Requirements Get the Sample Code Enable the Sheets API Run the Sample App Create a Client ID Add Google Sign-in Add Spreadsheet Controls Creating Spreadsheets Add Header Row Sync Data to the Spreadsheet Add a Pivot Table and Chart Congratulations!

Welcome to Your First Lab!