Airtable + Pennylane

Airtable + Pennylane integrations

Manage new Pennylane invoices by creating or updating records in Airtable

Streamline your invoicing with this efficient workflow. When a new invoice is created in Pennylane, it promptly updates or creates a record in Airtable. This process ensures you always have the most current billing information at your fingertips, making bookkeeping less of a chore and more of a smooth operation.

When this happens...
New Customer Invoice V2Triggers when a new customer invoice is created or fetches existing invoices with optional filtering.
TriggerPolling
automatically do this!
Create or Update RecordFind and update an existing record, or create a new one.
ActionWrite

Start free with email

Start free with Google

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

More things you can do with Pennylane and Airtable

Discover other triggers and actions you can use with Pennylane and Airtable

- 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 name
  Required
- VAT number
- Registration number
- Customer phone
- Billing address
  Required
- Billing postal code
  Required
- Billing city
  Required
- Billing country code
  Required
- 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 date
  Required
- Invoice deadline
  Required
- Customer ID
  Required
- Draft invoice
  Required
- 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 label
  Required
- Quantity
  Required
- Section rank
- Line discount type
- Line discount value
- Ledger account ID
- Unit price (excluding tax)
  Required
- Unit
  Required
- VAT rate
  Required
- Line description
- Product ID
- Line imputation start date
- Line imputation end date
Action
Write

- Customer ID
  Required
- 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 date
  Required
- Quote deadline
  Required
- Customer ID
  Required
- 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
  Required
- Quantity
  Required
- Section rank
- Line discount type
- Line discount value
- Ledger account ID
- Unit price (excluding tax)
  Required
- Unit
  Required
- VAT rate
  Required
- Line description
- Product ID
- Line imputation start date
- Line imputation end date
Action
Write

- Subscription ID
  Required
- Stop subscription
- Mode type
- Email recipients
- Payment conditions
- Payment method
- Recurring rule Type
- Recurring rule Interval
- Recurring rule Count
- Day of month (for monthly recurrence)
- Day of week (for weekly recurrence)
- Customer ID
- Currency
- Customer Invoice Template ID
- PDF Invoice Free Text
- PDF Invoice Subject
- PDF Description
- Special Mention
- Language
- Discount
- Invoice Line Sections
- New Line: Label
- New Line: Quantity
- New Line: Unit Price
- New Line: Unit
- New Line: VAT Rate
- New Line: Description
- New Line: Product ID
- New Line: Ledger Account ID
- New Line: Section Rank
- New Line: Discount
- Update Line: ID
- Update Line: Label
- Update Line: Quantity
- Update Line: Unit Price
- Update Line: Unit
- Update Line: VAT Rate
- Update Line: Description
- Update Line: Product ID
- Update Line: Ledger Account ID
- Update Line: Section Rank
- Update Line: Discount
- Delete Line IDs
Action
Write
- Existing billing subscription identifier
  Required
Action
Search
- Existing invoice identifier
  Required
Action
Search
- Existing quote identifier
  Required
Action
Search
- Existing invoice identifier
  Required
- Invoice date
  Required
- Invoice deadline
  Required
- Customer ID
  Required
- Draft invoice
  Required
- 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 label
  Required
- Quantity
  Required
- Section rank
- Line discount type
- Line discount value
- Ledger account ID
- Unit price (excluding tax)
  Required
- Unit
  Required
- VAT rate
  Required
- Line description
- Product ID
- Line imputation start date
- Line imputation end date
Action
Search or write
- Existing quote identifier
  Required
- Quote date
  Required
- Quote deadline
  Required
- Customer ID
  Required
- 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
  Required
- Quantity
  Required
- Section rank
- Line discount type
- Line discount value
- Ledger account ID
- Unit price (excluding tax)
  Required
- Unit
  Required
- VAT rate
  Required
- Line description
- Product ID
- Line imputation start date
- Line imputation end date
Action
Search or write
- Help Text
- Base
  Required
- Table
  Required
- Last modified time column
  Required
- Limit to view
- Include file contents?
Trigger
Polling
Try It
- Base
  Required
- Table
  Required
