PostgreSQL + Xero

Create or update Xero contacts from new PostgreSQL rows

Maintain your contact list effortlessly with this handy workflow. Whenever a new row is added in PostgreSQL, it prompts an immediate creation or update of a contact in Xero. This automation not only saves time but also ensures that your contact list in Xero stays current and accurate with the data in your PostgreSQL database. Make your database maintenance faster and more efficient with this seamless process.

When this happens...
New Row
Triggered when you add a new row.
TriggerScheduled
automatically do this!
Create/Update Contact
Triggers when you add a new contact.
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

What does this mean?

- Table/ViewRequired
Trigger
Scheduled
Try It
- QueryRequired
Trigger
Scheduled
Try It
- Table/ViewRequired
- Primary KeyRequired
- Order ByRequired
- Trigger Column
Trigger
Scheduled
Try It
- TableRequired
- ID ColumnRequired
Action
Write
- QueryRequired
Action
Search

- OrganizationRequired
Trigger
Scheduled
Try It
- OrganizationRequired
Trigger
Scheduled
Try It

- OrganizationRequired
- Payment Type
Trigger
Scheduled
Try It
- OrganizationRequired
- Purchase Order Status
Trigger
Scheduled
Try It
- OrganizationRequired
- Payment Type
Trigger
Scheduled
Try It
- OrganizationRequired
Trigger
Scheduled
Try It
- OrganizationRequired
Trigger
Scheduled
Try It
- OrganizationRequired
- Invoice IDRequired
- NoteRequired
Action
Write
- OrganizationRequired
- Transaction TypeRequired
- ContactRequired
- Bank AccountRequired
- Date
Action
Write
- OrganizationRequired
- Contact NameRequired
- Account Number
- Contact Requirements
- Primary Person - First Name
- Primary Person - Last Name
- Primary Person - Email
- Secondary Person - First Name
- Secondary Person - Last Name
- Secondary Person - Email
- Include secondary person in emails sent to contact?
- Phone - Country Code
- Phone - Area Code
- Phone Number
- Fax - Country Code
- Fax - Area Code
- Fax - Number
- Mobile - Country Code
- Mobile - Area Code
- Mobile - Number
- Direct Dial - Country Code
- Direct Dial - Area Code
- Direct Dial - Number
- Address Type Of
- Address - Attention
- Address - Line 1
- Address - Line 2
- Address - City/Town
- Address - State/Region
- Address - Postal/Zip Code
- Address - Country
- Tax Number
- Bank Account Number
- Groups
- Contact Number
- Company Number
- Payment Terms - Invoice Due (days)
- Payment Terms - Type for Sales Invoices
- Payment Terms - Bill Due (days)
- Payment Terms - Type for Purchase Invoices
Action
Write
- OrganizationRequired
- TypeRequired
- ContactRequired
- Date
Action
Write
- OrganizationRequired
- Mark Item as a Sales Item?
- Mark Item as a Purchase Item?
- Item Name
- Item CodeRequired
Action
Write
- OrganizationRequired
- Contact NameRequired
- Email Address
- Contact Account Number
- Primary Person - First Name
- Primary Person - Last Name
- Phone - Country Code
- Phone - Area Code
- Phone Number
- Fax - Country Code
- Fax - Area Code
- Fax - Number
- Mobile - Country Code
- Mobile - Area Code
- Mobile - Number
- Direct Dial - Country Code
- Direct Dial - Area Code
- Direct Dial - Number
- Contact Address Type
- Address - Attention
- Address - Line 1
- Address - Line 2
- Address - City/Town
- Address - State/Region
- Address - Postal/Zip Code
- Address - Country
- Contact Tax Number
- Bank Account Number
- Contact Number
- Status
- Date
- Due Date
- Currency
- Url
- Attachment
- Branding Theme
- Number
- Reference
- Sent To Contact
- Line Items Type
- Item Code
- Description
- QuantityRequired
- Unit Price
- Discount %
- Discount Amount
- Account
- Tax Rate
- Tracking
Action
Write
- OrganizationRequired
- ContactRequired
- Project NameRequired
- Deadline for the project
- Project Estimate
Action
Write
- OrganizationRequired
- ContactRequired
- Repeated Invoice Schedule
- Invoice Creation: Frequency TypeRequired
- Invoice Creation: Frequency (Period)Required
- Due Date Type: Payment TermsRequired
- Set Due Dates (Days)Required
- Start Date: Required
- End Date
- StatusRequired
- Currency
- Branding Theme
- Reference
- Mark as approved for sending?
- Email a copy to Sender?
- Include PDF
- Line Amount Types
Action
Write
- Info
- OrganizationRequired
- Invoice IdRequired
- Contact
- Status
- Date
- Due Date
- Expected Payment Date
- Reference
- Branding Theme
- Url
- Currency
- Sent To Contact
- Attachments
- Invoice Number
- Line Amount Types
Action
Write
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- OrganizationRequired
Action
Search
- OrganizationRequired
- Invoice IDRequired
Action
Search
- OrganizationRequired
- Search ByRequired
- Contact NameRequired
- Account Number
- Contact Requirements
- Primary Person - First Name
- Primary Person - Last Name
- Primary Person - Email
- Secondary Person - First Name
- Secondary Person - Last Name
- Secondary Person - Email
- Include secondary person in emails sent to contact?
- Phone - Country Code
- Phone - Area Code
- Phone Number
- Fax - Country Code
- Fax - Area Code
- Fax - Number
- Mobile - Country Code
- Mobile - Area Code
- Mobile - Number
- Direct Dial - Country Code
- Direct Dial - Area Code
- Direct Dial - Number
- Address Type Of
- Address - Attention
- Address - Line 1
- Address - Line 2
- Address - City/Town
- Address - State/Region
- Address - Postal/Zip Code
- Address - Country
- Tax Number
- Bank Account Number
- Groups
- Contact Number
- Company Number
- Payment Terms - Invoice Due (days)
- Payment Terms - Type for Sales Invoices
- Payment Terms - Bill Due (days)
- Payment Terms - Type for Purchase Invoices
Action
Search or write

