When this happens...
PostgreSQLNew Row (Custom Query)
Then do this...
Google SheetsCreate Spreadsheet Row

Need a way to reliably give access to colleagues the PostgreSQL rows that match a particular custom query? Rather than constantly searching for and copying them, give this Zap a shot. Define your query during setup and, from then on, any new row found to match it on PostgreSQL will automatically trigger the addition of a new row on Google Sheets with all that data, tirelessly keeping track of all those specific items so you never have to dig for them again.

How It Works

  1. A new match is found for a custom query on PostgreSQL
  2. Zapier automatically creates a new row on Google Sheets

What You Need

  • PostgreSQL account
  • Google Sheets account
Premium
PostgreSQL is a Premium integration on Zapier.

Why Zapier?

Free

Get started for free—14 day trial of premium features and apps.

Easy

No coding required—automate any of 1,000+ apps in minutes.

Secure

Enterprise-level security—connect mission-critical apps.

It's easy to connect Google Sheets + PostgreSQL and requires absolutely zero coding experience—the only limit is your own imagination.

When this happens...
then do this!
Google Sheets
New or Updated Spreadsheet Row

Triggered when a new row is added or modified in a spreadsheet.

Google Sheets
Create Spreadsheet Row

Create a new row in a specific spreadsheet.

Google Sheets
New Spreadsheet Row

Triggered when a new row is added to the bottom of a spreadsheet.

Google Sheets
Update Spreadsheet Row

Update a row in a specific spreadsheet.

PostgreSQL
New or Updated Row

Triggered when a new row is added or modified.

PostgreSQL
Update Row

Updates an existing row.

PostgreSQL
New Row (Custom Query)

Triggered when new rows are returned from a custom query that you provide. Advanced Users Only

PostgreSQL
New Row

Adds a new row.

PostgreSQL
New Row

Triggered when you add a new row.

Google Sheets
Create Spreadsheet Row(s)

Create one or more new rows in a specific spreadsheet (with line item support).

Use our free platform to build a single Zapier integration and instantly connect your app with 1,000+ others.

Become a Zapier Integration Partner

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

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.