Google Workspace

Basic Add-on you own this product

This project is part of the liveProject series Create AI-Powered Workspace Add-ons
prerequisites
basic Apps Script or JavaScript • basic understanding of how APIs work • Google Cloud Console basics • Google Sheets basics
skills learned
create a project in Cloud platform • deploy a Workspace add-on • implement Invoice Document AI processors • update spreadsheets
Bruce Mcpherson
1 week · 6-8 hours per week · BEGINNER
Included with a Manning Online subscription
try now

pro $24.99 per month

  • access to all Manning books, MEAPs, liveVideos, liveProjects, and audiobooks!
  • choose one free eBook per month to keep
  • exclusive 50% discount on all purchases

lite $19.99 per month

  • access to all Manning books, including MEAPs!

team

5, 10 or 20 seats+ for your team - learn more

Look inside

Acme Widgets, a manufacturing company, manually logs its supplier invoices on spreadsheets in Google Workspace. Your task is to free the staff from this tedious task by creating an add-on that automatically extracts and records useful information from invoices. You’ll set up a Google Cloud Platform (GCP) account, implement and deploy the add-on, and create Document AI processors for processing invoices from multiple regions. You’ll add a CardService that improves the user experience by letting them select which files to process. You’ll use the Document AI REST API to process the invoices’ image data and write the processed data to a spreadsheet, enhancing the user interface. When you're done, you’ll have created a basic, easy-to-use Google Workspace add-on that extracts and records invoices in multiple formats, leaving the Acme Widgets staff free to focus on more productive tasks.

This project is designed for learning purposes and is not a complete, production-ready application or solution.

book resources

When you start your liveProject, you get full access to the following books for 90 days.

project author

Bruce Mcpherson

Bruce Mcpherson is a Google Developer Expert focusing on Google Workspace and Google Cloud Platform. Throughout his distinguished career, he’s held titles including Chief Architect, Head of Engineering, CTO, and CIO, at Motorola, Lucent, and Symbol. He's the author of O'Reilly Media’s Going GAS, Google Apps Script for Beginners, and Google Apps Script for Developers. His long-running Desktop Liberation site provides his expert guidance on Google Apps Script and Microsoft automation. He’s the developer of many open-source libraries (github.com/brucemcpherson) in a variety of languages and platforms. He speaks at conferences on Google technologies. He’s currently developing the platform for a startup specializing in AI-assisted video content analysis and classification and continues to mentor organizations whose mission is to improve diversity in tech.

prerequisites

This liveProject is for beginner-level Apps Script or JavaScript developers interested in creating a basic Google Workspace add-on to help automate their tasks. To begin these liveProjects you’ll need to be familiar with the following:

TOOLS
  • Google Workspace account (Google Sheets, JavaScript/Apps Script, Google Drive)
  • Google Cloud Console
  • Your favorite browser
TECHNIQUES
  • Basic JavaScript/Apps Script
  • Create and manage a billing account and cloud projects

you will learn

In this liveProject, you’ll learn to create a basic Google Workspace add-on that can process data in a variety of formats and is set up for the addition of future, more complex add-ons.

  • Create and run an Apps Script project
  • Set up and manage a Google Cloud Platform (GCP) project and its Billing account in the GCP Console
  • Enable APIs in GCP
  • Create document processors in the Document AI console
  • Write JavaScript (Apps Script) code, customize and add features using the CardService
  • Create a manifest to describe your add-on and assign permissions
  • Deploy and test the add-on
  • Debug state management

features

Self-paced
You choose the schedule and decide how much time to invest as you build your project.
Project roadmap
Each project is divided into several achievable steps.
Get Help
While within the liveProject platform, get help from other participants and our expert mentors.
Compare with others
For each step, compare your deliverable to the solutions by the author and other participants.
book resources
Get full access to select books for 90 days. Permanent access to excerpts from Manning products are also included, as well as references to other resources.

choose your plan

pro

monthly
annual
$24.99
$249.99
only $20.83 per month
  • access to all Manning books, MEAPs, liveVideos, liveProjects, and audiobooks!
  • choose another free product every time you renew
  • choose twelve free products per year
  • exclusive 50% discount on all purchases
  • Basic Add-on project for free

team

monthly
annual
$49.99
$499.99
only $41.67 per month
  • five seats for your team
  • access to all Manning books, MEAPs, liveVideos, liveProjects, and audiobooks!
  • choose another free product every time you renew
  • choose twelve free products per year
  • exclusive 50% discount on all purchases
  • Basic Add-on project for free