This Google Apps Script project automates the process of receiving, labeling, and managing gas cylinder deliveries and inventory. It integrates with Google Sheets, Google Drive, and Gmail to track orders, extract delivery details from PDF attachments, generate labels, and manage inventory.

• Automated Order Processing: Extracts PDF attachments from Gmail, saves them to Google Drive, and retrieves relevant order information.
• Label Generation: Creates and prints labels for received gas cylinders with serial numbers, order numbers, and PO details.
• Inventory Management: Updates Google Sheets with order details, including serial numbers, PO numbers, and status.
• User Interface Integration: Provides a Google Sheets menu for executing key functions like saving orders and printing labels.
• Automated Link Generation: Generates tracking links for serial numbers, purchase orders, and order numbers in Google Sheets.

1. Open Google Apps Script by going to Extensions > Apps Script in Google Sheets.
2. Copy and paste the provided script files into the Apps Script editor.
3. Deploy the script as a web app and configure permissions.
4. Ensure that the necessary Google Drive and Gmail API permissions are enabled.

• Receiving Orders: Automatically saves PDF delivery documents from Gmail to Google Drive.
• Label Printing: Extracts order data from Google Sheets and generates labels.
• Order Tracking: Updates receiving logs and creates tracking links for easy access.

• Gas Cylinder Receiving Receipt.js: Extracts and processes delivery documents from Gmail.
• Receiving Docs Sheet.js: Stores extracted delivery information in Google Sheets.
• Make Labels.js: Generates printable labels for received cylinders.
• UI.js: Creates a custom menu in Google Sheets for executing functions.
• Gas Cylinder Labels.html: HTML template for generating QR code labels.
• Locations.html: HTML template for handling different storage locations.
• appsscript.json: Configuration file for setting up permissions and runtime settings.

1. Open Apps Script Editor.
2. Click Deploy > New Deployment.
3. Select Web App, set permissions, and deploy.
4. Copy the deployment URL and integrate it into the UI functions.

This script requires access to:

• Google Drive (to save PDFs and generate labels)
• Gmail (to fetch order confirmations)
• Google Sheets (to manage inventory data)