5, 10 or 20 seats+ for your team - learn more
Welcome to Acme Widgets, a manufacturing company whose suppliers, local and international, send it documents of various types in a range of formats. Currently, Acme Widgets’ employees have to manually interpret and log data from these documents in spreadsheets. Your job is to automate this tedious process using Google's AI platform which applies Machine Learning models to make sense of and extract meaningful data from a collection of documents. In this series of liveProjects you’ll create, customize and deploy a Google Workspace add-on to automatically convert, deduplicate, organize, archive and extract actionable data from a variety of document types and formats using the power of AI—all from the comfort of a familiar spreadsheet environment.
The code provided was top quality and helped with this project, and can be used in real-life projects.
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.
Acme Widgets, a manufacturing company, processes its supplier invoices with an AI-powered Google Workspace add-on that automatically extracts and records invoice data. But the add-on has limited functionality, such as only being able to interpret single image files, which makes tasks like picking files difficult. It’s up to you to make basic tasks like these easier. You’ll enable the Google Picker API to add the ability to navigate and customize files. You’ll create and publish a file picker as a web app, and publish the add-on with the attached file picker. To further enhance the user interface, you’ll add image thumbnails and links to the picked files, as well as support for interpreting PDFs and images to accommodate a larger variety of documents. When you’re done, you’ll have helped ensure Acme Widgets’ accounts are accurate and made the staff’s lives easier—all while learning Google add-on customization skills.
Acme Widgets, a manufacturing company, uses an AI-powered Google Workspace add-on to automatically extract information from supplier invoices. Your task is to extend the add-on’s functionality so it can handle expense claim receipts, as well. You’ll add a Document AI processor designed for processing expenses, and you’ll enable additional fields in order to group related receipts. To increase user convenience, you’ll enable the uploading of local files and add a tab to re-pick recently selected files. Lastly, you’ll create unit tests that will help you update the add-on with more complex changes in the future.
Acme Widgets has an AI-powered Google Workspace add-on that interprets data from invoices and receipts. Add-ons have a processing time limit that keeps them from processing many documents at once. It’s up to you to solve this problem! You’ll create one delegate web app that archives files to centralized Google Cloud Storage (GCS) and another that batches the documents—allowing processing to be done in a way that bypasses the standard add-on response time limit. As you develop, you’ll implement incremental unit testing to detect code errors. When you’re done, you’ll have a powerful add-on that isn’t constrained by processing time limits and automatically archives documents to secure cloud storage.
Acme Widgets has a Google Workspace invoice processing add-on that uses Google Document AI to interpret data from PDFs and image formats. To make the tool more valuable, your task is to add the ability to accept documents in other formats. You’ll start by enabling a pop-up web app that displays the expanded list of newly supported file types. You’ll add functionality for picking additional file types and automatically converting them to a Document AI-supported format, then archiving them. You’ll also enable sorting and duplicate removal as you create a summarized view of invoices and expenses, making the company’s employees’ tasks easier and less time-consuming.
These liveProjects are for beginner-level Apps Script or JavaScript developers who want to automate tasks by creating Google Workspace add-ons. To begin these liveProjects you’ll need to be familiar with the following:
TOOLS