Integrated Webhooks - How to connect a Google Sheet to Sprinthub

In this article, we will explore how to connect a Google Sheets spreadsheet to Sprinthub using webhooks, facilitating the automatic and instant transfer of data between these platforms.

Steps to Connect a Google Sheets Spreadsheet to Sprinthub via Webhooks to send data to sprinthub

Here are the basic steps to set up this integration:

Preparation of the Google Sheets Spreadsheet:

• Make sure the spreadsheet contains the data needed to feed Sprinthub, such as lead details like Name, Lastname, email and whatsapp.

Configuration of the Webhook in Sprinthub:

• Access Sprinthub and go to the Webhook settings; for the integration we should leave it as follows:

• First it is necessary to create the keyword to connect the webhook, for example:

 'https://sprinthub-api-master.sprinthub.app/api/hook/google-sheets?i=g4&access_token=tdtcX1Hrw5MmTzQiLVA8_AtMA6H-FYA-uM_gnoYPVLS25A4VNT'

• Request body: What you want to receive from your spreadsheet, in our case Name, lastname, email and whatsapp.

Remember to put identifiers so that there is no duplication of leads.

• Automatic lead creation enabled with the tokens to perform the creation.

Configuration of the Google Sheets Spreadsheet:

• Open the spreadsheet and navigate to "Extensions" > "Apps Script". A screen will open where you can put your script for how the data will be sent to the webhook.

• In the Script Editor, write a function that will be triggered whenever a new row is added to the spreadsheet. This function can be configured to send a POST to the Sprinthub webhook URL, with the project's relevant data.

Below is the example code:

function enviarDadosParaWebhook() {
  var url = 'https://sprinthub-api-master.sprinthub.app/api/hook/google-sheets?i=g4&access_token=tdtcX1Hrw5MmTzQiLVA8_AtMA6H-FYA-uM_gnoYPVLS25A4VNT';

  var planilha = SpreadsheetApp.getActiveSpreadsheet();
  var abaAtiva = planilha.getSheetByName('Leads '); 

  if (!abaAtiva) {
    Logger.log('The specified sheet was not found.');
    return;
  }

  var dados = abaAtiva.getDataRange().getValues();

  // Remove the header row
  dados.shift(); // Remove the header

  // Filter empty or incomplete rows
  dados = dados.filter(function(row) {
    // Check if all fields are filled (assuming name, lastname, email and whatsapp are in the first four columns)
    return row[0] !== '' && row[1] !== '' && row[2] !== '' && row[3] !== '';
  });

  // Logging for debugging
  Logger.log('Filtered data:', dados);

  // Preparing data to send in the payload
  var payload = {
    'dados': dados.map(function(row) {
      return {
        'name': row[0],
        'lastname': row[1],
        'email': row[2],
        'whatsapp': row[3]
      };
    })
  };

  // Logging for debugging
  Logger.log('Payload sent:', payload);

  var options = {
    'method' : 'post',
    'contentType': 'application/json',
    'payload' : JSON.stringify(payload),
    'muteHttpExceptions': true  
  };
  }

Test and Debugging

• After testing and debugging the integration, and verifying that everything is correct. Run and check if the call was made in sprinthub.

• With the webhook successfully connected, we can add triggers, where editing the spreadsheet will be sent to the webhook files:

Disable automatic saving; with it enabled any row made will be POSTed to the webhook.

• Be aware of adjustments or improvements that may be necessary based on practical use.

Conclusion

Integrating a Google Sheets spreadsheet with Sprinthub via webhooks not only simplifies the workflow but also improves accuracy and efficiency in project management. With proper automation, you can transform how your teams collaborate and perform tasks, making the most of the capabilities of these powerful productivity and management tools.