Google Sheets + Pennylane
Create Google Sheets spreadsheet rows from new customer invoices in Pennylane
You can add new invoices and their associated values to Google Sheets spreadsheet rows, in order to simplify invoice management.
You can add new invoices and their associated values to Google Sheets spreadsheet rows, in order to simplify invoice management.
- When this happens...
New Customer InvoiceTriggers when a new invoice is created/imported or when an invoice matches the filter.
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
State filter
Customer identifier filter
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planState filter
Source filter
Customer identifier filter
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
New Product
Triggers when a new product is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planCustomer type (company or individual)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Create Estimate
Creates a new estimate.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Existing invoice identifierRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Customer IdentifierRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Update Billing Subscription
Updates Billing Subscription.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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 Customer
Triggers when a new customer is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planState filter
Customer identifier filter
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planCreate Billing Subscription
Creates a new billing subscription.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Create Customer Invoice
Creates a new customer invoice.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Product labelRequired
Product description
Product VAT rateRequired
Product price (including taxes)Required
Product unitRequired
Product currencyRequired
Product reference
Product identifier
Product substance
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Existing estimate identifierRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Product identifierRequired
Product label
Product description
Product VAT rate
Product price (including taxes)
Product unit
Product currency
Product reference
Product substance
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Existing estimate identifierRequired
Estimate statusRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record 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 found
About Google Sheets
Related categories
About Pennylane
Related categories
Related Zap Templates
- Create spreadsheet rows in Google Sheets for new estimates in Pennylane
- Create customer invoices in Pennylane from new spreadsheet rows in Google Sheets
- Add new Pennylane customers to Google Sheets rows automatically
- Create multiple spreadsheet rows in Google Sheets for new Pennylane customer invoices
- Create new Pennylane estimates from new or updated Google Sheets rows
- Update Google Sheets rows for new Pennylane billing subscriptions
- Create customer invoices in Pennylane for new or updated rows in Google Sheets
- Create new Pennylane subscriptions from new Google Sheets rows
- Create multiple rows in Google Sheets for new customers in Pennylane
- Create spreadsheets in Google Sheets for new customer invoices in Pennylane
- Generate Pennylane customer invoices from new Google Sheets spreadsheet rows on team drive
- Create Google Sheets rows for new Pennylane billing subscriptions
- Update Pennylane billing subscriptions with new or updated rows in Google Sheets
- Create Google Sheets rows from new customer invoices in Pennylane
- Format new Pennylane customer invoices into rows on Google Sheets
Related Zap Templates
- Create spreadsheet rows in Google Sheets for new estimates in Pennylane
- Create multiple spreadsheet rows in Google Sheets for new Pennylane customer invoices
- Create customer invoices in Pennylane for new or updated rows in Google Sheets
- Create spreadsheets in Google Sheets for new customer invoices in Pennylane
- Update Pennylane billing subscriptions with new or updated rows in Google Sheets
- Create customer invoices in Pennylane from new spreadsheet rows in Google Sheets
- Create new Pennylane estimates from new or updated Google Sheets rows
- Create new Pennylane subscriptions from new Google Sheets rows
- Generate Pennylane customer invoices from new Google Sheets spreadsheet rows on team drive
- Create Google Sheets rows from new customer invoices in Pennylane
- Add new Pennylane customers to Google Sheets rows automatically
- Update Google Sheets rows for new Pennylane billing subscriptions
- Create multiple rows in Google Sheets for new customers in Pennylane
- Create Google Sheets rows for new Pennylane billing subscriptions
- Format new Pennylane customer invoices into rows on Google Sheets