Airtable + Pennylane

Create Airtable records from new Pennylane customer invoices

Streamline your financial processes with this handy automation. When a new customer invoice is generated in Pennylane, it immediately creates a corresponding record in your Airtable. This workflow not only saves you valuable time but also ensures that your data in both systems remains consistent and up-to-date.

When this happens...
TriggerPolling
automatically do this!
Create Record
Creates a new record with auto-populating fields.
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
- Help Text
- BaseRequired
- TableRequired
- Last modified time columnRequired
- Limit to view
- Include file contents?
Trigger
Polling
Try It
- BaseRequired
- TableRequired
Action
Write
- NameRequired
- Workspace IDRequired
- Number of TablesRequired
Action
Write
- BaseRequired
- Table NameRequired
- Table Description
- Primary Field Name
- Primary Field Type
Action
Write
- BaseRequired
- TableRequired
- RecordRequired
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- BaseRequired
- TableRequired
- Record IDRequired
Action
Search
- BaseRequired
- Table IDRequired
Action
Search
- BaseRequired
Action
Search

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
- BaseRequired
- TableRequired
- Limit to View
- Include attachment content
Trigger
Polling
Try It
- BaseRequired
- TableRequired
- RecordRequired
- CommentRequired
Action
Write
- Cache Copy
- BaseRequired
- TableRequired
Action
Write
- BaseRequired
- TableRequired
- Help Text
- Primary lookup fieldRequired
- Secondary lookup field
Action
Write
- BaseRequired
- TableRequired
- RecordRequired
Action
Write
- BaseRequired
- TableRequired
- Number of RecordsRequired
Action
Write
- BaseRequired
- TableRequired
- Search by Field
- Search Value
- Search type
- Search Formula
- Limit to View
Action
Search
- BaseRequired
- Search KeywordRequired
- Search In
Action
Search
- Search KeywordRequired
Action
Search
- BaseRequired
- TableRequired
- Search by Field
- Search Value
- Search type
- Search Formula
- Limit to View
Action
Search or write

About Airtable

Organize anything with Airtable, a modern database created for everyone. Airtable is a fast and flexible way to create tables to keep track of anything, from sales leads to vacation planning to inventory management.

Learn more

Related categories

Databases

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

Airtable + Pennylane

Create Airtable records from new Pennylane customer invoices

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 or Updated Record

Create Record

Create Base

Create Table

Update Record

API Request (Beta)

Find Record by ID

Find Table by ID

Get Base Schema

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 Record

Add Comment to Record

Create Records (Advanced)

Create or Update Record

Delete Record

Update Multiple Records

Find Record

Find Table

Find Base

Find or Create Record

About Airtable

Related categories

Similar apps

Quickbase

Zoho Creator

Smartsheet

About Pennylane

Related categories

Related Zap Templates

Related Zap Templates