Airwallex + Google Sheets
Create beneficiaries in Airwallex from new or updated Google Sheets rows
Need to create multiple transfer contacts and beneficiaries? With this integration, you can easily create transfer contacts and beneficiaries in Airwallex. Once it's active, whenever there is a new or updated Google Sheets row, a corresponding beneficiary will be created in Airwallex automatically.
Need to create multiple transfer contacts and beneficiaries? With this integration, you can easily create transfer contacts and beneficiaries in Airwallex. Once it's active, whenever there is a new or updated Google Sheets row, a corresponding beneficiary will be created in Airwallex automatically.
- When this happens...
New or Updated Spreadsheet RowTriggers when a new row is added or modified in a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Create BeneficiaryCreates a Beneficiary.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Dont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDont Change Sheet Structure
No 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.Drive
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
Include Grid Data
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 foundMonitored CardRequired
Alert ThresholdRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
Card Transaction Failed
Triggers when a card transaction fails.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planLow Account Balance Alert
Triggers when the account balance for specified currencies goes below a threshold.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planCardRequired
Transaction Status
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Payment Acceptance Customer (Instant)
Triggers instantly when a new Payment Acceptance customer is created in your Airwallex account.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Company Name
Entity TypeRequired
First Name
Last Name
Date of Birth
Nickname
Transfer MethodsRequired
Personal Email
Personal Mobile Number
Street AddressRequired
CityRequired
StateRequired
PostcodeRequired
Country CodeRequired
Account CurrencyRequired
Account NameRequired
Account NumberRequired
Account Routing Type
Account Routing Value
Other Account Routing Type
Other Account Routing Value
Bank country codeRequired
Bank Name
Local Clearing System
Swift Code
Iban
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Email
First Name
Last Name
Business Name
Phone Number
Merchant Customer ID
Street
City
State
Postcode
Country Code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CustomerRequired
Name
Email
Phone Number
Customer Type
Nickname
Description
Tax Identification Number
Default Billing Currency
Default Legal Entity ID
Street
City
State
Postcode
Country Code
Metadata
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Status
Subscription Id
From Created At
To Created At
ActionThis is an event a Zap performs.SearchFind existing data in your appBilling Customer Id
Status
Payment Status
Invoice Number
ActionThis is an event a Zap performs.SearchFind existing data in your appMerchant Customer Id
Email
From Created At
To Created At
ActionThis is an event a Zap performs.SearchFind existing data in your app
Dont Change Sheet Structure
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Dont Change Sheet Structure
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 foundApproaching Card Limit (Instant)
Triggers instantly when a card's remaining spending limit falls below a configured threshold.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Card Transaction Failed (Instant)
Triggers instantly when a card transaction fails.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Beneficiary
Triggers when a new beneficiary is added to your Airwallex account.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planCardRequired
Transaction Status
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Payment Acceptance Customer
Triggers when a new Payment Acceptance customer is created in your Airwallex account.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planTransaction Status
Source Type
Page Size
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planCreate Cardholder
Creates a cardholder.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Beneficiary IDRequired
Company Name
Entity Type
First Name
Last Name
Date of Birth
Nickname
Transfer Methods
Personal Email
Personal Mobile Number
Street Address
City
State
Postcode
Country Code
Account Currency
Account Name
Account Number
Account Routing Type
Account Routing Value
Other Account Routing Type
Other Account Routing Value
Bank country code
Bank Name
Local Clearing System
Swift Code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CustomerRequired
Email
First Name
Last Name
Business Name
Phone Number
Merchant Customer ID
Street
City
State
Postcode
Country Code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Email
From Created At
To Created At
ActionThis is an event a Zap performs.SearchFind existing data in your appStatus
Request Id
Short Reference Id
Transfer Currency
From Created At
To Created At
ActionThis is an event a Zap performs.SearchFind existing data in your appBilling Customer Id
Status
Recurring Period
Recurring Period Unit
From Created At
To Created At
ActionThis is an event a Zap performs.SearchFind existing data in your app
About Airwallex
Related categories
About Google Sheets
Related categories
Related Zap Templates
- Create spreadsheet rows in Google Sheets for new Airwallex transactions (payouts, deposits, and conversions)
- Create Airwallex cardholders from new or updated Google Sheets rows
- Record new Airwallex transactions in Google Sheets rows
- Track new Airwallex transactions by creating multiple rows in Google Sheets
- Create multiple rows in Google Sheets for new Airwallex transactions