Trello and Google Sheets integration

How It Works & Setup Guide for the Automated Candidate Management & Feedback System This guide will walk you through setting up your n8n workflow. By the end, you'll have a fully automated system for managing your recruitment pipeline. How It Works: The Workflow Explained This workflow is designed in three logical phases to handle the entire post-interview process automatically. Phase 1: Trigger & Feedback Loop: The workflow triggers when an interview ends on your Google Calendar. It immediately sends a Slack message to the interviewer with a link to the feedback form. After a 2-hour wait, it checks if the feedback has been submitted. If not, it sends a reminder. Once feedback is received, it logs the data in Airtable and uses an If node to determine if the candidate has passed or failed. Phase 2: Automated Communication: Based on the candidate's status, the workflow sends a personalized and professional email using Gmail. For candidates who pass, it sends a follow-up invitation. For those who don't, it sends a polite rejection email crafted by a Code node. If a candidate is in the final stage and passes, the workflow automatically generates and sends an offer letter for signature via DocuSign. Phase 3: Onboarding & Reporting: Once a candidate accepts the offer (by signing the document), the workflow is triggered to create a new task list in Trello for the HR team. It sends a personalized welcome email to the new hire and a notification to the team on Slack. Finally, a Cron Trigger runs every Friday to collect all candidate data, calculate key recruitment metrics, log them in Google Sheets, and send a summary report to your team on Slack. Step-by-Step Setup Guide Follow these steps to configure the workflow in your n8n instance. Step 1: Prerequisites Before you begin, ensure you have the following accounts and a workspace set up: n8n Google Calendar, Google Sheets, Gmail Airtable Slack Trello DocuSign Step 2: Database & Form Preparation Airtable: Create a new Airtable base with two tables: Candidates Table: Create columns for Candidate Name, Email, Interviewer ID, Interview Date, and Status. Feedback Table: Create columns for Candidate Name, Overall Score, and Comments. Feedback Form: Create a feedback form (e.g., using Google Forms or Typeform) that collects the candidate's name, the interviewer's name, and a score/comments. Step 3: Import the Workflow In your n8n instance, click "New" and select "Import from File". Import the .json file you purchased. The entire workflow, with all nodes, will appear on your canvas. Step 4: Configure Credentials Click on any node with a red "!" icon (e.g., the Google Calendar Trigger or Slack node). In the right-hand panel, click "Create new credential". Follow the on-screen instructions to connect your accounts. Repeat this process for all nodes that require credentials. Step 5: Node-Specific Configuration Now, let's configure the specific details for each node to ensure it works for your company. Google Calendar Trigger: Click on the node and in the Calendar ID field, enter the ID of the calendar you use for scheduling interviews. Airtable Nodes: For every Airtable node in the workflow, enter the correct Base ID and Table Name (Candidates or Feedback) that you created in Step 2. Trello Node: Enter the Board ID and the specific List ID where you want new onboarding tasks to be created. Gmail Nodes: Customize the Subject and HTML Body of the emails to match your company's tone and branding. DocuSign Node: Enter your Account ID and the Template ID for your offer letter. Ensure your offer letter template includes the anchorString (e.g., /s1/) that the workflow uses to place the signature tag. Environment Variables: In your n8n settings, go to Environment Variables and add the following: FEEDBACK_FORM_URL: The URL of your feedback form. SCHEDULING_LINK: The URL for candidates to schedule their next interview. REPORTS_DASHBOARD_URL: A link to your Google Sheets report or a separate dashboard. Step 6: Final Step - Activating the Workflow Once all nodes are configured, click "Save" at the top of the canvas. Click the "Active" toggle in the top right corner. The workflow is now live! Final Tip: It's a good practice to test the system once by creating a test interview event on your calendar to ensure all steps run as expected.

Daily Sales Metrics Auto-Insight with Gemini, Google Sheets, Calendar, Telegram, Trello and Gmail Who’s it for This workflow is ideal for sales managers, operations teams, and business owners who need daily automated sales summaries and team notifications. It eliminates the hassle of manually gathering, analyzing, and reporting daily sales data, providing instant insights and proactive notifications to keep your team aligned. How it works / What it does This advanced workflow automates the entire daily sales reporting pipeline with actionable team alerts: Webhook captures new sales entries in real-time. The data is logged into Google Sheets. It retrieves all rows to compile current sales metrics. A custom node concatenates the data into an AI-friendly format. The Google Gemini Chat Model generates concise sales insights. HTML tags are cleaned up with a Remove HTML Tags node. The insights are classified (Good, Bad, Very Bad) using AI. Based on the classification: -- Teams are alerted via Telegram group messages. -- For negative insights, a Trello card backlog is created for follow-up. -- A Google Calendar meeting is scheduled automatically to discuss issues. An email summary is also sent out via Gmail to ensure no update is missed How to set up Import the workflow into your n8n instance. Configure the Webhook URL in your data source (POS, CRM, etc.). Connect Google Sheets, Google Gemini API, Trello, Telegram, and Google Calendar. Adjust classification logic inside the Classify Insight node if needed. Customize the message templates for email and Telegram. Test the workflow with sample data to validate automation flow. Requirements n8n account with active workflows. Google Sheets API credentials. Google Gemini API access. Telegram Bot Token & Group ID. Trello API Key & Token. Google Calendar API setup. Gmail or SMTP credentials for email notifications. How to customize the workflow Adjust the Concat Sales Data node if you want to include more fields or different data formats. Modify the Gemini prompt for personalized insight summaries. Change the classification thresholds (Good, Bad, Very Bad) based on your business KPIs. Update the notification messages in Telegram and Email nodes. Add or remove post-classification actions, like creating different task cards or sending escalations to other platforms (Slack, Microsoft Teams, etc.). Automate daily sales insights from Google Sheets using Gemini AI, classify results, and notify your team via email, Telegram, Trello, and Google Calendar instantly. Email Preview

