Process Other Formats you own this product

basic Apps Script or JavaScript • basic understanding of how APIs work • Google Cloud Console basics • Google Sheets basics
skills learned
use the Google Drive API to create conversion routes • convert a range of documents to native • summarize, sort, and deduplicate converted documents
Bruce Mcpherson
1 week · 6--8 hours per week · BEGINNER

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!


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

Look inside

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.

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

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 ( 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.


This liveProject is for beginner-level Apps Script or JavaScript developers interested in learning to enhance a Google Workspace add-on with support for a variety of document types. To begin these liveProjects you’ll need to be familiar with the following:

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


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


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
  • Process Other Formats project for free