Update Report & Generate PDF and Slides
Update Excel and Google Sheets trackers, generate PDF reports and slides
Report Generator: Excel, PDF & 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.