Google Calendar and Trello integration

📋 Overview This n8n workflow automatically converts your Google Calendar events for the current day into Trello cards every morning at 8 AM. It fetches all calendar events for the day, filters out routine events (like Lunch or Check email), and creates neatly formatted Trello cards with a predefined meeting notes template. Perfect for professionals who want to keep their daily meetings and tasks synced with their Trello board. ⚙️ Key Features 🕗 Runs daily at 8 AM (configurable via Cron node) 📅 Fetches all Google Calendar events for the current day 🚫 Skips routine/repetitive events (Lunch, Check email, etc.) 🧩 Creates Trello cards with structured meeting notes 🔗 Includes event URL and due date in Trello card 🧠 Customizable filters and templates for full control 🧱 Workflow Steps Run Daily at 8 AM (Cron Node) Automatically triggers the workflow every morning at 8:00 AM. You can adjust the time as needed. Calculate Today's Date Range (Function Node) Generates the ISO-formatted start and end times for the current day (00:00–23:59). These values are passed to the Google Calendar node for querying events. Fetch All Today's Calendar Events (Google Calendar Node) Fetches all events scheduled for today using your Google account. The calendar email ([email protected]) should be replaced with your actual email. Process Events One by One (SplitInBatches Node) Splits the list of events into single items for individual processing. Extract Event Details for Trello (Set Node) Maps each event’s details (summary, description, start time, and URL) into structured fields ready for Trello card creation. Filter Out Routine Events (If Node) Skips over common recurring events (like “Check email,” “Lunch,” “Wrap Up & Clear Desk,” or “Beers and Griping”). You can customize this list as needed. Create New Trello Card with Template (Trello Node) For non-filtered events, creates a new Trello card using a predefined meeting notes template. Includes: Title: Event summary Due date: Event start time Description: Preformatted meeting notes layout Source URL: Event link from Google Calendar Skip Filtered Event (NoOp Node) Handles skipped events gracefully without performing any action. 🧰 Setup Instructions Add Credentials Add Google Calendar OAuth2 credentials in n8n. Add Trello API credentials in n8n. Replace Placeholder Values Update the calendar email in the Google Calendar node. Add your Trello board and list IDs in the Trello node. Optional Customizations Modify the Cron node to change trigger time. Edit the Trello card template to match your meeting format. Add labels using idLabels in the Trello node. Adjust the filter conditions for different recurring tasks. 🧠 Example Use Case Imagine you have daily meetings in your Google Calendar. Each morning, this workflow: Collects all your events for the day. Skips unimportant ones (like lunch breaks). Automatically adds Trello cards for real meetings, each with a structured template for you to take notes and assign next steps. 🧾 Example Trello Card Template Title: Meeting with Client A Due Date: 2025-11-11T10:00:00Z Description: Meeting purpose (Integrations, Playbooks, UI Issues, Project): Task Next Steps (Task, Assigned to, Checkpoint Date): Task Decisions Made (What, Why, Impacts): Task Discussion (Items/Knowledge Shared): Task ✅ Requirements Google Calendar OAuth2 credentials Trello API credentials Active Google Calendar with events A Trello board/list to create cards in 📌 Notes You can adjust the workflow to run multiple times a day if needed. You can integrate Slack or email notifications for newly created cards. The workflow is lightweight and suitable for daily automation tasks. ✨ Tip: Combine this with n8n’s Slack or Notion integrations to get a full daily planning system that syncs your meetings, notes, and tasks automatically!

Overview This workflow automatically creates Trello cards for your daily Google Calendar events, helping you turn meetings and tasks into actionable Trello items without any manual effort. It ensures that your daily schedule seamlessly becomes a visual task board—ready for tracking, collaboration, and completion. Use Cases This automation is ideal for busy professionals and teams who rely on both Calendar and Trello. It saves time by syncing your events as organized Trello cards automatically. Meeting Task Management:** Automatically create Trello cards for each calendar meeting, making it easy to add notes, next steps, and action items. Daily Planning:** Every morning, your Trello board updates itself with that day’s meetings and key events. Team Visibility:** Share daily priorities with your team by linking Google Calendar to a shared Trello board. Good to Know This workflow runs automatically every day at 8 AM, ensuring your Trello board always reflects your day’s schedule. Required Setup:** You must have valid connections for Google Calendar and Trello in n8n. The workflow uses your Google Calendar to fetch events from the current day. Recurring Events:** Routine meetings such as “Lunch” or “Check email” are automatically filtered out. Environment Variables:** If you’re using a Trello link source, ensure the BASE_URL environment variable is defined (optional). How It Works This process begins with a daily trigger and flows through your Google Calendar, processing each event and creating a Trello card for actionable ones. Trigger Every Day at 8 AM – Starts the workflow automatically each morning. Get Start & End of Day – Calculates today’s date range (00:00 to 23:59). Get Today’s Events (Google Calendar) – Fetches all events within that time range. Split Events In Batches – Processes each calendar event individually. Set Trello Card Details – Extracts event details such as title, description, and time. Remove Recurring Tasks – Filters out repetitive or routine events. Create Trello Cards – Creates a new Trello card for each relevant event. Delete Task (No-Op) – Skips events that were filtered out. How to Use Follow these steps to set up and test your automation: Configure Credentials: Connect your Google Calendar OAuth2 and Trello API credentials in n8n. Verify Workflow Settings: Ensure the “Trigger Every Day at 8 AM” node matches your desired time zone. Test the Workflow: Run manually or wait for the next scheduled time to verify Trello card creation. Check Trello Board: Confirm that events appear as cards with correct names, descriptions, and due dates. Adjust Filtering: Modify the “Remove Recurring Tasks” node to include or exclude more recurring events if needed. Requirements Google account with access to Google Calendar Trello account with access to the target board Proper OAuth2 authentication for both integrations Workflow must remain active in n8n for automation to run Customizing this Workflow This flow can be easily extended for more advanced needs: Add Labels:** Apply Trello labels automatically based on event categories. Include Participants:** Append event attendees to Trello card descriptions. Sync Back:** Add a “Mark Done” automation that updates Google Calendar events when Trello cards are completed. Slack Integration:** Notify your team in Slack when a new Trello card is created.

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

This workflow will allow you at the beginning of each day to copy your google calendar events into Trello so you can take notes, label, or automate your tasks. When deploying this, don't forget to change: Label ID for meeting type under "Create Trello Cards". You should be able to find instructions Here on how to find the label ID. Description for Trello cards under "Create Trello Cards". I currently pull in notes but it should be simple to change to pull the Gcal description instead. You can change the trigger time to fire at a different time.