Google Sheets + Pennylane
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.
- When this happens...New Estimate
- automatically do this!Create Spreadsheet Row
Create a new row in a specific spreadsheet.
- 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 ItCursor
Limit
Sort
Customer ID
Invoice Number
Draft Status
Credit Note
External Reference
Try ItCursor
Limit
Sort
Customer ID
Try ItCompany 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 ItNew Product V2
Triggers when a new product is created.
Try ItStart 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
