Google Sheets + Paystack
Send simple invoices in Paystack when new rows are added on Google Sheets
Send bulk invoices to your customers using a spreadsheet. This Zap sends a payable invoice to a customer's email address as soon as their details are updated in a row in a specified Google Sheets spreadsheet.
Send bulk invoices to your customers using a spreadsheet. This Zap sends a payable invoice to a customer's email address as soon as their details are updated in a row in a specified Google Sheets spreadsheet.
- When this happens...
New Spreadsheet Row (Team Drive)Triggers when a new row is added to the bottom of a Google Team Drive spreadsheet.
TriggerScheduledZapier checks for new data every 15 min on the Free plan - automatically do this!
Send Simple InvoiceSend a payment request to your customers
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapScheduledZapier 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.TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.HTTP MethodRequired
URLRequired
Query String Parameters
Headers
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
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Search from last row
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
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 ZapScheduledZapier 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 ZapScheduledZapier 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 ZapScheduledZapier 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 ZapScheduledZapier checks for new data every 15 min on the Free planStatus of SubscriptionRequired
Try ItTriggerThis is the start of your ZapScheduledZapier 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 app
No 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 ZapScheduledZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
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
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
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
ColumnsRequired
Row CountRequired
First Row
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 foundTransaction timeoutRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew 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 ZapScheduledZapier checks for new data every 15 min on the Free planStatus of TransactionRequired
Try ItTriggerThis is the start of your ZapScheduledZapier 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 app
About Google Sheets
Related categories
About Paystack
Related categories
Related Zap Templates
- Add new payment page transactions from Paystack to Google Sheets as spreadsheet rows
- Add failed Paystack transactions as rows on Google Sheets spreadsheets
- Add new Paystack transactions to spreadsheet rows in Google Sheets
- Add new top-paying Paystack customers to spreadsheet rows in Google Sheets
- Send simple invoices in Paystack for new spreadsheet rows in Google Sheets
- 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
Related Zap Templates
- Add new payment page transactions from Paystack to Google Sheets as spreadsheet rows
- Add new top-paying Paystack customers to 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