Pennylane + SQL Server

Create new rows in SQL Server for each new customer in Pennylane

Easily manage your customer data with this workflow between Pennylane and SQL Server. When you gain a new customer in Pennylane, a corresponding new row will instantly be created in your SQL Server. This automation helps keep your database current and accurate, simplifying your customer management process.

When this happens...
TriggerPolling
automatically do this!
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

- 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 nameRequired
- VAT number
- Registration number
- Customer phone
- Billing addressRequired
- Billing postal codeRequired
- Billing cityRequired
- Billing country codeRequired
- 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 dateRequired
- Invoice deadlineRequired
- Customer IDRequired
- Draft invoiceRequired
- 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 labelRequired
- QuantityRequired
- Section rank
- Line discount type
- Line discount value
- Ledger account ID
- Unit price (excluding tax)Required
- UnitRequired
- VAT rateRequired
- Line description
- Product ID
- Line imputation start date
- Line imputation end date
Action
Write

- Customer IDRequired
- 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 dateRequired
- Quote deadlineRequired
- Customer IDRequired
- 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 labelRequired
- QuantityRequired
- Section rank
- Line discount type
- Line discount value
- Ledger account ID
- Unit price (excluding tax)Required
- UnitRequired
- VAT rateRequired
- Line description
- Product ID
- Line imputation start date
- Line imputation end date
Action
Write

- Subscription IDRequired
- Stop subscription
- Mode type
- Mode email settings
- Payment conditions
- Payment method
- Recurring rule Type
- Recurring rule Interval
- Recurring rule Count
- Customer ID
- Currency
- Customer Invoice Template ID
- PDF Invoice Free Text
- PDF Invoice Subject
- PDF Description
- Special Mention
- Language
- Discount
- Invoice Line Sections
- Invoice Line Label
- Invoice Line Quantity
- Invoice Line Raw Currency Unit Price
- Invoice Line Unit
- Invoice Line VAT Rate
- 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
- Existing billing subscription identifierRequired
Action
Search
- Existing invoice identifierRequired
Action
Search
- Existing quote identifierRequired
Action
Search
- Existing invoice identifierRequired
- Invoice dateRequired
- Invoice deadlineRequired
- Customer IDRequired
- Draft invoiceRequired
- 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 labelRequired
- QuantityRequired
- Section rank
- Line discount type
- Line discount value
- Ledger account ID
- Unit price (excluding tax)Required
- UnitRequired
- VAT rateRequired
- Line description
- Product ID
- Line imputation start date
- Line imputation end date
Action
Search or write
- Existing quote identifierRequired
- Quote dateRequired
- Quote deadlineRequired
- Customer IDRequired
- 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 labelRequired
- QuantityRequired
- Section rank
- Line discount type
- Line discount value
- Ledger account ID
- Unit price (excluding tax)Required
- UnitRequired
- VAT rateRequired
- Line description
- Product ID
- Line imputation start date
- Line imputation end date
Action
Search or write
- Table/ViewRequired
- Order By
- Dedupe Key
Trigger
Polling
Try It
New Table
Triggers when you add a new table.
Trigger
Polling
Try It
- QueryRequired
Trigger
Polling
Try It
- TableRequired
Action
Write
- TableRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search
- QueryRequired
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 dateRequired
- Mode typeRequired
- Mode email settingsRequired
- Payment conditionsRequired
- Payment methodRequired
- Recurring rule TypeRequired
- Recurring rule Interval
- Recurring rule Count
- Customer IDRequired
- Currency
- Customer Invoice Template ID
- PDF Invoice Free Text
- PDF Invoice Subject
- PDF Description
- Special Mention
- Language
- Discount
- Invoice Line Sections
- Invoice Line LabelRequired
- Invoice Line QuantityRequired
- Invoice Line Raw Currency Unit PriceRequired
- Invoice Line UnitRequired
- Invoice Line VAT RateRequired
- 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 IDRequired
- 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 nameRequired
- Customer last nameRequired
- Customer phone
- Billing addressRequired
- Billing postal codeRequired
- Billing cityRequired
- Billing country codeRequired
- 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 labelRequired
- Product description
- Product VAT rateRequired
- Product price (before tax)Required
- Product unit
- Product currency
- Product reference
- Product identifier
- Ledger account ID
Action
Write
- Quote IDRequired
- 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 IDRequired
- 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 identifierRequired
- Start dateRequired
- Mode typeRequired
- Mode email settingsRequired
- Payment conditionsRequired
- Payment methodRequired
- Recurring rule TypeRequired
- Recurring rule Interval
- Recurring rule Count
- Customer IDRequired
- Currency
- Customer Invoice Template ID
- PDF Invoice Free Text
- PDF Invoice Subject
- PDF Description
- Special Mention
- Language
- Discount
- Invoice Line Sections
- Invoice Line LabelRequired
- Invoice Line QuantityRequired
- Invoice Line Raw Currency Unit PriceRequired
- Invoice Line UnitRequired
- Invoice Line VAT RateRequired
- 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 labelRequired
- Product description
- Product VAT rateRequired
- Product price (before tax)Required
- Product unit
- Product currency
- Product reference
- Product identifier
- Ledger account ID
Action
Search or write
- Table/ViewRequired
Trigger
Polling
Try It
- QueryRequired
Trigger
Polling
Try It
- Table/ViewRequired
- Primary KeyRequired
- Order ByRequired
- Trigger Column
Trigger
Polling
Try It
- Disclaimer Copy
- QueryRequired
Action
Write
- TableRequired
- ID ColumnRequired
Action
Write
- QueryRequired
Action
Search

About Pennylane

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

Related categories

Accounting

About SQL Server

SQL server (or MS SQL) is a top of the line database geared for the cloud

Learn more

Related categories

Databases

Similar apps

Related Zap Templates

Create new SQL Server rows for new Pennylane products

Related Zap Templates

Create new SQL Server rows for new Pennylane products

Pennylane + SQL Server

Create new rows in SQL Server for each new customer in Pennylane

New Billing Subscription V2

New Customer Invoice V2

New Quote V2

Create Company Customer V2

Create Customer Invoice V2

Update Individual Customer V2

Create Quote V2

Update Billing Subscription V2

Get Billing Subscription V2

Retrieve Invoice V2

Retrieve Quote V2

Find or Create Customer Invoice V2

Find or Create Quote V2

New Row

New Table

New or Updated Row (Custom Query)

New Row

Find Row

Find Row via Custom Query

New Customer V2

New Product V2

Create Billing Subscription V2

Update Company Customer V2

Create Individual Customer V2

Create Product V2

Update Quote V2

Update Product V2

Retrieve Customer V2

Retrieve Product V2

Find or Create Billing Subscription V2

Find or Create ProductV2

New Column

New Row (Custom Query)

New or Updated Row

Create Custom Query

Update Row

Find Multiple Rows via Custom Query

About Pennylane

Related categories

About SQL Server

Related categories

Similar apps

MySQL

PostgreSQL

Firebase / Firestore

Related Zap Templates

Related Zap Templates