Airtable + Pennylane

Create or update Airtable records every time new estimates roll in on Pennylane

Keep your business records neat and up-to-date with this workflow. Whenever a new estimate is generated in Pennylane, the corresponding record is created or updated instantly in Airtable. This integration significantly reduces the risk of errors and removes the need for manual data entry, letting you focus more on your strategic decisions.

When this happens...
New Estimate
Triggers when a new estimate is created or when an estimate matches the filter.
TriggerScheduled
automatically do this!
Create or Update Record
Find and update an existing record, or create a new one.
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