PostgreSQL
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

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 PostgreSQL + Google Sheets and requires absolutely zero coding experience—the only limit is your own imagination.

When this happens...
then do this!
New or Updated Row

Triggered when a new row is added or modified.

Update Row

Updates an existing row.

New Row (Custom Query)

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

New Row

Adds a new row.

New Row

Triggered when you add a new row.

Create Worksheet

Create a blank worksheet with a title. Optionally, provide headers.

New Spreadsheet Row

Notifies your Zap when a new row is added to the bottom of a spreadsheet.

Create Spreadsheet Row

Create a new row in a specific spreadsheet.

New or Updated Spreadsheet Row

Notifies your Zap when a new row is added or modified in a spreadsheet.

Update Spreadsheet Row

Update a row in a specific spreadsheet.

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

Become a Zapier Integration Partner

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.

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

See Google Sheets Integrations