Refound your company for the AI era at ZapConnect 2026. Save your spot →

Google Sheets + Saturation + Filter by Zapier

Look up Google Sheets rows for new purchase orders marked paid in Saturation

Build a click-free, marked-paid activity log for effortless purchase-order reconciliation. This Zap automatically filters for purchaseOrder.paid, looks up the event ID in Google Sheets, and adds a row when absent. Select an event-ID lookup column and map ID, Entity Id (PO ID), Event and Occurred At during setup.

When this happens...
Updated Purchase OrderTriggers when a purchase order changes status (pending, approved, rejected, actualizing, paid or void). The event field carries the specific status. Use a Filter step to react to a specific status.
TriggerInstant
automatically do this!
Only continue if...Set up rules to specify when this Zap can continue running.
ActionFilter

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

More things you can do with these apps

Discover other triggers and actions you can use with Saturation, Filter by Zapier, and more

- Project
Trigger
Instant
Try It
- Project
Trigger
Instant
Try It
- Status
Trigger
Polling
Try It
- Project
Trigger
Instant
Try It
- Project
Trigger
Instant
Try It

- Purchase Order ID
  Required
- Action
  Required
- Transaction to link
Action
Write
- Project
- PO Number
- Name
- Vendor / Contact
- Budget Line ID
- Due Date
- Service Start Date
- Service End Date
- Notes
- Description
- Qty
- Unit
- Rate
- Amount
- Budget Line ID
Action
Write

- File
  Required
- File Name
- Link To (kind)
- Replace Existing Link
Action
Write
- Search Text
- Email
- Contact Type
Action
Search
- PO Number
- Status
- Project
- Vendor / Contact
Action
Search
- Project
  Required
- Phase
- Line Kind
- Account Code
Action
Search
- Document ID
  Required
Action
Search

- Project
Trigger
Instant
Try It
- Contact Type
- Text Filter
Trigger
Polling
Try It
- Project
- Source
- Type
Trigger
Polling
Try It
- Project
Trigger
Instant
Try It
- Document ID
  Required
- Link To (type)
  Required
- Replace Existing Link
Action
Write
- Name
  Required
- Contact Type
- Company
- Title
- Email
- Phone
- Address
- Website
- Notes
Action
Write
- Project
  Required
- Type
  Required
- Amount
  Required
- Currency
  Required
- Date
- Description
- Contact
- Budget Line ID
Action
Write
- Transaction ID
  Required
- Project
- Contact
- Budget Line ID
- Status
- Description
- Notes
- Amount
- Currency
Action
Write
- Project
- Search Text
- Status
Action
Search
- Project
- Source
- Type
- Status
- Contact
- Budget Line ID
- Date From
- Date To
- Amount Min
- Amount Max
- Text Search
Action
Search
- Project
  Required
- Phase
Action
Search
- Only continue if...
  Required
Action
Filter

About Google Sheets

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

Learn moreLearn moreHelpHelp

Related categories

Google

Spreadsheets

Similar apps

Zoho Creator

App Builder, Zoho

Smartsheet

Spreadsheets

Quip

Documents

About Saturation

Saturation is a production finance platform for film & TV — budgets, actuals, purchase orders, and receipts in one place.

HelpHelp

Related categories

Beta

Project Management

About Filter by Zapier

Only allow a Zap to proceed when a certain condition is met. For example, if you're sending a text message when you receive a new email, you could use a Filter that only sends a text message when the email received is from a certain address.

Learn moreLearn moreHelpHelp

Related categories

Developer Tools

Zapier

Related Zap Templates

Lookup Google Sheets rows for newly-updated Saturation purchase orders