Brand Asset Folder Automation & Client Notification - n8n Workflow

• Creative and digital agencies looking to streamline client onboarding processes.


• Project managers needing reliable, zero-touch file management systems.


• Freelancers handling high volumes of client projects requiring organized file storage.


• Teams that utilize Google Sheets as a primary source for project initiation data.

Starting a new project often involves repetitive administrative tasks like setting up file structures and sending initial communications. This specific n8n workflow eliminates that burden. By leveraging the power of an n8n trigger connected to Google Sheets, this automation instantly responds when a new row (representing a new project) is added or updated. It ensures that every new client receives a professional, personalized welcome email containing the specific link to their dedicated brand asset Google Drive folder, which the Google Drive n8n node automatically created moments earlier. This robust integration of Google services and Slack proves why utilizing pre-built n8n templates is essential for scaling agency operations and reducing manual effort required for project kick-off. Implementing this n8n workflow greatly enhances operational efficiency.

This entire n8n workflow is initiated by a centralized data source, ensuring seamless operational flow.

1. Project Initiation (n8n Trigger): The process begins with the Google Sheets Trigger n8n node, which constantly monitors a specified spreadsheet for row updates (new project data entry). This serves as the initial n8n trigger for the automation.


2. Data Structuring: The incoming data is cleaned and standardized using a Set n8n node (labeled 'Edit Fields'), ensuring critical information like clientname, contactemail, and deadline are correctly mapped and available to subsequent steps in the n8n workflow.


3. Google Drive Provisioning: The next n8n node, the Google Drive node ('Create Project Folder'), utilizes the standardized client name to automatically create a dedicated project folder. The output from this specific n8n node includes the unique folder link needed for client communication.


4. Client Notification (Gmail): The Gmail n8n node then executes, sending a highly personalized welcome email to the client using the contact information and project details passed down the workflow chain. Crucially, the folder link generated in the previous step is embedded in the email body, guiding the client directly to their asset drop-off point.


5. Internal Notification (Slack): Finally, the Slack n8n node ('Notify Team Slack') posts a notification to the internal #ops channel, alerting the team that the onboarding process has successfully started, providing real-time visibility into the status of this n8n workflow execution. Utilizing this n8n workflow ensures everyone is instantly informed.

To deploy this n8n workflow template, follow these steps:

1. Import: Copy the provided JSON code and paste it directly into your n8n canvas via the 'New' menu -> 'Import from JSON'.


2. Google Sheets Trigger Setup: Configure the Google Sheets Trigger n8n node. You will need to select the correct Google Sheet Document ID and the specific Sheet Name where your project intake data resides. Set up the Google Sheets Trigger OAuth2 credential.


3. Google Drive Setup: Configure the Google Drive n8n node. Ensure the connected Google Drive account has permission to create folders within your desired parent directory.


4. Gmail Setup: Configure the Gmail n8n node with your required sender credentials (Gmail OAuth2). Review the template message and subject lines to ensure they match your brand voice.


5. Slack Setup: Configure the Slack n8n node by setting up your Slack API credentials and updating the target channel name (currently #ops) if necessary.


6. Testing: Run the n8n workflow manually with sample data from your Google Sheet to verify folder creation, email delivery, and Slack notification before activating the n8n trigger.

Google Sheets Trigger
Function: Acts as the primary n8n trigger, initiating the entire n8n workflow upon detecting row updates in the project data spreadsheet.
Key Configuration: Listens for the rowUpdate event; requires specific Document ID and Sheet Name configuration.
Edit Fields (Set n8n node)
Function: Standardizes and organizes input fields (e.g., clientname, deadline) from the Google Sheet trigger output, preparing them for dynamic use by subsequent n8n nodes.
Key Configuration: Creates assignments for clientname, contactemail, projecttype, deadline, and branddrivefolder.
Create Project Folder (Google Drive n8n node)
Function: Creates a new, dedicated Google Drive folder for the client's assets. The creation step is critical to this n8n workflow.
Key Configuration: Resource set to drive; Folder name is dynamically set using the client name (={{ $json.clientname }}).
Gmail n8n node
Function: Sends the project welcome email, including the newly created Drive folder link, to the client.
Key Configuration: Send To is dynamic (={{ $json.contactemail }}); Message content dynamically embeds project details and the brand folder link ({{ $json.branddrivefolder }}).
Notify Team Slack (Slack n8n node)
Function: Provides immediate internal confirmation to the operations team that the client onboarding has started and the n8n workflow executed successfully.
* Key Configuration: Target Channel set to #ops; Notification text uses dynamic data from the 'Edit Fields' n8n node.