Automates the creation of work manuals by extracting essential details from Google Slides and organizing them into Google Sheets, improving workflow efficiency.
This tool serves as a pivotal asset for organizations aiming to centralize their manual documentation in Google Drive. By consolidating manuals onto a single platform, it facilitates easy access for all workers. Moreover, it ensures that the information within each work manual is conveyed in a concise manner, enhancing readability and comprehension.
- A Google account with access to Google Sheets and Slides.
- A foundational understanding of Google Sheets, Google Slides and Google Apps Script.
- Access a Sample Google Sheet: Begin by opening the Sample Google Sheet. You can also find the Sample Google Slide.
*Note: The samples provided are merely illustrative, showcasing a manual for an educational institution.
- Copy the Google Sheet: Make a copy of the Google Sheet to create your personalized version.
- Authorization: The first time you run the script, it will ask for your permission to access certain data. If you're using a free Gmail account, you might see a warning that says
Not Verified by Google. Don't worry about this warning - you still need to give permission for the script to work. The script is yours alone, and it won't share any data outside of Google, unless you choose to share your Google Sheet. The only data it might send outside of Google is website status codes, for monitoring purposes. - Return to Original Format: Use this option to reset the Google Sheet to its original format (i.e., Delete all of the sample sheets except index sheet, reset all pre-defined information, and clear contents in index sheet). Navigate to
Custom MenuClickSettingand clickDelete All Sheets and Pre-Set Info.
Fig: Setting Menu - Set Slide URL and Name of Index Sheet: Navigate to
Custom Menu > Settingand clickSet Necessary Infodesignating URL of Google Slide and name of the index sheet of Google Sheet.
- Make Slides with Designated Patterns
Users need to create slides in the designated Google Slide following a certain pattern. The first slide of each section should follow this structure:
Category:【Category Name】Subcategory Name
Task: Task Name
Summary: Summary Descriptions
Figure: Slide Structure The script gets and stores the details including the slide URL and category name from the first slide, which are later output in the Google Sheet.
- Update Index & Task Sheets
Navigate to
Custom Menuand clickUpdate Index & Task Sheets. This action automatically updates the index and task sheets based on the latest slide data.
Figure: Update Button 
Figure: Updates in Index Sheet 
Figure: Updates in Task Sheet
If you are interested in the logics on how the details from Google Slides are extracted and outputting them into Google Sheet, click HERE for the detailed explanation.
Please note that your use of this website is subject to the Terms and Conditions.
You can find the source code for this tool on Github. Click HERE .
- The original icon of this tool is created by Manual icons created by Freepik - Flaticon, modified by tsato21.
- The banner of this tool is made by Canva, using the above icon.
Last updated: May 5, 2024
