Appends a new row to a Google Sheet each time a payment event fires — no OAuth or Google account link required. SmartPay posts to a Google Apps Script web app URL that you deploy from your own Google account, giving you full control over which columns to write.

Getting the Apps Script URL

  1. Open your Google Sheet, then go to Extensions → Apps Script. This opens the Google Apps Script editor.

  2. Replace the default code with the template below, replacing YOUR_SHEET_ID with your sheet's ID (the long string between /d/ and /edit in the URL).

  3. Click Deploy → New deployment → Web app. Set Execute as: Me and Who has access: Anyone, then click Deploy.

  4. Copy the Web app URL from the confirmation dialog.

[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object]

Set up in SmartPay

BlockNote image

  1. Go to SmartPay → Extensions and toggle Google Sheets on.

  2. Click the gear icon to open Settings → Extensions → Google Sheets.

  3. Paste the Apps Script web app URL into Apps Script Web App URL.

  4. Select which payment events (Completed, Failed, Refunded) should trigger a row write.

  5. Click Save Changes.

BlockNote image