Google Sheets + Pennylane

Create Google Sheets rows from new customer invoices in Pennylane

Stay on top of your business finances with this seamless automation that connects Pennylane and Google Sheets. Whenever a new customer invoice is generated in Pennylane, a matching row is instantly created in your chosen Google Sheets spreadsheet. This allows for easy tracking of invoices, ensuring you never miss a transaction detail and keeping your financial records up to date.

When this happens...
TriggerPolling
automatically do this!
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

Supported triggers and actions

- Cursor
- Limit
- Sort
- Customer ID
- Invoice Number
- Draft Status
- Credit Note
- External Reference
Trigger
Polling
Try It
- Cursor
- Limit
- Sort
- Customer ID
- Invoice Number
- Draft Status
- Credit Note
- External Reference
Trigger
Polling
Try It
- Cursor
- Limit
- Sort
- Customer ID
Trigger
Polling
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
Action
Write
- 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
Action
Write

- 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
Action
Write
- 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
Action
Write

- 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
Action
Write
- Existing billing subscription identifierRequired
Action
Search
- Existing invoice identifierRequired
Action
Search
- Existing quote identifierRequired
Action
Search
- 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
Action
Search or write
- 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
Action
Search or write
- Dont Change Sheet Structure
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Instant
Try It
- Dont Change Sheet Structure
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger column
Trigger
Polling
Try It
- Drive
- SpreadsheetRequired
Trigger
Polling
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Use Timezone set up on the spreadsheet to format date values?
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Condition TypeRequired
- Background Color
- Text Color
- Bold Text
- Italic Text
Action
Write
- Drive
- Spreadsheet Containing the Worksheet to CopyRequired
- Worksheet to CopyRequired
- Copy Worksheet Destination
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
- Overwrite existing worksheet with the same title
- Headers
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Confirm DeletionRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Format TypeRequired
Action
Write
- SpreadsheetRequired
- WorksheetRequired
- New Sheet NameRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Sort by ColumnRequired
- Sort OrderRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- A1 RangeRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row IDRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search or write

New Customer V2
Triggers when a new customer is created.
Trigger
Polling
Try It
New Product V2
Triggers when a new product is created.
Trigger
Polling
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
Action
Write
- 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
Action
Write
- 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
Action
Write
- Product labelRequired
- Product description
- Product VAT rateRequired
- Product price (before tax)Required
- Product unit
- Product currency
- Product reference
- Product identifier
- Ledger account ID
Action
Write
- 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
Action
Write
- Product IDRequired
- Product label
- Product description
- Product VAT rate
- Product price (before tax)
- Product unit
- Product currency
- Product reference
- Product identifier
- Ledger account ID
Action
Write
- Existing customer identifier (source_id)Required
Action
Search
- Existing product identifier (source_id)Required
Action
Search
- 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
Action
Search or write
- 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
Action
Search or write
- Dont Change Sheet Structure
- Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Polling
Try It
- Drive
Trigger
Polling
Try It
- Dont Change Sheet Structure
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger column
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Column NameRequired
- Index
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Frozen Rows Count
- Frozen Columns Count
- Sheet Position
- Hide Sheet
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Source RangeRequired
- Destination RangeRequired
- Paste Type
Action
Write
- Drive
- TitleRequired
- Spreadsheet to Copy
- Headers
Action
Write
- Info
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row(s)Required
Action
Write
- Info
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row(s)Required
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Validation TypeRequired
- Input Message
- Strict Validation
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row countRequired
- Output format
- First row
Action
Search
- Spreadsheet IDRequired
Action
Search
- Drive
- SpreadsheetRequired
- TitleRequired
- Overwrite existing worksheet with the same title
- Headers
Action
Search or write

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Learn more

Related categories

Similar apps

About Pennylane

Pennylane centralizes all your cash flows and connects with your financial tools to ease and automate collaboration with your accountant.

Related categories

Accounting

Google Sheets + Pennylane

Create Google Sheets rows from new customer invoices in Pennylane

New Billing Subscription V2

New Customer Invoice V2

New Quote V2

Create Company Customer V2

Create Customer Invoice V2

Update Individual Customer V2

Create Quote V2

Update Billing Subscription V2

Get Billing Subscription V2

Retrieve Invoice V2

Retrieve Quote V2

Find or Create Customer Invoice V2

Find or Create Quote V2

New Spreadsheet Row

New or Updated Spreadsheet Row (Team Drive)

New Worksheet

Create Spreadsheet Row

Create Spreadsheet Row at Top

Create Conditional Formatting Rule

Copy Worksheet

Create Worksheet

Delete Sheet

Format Cell Range

Rename Sheet

Sort Range

Update Spreadsheet Row(s)

Lookup Spreadsheet Rows (Advanced)

Get Data Range

Get Row by ID

Lookup Spreadsheet Row

Find or Create Row

New Customer V2

New Product V2

Create Billing Subscription V2

Update Company Customer V2

Create Individual Customer V2

Create Product V2

Update Quote V2

Update Product V2

Retrieve Customer V2

Retrieve Product V2

Find or Create Billing Subscription V2

Find or Create ProductV2

New Spreadsheet Row (Team Drive)

New Spreadsheet

New or Updated Spreadsheet Row

Create Spreadsheet Column

Create Multiple Spreadsheet Rows

Change Sheet Properties

Copy Range

Create Spreadsheet

Clear Spreadsheet Row(s)

Delete Spreadsheet Row(s)

Format Spreadsheet Row

Set Data Validation

Update Spreadsheet Row

API Request (Beta)

Find Worksheet

Get Many Spreadsheet Rows (Advanced)

Get Spreadsheet by ID

Find or Create Worksheet

About Google Sheets

Related categories

Similar apps

Zapier Tables

Zoho Creator

Smartsheet

About Pennylane

Related categories

Related Zap Templates

Related Zap Templates