AWAM Sheets Automation Tool

Overview

This application provides professional automation features within Google Sheets. It is used in the context of client automation workflows and operates exclusively within the Google Sheets files where it is installed.

Main Features

• Duplicate name detection within participant lists
• Dynamic generation of data validation lists
• Automated integration of templates associated with specific events

How It Works

This tool is attached to a specific Google Spreadsheet.

1. Reads and modifies data within the active spreadsheet.
2. Retrieves file names from Google Drive folders explicitly linked to a client workflow.
3. Dynamically displays those files as dropdown validation options in the spreadsheet.

The application does not perform global indexing or unrestricted access to the user's Google Drive.

Required Permissions

• spreadsheets → Read and modify the active spreadsheet
• drive.file → Access only files explicitly used within the automation process

No data is collected for marketing or commercial resale purposes.

Contact

For questions regarding this application:

Email: s.menard@agence-awam.fr