Google Sheet Project, Tracking Packages online

Sign up for a free Google account to access Google Sheets, then create and share a new spreadsheet in Google Drive and set access permissions.

Learn basic Google Sheets operations, including undo/redo, printing selected cells, cell formatting, notes and comments, charts, and filter views, plus using formulas like sum and history to revert changes.

Copy the sheet via file > make a copy, name it, and open a new tab. On first run, authorize the script with your Gmail account to enable it.

Learn how to customize a Google Sheet layout and adjust the script to compensate for column changes, updating coordinates and data loads for UPS and FedEx data.

Add another carrier to the tracking script by customizing the URL and carrier, then inspect the site source and replace ATM element with the HCM element to handle different carriers.

Learn to insert an image as a clickable button in Google Sheets, assign and customize a script (default track), and use drawings or shapes to add text and new functions.