API - Google Sheets - Sending lead data to Google Sheets

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

SCRIPT FOR THE APPSCRIPT

function doPost(e) {
    var sheet = SpreadsheetApp.openById("YOUR_SPREADSHEET_ID").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 DATA FROM SPRINTHUB

{
  "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.