===== 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/report-generator
TITLE: Report Generator: Excel, PDF & Slides
CATEGORY: Custom GPTs

DESCRIPTION:
Update Excel and Google Sheets trackers, generate PDF reports and create presentation slides automatically from your data.

TRY IT:
https://chatgpt.com/g/g-wbMHmk0Sz-gen-ai-apps-update-report-deck

---

WHAT THIS GPT DOES:

The Report Generator helps you manage and transform your data into various formats:
- Update Excel spreadsheets with new data
- Sync with Google Sheets trackers
- Generate professional PDF reports
- Create presentation slides automatically
- Transform data into visual presentations
- Keep documentation up-to-date

---

HOW TO USE:

Simple commands in natural language to manage your data and generate reports:

- Update Data: Share your tracker updates in natural language (e.g., new application items, changes) and the GPT will update the data
- Get PDF Report: Simply say "send me the report" to get the latest data in PDF format
- Get Presentation Deck: Say "send me the deck" to receive the data as presentation slides

---

TECHNICAL DETAILS:

The Report Generator uses Make.com (formerly Integromat) workflows and Google Apps Script for automation.

Workflow Architecture:
- Make.com webhook receives update requests
- First workflow updates Google Sheets with new data
- Second workflow triggers Google Apps Script for PDF generation
- Same workflow triggers another Apps Script for presentation deck creation
- Automated email distribution through Apps Script

Integration Components:
- Make.com for workflow automation
- Google Sheets for data storage
- Google Apps Script for document generation
- Automated email notifications

Current Use Case:
Automating the process of updating trackers, generating PDF reports, and creating presentation slides through a series of integrated Make.com workflows and Google Apps Scripts, with automatic email distribution of the generated documents.

---

NOTE:
This is a Custom GPT designed to help you manage your data and create various types of documentation. It can handle Excel files, Google Sheets, generate PDF reports, and create presentation slides automatically.

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