In a demonstration of the expanding capabilities of OpenAI's custom GPTs, a new workflow showcases how agents can be built to automate the generation of weekly product metrics reports. The process, presented by OpenAI's Harsha, highlights the integration of data sources, intelligent processing through custom skills, and scheduled execution to deliver consistent, actionable insights.
This approach moves beyond simple data retrieval, enabling agents to perform complex analysis and present findings in a standardized format, significantly reducing manual effort for product teams.
The full discussion can be found on OpenAI Youtube's YouTube channel.
The 'Tally' Agent: Automating Metrics Reporting
The core of the demonstration is an agent named 'Tally', designed to read data from a Google Sheet, compute weekly product metrics by plan group, and draft a clear weekly update. The agent's metrics focus on the last 7 days (L7D) and week-over-week comparisons.
The agent's setup involves defining its role, specifying the data it needs to access, and integrating with relevant tools. For Tally, the primary data source is a Google Sheet, which it needs to access to gather the necessary information. The demonstration shows the process of connecting the agent to Google Drive, a crucial step for any agent that relies on spreadsheet data.
Connecting Data Sources: Google Drive Integration
The video illustrates the selection of Google Drive as a tool for the Tally agent. This integration allows the agent to search, reference, and even edit files directly from a user's Google Drive. The choice between an 'end-user account' and an 'agent-owned account' is presented, with the latter offering a more streamlined approach for shared agent functionality, allowing a single account for all users of the agent.
This capability is fundamental for automating data-driven tasks, as it removes the manual step of exporting and importing data into different systems. By directly accessing Google Sheets, the agent can ensure it is always working with the most up-to-date information.
Enhancing Agent Capabilities with ChatGPT Skills
A key aspect of building more effective agents is the ability to add custom skills. In this demonstration, ChatGPT is utilized to create a 'metrics standardization workflow' skill. This skill is designed to make the agent more reliable by providing reusable logic for several critical tasks:
- Validating the sheet schema.
- Mapping plan types (e.g., Free, Self-Serve, Enterprise).
- Identifying the latest snapshot and prior comparison snapshot.
- Computing weekly metrics consistently.
- Surfacing data quality caveats when inputs are missing or ambiguous.
The process involves prompting ChatGPT with the desired functionality, and it generates the necessary code and instructions. The agent then uses this skill to ensure that metrics are processed and reported uniformly, reducing the potential for errors or inconsistencies that can arise from manual analysis.
Automated Reporting Through Scheduling
To ensure the weekly reports are generated consistently and without manual intervention, the agent is scheduled to run automatically. The demonstration shows how to set up a weekly schedule, specifying the day and time for the report to be generated. This feature transforms the agent from a tool that can be prompted on demand to a proactive system that delivers regular updates.
The agent is configured to run every Friday at 12:00 PM. This automation ensures that the team receives their weekly analysis promptly, without needing to remember to initiate the process. The system also provides a log of all scheduled activities, offering transparency and a record of when reports were generated.
Activity Logs: Transparency and Debugging
The 'Activity' tab within the agent's interface serves as a detailed log of its operations. This includes records of completed tasks, errors encountered, and the time taken for each operation. For the Tally agent, the activity log shows instances of 'Run command: Task completed', indicating successful report generation.
This detailed history is invaluable for debugging and understanding the agent's behavior. If a report is not generated correctly, the activity log can pinpoint where the process failed. It also provides metrics on the agent's performance, such as the time taken to complete a task. In the example shown, one run took 4 minutes and 30 seconds, demonstrating the efficiency of the automated workflow.
The Output: A Standardized Weekly Update
The ultimate output of the Tally agent is a formatted weekly update, ready to be shared with the team. The demonstration shows the final Google Doc report, which includes an executive summary, notable changes, a data table, and charts visualizing key metrics. The agent not only processes the data but also formats it into a professional and easily digestible report.
The report details enterprise commerce metrics, user growth, and average session times across different segments. The agent's ability to create charts and synthesize this data into a narrative format is a significant step towards full automation of business intelligence tasks.
Building More Capable Workspace Agents
The entire process illustrates the power of OpenAI's agents in transforming how teams interact with their data. By building custom agents, organizations can:
- Answer complex team data questions.
- Create recurring reports automatically.
- Synthesize feedback and identify trends.
These capabilities are now available in ChatGPT Business, Enterprise, and Edu, signaling a move towards more sophisticated AI-powered workflow automation for businesses.
