Every sale lands in your spreadsheet.
Each time a payment succeeds, BCL adds a row to your Google Sheet with the date, order number, customer and amount. Sort, share and total your orders without typing them in.
Trusted by these companies
How it runs
Two nodes: the Payment Success trigger, joined to an Append to Sheet action.
Writes to Google Sheets. Connect your Google account under Platform Setup, then Integrations, then Google before you switch it on.
Make it yours in 4 steps
Four steps from the template to a sheet that fills itself.
Who it suits
Good for anyone who already runs their orders from a spreadsheet.
- Home bakers taking orders
- Donation drives
- Shops with packing teams
- Bookkeepers
Start from a ready-made automation
14 templates under Automations → Templates. One click creates the automation, switched off, so you can set your forms and messages before you turn it on.
- After payment Thank You Email on Payment Transaction SuccessSend email EmailSee the template
- After payment Wabot Payment Notification Transaction SuccessWhatsApp with receipt link WabotSee the template
- After payment SMS Niaga Payment + Subscriber Transaction SuccessSMSAdd to SMS Niaga group SMS NiagaSee the template
- After payment VIP Customer Detection Transaction SuccessCondition on amountTwo emails EmailSee the template
- After payment Google Sheets Transaction Log Transaction SuccessAdd a row Google SheetsSee the template
- Failed or cancelled Google Sheets Update Status Transaction Status ChangedUpdate the row Google SheetsSee the template
- Failed or cancelled Incomplete Payment Follow-up Transaction Status ChangedFailed emailCancelled email EmailSee the template
- Failed or cancelled Abandoned Cart WhatsApp Transaction Status ChangedWait 1 hourWhatsApp reminder WhatsAppSee the template
- Leads Webhook on Lead Submission Form SubmittedHTTP Request Your own systemSee the template
- Leads Lead Form SMS Notification Form SubmittedSMS to you SMSSee the template
- Events Event Registration Reminder Participant CreatedWait 1 dayWhatsApp reminder WabotSee the template
- Events WasapBot Event Reminder Participant CreatedWait 1 dayReminder WasapbotSee the template
- Events Certificate Wabot Notification Certificate GeneratedWhatsApp the link WabotSee the template
- Affiliates Welcome New Affiliate Affiliate JoinedWelcome emailAdd to Mail Niaga list Email + Mail NiagaSee the template
Questions owners ask
Common questions about the Google Sheets Transaction Log template.
My columns do not appear in the action. What is wrong?
BCL reads the column names from row 1 of the sheet. Type your headings in row 1, then click the refresh button next to Sheet.
Can BCL see my whole Google Drive?
No. BCL only asks for the files you pick. You choose your spreadsheet with the folder button in the Spreadsheet field.
Can I move a column later?
Avoid it. BCL saves each value against a column letter, so a moved column gets the wrong data. After any change to row 1, click refresh and check Column Values.
Step-by-step guides
Set it up with the help pages on docs.bcl.my.
Ready when you are.
Set up your first form today and try it out. When you are ready for real payments, connect Bayarcash and the same form goes live.