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, 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.
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.
prerequisites
This liveProject is for beginner-level Apps Script or JavaScript developers interested in learning to customize Google Workspace add-ons to increase functionality and usability. 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
- Basic JavaScript/Apps Script
- Create and manage a billing account and cloud projects
you will learn
In this liveProject, you’ll learn to customize Google add-ons with folder navigation and file picking as well as interpreting both images and PDFs.
- Implement a contextual workspace for Google Sheets
- Enable APIs in Google Cloud Platform
- Write JavaScript (Apps Script) code, customize and add features using CardService
- Implement a Google Drive file picker using the Google Picker API
- Associate the picker with the add-on and pass data between browser and server-side modules
- 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
-
![]()
Customize the Look and Feel project for free
Customize the Look and Feel 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
-
![]()
Customize the Look and Feel project for free
