Airtable + Pennylane

Create Airtable records from new Pennylane customer invoices

Effortlessly manage your customer invoicing workflow with this integration. When a new customer invoice is generated in Pennylane, a corresponding record will be created in your Airtable, complete with line item details. This ensures streamlined, accurate financial data management and reduces manual data entry. Enhance your business efficiency and keep your financial records up-to-date in real-time.

When this happens...
New Customer Invoice
Triggers when a new invoice is created/imported or when an invoice matches the filter.
TriggerScheduled
automatically do this!
Create Records (Advanced)
Create up to 10 new records (supports line items).
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

- State filter
- Customer identifier filter
Trigger
Scheduled
Try It
- State filter
- Source filter
- Customer identifier filter
Trigger
Scheduled
Try It
New Product
Triggers when a new product is created.
Trigger
Scheduled
Try It
- Customer type (company or individual)Required
Action
Write
Create Estimate
Creates a new estimate.
Action
Write

- Existing invoice identifierRequired
Action
Write
- Customer IdentifierRequired
Action
Write

Update Billing Subscription
Updates Billing Subscription.
Action
Write
- BaseRequired
- TableRequired
- Limit to View
- Include attachment content
Trigger
Scheduled
Try It
- BaseRequired
- TableRequired
Action
Write
- BaseRequired
- TableRequired
- Help Text
- Primary lookup fieldRequired
- Secondary lookup field
Action
Write
- BaseRequired
- TableRequired
- RecordRequired
Action
Write
- BaseRequired
- TableRequired
- Field to search
- Search value
- Search type
- Search formula (advanced)
- Limit to view
- Include attachment content
- Max records
Action
Search
- BaseRequired
- TableRequired
- Field to search
- Search value
- Search type
- Search formula (advanced)
- Limit to view
- Include attachment content
- Max records
Action
Search or write

New Customer
Triggers when a new customer is created.
Trigger
Scheduled
Try It
- State filter
- Customer identifier filter
Trigger
Scheduled
Try It
Create Billing Subscription
Creates a new billing subscription.
Action
Write
Create Customer Invoice
Creates a new customer invoice.
Action
Write
- Product labelRequired
- Product description
- Product VAT rateRequired
- Product price (including taxes)Required
- Product unitRequired
- Product currencyRequired
- Product reference
- Product identifier
- Product substance
Action
Write
- Existing estimate identifierRequired
Action
Write
- Product identifierRequired
- Product label
- Product description
- Product VAT rate
- Product price (including taxes)
- Product unit
- Product currency
- Product reference
- Product substance
Action
Write
- Existing estimate identifierRequired
- Estimate statusRequired
Action
Write
- Help Text
- BaseRequired
- TableRequired
- Last modified time columnRequired
- Limit to view
- Include file contents?
Trigger
Scheduled
Try It
- Cache Copy
- BaseRequired
- TableRequired
Action
Write
- BaseRequired
- TableRequired
- RecordRequired
Action
Write
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- BaseRequired
- TableRequired
- Search by Field
- Search Value
- Search type
- Search Formula
- Limit to View
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