API - Google Sheets - Sending lead data to Google Sheets

Step-by-step on how to send SprintHub data to a Google Sheets spreadsheet.

// SCRIPT FOR THE APPSCRIPT

function doPost(e) {
    var sheet = SpreadsheetApp.openById("ID_OF_YOUR_SPREADSHEET").getSheetByName("Sheet1");
    var data = JSON.parse(e.postData.contents);
    
    sheet.appendRow(data.values[0]);
    return ContentService.createTextOutput("Success").setMimeType(ContentService.MimeType.JSON);
}

// JSON TO SEND SPRINTHUB DATA

{
  "values": [
    [
      "{contactfield=firstname}", "{contactfield=lastname}", "{contactfield=email}", "{contactfield=mobile}"
    ]
  ]
}

Conclusion:

With these instructions, you will be ready to send any data available via the SprintHub token into a Google Sheets spreadsheet, via Automation Flow or any other automation block, whether from a CRM or even via Chatbot.