Google Sheets + PayPal
Create PayPal invoices from new or updated Google Sheets rows
Boost your billing efficiency with this workflow. Whenever there's an updated or new row in your Google Sheets, an invoice is instantly prepared in your PayPal account. This process ensures precise, timely financial document management and minimizes manual data entry.
Boost your billing efficiency with this workflow. Whenever there's an updated or new row in your Google Sheets, an invoice is instantly prepared in your PayPal account. This process ensures precise, timely financial document management and minimizes manual data entry.
- 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 InvoiceCreate a new draft invoice in PayPal.
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
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 foundInvoice Number
Reference
Currency Code
Invoice Date
Due Date
Payment Terms
Note
Terms and Conditions
Memo
Your Business Name
Your First Name
Your Last Name
Your Email
Your Phone Country Code
Your Phone Number
Your Phone Type
Your Website
Your Tax ID
Your Logo URL
Your Additional Notes
Your Address Line 1
Your Address Line 2
Your Address Line 3
Your City
Your State/Province
Your Postal Code
Your Country Code
Recipient Business Name
Recipient First Name
Recipient Last Name
Recipient Email
Recipient Phone Country Code
Recipient Phone Number
Recipient Phone Type
Recipient Additional Info
Recipient Language
Recipient Address Line 1
Recipient Address Line 2
Recipient Address Line 3
Recipient City
Recipient State/Province
Recipient Postal Code
Recipient Country Code
Shipping Business Name
Shipping First Name
Shipping Last Name
Shipping Address Line 1
Shipping Address Line 2
Shipping Address Line 3
Shipping City
Shipping State/Province
Shipping Postal Code
Shipping Country Code
Item NameRequired
Item Description
Item QuantityRequired
Item Unit AmountRequired
Unit of Measure
Item Date
Item Tax Name
Item Tax Percentage
Item Tax Note
Item Discount Type
Item Discount Value
Invoice Discount Type
Invoice Discount Value
Shipping Amount
Shipping Tax Name
Shipping Tax Percentage
Custom Charge Label
Custom Charge Amount
Allow Partial Payment
Minimum Amount Due
Allow Tip
Tax Calculated After Discount
Tax Inclusive Pricing
Template ID
Additional Recipients (CC)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.InvoiceRequired
Send to Recipient
Send Copy to Invoicer
Email Subject
Note to Payer
Additional Recipients (CC)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Capture IDRequired
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 appProduct IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSubscription IDRequired
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 foundAmountRequired
Currency Code
Payment Intent
Description
Reference ID
Custom ID
Invoice ID
Payer Email
Payer First Name
Payer Last Name
Item Name
Item Quantity
Item SKU
Item Category
Shipping Type
Shipping Full Name
Shipping Email
Shipping Address Line 1
Shipping Address Line 2
Shipping State/Province
Shipping City
Shipping Postal Code
Shipping Country Code
Return URL
Cancel URL
Brand Name
Shipping Preference
User Action
Soft Descriptor
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Authorization IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appInvoice IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appPlan IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appRefund IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app
About Google Sheets
Related categories
About PayPal
Related categories
Related Zap Templates
- Add rows to Google Sheets spreadsheets for new PayPal sales
- Log new PayPal transactions to Google Sheets spreadsheets
- Create Google Sheet rows for all new merchant transactions in Paypal
- Update Google Sheets rows from new PayPal sales
- Create Google Sheets spreadsheet rows from new refunded sales in PayPal
- Create Google Sheets row(s) for new successful sales in PayPal
- Log new PayPal sales and create multiple Google Sheets rows
- Find Start Booking customers and create Google Sheets rows for new successful PayPal sales
- Track PayPal successful sales by creating spreadsheets in Google Sheets
- Create Google Sheets columns for every successful PayPal sale
- Track all PayPal merchant transactions by creating multiple spreadsheet rows in Google Sheets
- Update Google Sheets rows with every successful PayPal sale
- Log all PayPal merchant transactions in new Google Sheets spreadsheets
- Update Google Sheets rows every time new PayPal merchant transactions occur
- Track all PayPal merchant transactions by creating worksheets in Google Sheets
- Clear spreadsheet rows in Google Sheets when new merchant transactions occur in PayPal
- Track all PayPal merchant transactions by creating corresponding columns in Google Sheets
- Create worksheets in Google Sheets for each new successful sale in PayPal
- Capture new PayPal payments and create rows in Google Sheets
- Create spreadsheet rows in Google Sheets for new billing subscriptions in PayPal
- Create multiple spreadsheet rows in Google Sheets for new billing subscription webhooks in PayPal
- Capture PayPal payments and create multiple rows in Google Sheets
- Create spreadsheet rows at top in Google Sheets for new payment sale webhooks in PayPal
Related Zap Templates
- Log new PayPal transactions to Google Sheets spreadsheets
- Create Google Sheets spreadsheet rows from new refunded sales in PayPal
- Find Start Booking customers and create Google Sheets rows for new successful PayPal sales
- Track all PayPal merchant transactions by creating multiple spreadsheet rows in Google Sheets
- Update Google Sheets rows every time new PayPal merchant transactions occur
- Create Google Sheet rows for all new merchant transactions in Paypal
- Create Google Sheets row(s) for new successful sales in PayPal
- Track PayPal successful sales by creating spreadsheets in Google Sheets
- Update Google Sheets rows with every successful PayPal sale
- Track all PayPal merchant transactions by creating worksheets in Google Sheets