- Table/ViewRequired
- Order By
- Dedupe Key
Trigger
Scheduled
Try It
New Table
Triggered when you add a new table.
Trigger
Scheduled
Try It
- TableRequired
Action
Write
- TableRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search
- QueryRequired
Action
Search
- OrganizationRequired
- Status
Trigger
Scheduled
Try It
- OrganizationRequired
- Status
- Type
Trigger
Scheduled
Try It
- OrganizationRequired
- Project State
Trigger
Scheduled
Try It
- OrganizationRequired
- Quote Status
Trigger
Scheduled
Try It
- OrganizationRequired
- Status
Trigger
Instant
Try It
- OrganizationRequired
- Status
- Change
- Contact
- Trigger Preference
- Copy
Trigger
Instant
Try It
- OrganizationRequired
- InvoiceRequired
Action
Write
- OrganizationRequired
- Credit Note IDRequired
- Invoice IDRequired
- AmountRequired
Action
Write
- OrganizationRequired
- From AccountRequired
- To AccountRequired
- AmountRequired
- Date
Action
Write
- OrganizationRequired
- ContactRequired
- Date
- Expiry
- Quote Number
- Reference
- Theme
- Title
- Summary
- Currency
- Amounts Are
- Terms
Action
Write
- OrganizationRequired
- Invoice IDRequired
Action
Write
- OrganizationRequired
- Contact NameRequired
- Email Address
- Status
- Date
- Due Date
- Currency
- Url
- Attachment
- Branding Theme
- Reference
- Line Items Type
- Item Code
- Description
- QuantityRequired
- Unit Price
- Account
- Tax Rate
- Tracking
Action
Write
- OrganizationRequired
- Document Type
- Document ID or NumberRequired
- Paid ToRequired
- Date
- Currency Rate
- AmountRequired
- Reference
Action
Write
- OrganizationRequired
- Contact (supplier)Required
- Date
- Delivery Date
- Order Number
- Reference
- Theme
- Currency
- Tax Type
- Delivery Address
- Attention
- Telephone
- Delivery Instructions
- Attachments
- Purchase Order Status
Action
Write
- OrganizationRequired
- Purchase OrderRequired
- Contact
- Update Method for Line Items
- Date
- Delivery Date
- Line Amount Types
- Purchase Order Number
- Reference
- Branding Theme
- Currency
- Status
- Sent to Contact
- Delivery Address
- Attention To
- Telephone
- Delivery Instructions
- Expected Arrival Date
Action
Write
- OrganizationRequired
- Resource typeRequired
- FileRequired
Action
Write
- OrganizationRequired
- Search ByRequired
Action
Search
- OrganizationRequired
- Search ByRequired
Action
Search
- OrganizationRequired
- Search ByRequired
Action
Search
- OrganizationRequired
- Search ByRequired
- Mark Item as a Sales Item?
- Mark Item as a Purchase Item?
- Item Name
- Item CodeRequired
Action
Search or write

About PostgreSQL

PostgreSQL is a powerful, open-source database engine with a uniquely advanced query optimizer and dozens of built in features, making it an easy choice for production databases.

Learn more

Related categories

Databases

Similar apps

About Xero

Xero is an accounting app that lets you track businesses expenses and accounting with intuitive mobile apps and web interfaces for point-of-sale, ecommerce, time-tracking, and more.

Learn more

Related categories

Accounting

Similar apps

Related Zap Templates

Create new PostgreSQL rows for each new Xero sales invoice

Create new rows in PostgreSQL for every new contact in Xero

Create sales invoices in Xero from new rows in PostgreSQL

PostgreSQL + Xero

Create or update Xero contacts from new PostgreSQL rows

New Column

New Row (Custom Query)

New or Updated Row

Trigger Column

Update Row

Find Multiple Rows via Custom Query

New Bank Transaction

New Contact

New Payment

Payment Type

New Purchase Order

Purchase Order Status

New Reconciled Payment

Payment Type

New or Updated Contact

Updated Quote

Add Note to Invoice

Create Bank Transaction

Date

Create/Update Contact

Account Number

Contact Requirements

Primary Person - First Name

Primary Person - Last Name

Primary Person - Email

Secondary Person - First Name

Secondary Person - Last Name

Secondary Person - Email

Include secondary person in emails sent to contact?

Phone - Country Code

Phone - Area Code

Phone Number

Fax - Country Code

Fax - Area Code

Fax - Number

Mobile - Country Code

Mobile - Area Code

Mobile - Number

Direct Dial - Country Code

Direct Dial - Area Code

Direct Dial - Number

Address Type Of

Address - Attention

Address - Line 1

Address - Line 2

Address - City/Town

Address - State/Region

Address - Postal/Zip Code

Address - Country

Tax Number

Bank Account Number

Groups

Contact Number

Company Number

Payment Terms - Invoice Due (days)

Payment Terms - Type for Sales Invoices

Payment Terms - Bill Due (days)

Payment Terms - Type for Purchase Invoices

Create Credit Note

Date

Create Inventory Item

Mark Item as a Sales Item?

Mark Item as a Purchase Item?

Item Name

Create Sales Invoice

Email Address

Contact Account Number