Receive a Weekly Summary of Closed Gorgias Support Tickets

This step automatically triggers the workflow every Sunday at midnight to analyze the past week's closed tickets. The schedule uses a weekly cron pattern that runs without any intervention from you. No configuration is needed - the timing is pre-set to give you a fresh analysis at the start of each week with data from the previous 7 days.

This step automatically queries your "Closed Gorgias Support Tickets" database table to pull tickets that were closed within the last week. The query uses date filtering to select only tickets with a "Closed Date" between one week ago and now. The system handles the date calculations and SQL query execution automatically, gathering all the ticket data that will be analyzed in the next steps.

This step processes the retrieved support tickets and extracts only the message content for AI analysis. The custom JavaScript code maps through each ticket record, pulls out the "Message" field, and converts the collection into a JSON string format. This cleaning process ensures the AI receives structured, readable text data instead of raw database records with metadata that could confuse the analysis.

const Mesa = require('vendor/Mesa.js');

/**
 * A Mesa Script exports a class with a script() method.
 */
module.exports = new class {

  /**
   * Mesa Script
   *
   * @param {object} payload The payload data
   * @param {object} context Additional context about this task
   */
  script = (payload, context) => {
    const vars = context.steps;
    
    // Get support tickets
    let supportTickets = vars.data_1;

    // Pull out the messages
    let supportTicketMessages = supportTickets.map(item => ({ "Message": item.Message }));

    // JSON stringify the messages
    let supportTicketMessagesString = JSON.stringify(supportTicketMessages);

    // We're done, call the next step!
    Mesa.output.next({support_ticket_messages_string: supportTicketMessagesString});
  }
}

This step sends the formatted ticket messages to an AI system with instructions to analyze the text and identify key trends, customer insights, or concerns. The AI processes all the message content from the week's closed tickets and generates a comprehensive analysis highlighting common issues, customer sentiment patterns, and actionable insights. The temperature is set to 1 for balanced creativity and accuracy in the analysis.

You'll configure the recipient email address where you want to receive your weekly support ticket summary. The email will have "Weekly Summary" as the subject line and contain the AI's analysis of trends and insights from your closed tickets. Enter your email address in the "What is your email address?" field - this is the only configuration required for the entire workflow.