Add Project Tasks to Google Sheets with GPT-4.1-mini Chat Assistant
    100%
    Automation
    0(0 reviews)
    1362 downloads

    Add Project Tasks to Google Sheets with GPT-4.1-mini Chat Assistant

    NM

    Curated by n8n Markets team

    Last updated: March 8, 2026

    Let your team create, track, and manage project tasks through natural conversation. This workflow uses an AI Project Manager Agent that chats with users, gathers the task details it needs, and automatically adds them to a Google Sheet. --- ## ✅ What this template does - Lets you chat naturally with an AI to add new project tasks - Automatically detects if the user wants to *create* or *update* an item (updates coming soon) - Collects `Task`, `Description`, and `Status` fields — allows “don’t know” responses - Appends new entries directly into your connected Google Sheets - Provides real-time confirmation when the task is added > Trigger: n8n Chat Trigger > Integrations: OpenAI GPT-4.1-mini + Google Sheets (OAuth2) --- ## 🧠 How it works 1. The Chat Trigger starts a chat with the user. 2. The AI Project Manager Agent asks guiding questions to gather the task name, description, and status. 3. When all fields are complete (`all Info = Yes`), the data is passed to the Google Sheets node. 4. The task is automatically added to your project tracker sheet. 5. The AI confirms completion in chat. --- ## ⚙️ Setup instructions ### 1. Connect OpenAI 1. Go to [OpenAI Platform](https://platform.openai.com/api-keys) → copy your API key. 2. In n8n, create New Credentials → OpenAI API and paste your key. 3. Ensure your account has active billing under [OpenAI Billing](https://platform.openai.com/settings/organization/billing/overview). ### 2. Connect Google Sheets (OAuth2) 1. In n8n → Credentials → New → Google Sheets (OAuth2) 2. Sign in with your Google account and grant access. 3. Select your spreadsheet and tab (e.g., “Tasks”) when prompted. - Example sheet: `https://docs.google.com/spreadsheets/d/1pbK-B-Q9p8fVjxJIsjEVrAfRgqEPCeYw8rZojZPAb84/edit` ### 3. Test your chat Click Execute Workflow, then start chatting: > “Add a task for reviewing the project report tomorrow.” The agent will ask questions if needed, then add the record to your sheet. --- ## 🧩 Customization ideas - Add a Date Added or Assigned To column to the Google Sheet - Integrate with Slack or Outlook to message assigned users - Extend the agent to support task *updates* and *deletes* - Replace Google Sheets with Airtable or Notion if preferred --- ## 🪄 Requirements - n8n version ≥ 1.100 - OpenAI API key - Google Sheets account --- ## 📬 Contact Need help customizing this (e.g., adding deadlines, linking to Notion, or Slack notifications)? - 📧 robert@ynteractive.com - 🔗 [Robert Breen](https://www.linkedin.com/in/robert-breen-29429625/) - 🌐 [ynteractive.com](https://ynteractive.com)

    What's Included

    • Complete n8n workflow template with 0 nodes. Ready to import and customize.

    Requirements

    n8n instance (self-hosted or cloud). credentials.

    How to Use

    1. Download the workflow JSON 2. Import into your n8n instance 3. Configure credentials for 4. Activate and enjoy automation

    How to import this template into n8n

    1. Download the workflow JSON file from this page.
    2. In n8n, open Workflows, create a new workflow and choose Import from File.
    3. Open each node that shows a warning and connect your own credentials.
    4. Run the workflow once manually to check the output before you activate it.
    Included in Pro
    • Importable n8n workflow JSON file
    • Download with Builder Pro or Agency Unlimited
    • Built for n8n v1.0++
    • Setup time: 15-30 min

    Included in Builder Pro — $19/mo, 4,177 premium workflows

    Before you activate

    Templates are reviewed before they are listed. Test with your own credentials and data before running it in production.

    Updated Mar 2026
    v1.0
    SSL
    Secure
    GDPR

    100% Secure Checkout

    Refund requests within 7 days of a new subscription

    Dependencies & Requirements

    Google Sheets
    Data

    ⚠️ 1 service require credentials. Make sure you have accounts set up before importing.

    Reviews

    0

    No reviews yet

    See all 0 reviews ↓
    —

    0 reviews

    5★
    0
    4★
    0
    3★
    0
    2★
    0
    1★
    0

    No reviews yet.

    Questions & Answers

    0

    Log in to ask a question.

    No questions yet. Be the first to ask!

    People Also Bought