Automated Trello Card Creation from Google Forms Submissions - n8n Workflow

Markdown-formatted list of users:

Sales and Marketing Teams: Who rely on Google Forms for lead generation and need instant visibility in their sales pipeline (Trello).
Project Managers: Automating the intake of requests or new tasks into project boards.
n8n Automation Specialists: Looking for advanced examples of conditional logic (Switch, Code nodes) combined with API calls (HTTP Request n8n node) for complex data synchronization.
Businesses needing a reliable n8n workflow to eliminate manual data entry between forms and task management systems.

Manually transferring lead data from Google Forms into a project management tool like Trello is time-consuming and error-prone. This specialized n8n workflow solves this by providing a hands-free integration. Leveraging the robust capabilities of n8n, every new form submission detected in the Google Sheet is immediately processed. Not only does this automation create a new Trello card, but it also handles the complexities of mapping structured lead details (like Company Size, Lead Source, and Industry) to designated Trello Custom Fields using subsequent API calls. This sophisticated approach ensures that your Trello board is immediately populated with rich, actionable data, making this a highly valuable n8n template for lead management and efficient team triage.

This automation is triggered by the submission of a new form response, which appears as a new row in a connected Google Sheet.

1. Trigger: The Google Sheets Trigger n8n node, titled 'New Form', constantly monitors the specified spreadsheet for new rows.


2. Data Preparation: The 'Set Fields' n8n node extracts and standardizes the relevant form data (Name, Email, Company Size, Needs) from the Google Sheets output, making the data easily accessible for subsequent nodes.


3. Card Creation: The 'Create Card' Trello n8n node uses the prepared data to instantly create a new card on the target Trello board, setting the title and description based on the lead's name and needs.


4. Custom Field Setup: The 'Set IDs' n8n node stores the necessary Trello Custom Field IDs (which must be configured manually by the user) for various fields like Name, Email, and Company Size.


5. Basic Field Update: The 'Trello | Update Custom Fields' HTTP Request n8n node performs the first update, setting simple text fields (Name, Email, Company Name) on the newly created Trello card via the Trello API.


6. Conditional Mapping (Company Size): The 'Options for Company Size' Switch n8n node routes the workflow based on the submitted company size value. It branches into several 'Set' n8n nodes (e.g., 'Solo (1)', 'Small (2–10)'), each retrieving the corresponding Trello Custom Field Option ID (sizeOption). The subsequent 'Trello | Update Company Size' HTTP Request n8n node uses this dynamic option ID to update the Trello card's Company Size field.


7. Conditional Mapping (Lead Source): A similar logic is executed for the 'Lead Source' using a second Switch n8n node and multiple 'Set' n8n nodes, updating the lead source custom field.


8. Code-Based Mapping (Company Industry): For 'Company Industry', a Code n8n node, 'Options for Company Industry', handles the mapping logic, translating the incoming text value from the form into the appropriate Trello custom field Option ID (trelloIndustryOptionId).


9. Final Update: The 'Trello| Update Company Industry' HTTP Request n8n node concludes the process by applying the final custom field updates, ensuring the Trello card is fully enriched.

Markdown-formatted guide:

1. Import the n8n workflow: Copy the provided JSON code and import it into your n8n instance using the 'New' -> 'Import from JSON' option.


2. Google Sheets Credentials: Configure the 'New Form' Google Sheets Trigger n8n node. You will need a valid Google Sheets Trigger OAuth2 API credential set up to access the spreadsheet where your Google Form responses are collected.


3. Trello Credentials: Configure all Trello and HTTP Request n8n nodes with your Trello API credentials.


4. Trello Configuration (Crucial Step): You must create the corresponding Trello Board, List, and Custom Fields (for Name, Email, Company Size, Lead Source, Industry, etc.) beforehand.


5. Replace Placeholders: In the 'Create Card' Trello n8n node, replace {your-lis-id} with your Trello List ID. In the 'Set IDs' n8n node, replace all {field-id} placeholders with the IDs of your Trello custom fields. In the 'Set' n8n nodes and the 'Code' n8n node that handle mapping (e.g., 'Solo (1)', 'Youtube', 'Options for Company Industry'), replace all {option-id} placeholders with the correct Option IDs for the corresponding Trello Custom Field options. These IDs are necessary because this n8n template relies on exact custom field option matching.

Markdown-formatted details:

Google Sheets Trigger (New Form): This critical n8n trigger node initiates the entire automation when a new row is detected in the linked Google Form responses spreadsheet. It functions by polling for new data every minute.
Set (Set Fields): An essential n8n node used for structuring the incoming raw data from Google Sheets, assigning fields like 'Name', 'Email Address', and 'Company Name' to clean variables for easy access throughout the rest of the n8n workflow.
Trello (Create Card): Creates the initial Trello card. Key configuration involves dynamically setting the Card Name (using lead name and company) and Description using expressions referencing the data prepared by the previous Set n8n node.
Set (Set IDs): Stores hardcoded IDs for Trello Custom Fields (e.g., fieldName, fieldEmail, fieldCompanySize). These IDs are crucial for subsequent API calls made by the HTTP Request n8n nodes.
HTTP Request (Trello | Update Custom Fields, etc.): Multiple instances of this n8n node are used to interface directly with the Trello API (/1/cards/{id}/customFields) to update complex custom fields. It sends PUT requests with JSON payloads containing the required Custom Field ID and the new value.
Switch (Options for Company Size, Options for Lead Source): A core logic n8n node that directs the flow based on conditional values (Company Size, Lead Source) received from the form. This facilitates mapping text inputs to specific Trello Option IDs.

• Code (Options for Company Industry): A custom scripting n8n node utilized to handle complex conditional mapping for the Company Industry field, translating form answers into the specific Trello Option ID required for that Custom Field. This demonstrates advanced customization within the n8n workflow.