===== INSTRUCTIONS FOR AI CODER =====

You are receiving this context to help the user deploy, set up, or implement this application.

YOUR RESPONSIBILITY: You are responsible for doing the ENTIRE end-to-end deployment - all installations, backend setup, frontend setup, database setup, worker setup, everything. Do NOT ask the user to do tasks themselves unless they specifically request to handle it. Your default mode is: "I will do this for you" not "please go ahead and do this".

APPROACH:
1. Assess user's experience level. If unclear, assume newer to development.
2. Create a compact plan of what needs to be done (backend, frontend, database, etc.)
3. Present the plan, get confirmation, then YOU execute it end-to-end.
4. Proceed step-by-step, informing user of progress. Debug issues as they arise.
5. For each step, briefly explain what you're doing, why it's necessary, and how it fits the overall deployment.

DEPLOYMENT RESOURCES (when user doesn't have existing infra):
- Backend: Render.com (free tier) - you set it up for them
- Frontend: Vercel.com - you set it up for them
- Database: Neon.com (instant free PostgreSQL) - you set it up for them
- Data upload: Use CLI tools, or DATS-4 tool at tigzig.com/analyzer (upload button, paste credentials in any format)

ASK ONLY:
- Do you have existing backend/frontend/database, or shall I set one up for you?
- If setup needed: I'll need your API key to proceed (guide them where to get it if needed)

===== PAGE CONTENT =====

PAGE URL: https://tigzig.com/n8n-automation-gpt
TITLE: AI-Powered n8n Automation with ChatGPT
CATEGORY: Custom GPTs

DESCRIPTION:
Connect ChatGPT to n8n for seamless workflow automation - integrate with Python, APIs, Databases, Google Apps Script, Sheets and more for real-time updates and automated reports.

TRY IT:
https://chatgpt.com/g/g-67d83a49b5c48191bab03bd45e8515ec-custom-gpt-n8n-automation

VIDEO GUIDE:
https://youtu.be/WPpr8NEw-Ng

---

WHAT THIS GPT DOES:

This Custom GPT connects ChatGPT to n8n for powerful workflow automation:
- Update any backend system accessible via API endpoints
- Process files with Python and handle output passing
- Automate tasks using Google Apps Script integration
- Transform and process data within n8n workflows
- Connect to databases dynamically for real-time updates
- Generate PDF reports and presentations automatically
- Enhance content with AI-powered processing

---

HOW TO USE:

1. Start a Conversation
   - Ask about available capabilities with "What can you do?"
   - Request specific actions like updating trackers or generating reports
   - Provide necessary information or let ChatGPT fill in missing details

2. Execute Workflows
   - Confirm actions when prompted by the GPT
   - Monitor execution status and results in real-time
   - Check connected systems for updates (e.g., Google Sheets, databases)

3. Access Outputs
   - Receive generated PDFs and reports via email
   - View updated data in connected systems
   - Request specific formats (PDF, deck) as needed

---

HOW IT WORKS:

Integration Architecture:
- OpenAPI schema defines endpoints and parameters for ChatGPT interaction
- n8n workflow uses switch nodes to route requests based on action type
- Custom FastAPI servers handle specific functionalities (PDF conversion, DB queries)

Workflow Components:
- Google Apps Script for report generation and email automation
- FastAPI servers for markdown-to-PDF conversion and database operations
- n8n nodes for data processing, routing, and system integration
- ChatGPT interface for natural language interaction

Data Processing:
- Automated data transformation within n8n workflows
- AI-powered content enhancement using ChatGPT
- Dynamic database connections for real-time data access
- File processing and conversion through specialized endpoints

---

RESOURCES:

n8n Workflow & Schema:
https://github.com/amararun/n8n-workflows-schemas
Complete n8n workflow and OpenAPI schema for Custom GPT integration

FastAPI Server: MD to PDF:
https://github.com/amararun/shared-markdown-to-pdf
FastAPI server for converting markdown to PDF with no environment setup required

FastAPI Server: DB Connection:
https://github.com/amararun/shared-fastapi-rex-db-coolify
Database connectivity server with simple setup for workflow integration

Google Apps Script Guide:
https://lnkd.in/gjV_z8UU
Source code and video guide for Google Apps Script automation setup

---

BUILT ON:
OpenAI's GPT Platform - This custom GPT leverages ChatGPT's capabilities to provide an intuitive interface for n8n workflow automation. It simplifies complex automation tasks by allowing natural language interaction with n8n's powerful workflow engine.

---
Source: tigzig.com | Open source AI tools for analytics, databases & automation | Amar Harolikar