Currently, our business maintains a list of its subscribers in a Google Doc which is viewable by our partners. Partners check to make sure our subscribers are in good standing before honoring a discount. As of now, we manually add names (or remove them) from this list as needed.

We’d like to create a workflow/Zap that automates this process. For example, if we create a field in an Organization within PipeDrive that lists each subscriber as ‘paid’, could we create a Zap to edit the Google Doc as people pay (or are designated as not paid)?

I see options to add a row or edit a row with a Zap, but don’t understand how to set the condition of evaluating one field (‘Paid’), then updating the Sheet. Initial trials have proved frustrating. Am I making this too complicated? Or not understanding the complexity sufficiently?

The videos outlining the basics of Zapier are easy to understand.. but I’ve so far been unable to translate them into actions that make sense.