Google Sheets Integration



Automatically sync Suhep data to Google Sheets for custom reporting and analysis.

Via Zapier (No Code)



  • 1.Create a Zap: Suhep → Google Sheets
  • 2.Trigger: New Ticket Created
  • 3.Action: Create Spreadsheet Row
  • 4.Map fields: subject, status, priority, category, created date, customer email


    • Via API (Custom)



    Use the Suhep API to pull data into Sheets:

  • 1.Create a Google Apps Script
  • 2.Use UrlFetchApp.fetch() to call Suhep API
  • 3.Parse the JSON response
  • 4.Write rows to your spreadsheet
  • 5.Set a time-based trigger to run daily




    • | Column | Data | |--------|------| | Ticket ID | ticket.id | | Subject | ticket.subject | | Status | ticket.status | | Priority | ticket.priority | | Category | ticket.category | | Customer | ticket.customerEmail | | Created | ticket.createdAt | | Resolved | ticket.updatedAt | | AI Resolved | ticket.aiResolved |

    Use Cases



  • •Weekly team performance reviews
  • •Monthly executive reports
  • •Trend analysis in Google Data Studio
  • •Custom dashboards with Google Charts