14 views
1. Initial setup Clone the Notion template: Start by duplicating the template from the provided link Set up your Google Spreadsheet: Create a new Google Spreadsheet Open Apps Script and copy and paste the code Run the 'setupTriggers()' function to set up the environment Grant necessary permissions 2. Enter ISBN information Enter ISBN via Google Form (single book) Enter directly in the 'Manual Entry' tab of Google Sheet (multiple books) Barcode scanner can be used (for bulk entry) 3. Process book information The entered ISBN information is automatically processed and recorded in the 'Book Information DB' Create a 'Simple Title' in the 'Book Information DB' (Book title excluding subtitle or an easy-to-understand name) 4. Work on the table of contents (manually) Click the 'New Page' button to apply the 'Table of Contents DB' template Manually enter the table of contents in the 'For Work' tab of the 'Table of Contents DB' Copy the table of contents information from the 'Table of Contents' column of the 'Book Information DB' Edit the table of contents information if necessary (make each chapter a separate block) 5. Use additional features Use properties such as book status, yearly statistics, and storage location to analyze the book Use the ISBN processing function through the automatically generated 'Book Information' menu. This process enables systematic management of reading notes in Notion. You can build an efficient book information management system by combining automated ISBN processing and manual table of contents work.