GoCardless + Google Sheets
Generate GoCardless payments from new Google Sheets rows
Automate your mandate payment collection and get paid on time. This integration will automatically create a mandate payment as soon you add a new row in a specified Google Sheets spreadsheet. All you need is an existing mandate and your payment information.
Automate your mandate payment collection and get paid on time. This integration will automatically create a mandate payment as soon you add a new row in a specified Google Sheets spreadsheet. All you need is an existing mandate and your payment information.
- When this happens...
New Spreadsheet RowTriggers when a new row is added to the bottom of a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Create Direct Debit PaymentCreate a direct debit payment. This can only be created when linked to a mandate
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 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
New Payment Authorisation Request
Triggers when a new mandate or instant bank payment (IBP) has been initiated and billing information is requested.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Mandate Activated
Triggers when a payment mandate is activated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Mandate Created
Triggers when a payment mandate is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Failed Payment
Triggers when a payment fails.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Payment Submitted
Triggers when the payment has been submitted to the banking system for processing, and can no longer be cancelled.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.CurrencyRequired
GoCardless Customer ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Payment AmountRequired
CurrencyRequired
DescriptionRequired
GoCardless Customer ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Name
Payment AmountRequired
CurrencyRequired
Interval UnitRequired
Interval
GoCardless Mandate ID
GoCardless Customer ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Billing Request IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appCustomer Bank Account IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appPayment IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appPayout IDRequired
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 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 foundPayment Authorisation Approved
Triggers when a customer successfully sets up their billing information.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Mandate Cancelled
Triggers when a payment mandate is cancelled (manually by a customer or because the billing period ended).
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Payment Confirmed
Triggers when a payment has been collected, but not yet paid out to your account.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Payment Paid Out
Triggers when a payment has been paid out to your account.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Payout Paid
Triggers when a payout has been paid to your account.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Payment AmountRequired
CurrencyRequired
DescriptionRequired
GoCardless Customer ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Payment AmountRequired
CurrencyRequired
Charge Date
Description
Custom Payment Reference
GoCardless Mandate ID
GoCardless Customer ID
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.Customer IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appMandate IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appPayout IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app
About GoCardless
Related categories
About Google Sheets
Related categories
Related Zap Templates
- Record GoCardless failed payments in Google Sheets rows
- Add new GoCardless completed billing requests to Google Sheets
- Add newly cancelled GoCardless mandates to Google Sheets rows
- Create GoCardless mandates from new Google Sheets rows
- Create GoCardless instant payments from new Google Sheets rows
- Create new rows in Google Sheets for GoCardless payment authorisations
- Create Google Sheets rows for new GoCardless mandates
- Add new GoCardless payments to Google Sheets rows when paid out
- Secure GoCardless payments and create new rows in Google Sheets
- Manage new or updated Google Sheets rows with custom actions in GoCardless
- Create multiple rows in Google Sheets for every new payment paid out in GoCardless
- Record failed GoCardless payments by creating multiple rows in Google Sheets instantly
- Create multiple rows in Google Sheets for new mandates in GoCardless
- Create a new row at the top of Google Sheets for each new mandate in GoCardless
Related Zap Templates
- Record GoCardless failed payments in Google Sheets rows
- Create GoCardless mandates from new Google Sheets rows
- Create Google Sheets rows for new GoCardless mandates
- Manage new or updated Google Sheets rows with custom actions in GoCardless
- Create multiple rows in Google Sheets for new mandates in GoCardless
- Add new GoCardless completed billing requests to Google Sheets
- Create GoCardless instant payments from new Google Sheets rows
- Add new GoCardless payments to Google Sheets rows when paid out
- Create multiple rows in Google Sheets for every new payment paid out in GoCardless
- Create a new row at the top of Google Sheets for each new mandate in GoCardless