Paystack with Google Sheets for Simple Reporting

1. Create a new Zap in Zapier.
2. Trigger: search for "Paystack" and select the charge.success event.
3. Action: select Google Sheets → Create Spreadsheet Row.
4. Map Paystack fields to sheet columns: Reference → Column A, Amount → Column B (divide by 100 for major unit), Customer Email → Column C, Channel → Column D, Date → Column E.
5. Test and turn on the Zap. Every successful Paystack payment will now add a row to your sheet.

For a free, code-based option, deploy a Google Apps Script web app that receives Paystack webhooks:

// In Google Apps Script (Tools > Script Editor in your Google Sheet)
function doPost(e) {
  var payload = JSON.parse(e.postData.contents);

  // Basic event filter — in production, validate HMAC here
  if (payload.event !== 'charge.success') {
    return ContentService.createTextOutput('ignored');
  }

  var txn = payload.data;
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  sheet.appendRow([
    txn.reference,
    txn.amount / 100,          // convert from minor unit
    txn.currency,
    txn.customer.email,
    txn.channel,
    txn.paid_at,
    txn.gateway_response,
  ]);

  return ContentService.createTextOutput('ok');
}

Deploy as Web App (Execute as: Me, Who has access: Anyone). Copy the deployment URL and add it to Paystack webhook settings. Paystack will POST to your Apps Script on every event.

For full reconciliation, see Paystack with Xero or QuickBooks.

Sign up for the McTaba newsletter