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...
New Customer Invoice
Triggers when a new invoice is created/imported or when an invoice matches the filter.
TriggerScheduled
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

- 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