Google Sheets + Pennylane
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...
New or Updated Spreadsheet RowTriggers when a new row is added or modified in a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
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 planDont 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 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 foundCursor
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 planCursor
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 planCompany 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 appExisting invoice identifierRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appExisting quote identifierRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appExisting 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 foundExisting 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 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
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 planNew 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 planStart 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 appExisting product identifier (source_id)Required
ActionThis is an event a Zap performs.SearchFind existing data in your appExisting 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 foundExisting 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
About Google Sheets
Related categories
About Pennylane
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