How It Works ⚙️ This workflow is a comprehensive, AI-powered system that acts as a virtual support manager. It automates the entire process of handling incoming support tickets, ensuring speed, accuracy, and efficiency. Ticket Ingestion: The workflow starts when a new email arrives in your support inbox via the Gmail Trigger. AI Analysis & Triage: An OpenAI node acts as an intelligent agent, instantly analyzing the email to categorize the issue, assign a priority, and determine the customer's sentiment (e.g., "Angry," "Neutral"). Proactive Escalation: The workflow uses an If node to check for "Critical" priority or "Angry" sentiment. If these conditions are met, it takes a separate path to notify a manager immediately. Ticket Creation: Regardless of urgency, a Trello card is created for the ticket, including all the AI's analysis and the original email content. Automated Response: For low-priority tickets, a second If node and a Gmail node can send an automated, AI-generated response, completely freeing up your team. Performance Reporting: All ticket data, including the AI's analysis, is logged to a Google Sheets dashboard for real-time analytics and to track support trends. How to Set Up 🛠️ Import the Workflow: Copy the provided workflow JSON and import it into your n8n instance. Configure Credentials: Gmail: Add your OAuth2 credential for your support inbox. OpenAI: Add your API Key. Trello: Add your API Key and token. Slack: Add your Bot Token credential. Google Sheets: Add your OAuth2 credential. Customize Workflow Nodes: Node 1 (Gmail Trigger): Ensure this is connected to your official support email address. Node 2 (OpenAI): The prompt is pre-configured but can be customized to better fit your specific categories or tone. Node 4 (Trello): Replace [YOUR TRELLO BOARD LIST ID] with the list ID for new tickets on your board. Node 5 (Slack): Replace [MANAGER'S SLACK USER ID] and [YOUR SUPPORT TEAM SLACK CHANNEL ID] with the correct IDs. Node 9 (Google Sheets): Replace [YOUR SUPPORT DASHBOARD SPREADSHEET ID] with your spreadsheet ID and ensure your sheet columns match the workflow's data. Save & Activate: Once all settings and credentials are configured, save the workflow and click the "Inactive" toggle in the top-right corner to make it live.

⚙️ How It Works This workflow is a comprehensive, AI-powered system that transforms customer feedback into strategic business intelligence. It operates in a multi-stage process to ensure every review or mention is handled proactively and intelligently. 🔊 Multi-Channel Listening Triggers monitor platforms like Shopify, Twitter, and more for new reviews or mentions. 🧠 AI-Powered Analysis When feedback is detected, it's sent to an OpenAI node. The AI performs: Sentiment analysis: Positive, Negative, or Neutral Scoring & categorization (e.g., Shipping, Product Quality) Urgency assessment to prioritize response 🔀 Smart Conditional Logic An If node evaluates sentiment and urgency The workflow branches into customized response paths 🚨 Automated Escalation Negative or high-urgency feedback triggers: Slack alerts to the appropriate team channel Trello or Asana tasks for rapid issue resolution 📊 Centralized Logging All feedback + AI analysis is logged in Google Sheets Enables long-term trend analysis and strategic decision-making 💬 Proactive Engagement Positive reviews trigger a "Thank You" email Strengthens customer loyalty and boosts brand trust 🛠️ How to Set Up 1️⃣ Import the Workflow Copy and paste the workflow JSON into your n8n instance 2️⃣ Configure Credentials Set up access for: OpenAI**: Add your API Key Shopify**: Add your store's API credentials Slack**: Add Bot Token & Channel ID Trello**: Add API Key, Token, Board ID & List ID Google Sheets**: Add OAuth2 credentials 3️⃣ Customize Triggers Start with the Shopify Trigger node Add additional sources (e.g., Twitter, Webhook) and connect to the AI Analysis Node 4️⃣ Adjust AI Prompt In Node 2 (AI Analysis), update the prompt for: Custom business categories Specific analysis instructions 5️⃣ Update Conditional Logic In Node 4 (If Is Negative): Add conditions like urgency == "High" for critical issues 6️⃣ Replace Placeholders Replace all placeholder values: YOUR_SLACK_CHANNEL_ID YOUR_TRELLO_BOARD_ID YOUR_SPREADSHEET_ID ...with your actual credentials 7️⃣ Save & Activate ✅ Save your workflow 🔁 Click the Inactive toggle in the top-right corner to activate