Action
Write
- Name
  Required
- Workspace ID
  Required
- Number of Tables
  Required
Action
Write
- Base
  Required
- Table Name
  Required
- Table Description
- Primary Field Name
- Primary Field Type
Action
Write
- Base
  Required
- Table
  Required
- Record
  Required
Action
Write
- Api_docs_info
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Base
  Required
- Table
  Required
- Record ID
  Required
Action
Search
- Base
  Required
- Table ID
  Required
Action
Search
- Base ID
  Required
Action
Search
- Base
  Required
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 date
  Required
- Mode type
  Required
- Email recipients
- Payment conditions
  Required
- Payment method
  Required
- Recurring rule Type
  Required
- Recurring rule Interval
- Recurring rule Count
- Day of month (for monthly recurrence)
- Day of week (for weekly recurrence)
- Customer ID
  Required
- Currency
- Customer Invoice Template ID
- PDF Invoice Free Text
- PDF Invoice Subject
- PDF Description
- Special Mention
- Language
- Discount
- Invoice Line Sections
- Invoice Line Label
  Required
- Invoice Line Quantity
  Required
- Invoice Line Raw Currency Unit Price
  Required
- Invoice Line Unit
  Required
- Invoice Line VAT Rate
  Required
- 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 ID
  Required
- 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 name
  Required
- Customer last name
  Required
- Customer phone
- Billing address
  Required
- Billing postal code
  Required
- Billing city
  Required
- Billing country code
  Required
- 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 label
  Required
- Product description
- Product VAT rate
  Required
- Product price (before tax)
  Required
- Product unit
- Product currency
- Product reference
- Product identifier
- Ledger account ID
Action
Write
- Quote ID
  Required
- 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 ID
  Required
- 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 identifier
  Required
- Start date
  Required
- Mode type
  Required
- Email recipients
- Payment conditions
  Required
- Payment method
  Required
- Recurring rule Type
  Required
- Recurring rule Interval
- Recurring rule Count
- Day of month (for monthly recurrence)
- Day of week (for weekly recurrence)
- Customer ID
  Required
- Currency
- Customer Invoice Template ID
- PDF Invoice Free Text
- PDF Invoice Subject
- PDF Description
- Special Mention
- Language
- Discount
- Invoice Line Sections
- Invoice Line Label
  Required
- Invoice Line Quantity
  Required
- Invoice Line Raw Currency Unit Price
  Required
- Invoice Line Unit
  Required
- Invoice Line VAT Rate
  Required
- 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 label
  Required
- Product description
- Product VAT rate
  Required
- Product price (before tax)
  Required
- Product unit
- Product currency
- Product reference
- Product identifier
- Ledger account ID
Action
Search or write
- Base
  Required
- Table
  Required
- Limit to View
- Include attachment content
Trigger
Polling
Try It
- Base
  Required
- Table
  Required
- Record
  Required
- Comment
  Required
Action
Write
- CacheCopy
- Base
  Required
- Table
  Required
Action
Write
- Base
  Required
- Table
  Required
- Helptext
- Primary lookup field
  Required
- Secondary lookup field
Action
Write
- Base
  Required
- Table
  Required
- Record
  Required
Action
Write
- Base
  Required
- Table
  Required
- Number of Records
  Required
Action
Write
- Base
  Required
- Table
  Required
- Search by Field
- Search Value
- Search type
- Search Formula
- Limit to View
Action
Search
- Base
  Required
- Search Keyword
  Required
- Search In
Action
Search
- Search Keyword
  Required
Action
Search
- Base
  Required
- Table
  Required
Action
Search
- Base
  Required
- Table
  Required
- 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 moreLearn moreHelpHelp

Related categories

Databases

Similar apps

Quickbase

App Builder

Zoho Creator

App Builder, Zoho

Smartsheet

Spreadsheets

About Pennylane

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

Learn moreLearn moreHelpHelp

Related categories

Accounting

Airtable + Pennylane

Airtable + Pennylane

Manage new Pennylane invoices by creating or updating records in Airtable

More things you can do with Pennylane and Airtable

Related Zap Templates

Related Zap Templates