Create spreadsheet rows in Google Sheets for new estimates in Pennylane
Keep your Google Sheets and Pennylane spreadsheets organized and up-to-date with this workflow. Whenever a new column is created in your Pennylane spreadsheet, this automation will also create a matching column in your Google Sheets spreadsheet, helping you maintain consistent structure across multiple platforms. Save time and effort by streamlining your spreadsheet management with this easy-to-use automation.
Keep your Google Sheets and Pennylane spreadsheets organized and up-to-date with this workflow. Whenever a new column is created in your Pennylane spreadsheet, this automation will also create a matching column in your Google Sheets spreadsheet, helping you maintain consistent structure across multiple platforms. Save time and effort by streamlining your spreadsheet management with this easy-to-use automation.
- Free forever for core features
- 14 day trial for premium features & apps
- Cursor 
- Limit 
- Sort 
- Customer ID 
- Invoice Number 
- Draft Status 
- Credit Note 
- External Reference 
 Try It
- Cursor 
- Limit 
- Sort 
- Customer ID 
- Invoice Number 
- Draft Status 
- Credit Note 
- External Reference 
 Try It
- Cursor 
- Limit 
- Sort 
- Customer ID 
 Try It
- 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 
 
- New Customer V2- Triggers when a new customer is created. Try It
- New Product V2- Triggers when a new product is created. Try It
- 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 
 
- 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 
 











