Create new Pennylane estimates from new or updated Google Sheets rows
Keep your financial records up-to-date with this workflow. Whenever a new or edited row appears in Google Sheets, an estimate gets swiftly generated in Pennylane, ensuring your accounting is always current and precise. Eliminate the manual transfer of data and let this automation work for you, streamlining your business finances in real-time.
Keep your financial records up-to-date with this workflow. Whenever a new or edited row appears in Google Sheets, an estimate gets swiftly generated in Pennylane, ensuring your accounting is always current and precise. Eliminate the manual transfer of data and let this automation work for you, streamlining your business finances in real-time.
- 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
- 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 Google Sheets spreadsheet rows from new customer invoices in Pennylane
- Add new Pennylane customers to Google Sheets rows automatically
- 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 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
- 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






