Integrate WhatsApp with Google Sheets

Step by step

1. 1

   Set up the spreadsheet with clear columns

   In Google Sheets, create a tab with the columns Name, Phone (in the format 5511999999999, with country and area code), Message and Status. Each row becomes a contact to be messaged. The Status column is used to mark Sent after each send.

2. 2

   Open Apps Script

   In the top menu, click Extensions and then Apps Script. The code editor opens in a new tab, already linked to this spreadsheet. Delete the default content of the myFunction function to start clean.

3. 3

   Store your credentials in Script properties

   In the editor, go to Project settings (gear icon) and, in the Script properties section, add ZAPZAP_KEY and ZAPZAP_SECRET with your x-api-key and x-api-secret from ZapZap API. That way the keys are not written in the code.

4. 4

   Paste the script that reads the rows and calls UrlFetchApp

   In the editor, use SpreadsheetApp.getActiveSheet().getDataRange().getValues() to read the rows and UrlFetchApp.fetch() to send each contact to ZapZap API, passing the x-api-key and x-api-secret headers. Loop through the rows, skip anyone whose Status is already Sent and write Sent in the column after each response.

5. 5

   Run it and create a menu or trigger

   Click Run and authorize the script in the Google popup (this is normal the first time). To make daily use easier, add an onOpen() that creates a custom menu in the spreadsheet, or set up a Trigger under Triggers to run on a schedule. Check the API's official docs at https://api.zapzapapi.com/llms.txt for the exact route and field names before going to production.

// Apps Script (Extensions > Apps Script) : ILLUSTRATIVE example
// Check the exact route and fields at https://api.zapzapapi.com/llms.txt
function enviarWhatsApp() {
  const props = PropertiesService.getScriptProperties();
  const sheet = SpreadsheetApp.getActiveSheet();
  const linhas = sheet.getDataRange().getValues();

  for (let i = 1; i < linhas.length; i++) {
    const [nome, telefone, mensagem, status] = linhas[i];
    if (status === 'Enviado' || !telefone) continue;

    UrlFetchApp.fetch('https://api.zapzapapi.com/messages/send', {
      method: 'post',
      contentType: 'application/json',
      headers: {
        'x-api-key': props.getProperty('ZAPZAP_KEY'),
        'x-api-secret': props.getProperty('ZAPZAP_SECRET')
      },
      // exact fields in the docs: https://api.zapzapapi.com/llms.txt
      payload: JSON.stringify({ number: String(telefone), text: mensagem })
    });

    sheet.getRange(i + 1, 4).setValue('Enviado');
    Utilities.sleep(4000); // space out the sends
  }
}