Create customer invoices in Pennylane for new or updated rows in Google Sheets
Effortlessly maintain your financial records with this automatic workflow. Whenever there's a new or updated row in your Google Sheets, it instantly creates a customer invoice in Pennylane. This ensures your invoices are always up-to-date, eliminating the need for manual data entry, and gives you more time to focus on growing your business.
Effortlessly maintain your financial records with this automatic workflow. Whenever there's a new or updated row in your Google Sheets, it instantly creates a customer invoice in Pennylane. This ensures your invoices are always up-to-date, eliminating the need for manual data entry, and gives you more time to focus on growing your business.
- When this happens...  TriggerPollingZapier checks for new data every 15 min on the Free plan TriggerPollingZapier checks for new data every 15 min on the Free plan
- automatically do this!  ActionWriteCreate a new record or update an existing record in your app. 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 plan
- Dont 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 app
- Drive 
- SpreadsheetRequired 
- WorksheetRequired 
- ColumnsRequired 
- Row countRequired 
- Output format 
- First row 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- Spreadsheet IDRequired 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- Drive 
- 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
- Cursor 
- Limit 
- Sort 
- Customer ID 
- Invoice Number 
- Draft Status 
- Credit Note 
- External Reference 
 Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
- Cursor 
- Limit 
- Sort 
- Customer ID 
- Invoice Number 
- Draft Status 
- Credit Note 
- External Reference 
 Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
- Company nameRequired 
- VAT number 
- Registration number 
- Customer phone 
- Billing addressRequired 
- Billing postal codeRequired 
- Billing cityRequired 
- Billing country codeRequired 
- Delivery address 
- Delivery postal code 
- Delivery city 
- Delivery country code 
- Customer payment conditions 
- Customer billing IBAN 
- Recipient 
- Reference 
- Ledger account number 
- Notes 
- Customer emails 
- External reference 
- Billing language 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Invoice dateRequired 
- Invoice deadlineRequired 
- Customer IDRequired 
- Draft invoiceRequired 
- Invoice template ID 
- Additional free field 
- Invoice title 
- Invoice description 
- Invoice currency 
- Special mentions 
- Invoice language 
- External reference 
- Discount type 
- Discount value 
- Banking provider 
- Provider field name 
- Provider field value 
- Section title 
- Section description 
- Section rank 
- Line labelRequired 
- QuantityRequired 
- Section rank 
- Line discount type 
- Line discount value 
- Ledger account ID 
- Unit price (excluding tax)Required 
- UnitRequired 
- VAT rateRequired 
- Line description 
- Product ID 
- Line imputation start date 
- Line imputation end date 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Customer IDRequired 
- Customer first name 
- Customer last name 
- Customer phone 
- Billing address 
- Billing postal code 
- Billing city 
- Billing country code 
- Delivery address 
- Delivery postal code 
- Delivery city 
- Delivery country code 
- Customer payment conditions 
- Customer billing IBAN 
- Recipient 
- Reference 
- Ledger account number 
- Notes 
- Customer emails 
- External reference 
- Billing language 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Quote dateRequired 
- Quote deadlineRequired 
- Customer IDRequired 
- Quote template ID 
- Additional free field 
- Quote subject 
- Quote description 
- Quote currency 
- Special mentions 
- Quote language 
- External reference 
- Discount type 
- Discount value 
- Section title 
- Section description 
- Section rank 
- Line labelRequired 
- QuantityRequired 
- Section rank 
- Line discount type 
- Line discount value 
- Ledger account ID 
- Unit price (excluding tax)Required 
- UnitRequired 
- VAT rateRequired 
- Line description 
- Product ID 
- Line imputation start date 
- Line imputation end date 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Subscription IDRequired 
- Stop subscription 
- Mode type 
- Mode email settings 
- Payment conditions 
- Payment method 
- Recurring rule Type 
- Recurring rule Interval 
- Recurring rule Count 
- Customer ID 
- Currency 
- Customer Invoice Template ID 
- PDF Invoice Free Text 
- PDF Invoice Subject 
- PDF Description 
- Special Mention 
- Language 
- Discount 
- Invoice Line Sections 
- Invoice Line Label 
- Invoice Line Quantity 
- Invoice Line Raw Currency Unit Price 
- Invoice Line Unit 
- Invoice Line VAT Rate 
- Invoice Line Description 
- Invoice Line Product ID 
- Invoice Line Ledger Account ID 
- Invoice Line Section Rank 
- Invoice Line Discount Type 
- Invoice Line Discount Value 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Existing billing subscription identifierRequired 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- Existing invoice identifierRequired 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- Existing quote identifierRequired 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- Existing invoice identifierRequired 
- Invoice dateRequired 
- Invoice deadlineRequired 
- Customer IDRequired 
- Draft invoiceRequired 
- Invoice template ID 
- Additional free field 
- Invoice title 
- Invoice description 
- Invoice currency 
- Special mentions 
- Invoice language 
- External reference 
- Discount type 
- Discount value 
- Banking provider 
- Provider field name 
- Provider field value 
- Section title 
- Section description 
- Section rank 
- Line labelRequired 
- QuantityRequired 
- Section rank 
- Line discount type 
- Line discount value 
- Ledger account ID 
- Unit price (excluding tax)Required 
- UnitRequired 
- VAT rateRequired 
- Line description 
- Product ID 
- Line imputation start date 
- Line imputation end date 
 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
