# Update Excel/Sheets trackers, generate PDF reports and slides

Update Excel/Sheets trackers, generate PDF reports and slides

## Links
- App: https://chatgpt.com/g/g-wbMHmk0Sz-gen-ai-apps-update-report-deck
- Docs: https://tigzig.com/app-documentation/report-generator.html

## Tags
chatgpt-integrations

## Documentation

    - [Try the GPT](https://chatgpt.com/g/g-wbMHmk0Sz-gen-ai-apps-update-report-deck)

# Update Report & Generate PDF and Slides

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

## 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.