AutomateWithAppsScript

A comprehensive collection of Google Apps Script utilities for automating event management workflows, including registration analysis, ticket generation, QR code scanning, and email automation.

---

📁 Repository Structure

This repository contains multiple folders, each focused on specific automation tasks:

📊 registration-analytics/

Purpose: Analyze and compare event registration data across multiple Google Sheets.

Features:

• Compare email registrations across multiple event sheets
• Find common participants between events
• Identify multiple registrations from the same email
• Generate detailed reports and analytics

Scripts:

• eventRegistrationComparator.js - Count common participants between events
• eventRegistrationComparator(mail ids as output).js - List actual email addresses
• Finding multiple registration from same mail id.js - Find duplicate registrations

🎫 ticket-automation/

Purpose: Complete ticket automation system with QR code generation and team ID management.

Features:

• QR code generation for event tickets
• Team ID generation based on various criteria (game selection, team size, birthdate)
• Automated ticket sending via email
• HTML form integration for ticket processing

Scripts:

• QRcode_genration.js - Generate QR codes for tickets
• Team id genration according to game selected.js - Game-based team IDs
• Team id genration according to team size.js - Size-based team IDs
• Team id genration basic version from Birthdate.js - Birthdate-based team IDs

📧 email-automation/

Purpose: Automated email system for event communication and reminders.

Features:

• Entry received confirmation emails
• Payment confirmation emails
• Reminder emails for registrations
• Invitation emails for past participants
• Admin status reports

Scripts:

• Entery reciveed mail.js - Entry confirmation emails
• Payment conformation mail.js - Payment confirmations
• Reminder mail.js - Registration reminders
• Invitation to the last year participants.js - Past participant invites
• Sending mail for team registration with report to the admin regarding status .js - Team registration with admin reports

📱 qr-attendance-scanner/

Purpose: QR code scanning system for event attendance tracking.

Features:

• Web-based QR code scanner
• Real-time attendance marking
• Admin email notifications
• Google Sheets integration for attendance records

Files:

• code.js - Main Apps Script code
• index.html - Web interface for scanning

🔧 utilities/

Purpose: Miscellaneous utility scripts for Google Sheets automation.

Scripts:

• Fill Zeros with Preceding Average.js - Data processing utility
• Find Max Value in Column B and Corresponding Name in Column A.js - Data analysis utility
• Missing text.js - Text processing utility

---

🚀 Quick Start

1. Choose your automation need from the folders above
2. Navigate to the specific folder and read its README
3. Copy the desired script(s) into your Google Apps Script editor
4. Configure the placeholders (Sheet IDs, email addresses, etc.)
5. Run the main function from the Apps Script editor

---

📋 Prerequisites

• Google Account with access to Google Sheets and Google Drive
• Basic understanding of Google Apps Script
• Google Apps Script editor access (available at script.google.com)

---

⚙️ Configuration

Most scripts require configuration of these placeholders:

• YOUR_SPREADSHEET_ID - Your Google Sheet ID
• YOUR_SHEET_NAME - Your sheet name
• YOUR_ADMIN_EMAIL - Admin email address
• YOUR_FOLDER_ID - Google Drive folder ID

Replace these with your actual values before running the scripts.

---

📖 Usage Examples

Registration Analysis

// In eventRegistrationComparator.js
var sheetNames = ["Workshop A", "Workshop B", "Workshop C"];
compareEventRegistrations(); // Creates EventPairs sheet with analysis

QR Code Generation

// In QRcode_genration.js
const spreadsheet = SpreadsheetApp.openById("YOUR_SPREADSHEET_ID");
generateTeamAndQRCode(); // Generates QR codes and saves to Drive

Email Automation

// In Reminder mail.js
const sheetId = 'YOUR_SHEET_ID';
const adminEmail = 'admin@example.com';
sendReminderEmails(); // Sends reminder emails to registrants

---

🤝 Contributing

We welcome contributions! Feel free to:

• Add new automation scripts
• Improve existing functionality
• Fix bugs or issues
• Enhance documentation
• Share your use cases

---

📄 License

These scripts are provided as-is for internal automation and analysis. Please review and adapt them as needed for your use case.

---

📞 Support

Each folder contains detailed README files with specific setup instructions, usage examples, and troubleshooting tips. If you encounter issues:

1. Check the specific folder's README
2. Verify all placeholders are replaced with actual values
3. Check Google Apps Script execution logs for errors
4. Ensure proper permissions for Sheets/Drive access