I’ve got a membership product where orders get added to a Google sheet. When a new row is added, I can use Integromat or Zapier to add a new customer record in Airtable.
I’m struggling to find out how to do the following
If a customer cancels their subscription, I have a cancelled field and date which gets updated. However, if the customer buys it again in a few months, I want the same record to be updated but with the cancellation fields cleared.
So in effect, if a new row is added to Google sheets, I want it to check whether the customer record already exists then just update it, otherwise add a new customer.
Is this possible? I’m probably suffering from baby brain but integromat only seems to have a either add or update. I want to combine the two. There was something about smart links on there. Do I need to create an Orders table and somehow link the two then somehow use that to do updates if needed?