# Google Apps Script > Custom scripts that connect Gmail, Sheets, Drive, and Docs directly, automation built right into Google Workspace. Page: https://showcase.growlyze.cloud/tag/google-apps-script 13 case studies in full below. # Automated PDF Data Extraction from Gmail and Google Sheets Integration > Developed an automated solution for a client who received daily PDFs via email. Section: Google Apps Script Page: https://showcase.growlyze.cloud/case/gas-automated-pdf-data-extraction-from-gmail Developed an automated solution for a client who received daily PDFs via email. Created a Google Apps Script that scans Gmail for specific emails containing PDF attachments, downloads and parses these PDFs to extract vital information, and transfers this extracted data into a designated Google Sheet. The script is scheduled to run automatically at a pre-defined time each day, ensuring timely data processing and minimal manual intervention. **Features** - User Authentication: Secure login mechanism to authenticate users. - PDF Upload: Interface to upload PDF files manually. - Data Extraction: Extract specific fields like order code, shipping address, product details, etc., from the uploaded PDF. - Google Sheets Integration: Populate the extracted data into a Google Sheet. - Scheduled Email Fetching: Automated function to fetch PDF attachments from a user’s email at scheduled intervals. - Data Validation: Validation checks to ensure data consistency and accuracy. Image: Feature list and the two-workflow design: a scheduled main flow (PDF parsing → validation → sheet integration) alongside a manual upload flow (login → upload). (https://showcase.growlyze.cloud/case-content/google-apps-script-portfolio/image1.png) Image: The FastAPI backend that handles the upload, invoice parsing, and Sheets integration. (https://showcase.growlyze.cloud/case-content/google-apps-script-portfolio/image2.png) --- # Growth Model Development with Defined KPIs > Designed a dynamic growth model in Google Sheets, complete with Key Performance Indicators (KPIs) to enhance visibility and guide decision-making. Section: Google Apps Script Page: https://showcase.growlyze.cloud/case/gas-growth-model-development-with-defined-kpis Designed a dynamic growth model in Google Sheets, complete with Key Performance Indicators (KPIs) to enhance visibility and guide decision-making. Image: The growth funnel model: awareness, engagement, and retention KPIs tracked month over month. (https://showcase.growlyze.cloud/case-content/google-apps-script-portfolio/image3.png) --- # BigQuery to Google Sheets Data Pipeline > Implemented a robust data pipeline using SyncWith and SQL to extract and sync data from BigQuery to Google Sheets for real-time analytics and reporting. Section: Google Apps Script Page: https://showcase.growlyze.cloud/case/gas-bigquery-to-google-sheets-data-pipeline Implemented a robust data pipeline using SyncWith and SQL to extract and sync data from BigQuery to Google Sheets for real-time analytics and reporting. Image: A scheduled BigQuery SQL query joining employer and sign-up data by month for the KPI sheet. (https://showcase.growlyze.cloud/case-content/google-apps-script-portfolio/image4.png) --- # Google Sheets Data Visualization Dashboard > Created an interactive dashboard within Google Sheets for effective data visualization and tracking, serving as a quick reference tool for stakeholders. Section: Google Apps Script Page: https://showcase.growlyze.cloud/case/gas-google-sheets-data-visualization-dashboard Created an interactive dashboard within Google Sheets for effective data visualization and tracking, serving as a quick reference tool for stakeholders. Image: A CRM dashboard inside Google Sheets tracking hiring totals, job closures, and feedback scores. (https://showcase.growlyze.cloud/case-content/google-apps-script-portfolio/image5.png) --- # Batch Creation of Folders and Files > The script initiates by creating a structured main folder in Google Drive. Section: Google Apps Script Page: https://showcase.growlyze.cloud/case/gas-batch-creation-of-folders-and-files - The script initiates by creating a structured main folder in Google Drive. - Within this main folder, it systematically generates a set of predefined subfolders. - For each subfolder, the script creates specific spreadsheet files from templates designed for various purposes. - Google Docs templates are duplicated and placed into their respective folders, ready for use. - A master spreadsheet is updated with the names, IDs, and direct links to all created folders and files, facilitating easy navigation and organization. Image: The batch-creation script that generates each client’s folder structure, contract, and accounting files from templates. (https://showcase.growlyze.cloud/case-content/google-apps-script-portfolio/image6.png) --- # Batch Management of Access > The script reads from a spreadsheet cell that lists email addresses authorized for file access. Section: Google Apps Script Page: https://showcase.growlyze.cloud/case/gas-batch-management-of-access - The script reads from a spreadsheet cell that lists email addresses authorized for file access. - It programmatically adjusts the sharing settings of designated Google Drive files and folders, granting access to the emails provided. - Concurrently, it ensures that access is removed from email addresses not currently listed in the spreadsheet. - This process is tailored to manage differing access levels needed for team members versus clients. - The script offers an efficient mechanism to control document access, reducing the risk of unauthorized viewing or editing. --- # Email Reminder System > The script is scheduled to run daily to ensure real-time relevancy of its functions. Section: Google Apps Script Page: https://showcase.growlyze.cloud/case/gas-email-reminder-system - The script is scheduled to run daily to ensure real-time relevancy of its functions. - It begins by accessing specific files through provided links within a master file. - Once the file is opened, the script navigates to a particular sub-tab where date-specific data is stored. - It compares the stored dates against the current date to identify matches. - When a match is found, indicating a task or event due that day, it triggers the sending of customized email reminders to designated recipients. - This automation ensures that reminders are sent out without fail, improving the consistency of communications and task management. Image: Extracting a hyperlink from a spreadsheet cell to locate the right file before checking its dates. (https://showcase.growlyze.cloud/case-content/google-apps-script-portfolio/image7.png) Image: A due-diligence checkup variant: comparing today’s date against the sheet before sending a scheduled compliance email. (https://showcase.growlyze.cloud/case-content/google-apps-script-portfolio/image8.png) Image: The companion screening script that walks each row and extracts the linked spreadsheet before processing it. (https://showcase.growlyze.cloud/case-content/google-apps-script-portfolio/image9.png) --- # Google Apps Script for Chart Automation > Utilized Google Apps Script to automate the generation and saving of chart images to Google Drive, streamlining the reporting process. Section: Google Apps Script Page: https://showcase.growlyze.cloud/case/gas-google-apps-script-for-chart-automation Utilized Google Apps Script to automate the generation and saving of chart images to Google Drive, streamlining the reporting process. --- # Automated PDF Invoicing via Email > Created Google Apps Script to automatically format data into PDF invoices and send them via email, saving manual effort and enhancing operational efficiency. Section: Google Apps Script Page: https://showcase.growlyze.cloud/case/gas-automated-pdf-invoicing-via-email Created Google Apps Script to automatically format data into PDF invoices and send them via email, saving manual effort and enhancing operational efficiency. --- # Automated Column Management in Inventory Sheet > Developed an app script to automatically update columns in an inventory sheet based on values in another sheet, enabling seamless data synchronization within Google Sheets. Section: Google Apps Script Page: https://showcase.growlyze.cloud/case/gas-automated-column-management-in-inventory-sheet Developed an app script to automatically update columns in an inventory sheet based on values in another sheet, enabling seamless data synchronization within Google Sheets. Image: Syncing active/inactive status between a main sheet and a linked inventory spreadsheet. (https://showcase.growlyze.cloud/case-content/google-apps-script-portfolio/image10.png) Image: A custom menu for updating inventory values and normalizing leading zeros on demand. (https://showcase.growlyze.cloud/case-content/google-apps-script-portfolio/image11.png) --- # CSV-Based Inventory Data Entry Automation > Created a script to automate data entry in an inventory sheet from CSV files. Section: Google Apps Script Page: https://showcase.growlyze.cloud/case/gas-csv-based-inventory-data-entry-automation Created a script to automate data entry in an inventory sheet from CSV files. The script also includes a data cleaning function to ensure accuracy and integrity of the imported data. Image: Multi-warehouse inventory data with flagged data-quality issues the cleaning step catches: mismatched locations and unidentified SKUs. (https://showcase.growlyze.cloud/case-content/google-apps-script-portfolio/image12.png) --- # Project Tracker Management > Worked on developing a Project Tracker in Google Sheets to allocate tasks, track project milestones, and monitor team performance, complete with real-time updates and visual dashboards for easy interpretation. Section: Google Apps Script Page: https://showcase.growlyze.cloud/case/gas-project-tracker-management Worked on developing a Project Tracker in Google Sheets to allocate tasks, track project milestones, and monitor team performance, complete with real-time updates and visual dashboards for easy interpretation. Image: A Gantt-style project schedule generated directly in Google Sheets. (https://showcase.growlyze.cloud/case-content/google-apps-script-portfolio/image13.png) --- # Shopify to Google Sheets Data Transfer with Task Allocation > Leveraged expertise in API integration and Google Sheets to create an automated system that transfers data from Shopify to Google Sheets using the ‘Sync With’ extension. Section: Google Apps Script Page: https://showcase.growlyze.cloud/case/gas-shopify-to-google-sheets-data-transfer Leveraged expertise in API integration and Google Sheets to create an automated system that transfers data from Shopify to Google Sheets using the ‘Sync With’ extension. Utilized Google Apps Script and various functions to allocate customer-specific tasks to agents, and integrated this data into Aircall for seamless customer outreach. The system is set to update daily. Image: The task-distribution function that splits unattended calls evenly across the agent roster. (https://showcase.growlyze.cloud/case-content/google-apps-script-portfolio/image14.png)