Google Sheets + Paystack
Add new Paystack transactions to spreadsheet rows in Google Sheets
Do you want to automate your reconciliation process? This Paystack-Google Sheets integration will listen for new successful Paystack transactions and automatically send the information to Google Sheets in a new row, storing them safely so you have all you need for reconciliation.
Do you want to automate your reconciliation process? This Paystack-Google Sheets integration will listen for new successful Paystack transactions and automatically send the information to Google Sheets in a new row, storing them safely so you have all you need for reconciliation.
- When this happens...
New TransactionTriggers when there's a new successful or failed transaction.
TriggerPollingZapier checks for new data every 15 min on the Free plan - automatically do this!
Create Spreadsheet RowCreate a new row in a specific spreadsheet.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Transaction timeoutRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
New Customer
Triggers when a new customer is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Status of TransactionRequired
Payment Page IDRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planStatus of TransactionRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNameRequired
DescriptionRequired
PriceRequired
CurrencyRequired
Unlimited
Quantity
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CodeRequired
TokenRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TransactionRequired
Reason
Amount to refund
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Terminal NameRequired
Whatsapp NumberRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TerminalRequired
Invoice IDRequired
Offline ReferenceRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.EmailRequired
First Name
Last Name
AmountRequired
Currency
DescriptionRequired
Invoice Number
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Order IdRequired
StatusRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Email AddressRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appTransaction referenceRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appCustomer's email addressRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNo Team Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Frozen Rows Count
Frozen Columns Count
Sheet Position
Hide Sheet
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Source RangeRequired
Destination RangeRequired
Paste Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Validation TypeRequired
Input Message
Strict Validation
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
Additional request headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
ColumnsRequired
Row countRequired
Output format
First row
ActionThis is an event a Zap performs.SearchFind existing data in your appSpreadsheet IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
Cancelled Subscription
Triggers when there's a an existing subscription is cancelled by you or the customer.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Chargeback
Triggers when a chargeback is logged against your account and awaiting your feedback
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Order
Triggers when a new order is made on your account
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Refund
Triggers when a refund happens on your account
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planStatus of SubscriptionRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planVt CodeRequired
Name
TargetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.EmailRequired
ChannelRequired
Callback UrlRequired
Number
Bank Code
State
City
Street
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CustomerRequired
Invoice Limit
Pick from the plans you created on your Paystack dashboard Required
Set the date for the first debit. Date format should be YYYY-MM-DD
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.EmailRequired
AmountRequired
Currency
Reference
Callback Url
Plan
Split Code
Ubaccount
Bearer
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Vt CodeRequired
TargetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CodeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TerminalRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appOrder IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appTransaction transfer codeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appAccount NumberRequired
Bank CodeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appNo Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
Use Timezone set up on the spreadsheet to format date values?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Condition TypeRequired
Background Color
Text Color
Bold Text
Italic Text
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
Spreadsheet Containing the Worksheet to CopyRequired
Worksheet to CopyRequired
Copy Worksheet Destination
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Confirm DeletionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Format TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SpreadsheetRequired
WorksheetRequired
New Sheet NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Sort by ColumnRequired
Sort OrderRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Row IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
About Google Sheets
Related categories
About Paystack
Related categories
Related Zap Templates
- Add failed Paystack transactions as rows on Google Sheets spreadsheets
- Add new top-paying Paystack customers to spreadsheet rows in Google Sheets
- Send simple invoices in Paystack when new rows are added on Google Sheets
- Send simple invoices in Paystack for new spreadsheet rows in Google Sheets
- Add new payment page transactions from Paystack to Google Sheets as spreadsheet rows
- Log new Paystack transactions and update rows in Google Sheets
- Add new Paystack subscriptions to Google Sheets as rows
- Create multiple Google Sheets rows for new Paystack transactions
- Create new Google Sheets rows for every new Paystack order
- Send simple invoices in Paystack for new or updated rows in Google Sheets
- Create multiple spreadsheet rows in Google Sheets for new payment transactions in Paystack
- Create multiple spreadsheet rows in Google Sheets for new orders in Paystack
- Update Google Sheets rows when new Paystack payment page transactions occur
- Track cancelled Paystack subscriptions by creating rows in Google Sheets
- Create rows in Google Sheets for new customers in Paystack
Related Zap Templates
- Add failed Paystack transactions as rows on Google Sheets spreadsheets
- Send simple invoices in Paystack for new spreadsheet rows in Google Sheets
- Add new Paystack subscriptions to Google Sheets as rows
- Send simple invoices in Paystack for new or updated rows in Google Sheets
- Update Google Sheets rows when new Paystack payment page transactions occur
- Add new top-paying Paystack customers to spreadsheet rows in Google Sheets
- Add new payment page transactions from Paystack to Google Sheets as spreadsheet rows
- Create multiple Google Sheets rows for new Paystack transactions
- Create multiple spreadsheet rows in Google Sheets for new payment transactions in Paystack
- Track cancelled Paystack subscriptions by creating rows in Google Sheets
- Send simple invoices in Paystack when new rows are added on Google Sheets
- Log new Paystack transactions and update rows in Google Sheets
- Create new Google Sheets rows for every new Paystack order
- Create multiple spreadsheet rows in Google Sheets for new orders in Paystack
- Create rows in Google Sheets for new customers in Paystack