Airtable + Pennylane

Update Pennylane customers when new records are added in Airtable

Stay on top of your customer updates with this effective automation. When a new record is created in Airtable, customer data in Pennylane is simultaneously updated. This workflow ensures you maintain accurate, up-to-date details for each client, reducing manual data updating and empowering better business processes.

When this happens...
New Record
Triggers when a new record is created or new or existing records when first added to a selected view.
TriggerScheduled
automatically do this!
Update Customer
Updates customer.
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

- 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
- 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

- 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
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

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