- Existing quote identifierRequired 
- Quote dateRequired 
- Quote deadlineRequired 
- Customer IDRequired 
- Quote template ID 
- Additional free field 
- Quote subject 
- Quote description 
- Quote currency 
- Special mentions 
- Quote language 
- External reference 
- Discount type 
- Discount value 
- Section title 
- Section description 
- Section rank 
- Line labelRequired 
- QuantityRequired 
- Section rank 
- Line discount type 
- Line discount value 
- Ledger account ID 
- Unit price (excluding tax)Required 
- UnitRequired 
- VAT rateRequired 
- Line description 
- Product ID 
- Line imputation start date 
- Line imputation end date 
 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
- 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 plan
- Drive 
- 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 app
- Drive 
- SpreadsheetRequired 
- WorksheetRequired 
- A1 RangeRequired 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- Drive 
- SpreadsheetRequired 
- WorksheetRequired 
- Row IDRequired 
 ActionThis is an event a Zap performs.SearchFind existing data 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 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.Search or writeFind existing data in your app, or create a new record if no data is found
 - New Customer V2- 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 plan
 - New Product V2- 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 plan
- Start dateRequired 
- Mode typeRequired 
- Mode email settingsRequired 
- Payment conditionsRequired 
- Payment methodRequired 
- Recurring rule TypeRequired 
- Recurring rule Interval 
- Recurring rule Count 
- Customer IDRequired 
- Currency 
- Customer Invoice Template ID 
- PDF Invoice Free Text 
- PDF Invoice Subject 
- PDF Description 
- Special Mention 
- Language 
- Discount 
- Invoice Line Sections 
- Invoice Line LabelRequired 
- Invoice Line QuantityRequired 
- Invoice Line Raw Currency Unit PriceRequired 
- Invoice Line UnitRequired 
- Invoice Line VAT RateRequired 
- Invoice Line Description 
- Invoice Line Product ID 
- Invoice Line Ledger Account ID 
- Invoice Line Section Rank 
- Invoice Line Discount Type 
- Invoice Line Discount Value 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Customer IDRequired 
- Company name 
- VAT number 
- Registration number 
- Customer phone 
- Billing address 
- Billing postal code 
- Billing city 
- Billing country code 
- Delivery address 
- Delivery postal code 
- Delivery city 
- Delivery country code 
- Customer payment conditions 
- Customer billing IBAN 
- Recipient 
- Reference 
- Ledger account number 
- Notes 
- Customer emails 
- External reference 
- Billing language 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Customer first nameRequired 
- Customer last nameRequired 
- Customer phone 
- Billing addressRequired 
- Billing postal codeRequired 
- Billing cityRequired 
- Billing country codeRequired 
- Delivery address 
- Delivery postal code 
- Delivery city 
- Delivery country code 
- Customer payment conditions 
- Customer billing IBAN 
- Recipient 
- Reference 
- Ledger account number 
- Notes 
- Customer emails 
- External reference 
- Billing language 
 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 (before tax)Required 
- Product unit 
- Product currency 
- Product reference 
- Product identifier 
- Ledger account ID 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Quote IDRequired 
- Quote date 
- Quote deadline 
- Customer ID 
- Quote template ID 
- Additional free field 
- Quote subject 
- Quote description 
- Quote currency 
- Special mentions 
- Quote language 
- External reference 
- Discount type 
- Discount value 
- Section title 
- Section description 
- Section rank 
- Line label 
- Quantity 
- Section rank 
- Line discount type 
- Line discount value 
- Ledger account ID 
- Unit price (excluding tax) 
- Unit 
- VAT rate 
- Line description 
- Product ID 
- Line imputation start date 
- Line imputation end date 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Product IDRequired 
- Product label 
- Product description 
- Product VAT rate 
- Product price (before tax) 
- Product unit 
- Product currency 
- Product reference 
- Product identifier 
- Ledger account ID 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Existing customer identifier (source_id)Required 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- Existing product identifier (source_id)Required 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- Existing billing subscription identifierRequired 
- Start dateRequired 
- Mode typeRequired 
- Mode email settingsRequired 
- Payment conditionsRequired 
- Payment methodRequired 
- Recurring rule TypeRequired 
- Recurring rule Interval 
- Recurring rule Count 
- Customer IDRequired 
- Currency 
- Customer Invoice Template ID 
- PDF Invoice Free Text 
- PDF Invoice Subject 
- PDF Description 
- Special Mention 
- Language 
- Discount 
- Invoice Line Sections 
- Invoice Line LabelRequired 
- Invoice Line QuantityRequired 
- Invoice Line Raw Currency Unit PriceRequired 
- Invoice Line UnitRequired 
- Invoice Line VAT RateRequired 
- Invoice Line Description 
- Invoice Line Product ID 
- Invoice Line Ledger Account ID 
- Invoice Line Section Rank 
- Invoice Line Discount Type 
- Invoice Line Discount Value 
 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
- Existing product identifier (source_id)Required 
- Product labelRequired 
- Product description 
- Product VAT rateRequired 
- Product price (before tax)Required 
- Product unit 
- Product currency 
- Product reference 
- Product identifier 
- Ledger account ID 
 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
Related categories
Related categories
Related Zap Templates
- Create Google Sheets spreadsheet rows from new customer invoices in Pennylane
- 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 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 Google Sheets spreadsheet 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 spreadsheets in Google Sheets for new customer invoices in Pennylane
- Update Pennylane billing subscriptions with new or updated rows in Google Sheets
- Create spreadsheet rows in Google Sheets for new estimates in Pennylane
- Create multiple spreadsheet rows in Google Sheets for new Pennylane customer invoices
- 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
- Create customer invoices in Pennylane from new spreadsheet rows in Google Sheets
- Create new Pennylane estimates from new or updated Google Sheets rows
- 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






